insert data into database when user enters data within dgv

Question

how to insert the data into the database when user enter the data within the datagridview cell. and how to update also. language = C#

Nhlanhla A W Mkhize · Answer

Try using the above code for a connection that is only open onceyou can also bind the grid to the database.

Nhlanhla A W Mkhize · Answer

for(int i=0; i< dataGridView1.Rows. Count;i++) { string StrQuery= @INSERT INTO tableName VALUES ( + dataGridView1.Rows [i].Cells [ColumnName].Value +  + dataGridView1.Rows [i].Cells [ColumnName].Value +);; try { SqlConnection conn = new SqlConnection(); conn.Open(); using (SqlCommand comm = new SqlCommand (StrQuery conn)) { comm. ExecuteNonQuery(); } conn.Close(); }

saurabh mittal · Answer

hi Akaash you can check this link .May be it will be helpful for u http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html