请大家进来看看,不胜感激!!
在调试运行中向数据库中添加一条新数据的时候,在最后一条语句“sqlDataAdapter1.Update (new_info);//到此添加完毕”出现如下错误提示:未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 system.data.dll 中。其他信息:系统错误
请高手们帮帮啊。
代码如下:
private void btn_add_Click(object sender, System.EventArgs e)
{
// 添加
string str_ins;
str_ins="SELECT * FROM hprkd";
DataSet ds_info=new DataSet ();
sqlDataAdapter1.SelectCommand .CommandText =str_ins;
sqlDataAdapter1.Fill (ds_info);
DataRow newRow=ds_info.Tables [0].NewRow ();
newRow.BeginEdit ();
newRow[0]=cb_hpid.SelectedItem .ToString ().Trim ();
newRow[1]=tb_num.Text .ToString ().Trim ();
newRow[2]=tb_rkdh.Text .ToString ().Trim ();
newRow[3]=dateTimePicker1.Value .Date ;
newRow[4]=cb_ghdw.SelectedItem .ToString ().Trim ();
newRow[5]=tb_lry.Text .ToString ().Trim ();
newRow[6]=tb_shy.Text .ToString ().Trim ();
newRow[7]=tb_bz.Text .ToString ().Trim ();
newRow.EndEdit ();
ds_info.Tables [0].Rows .Add (newRow);
DataSet new_info=new DataSet ();
new_info.Merge (ds_info.GetChanges ());
sqlDataAdapter1.Update (new_info);//到此添加完毕
}