private void btnSql_Click(object sender, EventArgs e)
        {
 
            //creat a dataset
            DataSet dsExcel = new DataSet("Excel");
 
            //create a sql data adapter
            SqlDataAdapter sqlDA = new SqlDataAdapter("Select * from ExcelToSql", sqlConn);
 
            //build commands for the damn data adpater so we can update
            SqlCommandBuilder sqlComm1 = new SqlCommandBuilder(sqlDA);
 
            //fill the dataset, table called Excel
            sqlDA.Fill(dsExcel, "Excel");
 
            //make changes to the dataset
            dsExcel.Clear();
 
            //update please work!!!
            sqlDA.Update(dsExcel, "Excel");
 
 
 
 
        }//end btnSql_Click

dsExcel.Clear();

public static DataSet SelectSqlSrvRows(string myConnection, string mySelectQuery, string myTableName)
{
   SqlConnection myConn = new SqlConnection(myConnection);
   SqlDataAdapter myDataAdapter = new SqlDataAdapter();
   myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
   SqlCommandBuilder cb = new SqlCommandBuilder(myDataAdapter);

   myConn.Open();

   DataSet ds = new DataSet();
   myDataAdapter.Fill(ds, myTableName);

   //code to modify data in DataSet here

   //Without the SqlCommandBuilder this line would fail
   myDataAdapter.Update(ds, myTableName);

   myConn.Close();

   return ds;
}