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

mad pop

Hi ,

i need some help in completing a small task . " How to insert,update,delete 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

2 Replies

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

Nanhe Siddique11y ago
hi pop
use RowLeave and RowEnter Events
use this code

private void dataGridView1_RowEnter(object sender,DataGridViewCellEventArgs e)
{
for (int i = 0; i < dataGridView1.Rows[e.RowIndex].Cells.Count; i++)
{
dataGridView1[i, e.RowIndex].Style.BackColor = Color.Yellow;
}
}
private void dataGridView1_RowLeave(object sender,DataGridViewCellEventArgs e)
{
for (int i = 0; i < dataGridView1.Rows[e.RowIndex].Cells.Count; 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 Laxman11y ago
Hi , this is very easy simple when your updating that time on pass the updating Id, columns values to your Sql it can update .