private void btnAdd_Click(object sender, EventArgs e)
{
SqlConnection conn =new SqlConnection("Data Source=JIAO\\SQL2005;Initial Catalog=SalaryMS;User ID=sa;pwd=123");
conn.Open();
string insertSql = "insert into users where userName="+textBox1.Text+"";
SqlCommand comm = new SqlCommand(insertSql,conn);
int updCount = comm.ExecuteNonQuery();
conn.Close();
}提示异常:where子句附近有错误
{
SqlConnection conn =new SqlConnection("Data Source=JIAO\\SQL2005;Initial Catalog=SalaryMS;User ID=sa;pwd=123");
conn.Open();
string insertSql = "insert into users where userName="+textBox1.Text+"";
SqlCommand comm = new SqlCommand(insertSql,conn);
int updCount = comm.ExecuteNonQuery();
conn.Close();
}提示异常:where子句附近有错误
string insertSql = "insert into users where userName='"+textBox1.Text+"'";
string insertSql = "insert into users where userName="+textBox1.Text+"";
------
insert into users where username=某值这是个什么SQL语句,楼主你到底想干嘛?到底是插入还是干什么?
string insertSql = "insert into users(userName) values('"+textBox1.Text+"')";