Click here to Skip to main content
15,919,749 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to save Dataset changes (mydataset.GetChanges) to
my sqladapter like this:
C#
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 ());
            }

This work properly for oledb adapter how to use it for sql adapter?
Posted
Updated 11-Mar-13 20:03pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900