*SelectOne SqlDataReader 通过SqlDataReader实现一条记录的读取*

---------------------------------------------------------------------------------------------------
*SelectOne SqlDataReader*
private void SelectOne()
{
 string ConnString=ConfigurationSettings.AppSettings["SQLConn"];
 string SelectOneStr="select * from Emp"; //where ID='M001'";
 SqlConnection Sqlcon=new SqlConnection(ConnString);
 SqlCommand Sqlcom=new SqlCommand(SelectOneStr,Sqlcon);
 Sqlcon.Open();
 ArrayList MyListName=new ArrayList();
 ArrayList MyListID=new ArrayList();
 SqlDataReader dbRead=Sqlcom.ExecuteReader();
 string [] AllFiled=new string[dbRead.FieldCount];
 
 if (dbRead.HasRows)
 {
  while(dbRead.Read())
  {
   MyListID.Add(dbRead.GetValue(0));//GetString(0));
   MyListName.Add(dbRead.GetString(1));
   Name.Text+=dbRead.GetString(0).ToString();
   dbRead.GetValues(AllFiled);
   for (int i=0; i<dbRead.FieldCount; i++)
   {
    Response.Write(AllFiled[i]); 
   }
   Response.Write("<br>");
  }
  DataList1.DataSource=MyListName;
  MyList.DataSource=MyListID;
  MyList.DataBind();
  DataList1.DataBind();
 }

 dbRead.Close();
 Sqlcon.Close();
}
---------------------------------------------------------------------------------------------------