Populate a DataSet with multiple DataTable objects using multiple SELECT statements : DataSet : Database C# Source Code

Populate a DataSet with multiple DataTable objects using multiple SELECT statements

    


using System;
using System.Data;
using System.Data.SqlClient;

class MultipleDataTables
{
  public static void Main()
  {
    SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");

    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
    mySqlCommand.CommandText =
      "SELECT TOP 2 ID, FirstName, LastName " +
      "FROM Employee " +
      "ORDER BY ID;" +
      "SELECT ID, LastName " +
      "FROM MyEmployee " +
      "WHERE ID = 9;";

    SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
    mySqlDataAdapter.SelectCommand = mySqlCommand;
    DataSet myDataSet = new DataSet();
    mySqlConnection.Open();
    int numberOfRows = mySqlDataAdapter.Fill(myDataSet);
    Console.WriteLine("numberOfRows = " + numberOfRows);
    mySqlConnection.Close();

    myDataSet.Tables["Table"].TableName = "Employee";
    myDataSet.Tables["Table1"].TableName = "MyEmployee";

    foreach (DataTable myDataTable in myDataSet.Tables) {
      Console.WriteLine("\nReading from the " +
        myDataTable.TableName + "DataTable");
      foreach (DataRow myDataRow in myDataTable.Rows)
      {
        foreach (DataColumn myDataColumn in myDataTable.Columns)
        {
          Console.WriteLine(myDataColumn + "= " +
            myDataRow[myDataColumn]);
        }
      }
    }
  }
}
           
       
    
   
  
   

Related in same category :
• Print DataSet out
• Finding Data
• How to perform a SELECT statement and store the returned rows in a DataSet object
• Populate a DataSet object using a SELECT statement
• Populate a DataSet object with multiple DataTable objects
• Use the Merge() method
• DataSet Delete
• For each row in DataSet, reference the column data by column name
• DataSet Read
• ReadXml
• Open the XML file and read into a DataSet
• Populate a DataSet object with a range of rows from a SELECT statement
• Using Datasets
• Using Multi Tabled Datasets
• Read data from DataSet