How to insertupdate record in data grid view (inline)

Question

Hi  i need some help in completing a small task .  How to insertupdatedelete record in data grid view using inline i.e (suppose if we update a record in the data grid then after click on the next row the data which is updated should be save directly to the sql server database ). i already surfed so many pages but i didnt get what i want 1 max 25 developer 2 rex 36 team lead if u check the above table suppose if a made any changes to the name  max  to rambo then after clicking on the next row it should be directly updated to data base like wise insert and delete to . Thanks in advance

Nanhe Siddique · Answer

hi pop use RowLeave and RowEnter Events use this code private void dataGridView1_RowEnter(object senderDataGridViewCellEventArgs e) { for (int i = 0; i { dataGridView1[i e.RowIndex].Style.BackColor = Color.Yellow; } } private void dataGridView1_RowLeave(object senderDataGridViewCellEventArgs e) { for (int i = 0; i { dataGridView1[i e.RowIndex].Style.BackColor = Color.Empty; } } or read this link http://www.codeproject.com/Articles/12846/Auto-Saving-DataGridView-Rows-to-a-SQL-Server-Data https://social.msdn.microsoft.com/Forums/windows/en-US/e9200204-5af2-467b-a9e9-7c84fafe0810/how-to-rowchanged-in-datagridview http://stackoverflow.com/questions/14929761/datagridview-row-update-event if it help you Please Mark Accept Answer

Lucky Laxman · Answer

Hi  this is very easy simple when your updating that time on pass the updating Id columns values to your Sql it can update .

How to insert,update record in data grid view (inline)