datagridview data store in database table

Question

Hi I want when i enter data in datagridview cell then that store or insert in database table

Pravin Ghadge · Answer

Hi Shubhangi 1)Use Row_added event of datagridview 2)In this eventWrite Code of inserting record in database

Pravin Ghadge · Answer

Hi u can use Row_Added event: if(datagridview.row.count>0) { da = new SqlDataAdapter(); DataRow vDr; da.SelectCommand = new SqlCommand(); da.SelectCommand.CommandType = CommandType.Text; vCmBld = new SqlCommandBuilder(da); da.SelectCommand.Connection = con; da.SelectCommand.CommandText = Select * from tablname; da.Fill(vDs  GradeDGV ); vDr = vDs.Tables[ GradeDGV _PAYMENT].NewRow(); vDr[SrNo] = dataGridView1.Rows[datagridvew.rows.count].Cells[SrNo].Value; //specifed ur column name vDs.Tables[ GradeDGV ].Rows.Add(vDr); da.Update(vDs  GradeDGV ); vDs.Dispose(); da.Dispose(); }

shubhangi khandale · Answer

thanks sir but how to add records which is enter in cell. using cell class this records insert in datagridview only not in database table