Question

ASP.net中插入数据

我有7个TextBox1....TextBox7
我想向数据库中信息:姓名，学号，年龄等等，
我是我的插入代码
SqlConnection con = new SqlConnection("server=localhost;database=student;uid=sa;pwd=zyb");
con.Open();
SqlDataAdapter mydata = new SqlDataAdapter();
mydata.InsertCommand = new SqlCommand("insert into baseStu (TextBox1,TextBox2,TextBox3,TextBox4,TextBox5,TextBox6,TextBox7)values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "'," + TextBox4.Text + "'," + TextBox5.Text + "'," + TextBox6.Text + "'," + TextBox7.Text + "')", con);

我插入之后在数据库中怎么找不到我刚才插入的记录了

Answer 1

insert into baseStu (TextBox1,TextBox2,TextBox3,TextBox4,TextBox5,TextBox6,TextBox7)??你数据库中的字段也是TextBox1,TextBox2,TextBox3,TextBox4,TextBox5,TextBox6,TextBox7？？
还要一个 com.ExecuteNoneQuery(); 命令没写。

Answer 2

(TextBox1,TextBox2,TextBox3,TextBox4,TextBox5,TextBox6,TextBox7)values
……
括号里应该写的是你的那张表里的那些字段名。

Answer 3

string str="insert into baseStu (TextBox1,TextBox2,TextBox3,TextBox4,TextBox5,TextBox6,TextBox7)values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "'," + TextBox4.Text + "'," + TextBox5.Text + "'," + TextBox6.Text + "'," + TextBox7.Text + "')";
SqlConnection con = new SqlConnection("server=localhost;database=student;uid=sa;pwd=zyb");
con.Open();
SqlCommand sqlcom=new SqlCommand(str,con);
sqlcom.ExecuteNoneQuery();
con.Close();
一定要确定数据库里的列名也是TextBox1,TextBox2,TextBox3,TextBox4,TextBox5,TextBox6,TextBox7

Answer 4

哎~ 这代码……

Answer 5

你的sql语句里要插入的也是textbox吗？