SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=.;database=Studentdb;uid=sa;pwd=123456;";
conn.Open();
string sql = "delete from StudentInfo where ID =" + dataGridView1.SelectedRows[0] ; SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
帮忙看看
老师异常
都无奈了
conn.ConnectionString = "server=.;database=Studentdb;uid=sa;pwd=123456;";
conn.Open();
string sql = "delete from StudentInfo where ID =" + dataGridView1.SelectedRows[0] ; SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
帮忙看看
老师异常
都无奈了
猎取的值是否不会为NULL
你觉得这句话有没有问题,特别是dataGridView1.SelectedRows[0] 你没有获得到id
后面不写了?列呢?,这样是一个datagridviewrow么
dataGridView1.SelectedRows[0].Cells[0].Value
加个断点。看 sql到底是什么内容。
{
string sql = "delete from StudentInfo where ID =" +
dataGridView1.SelectedRows[0].Cells[1].Value.ToString();}
conn.ConnectionString = "server=.;database=Studentdb;uid=sa;pwd=123456;";
conn.Open();
string sql = "delete from StudentInfo where ID ='"" +dataGridView1.SelectedRows[0]+'"" ; //注意引号和格式。 SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
conn.ConnectionString = "server=.;database=Studentdb;uid=sa;pwd=123456;";
conn.Open();
string sql = "delete from StudentInfo where ID ='"" +dataGridView1.SelectedRows[0].tostrint()+'"" ; //注意引号和格式。 还要加上tostring()这个东东哈! SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();