Question

这段代码错在哪？asp.net（c#）

请帮我检查一下以下代码哪里有错误：

int num;
while(read.Read())
{
num = (Int32)read[0];

for (int i = 1; i <= num; i++)
{
Label control = new Label();

string sqltm = "select 题目,A,B,C,D from 题库 where 题号='" + i + "'and 课程名='" + Session["course"].ToString() + "'";
OleDbCommand cmdtm = new OleDbCommand(sqltm, conn);
OleDbDataReader reader = cmdtm.ExecuteReader();

control.Text = i.ToString() + reader["题目"];
control.Text=i.ToString();
PlaceHolder1.Controls.Add(control);
PlaceHolder1.Controls.Add(new LiteralControl("<br>"));

}

}

为什么OleDbDataReader reader = cmdtm.ExecuteReader();这一段老出现绿色提示，运行不过去呢？

Answer 1

OleDbCommand cmdtm = new OleDbCommand(sqltm, conn);
OleDbDataReader reader = cmdtm.ExecuteReader();
改成
OleDbCommand cmdtm = new OleDbCommand(sqltm, conn);
cmdtm.open()
OleDbDataReader reader = cmdtm.ExecuteReader();