Question

在调用“Fill”前，SelectCommand 属性尚未初始化

private void button1_Click(object sender, EventArgs e)
{

String ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\Administrator\\桌面\\db3.mdb";
OleDbConnection myCon = new OleDbConnection(ConnStr);
myCon.Open();
DataTable ReaderTable = new DataTable();

string CMDstring = "Select 读者姓名,年级 From 登录AND读者信息 WHERE 读者编号=@" + this.textBox1.Text;
OleDbCommand CMD = new OleDbCommand(CMDstring,myCon);
CMD.CommandType=CommandType.Text;

OleDbDataAdapter DA = new OleDbDataAdapter();
DA.Fill(ReaderTable);

this.textBox2.Text = ReaderTable.Rows[0][0].ToString();
this.textBox3.Text = ReaderTable.Rows[0][1].ToString();

}

其中的Access文件为

读者编号 读者姓名 年级

Answer 1

DA.SelectCommand = CMD;
DA.Fill(ReaderTable);