title: Saving Dataset to database
body: <p>I am trying to save a dataset to a database.  I got a dataset from another class, Now changes will be made on the form by a user on a datagridview, then the changed Dataset needs to be saved in the database. </p>
  
  <p>I am using the below code; Its not generating any errors, but the data is not being saved in the database.</p>
  
  <pre><code>public class myForm    
  {    
      DataSet myDataSet = new DataSet();
      public void PouplateGridView()
      {
          try
          {
              SqlService sql = new SqlService(connectionString); // Valid Connection String, No Errors
  
  
              myDataSet = sql.ExecuteSqlDataSet("SELECT * FROM Qualification"); // Returns a DataSet
              myDataGridView.DataSource = myDataSet.Tables[0];
              myDataGridView.AutoGenerateColumns = true;
              myDataGridView.AutoResizeColumns();
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.InnerException + Environment.NewLine + ex.Message, "Error");
              this.Close();
          }
  
      }
  
      private void btnSave_Click(object sender, EventArgs e)
      {
          //myDataSet.AcceptChanges();EDIT:Don't know why, but this line wasn't letting the chane in db happen.
          SqlCommand sc = new SqlCommand("SELECT * FROM Qualification", sql.Connection); //ADDED after Replies
          SqlDataAdapter da = new SqlDataAdapter();
          SqlCommandBuilder scb = new SqlCommandBuilder(da); //ADDED after replies
          da.Update(myDataSet.Tables[0]);
      }
  }
  public class mySqlService
  {
  public DataSet ExecuteSqlDataSet(string sql)
          {
              SqlCommand cmd = new SqlCommand();
              this.Connect();
              SqlDataAdapter da = new SqlDataAdapter();
              DataSet ds = new DataSet();
  
              cmd.CommandTimeout = this.CommandTimeout;
              cmd.Connection = _connection;
              if (_transaction != null) cmd.Transaction = _transaction;
              cmd.CommandText = sql;
              cmd.CommandType = CommandType.Text;
  
              da.SelectCommand = cmd;
  
              da.Fill(ds);
              da.Dispose();
              cmd.Dispose();
  
              if (this.AutoCloseConnection) this.Disconnect();
  
              return ds;
          }
  }
  </code></pre>
  
  <p>What am I doing wrong here? There are ways on the web to save the dataset, if the datset is created, edited and saved in the same class etc., BUT I would like to have the select dataset method in the mySqlService class. How should I, now can save the dataset to the database?</p>
  
  <p>EDIT:
  I have commented the three lines that were required to make the code work. The code works now.</p>