OleDbConnection conn = null;
OleDbDataReader reader = null;
//职称加载
try
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("aa.mdb"));
conn.Open();
OleDbCommand cmd = new OleDbCommand("Select 职称 FROM boyd_teacherstyle", conn);
reader = cmd.ExecuteReader();
teacherstyle.DataSource = reader;
if(reader.Read())
{
teacherstyle.DataTextField="职称";
teacherstyle.DataValueField="职称";
teacherstyle.DataBind();
}
else
{
teacherstyle.Items.Add("请先添加!");
}
}
finally
{
if (reader != null)  reader.Close();
if (conn != null)  conn.Close();
}如题,代码若有问题,麻烦大师指点。

解决方案 »

  1.   

    if(reader.Read())
    这句话已经read一条了
      

  2.   

    OleDbConnection conn = null;
    OleDbDataReader reader = null;
    //职称加载
    try
    {
    conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("aa.mdb"));
    conn.Open();
    OleDbCommand cmd = new OleDbCommand("Select 职称 FROM boyd_teacherstyle", conn);
    reader = cmd.ExecuteReader();
    teacherstyle.DataSource = reader; teacherstyle.DataTextField="职称";
    teacherstyle.DataValueField="职称";
    teacherstyle.DataBind();         if(teacherstyle.Items.Count<1)
          teacherstyle.Items.Add("请先添加!");}
    finally
    {
    if (reader != null)  reader.Close();
    if (conn != null)  conn.Close();
    }