SqlCommand comm = new SqlCommand ("select * from Room",conn); SqlCommand comm2 = new SqlCommand ("delete * from Room where Room_N0='"+textBox1.Text+"'",conn); SqlCommandBuilder scb = new SqlCommandBuilder (da); da.SelectCommand=comm; da.Fill(ds,"Room"); MessageBox.Show(ds.GetXml()); da.DeleteCommand = comm2; DataTable dt = new DataTable(); dt = ds.Tables[0]; //DataRow dr = new DataRow(); foreach(DataRow dr in ds.Tables[0].Select("Room_No = '"+textBox1.Text+"'")) { dr.Delete(); } MessageBox.Show(ds.GetXml()); da.Update(ds,"Room");/// the problem is in this line
SqlCommand comm2 = new SqlCommand ("delete * from Room where Room_N0=@Room_NO",conn); comm2.Parameters.Add("@TID", SqlDbType.Int).Value = textBox1.Text; conn.Open(); comm2.ExecuteNonQuery(); conn.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)