SqlDataReaderd作用方法详解

就是一张数据表
public ArrayList GetDealer()
{
ArrayList alGrade = new ArrayList();
SqlConnection Conn = new SqlConnection(SqlConn);
if (Conn.State.ToString() == "Closed")
Conn.Open();
string strSql = "select 经销商姓名 from 经销商表 ";
SqlCommand cmd = new SqlCommand(strSql, Conn);
SqlDataReader dr = null;
try
{
dr = cmd.ExecuteReader();
}
catch (Exception ex)
{

throw new Exception(ex.Message);
}
while (dr.Read())
{
alGrade.Add(dr["经销商姓名"].ToString());
}
if (Conn.State.ToString() == "Open")
Conn.Close();
return alGrade;
}
这