Populate a DataSet object with a range of rows from a SELECT statement : DataSet : Database C# Source Code

Populate a DataSet object with a range of rows from a SELECT statement

    

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

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

    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
    mySqlCommand.CommandText =
      "SELECT TOP 5 ID, FirstName, LastName " +
      "FROM Employee " +
      "ORDER BY ID";
    SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
    mySqlDataAdapter.SelectCommand = mySqlCommand;
    DataSet myDataSet = new DataSet();
    mySqlConnection.Open();

    Console.WriteLine("Retrieving rows from the Employee table");
    int numberOfRows = mySqlDataAdapter.Fill(myDataSet, 1, 3, "Employee");
    Console.WriteLine("numberOfRows = " + numberOfRows);

    mySqlConnection.Close();

    DataTable myDataTable = myDataSet.Tables["Employee"];

    foreach (DataRow myDataRow in myDataTable.Rows)
    {
      Console.WriteLine("ID = " + myDataRow["ID"]);
      Console.WriteLine("FirstName = " + myDataRow["FirstName"]);
      Console.WriteLine("LastName = " + myDataRow["LastName"]);
    }
  }
}
           
       
    
   
  
   

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
• Populate a DataSet with multiple DataTable objects using multiple SELECT statements
• 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
• Using Datasets
• Using Multi Tabled Datasets
• Read data from DataSet