110,534
社区成员
发帖
与我相关
我的任务
分享
string conStr = "Server= USERSWO-MI8QI4Q\\SQLEXPRESS;Initial Catalog=LibraryCRM;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(conStr);
int index = this.dataGridView2.CurrentCell.RowIndex;
string readerID = this.dataGridView2.Rows[index].Cells["readerIDDataGridViewTextBoxColumn"].Value.ToString();
string strSQL = "Delete From ReaderInfo Where readerID= '" + readerID + "'";
try
{
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter(strSQL ,conn );
DataSet ds = new DataSet();
sda.Fill(ds, "ReaderInfo");
dataGridView2.DataSource = ds.Tables["ReaderInfo"];
MessageBox.Show("成功删除数据!");
}
SqlDataAdapter sda = new SqlDataAdapter(strSQL ,conn ); DataSet ds = new DataSet();
sda.Fill(ds, "ReaderInfo");
这个代码,strSQL中是删除语句,用来填充DS自然无效为NULL.
System.NullReferenceException 查询一下数据库中是否有NULL的字段处理上出问题.string conStr = "Server= USERSWO-MI8QI4Q\\SQLEXPRESS;Initial Catalog=LibraryCRM;Integrated Security=SSPI";
SqlConnection conn = new SqlConnection(conStr);
int index = this.dataGridView2.CurrentCell.RowIndex;
string readerID = this.dataGridView2.Rows[index].Cells["readerIDDataGridViewTextBoxColumn"].Value.ToString();
string strSQL = "Delete From ReaderInfo Where readerID= '" + readerID + "'";
try
{
conn.Open();
//此处加下面几句
SqlCommand cmd=conn.CreateCommand();
cmd.CommandText=strSQL;
cmd.ExecuteNonQuery(); //删除,不建议这样删除视图
conn.Close();
strSQL="SELECT * FROM ReaderInfo "; //需要重新绑定
SqlDataAdapter sda = new SqlDataAdapter(strSQL ,conn );
DataSet ds = new DataSet();
sda.Fill(ds, "ReaderInfo");
dataGridView2.DataSource = ds.Tables["ReaderInfo"];
MessageBox.Show("成功删除数据!");
}