Loading

delete datagridview records

ta mu

i want to delete record which is selected in datagridview from database but i got error

SqlCommand cmd = new SqlCommand();
               cmd.CommandText = "DELETE FROM addcustomer WHERE ccount_No=" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString() + "";
               my.Open();

               cmd.Connection = my;
              cmd.ExecuteNonQuery();

error is
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

plz help me

2 Replies

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

ta mu13y ago
data type is int

still getting that error with your code
0
Mohan Gopi13y ago
try this;

can you share me the ccount_No datatype .

string selectedvalue=dataGridView1.SelectedRows[0].Cells[0].Value.ToString() ;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "DELETE FROM addcustomer WHERE ccount_No=" +selectedvalue + "";
my.Open();

cmd.Connection = my;
cmd.ExecuteNonQuery();

Check what will be the selectedvalue string received.
0