向sql中插入数据的时候报截断问题,但数据和sql语句都是正确的,后来才发现是把控件名直接作为值插入了,下意识把控件当作了变量,改为UserName.Text就成功插入了。
string conStr = "Server=(local); Database=SqlDemos;" +
"Integrated Security=SSPI;Persist Security Info=False";
int r = 0;
using (SqlConnection conn = new SqlConnection(conStr))
{
using (SqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText= string.Format(@" INSERT INTO[dbo].[UserInfo](UserName, UserAge, UserPwd, DelFlag, CreateDate)
VALUES('{0}','{1}','{2}','{3}','{4}')",txtUserName,txtAge,txtPwd1,txtUserName,System.DateTime.Now);
//cmd.CommandText = "INSERT INTO UserInfo (UserName, UserAge, UserPwd, DelFlag, CreateDate)VALUES" +
// "('{txtUserName}','{txtAge}','{txtPwd1}','{txtUserName}','{System.DateTime.Now}')";
//----------------------------------------------
r = cmd.ExecuteNonQuery();//被截断????
}
}
MessageBox.Show(r.ToString());
长记性了,下次一定要注意这个问题
Tips