varchar 只能存数值????
sqlcon.ConnectionString = "server=.;database=test_2;uid=sa;pwd=yun900125";
sqlcon.Open();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandText = "insert into table_ID (ID,pwd) values ("+this.txtIDLogin.Text.ToString()+","+this.txtPwdLogin.Text.ToString()+") "; sqlcmd.ExecuteNonQuery();
sqlcmd.CommandText = "insert into table_sbujects(ID,class,fullname,number) values(" + this.txtIDLogin.Text.ToString() + "," + this.txtClassLogin.Text.ToString() + "," + this.txtNameLogin.Text.ToString() + "," + this.txtNumberLogin.Text.ToString() + ")"; sqlcmd.ExecuteNonQuery();
sqlcon.Close();
上面红色部分里的Text,如果写的是数值,调试,没问题。但是如果输入字母,就会报错。
难道varchar只能存数值??? 不是应该是数字、字母、汉字都能存么??