SqlConnection conn = new SqlConnection("server =(local);database = shujuku;uid = sa;pwd = 123456");
conn.Open();
//string xuehao = textBox13.Text, xingming = textBox14.Text, zhuanye = textBox15.Text, xingbie = textBox16.Text, minzu = textBox17.Text, daoshi = textBox18.Text;
string tianjia1 = "insert into list(学号,姓名,专业,性别,民族,导师) values('" + textBox13 + "','" + textBox14 + "','" + textBox15 + "','" + textBox16 + "','" + textBox17 + "','" + textBox18 + "');
SqlCommand command = new SqlCommand(tianjia1, conn);
command.ExecuteNonQuery();
MessageBox.Show("数据添加成功");我把逗号去了 又有新问题了 就是一直显示两个错误 1:请输入;,2:常量中有换行符。请高手指教 谢谢
conn.Open();
//string xuehao = textBox13.Text, xingming = textBox14.Text, zhuanye = textBox15.Text, xingbie = textBox16.Text, minzu = textBox17.Text, daoshi = textBox18.Text;
string tianjia1 = "insert into list(学号,姓名,专业,性别,民族,导师) values('" + textBox13 + "','" + textBox14 + "','" + textBox15 + "','" + textBox16 + "','" + textBox17 + "','" + textBox18 + "');
SqlCommand command = new SqlCommand(tianjia1, conn);
command.ExecuteNonQuery();
MessageBox.Show("数据添加成功");我把逗号去了 又有新问题了 就是一直显示两个错误 1:请输入;,2:常量中有换行符。请高手指教 谢谢
str = "12
34";
错误。
------------
错了吧。应该textBox13.Text
如果插入成功,用
Response.Write("<script>alert('数据添加成功!');</"+"script>");
替换你的messagebox那一行~
string tianjia1 = "insert into list(学号,姓名) values('" + a + "','" + a + "')";