Update datagridview

Question

Hello everyone, I insert the datagridview control and I link it with a datasource but I stuck to the update with this datagridview when inserting new line in database?

Sourabh Somani · Answer

On Inserting Time Again Bind your GridView from Database

Rupali Shinde · Answer

Hi, Please check below link as well for help :) http://www.dotnetfunda.com/forums/show/12674/crud-operation-in-window-datagrid If it works out, Please Accept this as Answer

Rupali Shinde · Answer

Hi, Please check below code, you can implement in this way. you get solution to ur problem : private void bindgrid () { OleDbConnection con = new OleDbConnection ( ConnectionString ); con . Open (); str = "select * from employee" ; com = new OleDbCommand ( str , con ); oledbda = new OleDbDataAdapter ( com ); ds = new DataSet (); oledbda . Fill ( ds , "employee" ); dataGridView1 . DataMember = "employee" ; dataGridView1 . DataSource = ds ; con . Close (); } private void btn_update_Click ( object sender , EventArgs e ) { OleDbConnection con = new OleDbConnection ( ConnectionString ); con . Open (); str = "Update employee set sno=@sno,name=@name,address=@address,age=@age Where sno=@sno" ; com = new OleDbCommand ( str , con ); com . Parameters . AddWithValue ( "@sno" , txt_sno . Text ); com . Parameters . AddWithValue ( "@name" , txt_name . Text ); com . Parameters . AddWithValue ( "@address" , txt_address . Text ); com . Parameters . AddWithValue ( "@age" , txt_age . Text ); com . ExecuteNonQuery (); MessageBox . Show ( "Record Successfully Updated" ); con . Close (); bindgrid (); } If it works out, Please Accept this as Answer

abdelwaheb ammar · Answer

can you send me an example or a link explain that ?

Sourabh Somani · Answer

Then Create an object of DataGridViewRow and Add data to that row and when you insert modify DataGridViewAlso :)

abdelwaheb ammar · Answer

but the dataGridview which i inserted is related with datasource graphically and with Table Adapter.

Sourabh Somani · Answer

public void BindGrid() { SqlConnection con=new SqlConnection(ConnectionString); SqlCommand cmd=new SqlCommand(qry,con); SqlDataAdapter adpt=new SqlDataAdapter(cmd) ; DataTable dt=new DataTable(); adpt.Fill(dt); DataGridView1.DataSource=dt; } After Insert Successfully on click of button Call BindGrid Methd

abdelwaheb ammar · Answer

which method it can make this?

Update datagridview

Answers (8)