为什么不能插入数据库..在线等..急..
来源:百度知道 编辑:UC知道 时间:2024/06/08 02:16:58
strconn = "server=localhost;uid=sa;pwd=123;database=jiaowu";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
TextBox tb = (TextBox)e.Item.FindControl("TextBox1");
TextBox tb1 = (TextBox)e.Item.FindControl("TextBox2");
TextBox tb2 = (TextBox)e.Item.FindControl("TextBox3");
string Sql;
Sql = "insert into xueshengbiao values ('" + tb.Text.Trim() + "','" + tb1.Text.Trim() + "','" + tb2.Text.Trim() + "')";
SqlCommand comm = new SqlCommand(Sql, conn);
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = comm;
da.InsertCommand.ExecuteNonQuery();
strconn = "server=localhost;uid=sa;pwd=123;database=jiaowu";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
TextBox tb = (TextBox)e.Item.FindControl("TextBox1");
TextBox tb1 = (TextBox)e.Item.FindControl("TextBox2");
TextBox tb2 = (TextBox)e.Item.FindControl("TextBox3");
string Sql;
Sql = "insert into xueshengbiao values ('" + tb.Text.Trim() + "','" + tb1.Text.Trim() + "','" + tb2.Text.Trim() + "')";
SqlCommand comm = new SqlCommand(Sql, conn);
comm.ExecuteNonsery();
coon.close();
你引入的那个适配器根本没用 直接用sqlcommand 命令就搞定了
string strconn = "server=localhost;uid=sa;pwd=123;database=jiaowu";
SqlConnection conn = new SqlConnection(strconn);
TextBox tb = (TextBox)e.Item.FindControl("TextBox1");
TextBox tb1 = (TextBox)e.Item.FindControl