S SqlConnection con = new SqlConnection(_lg.connectionstring); con.Open(); SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(_commandstring, con); this.myDataSet.Clear(); mySqlDataAdapter.Fill(myDataSet, "MyTable"); try { DataSet mychangeDataSet = this.myDataSet.GetChanges(); if (mychangeDataSet != null) { mySqlDataAdapter . Update(mychangeDataSet.Tables ["MyTable"]); this.myDataSet.AcceptChanges(); myDataSet.Clear(); mySqlDataAdapter.Fill(this.myDataSet, "MyTable"); mydatagridview.DataSource = myDataSet.Tables["MyTable"].DefaultView; } } catch(Exception ex) { MessageBox.Show(ex.ToString ()); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)