control SqlCommand to return a single row

image_pdfimage_print
   
 

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

class SingleRowCommandBehavior {
    public static void Main() {
        SqlConnection mySqlConnection = new SqlConnection("server=localhost;database=Northwind;uid=sa;pwd=sa");

        SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
        mySqlCommand.CommandText = "SELECT ProductID, ProductName, QuantityPerUnit, UnitPrice FROM Products";

        mySqlConnection.Open();
        SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(CommandBehavior.SingleRow);

        while (mySqlDataReader.Read()) {
            Console.WriteLine("mySqlDataReader[" ProductID"] = " + mySqlDataReader["ProductID"]);
            Console.WriteLine("mySqlDataReader[" ProductName"] = " + mySqlDataReader["ProductName"]);
            Console.WriteLine("mySqlDataReader[" QuantityPerUnit"] = " + mySqlDataReader["QuantityPerUnit"]);
            Console.WriteLine("mySqlDataReader[" UnitPrice"] = " + mySqlDataReader["UnitPrice"]);
        }

        mySqlDataReader.Close();
        mySqlConnection.Close();
    }
}