asp.net写入数据库出错

来源:百度知道 编辑:UC知道 时间:2024/06/14 09:29:56
private void ConnectDd()
{
//throw new Exception("The method or operation is not implemented.");
SqlConnection myCon=new SqlConnection();
myCon.ConnectionString =
"User id=sa;pwd=600178;database=my site;server=(local)";
myCon.Open();
//Page.Response.Write(myCon.State);
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandText =
"insert into zhu_ce value('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "') ";
SqlDataReader sdr = myCom.ExecuteReader();
if (sdr.Read()) Page.Response.Write("已插入!");

sdr.Close();
myCon.Close();
}

报错:第 1 行: 'value' 附近有语法错误。
[SqlException (0x

"insert into zhu_ce values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "') ";

插入应该是用ExecuteNonQuery方法

ExecuteReader 这个好像不能执行添加操作吧?
插入操作是要用ExecuteNonQuery这个方法吧?

如上所说,ExecuteReader 是执行读取操作的...
还有,插入语句的"Value"应该是"values"