帮帮忙~

[ziqiao_1988]

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子句附近有错误

[lijing3333]

......差字段...汗...表不能随便插得....

[我姓区不姓区]

单引号少了
string insertSql = "insert into users where userName='"+textBox1.Text+"'";

[sirBUAA]

UP

[pt1314917]

string insertSql = "insert into users where userName="+textBox1.Text+""; 
------
insert into users where username=某值

这是个什么SQL语句，楼主你到底想干嘛？到底是插入还是干什么？

[wuyq11]

string insertSql = "insert into users where userName='"+textBox1.Text.Replace("'","''")+"'";

[我姓区不姓区]

看错了，楼主是要insert啊……那value呢？
string insertSql = "insert into users(userName) values('"+textBox1.Text+"')";

[ziqiao_1988]

错误改了，谢啦！

[我姓区不姓区]

提高你的结贴率