Question

ExecuteReader: Connection 属性尚未初始化。

protected void Button1_Click(object sender, EventArgs e)
{
string named = TextBox2.Text;
string Connection = "Provider=Microsoft.Jet.OleDb.4.0;";
Connection += @"Data Source=E:\WebSite1\db1\cj.mdb";
OleDbConnection objConnection = new OleDbConnection(Connection);
objConnection.Open();

string sql = "select [name],[password] from zhuce where name='" + named + "'";
OleDbCommand Olcmd = new OleDbCommand();

OleDbDataReader dr = Olcmd.ExecuteReader();
if (dr.Read())
{

Label5.Text = "<p>姓名：" + Convert.ToString(dr["name"]) + "</p><p>密码：" + Convert.ToString(dr["password"]) + "</p>";
}
else
{
Response.Write("<script type='text/javascript' >alert('您输入的信息有误，请返回后重新输入')</script>");
}
各位高手帮忙看下哪的错误，我郁闷死了都·非常感谢的

Answer 1

OleDbCommand Olcmd = new OleDbCommand();

OleDbDataReader dr = Olcmd.ExecuteReader();

你这里没有指明olcmd所关联的CONNECTION对键亮象稿念宽
改成高咐这样
OleDbCommand Olcmd = new OleDbCommand();
Olcmd.Connection=objConnection;

Answer 2

额，补充下。。耐困前不只没有指定connection,也没有指定昌清commandtext。建议你以后初始化数据库操作对象时，用它带参数的构尺脊造函数来实例化。
OleDbCommand Olcmd = new OleDbCommand(sql,objConnection);