string str,sql1,sql2;
sql1 = "insert into UserInfo (UserName,PassWord,Role";
sql2 = "values ('" + textBox1.Text.ToString() + "','" + textBox2.Text.ToString() + "','" + comboBox1.Text.ToString () ;
str=sql1+")"+sql2+")";
cmd.CommandText = str;
cmd.ExecuteNonQuery();

sql2+")";

这个加号你想做什么

你太有个性了,这样拼凑String...

你不知道内存很珍贵嘛?

sql1 = String.Format("insert into UserInfo (UserName,PassWord,Role) values({0},{1},{2})",textBox1.Text.Trim(),textBox2.Text.Trim(),comboBox1.Text.Trim());

values 前面少个空格

您的办法不行

不是

也不行

）不是要放到引号里面么

string str = "insert into UserInfo (UserName,PassWord,Role) values ('" + textBox1.Text.ToString() + "','" + textBox2.Text.ToString() + "','" + comboBox1.Text.ToString () + "')";
cmd.CommandText = str;

[此贴子已经被作者于2007-11-1 13:58:40编辑过]