Column named cannot be found?

Question

Hi,

I have a datagridview and a delete button.When user select a row and click delete button (outside of the datagridview) it must delete relevant row from datagridview.

Right now it is working but sometime it throws this error

"Column named RecordID cannot be found" from below highlighted line

int selectedIndex = InternetGroupDGV.CurrentCell.RowIndex;

if (selectedIndex > -1)
{
int selectedrowindex = InternetGroupDGV.CurrentCell.RowIndex;
DataGridViewRow selectedRow = InternetGroupDGV.Rows[selectedrowindex];
string recID = Convert.ToString(selectedRow.Cells["RecordID"].Value);

SqlConnection con = new SqlConnection(this.configuration.Connstring);
SqlCommand deleteCMD = new SqlCommand("InternetGroup_Delete", con);
deleteCMD.CommandType = CommandType.StoredProcedure;
deleteCMD.Parameters.AddWithValue("@RecordID", recID);
con.Open();
deleteCMD.ExecuteNonQuery();
callDB(); //Bind

}
else
{
MessageBox.Show("Error Occured");
}

Seems me once it deleted a record it cannot find out RecordID to delete again.
Any ideas?
Thanks

Upendra Pratap Shahi · Answer

int rowindex = DataGrid1.CurrentCell.RowIndex; int columnindex = DataGrid1.CurrentCell.ColumnIndex; DataGrid1 .Rows[rowindex].Cells[columnindex].Value. ToString ();

Upendra Pratap Shahi · Answer

Thanks for appreciation resign-designs

Jaipal Reddy · Answer

Try the follwing code : int rowindex = dataGrid1.CurrentCell.RowIndex; int columnindex= = dataGrid1.CurrentCell.ColumnIndex; dataGrid1 .Rows[rowindex].Cells[columnindex].Value.ToString()

Resign Designs · Answer

I am calling it callDB(); //Bind What I can see that I only can delete 1 record.When I click second record to delete this error comes

Jaipal Reddy · Answer

Just call your datagrid bind method again after deleting the record.

Upendra Pratap Shahi · Answer

kindly update your datagrid after deleting the row to avoid this problem because it seems like no updation occured in your datagrid after deletion of a row.

Column named cannot be found?

Answers (6)