using System;using System.Data.SqlClient;namespace DataReaderDemo{  class Program  {    static void Main(string[] args)    {      string constr = "Server = .; user=name;pwd=mima;database=mysql";      SqlConnection myCon = new SqlConnection(constr);      try      {        myCon.Open();        string sql = "select * from mytable01 ";        SqlCommand mycom = new SqlCommand(sql, myCon);        //聲明DataReader        SqlDataReader mydr;        mydr = mycom.ExecuteReader();        if (mydr.HasRows)           {          Console.WriteLine("mytable01中存在數據");        }        else        {          Console.WriteLine("mytable01中不存在任何數據");        }        //----------------方法----------------------        Console.WriteLine("第一列的數據類型"+mydr.GetDataTypeName(0));        Console.WriteLine("獲取對應列的名稱:(第一列)"+mydr.GetName(0));        string mystr = "age";  //直接寫會報異常，需要有個轉換的過程        Console.WriteLine(mydr.GetOrdinal(mystr));        /* 此時將上面的15行的str，換為         *  string sql = "select * from mytable01 where id=1";        if (mydr.Read())        {          Console.WriteLine("取得指定字段的數據：" + mydr.GetValue(0));        }         */        /*將15行的 str更改為：         * string sql = "select * from mytable01 where gender='男'";        object[] myobj = new object[mydr.FieldCount];        while(myde.Read()){          mydr.GetValues(myobj);          foreach (object item in myobj)          {            Console.Write(item + "/t");            Console.WriteLine();          }         }         */        //訪問DataReader 對象時使用索引要比字段名稱快很多        while (mydr.Read())        {          Console.WriteLine(mydr[0].ToString()+",");          Console.WriteLine(mydr[1].ToString() + ",");          Console.WriteLine(mydr["gender"].ToString());        }        //----------------屬性----------------------        Console.WriteLine("表中有幾個字段:"+mydr.FieldCount);        Console.WriteLine("是否關閉："+mydr.IsClosed);        mydr.Close();        Console.WriteLine("是否關閉：" + mydr.IsClosed);      }      catch(Exception ex)      {        Console.WriteLine(ex.Message.ToString());      }      finally      {        myCon.Close();      }      Console.Read();    }  }}