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();
}如题,代码若有问题,麻烦大师指点。
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();
}如题,代码若有问题,麻烦大师指点。
这句话已经read一条了
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();
}