使用序号访问SqlDataReader中指定列的数据

// 使用序号访问SqlDataReader中指定列的数据

// OrdinalIndexer.cs

using   System;

using   System.Data;

using   System.Data.SqlClient;

using   System.Text;

namespace   Ch12

{

      class   OrdinalIndexer

    {

          static   void   Main(   string [] args)

        {

              string   strConn =   "server=.\\MSSQL2012;integrated security=true;database=Northwind;" ;

              string   sql =   "select firstname,lastname from employees"   ;

              string   strline =   "==" ;          

            SqlConnection conn =   new   SqlConnection(strConn);

              try

            {

                conn.Open();

                SqlCommand cmd =   new   SqlCommand(sql, conn);

                  //创建数据读取器

                SqlDataReader reader = cmd.ExecuteReader();

                  // 在"First Name"的前面填充空格,使其总长度达到11个

                  Console .WriteLine(   "{0}   Last Name" ,   "First Name" .PadLeft(11));

                  // 在"=="前后各填充"="，使其总长度达到11

                  Console .WriteLine(   "{0}   {1}" , strline.PadLeft(11,   '='   ), strline.PadRight(11,   '=' ));

                  while   (reader.Read())

                {

                      Console .WriteLine(   "{0} | {1}" ,

                        reader[0].ToString().PadLeft(11),

                        reader[1].ToString());

                }

                reader.Close();

            }

              catch (   Exception   ex)

            {

                  Console .WriteLine(   "发生错误:"   + ex);

            }

              finally

            {

                conn.Close();

                  Console .ReadLine();

            }

        }

    }

}

----------------------------

 First Name   Last Name

===========   ===========

      Nancy | Davolio

     Andrew | Fuller

      Janet | Leverling

   Margaret | Peacock

     Steven | Buchanan

    Michael | Suyama

     Robert | King

      Laura | Callahan

       Anne | Dodsworth

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/bloodfist/p/3273643.html