What is wrong?

private void button4_Click(object sender, EventArgs e)
{
if (bar_code1DataGridView.SelectedRows.Count > 0)
{
DataGridViewRow dr = bar_code1DataGridView.SelectedRows[0];
if (!string.IsNullOrEmpty(dr.Cells["dataGridViewTextBoxColumn1"].Value.ToString()))
{
String cs = "Data Source=.\\SQLEXPRESS;Initial Catalog=barcode;Integrated Security=True";
using (SqlConnection openCon = new SqlConnection(cs))
{
using (SqlCommand querySaveStaff = new SqlCommand("DELETE FROM bar_code1 WHERE id=@id", openCon))
{
// querySaveStaff.Parameters.Add("@id",SqlDbType.Int).Value=idTextBox.Text;
querySaveStaff.Parameters.AddWithValue("@id", 0);
openCon.Open();
querySaveStaff.ExecuteNonQuery();
openCon.Close();
}
}
using (SqlConnection openCon = new SqlConnection(cs))
{
string saveStaff = "SELECT * FROM dbo.bar_code1 ";
openCon.Open();
using (SqlDataAdapter querySaveStaff = new SqlDataAdapter(saveStaff, cs))
{
querySaveStaff.Fill(barcodeDataSet.bar_code1);
bar_code1DataGridView.DataSource = barcodeDataSet.bar_code1;
bar_code1DataGridView.Update();
bar_code1DataGridView.Refresh();
}
}
}
}
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

sudipta sanyal8y ago
Accepted answer
Hi

You are not passing any value in parametter

querySaveStaff.Parameters.AddWithValue("@id", 0);

Please pass the ID for delete the records
Prashanth J8y ago
Try to put the break point and debug , you may find any error or problem
Bharathi Raja8y ago
debugger to check the get value
Goran Bibic8y ago
Visual studio no have error.
When I click on button, don't delete row
That is problem
Suraj Kumar8y ago
Hello Goran,

As you have provided codes and not given proper issue you are facing. So, please specify actual error details.

Thanks