Populate a DataSet object using a SELECT statement : SqlCommand : Database C# Source Code

Populate a DataSet object using a SELECT statement

    
 

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

class PopulateDataSetUsingSelect {
    public static void Main() {
        SqlConnection mySqlConnection = new SqlConnection("server=localhost;database=Northwind;uid=sa;pwd=sa");
        SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
        mySqlCommand.CommandText =
          "SELECT TOP 5 ProductID, ProductName, UnitPrice " +
          "FROM Products " +
          "ORDER BY ProductID";
        SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
        mySqlDataAdapter.SelectCommand = mySqlCommand;
        DataSet myDataSet = new DataSet();
        mySqlConnection.Open();
        Console.WriteLine("Retrieving rows from the Products table");
        int numberOfRows = mySqlDataAdapter.Fill(myDataSet, "Products");
        Console.WriteLine("numberOfRows = " + numberOfRows);
        mySqlConnection.Close();
        DataTable myDataTable = myDataSet.Tables["Products"];
        foreach (DataRow myDataRow in myDataTable.Rows) {
            Console.WriteLine("ProductID = " + myDataRow["ProductID"]);
            Console.WriteLine("ProductName = " + myDataRow["ProductName"]);
            Console.WriteLine("UnitPrice = " + myDataRow["UnitPrice"]);
        }
    }
}

 
    
   
  
   

Related in same category :
• Use the GetOrdinal() method of a DataReader object to get the numeric positions of a column
• How to use the ExecuteScalar() method to run a SELECT statement that returns a single value
• Use the ExecuteNonQuery() method to run INSERT, UPDATE, and DELETE statements
• Use SqlCommand to call SQL and insert data to database table
• Delete data from database using SqlCommand
• Get row count from SqlCommand
• Pass parameters to SqlCommand
• Get row count by 'ExecuteScalar'
• Execute multiple SQL statements(insert) using a SqlCommand object
• execute multiple SELECT statements(select) using a SqlCommand object and read the results using a SqlDataReader object
• Async Command Object
• Use ExecuteXmlReader() to run a SELECT statement that returns XML