Update datagridview

abdelwaheb ammar

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?

8 Replies

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

Rupali Shinde10y ago
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
0

Rupali Shinde10y ago

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 ammar10y ago
can you send me an example or a link explain that ?
0
Sourabh Somani10y ago
Then Create an object of DataGridViewRow and Add data to that row and when you insert modify DataGridViewAlso :)
0
abdelwaheb ammar10y ago
but the dataGridview which i inserted is related with datasource graphically and with Table Adapter.
0
Sourabh Somani10y ago
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
0
abdelwaheb ammar10y ago
which method it can make this?
0
Sourabh Somani10y ago
On Inserting Time Again Bind your GridView from Database
0