string connectionstring = "data source=(local);initial catalog=MyQQ;" + "integrated security=SSPI;";
SqlConnection connection=new SqlConnection (connectionstring);
connection.Open();
string sql = "insert into T1(c1,c2) values ({0},{1}),t1.Text,t2.Text";
SqlCommand command = new SqlCommand(sql, connection);
int i = command.ExecuteNonQuery();
if (i == 1)
MessageBox.Show("注册成功");
else
MessageBox.Show("注册失败");
错误提示一直指着int i = command.ExecuteNonQuery();这一句说未处理SqlException, ‘0’附近有语法错误
哪位大哥可以说一下到底哪里错了,万分感谢!!!
string sql = "insert into T1(c1,c2) values ({0},{1}),t1.Text,t2.Text";
如果我把这一句改成
string sql = "insert into T1(c1,c2) values (1,100)";话,1,100这2个数就确实可以录入数据库里面,还有,c1,c2列中都是int型的
哪位大哥知道哪里错了,改怎么改?谢谢!!