DataGridView records actions

Question

Hello, How can i make a dataGridView to work programmatically when the user leaves the row? (add,delete,save/update records). Thank you in advance.

Kirtan Patel · Answer

Hi Friend , Here is How you will check weather it is was new row or not . :) private void dataGridView1_RowLeave( object sender, DataGridViewCellEventArgs e) { int index = e.RowIndex; if (dataGridView1.Rows[index].IsNewRow == false ) { // string PrimaryKey = dataGridView1.Rows[index].Cells[0].Value.ToString(); //string Column1 = dataGridView1.Rows[index].Cells[2].Value.ToString(); //string Column2 = dataGridView1.Rows[index].Cells[2].Value.ToString(); // string Column3 = dataGridView1.Rows[index].Cells[2].Value.ToString(); } else { // Code For Inserting if it was new MessageBox .Show( "It Was New Line" ); } }

Dealy · Answer

Thank you for the help and i apologize for the late answer.

Dealy · Answer

Thanks. How do i know that is new record though and i should insert the record not update?

Kirtan Patel · Answer

Hi , you can do it with RowLeave Event of DataGridView private void dataGridView1_RowLeave( object sender, DataGridViewCellEventArgs e) { //Get the Rowindex int index = e.RowIndex; //get Current Values of Columns From Row to Write in Database string PrimaryKey = dataGridView1.Rows[index].Cells[0].Value.ToString(); string Column1 = dataGridView1.Rows[index].Cells[1].Value.ToString(); string Column2 = dataGridView1.Rows[index].Cells[2].Value.ToString(); string Column3 = dataGridView1.Rows[index].Cells[3].Value.ToString(); //Sql Programming For Updating Record in Database Here From Above Values // Execute Query Like // update tablename set x=value ,y =value where primarykey = Primarykey }

DataGridView records actions

Answers (4)