SqlDataReader.GetSqlInt32 : SqlDataReader « System.Data.SqlClient « C# / C Sharp by API

1. C# / C Sharp by API
2. System.Data.SqlClient
3. SqlDataReader

SqlDataReader.GetSqlInt32

  


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

class StronglyTypedColumnValuesSql {
    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, " +
           "UnitsInStock, Discontinued " +
           "FROM Products " +
           "ORDER BY ProductID";

        mySqlConnection.Open();

        SqlDataReader productsSqlDataReader =
          mySqlCommand.ExecuteReader();

        int productIDColPos = productsSqlDataReader.GetOrdinal("ProductID");
        int productNameColPos = productsSqlDataReader.GetOrdinal("ProductName");
        int unitPriceColPos = productsSqlDataReader.GetOrdinal("UnitPrice");
        int unitsInStockColPos = productsSqlDataReader.GetOrdinal("UnitsInStock");
        int discontinuedColPos = productsSqlDataReader.GetOrdinal("Discontinued");

        while (productsSqlDataReader.Read()) {
            SqlInt32 productID = productsSqlDataReader.GetSqlInt32(productIDColPos);
            Console.WriteLine("productID = " + productID);

            SqlString productName = productsSqlDataReader.GetSqlString(productNameColPos);
            Console.WriteLine("productName = " + productName);

            SqlMoney unitPrice = productsSqlDataReader.GetSqlMoney(unitPriceColPos);
            Console.WriteLine("unitPrice = " + unitPrice);

            SqlInt16 unitsInStock = productsSqlDataReader.GetSqlInt16(unitsInStockColPos);
            Console.WriteLine("unitsInStock = " + unitsInStock);

            SqlBoolean discontinued = productsSqlDataReader.GetSqlBoolean(discontinuedColPos);
            Console.WriteLine("discontinued = " + discontinued);
        }
        productsSqlDataReader.Close();
        mySqlConnection.Close();
    }
}

   
    
  

Related examples in the same category