紧急求教：100分送上，小问题一个，因为我是菜鸟

[WebmasterC]

＝＝＝＝＝＝＝＝＝＝＝＝＝＝故障原因============================
“/”应用程序中的服务器错误。
--------------------------------------------------------------------------------

ExecuteReader：Connection 属性尚未初始化。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.InvalidOperationException: ExecuteReader：Connection 属性尚未初始化。
=========================== 代码 =============================
string uid , pwd;
int iLoginPass = -1;

uid = TextBox1.Text;
pwd = TextBox2.Text;
string sQueryUser = "Select count(*) as iCount from UserAccount where UserID = "+uid+" .and. pssword = "+pwd+"";

sqlConnection1.Open();
iLoginPass = (int)sqlCommand1.ExecuteScalar();
sqlConnection1.Close();

switch(iLoginPass)
{
case 0:
Response.Redirect("error.htm");
break;
case 1:
Response.Redirect("/zidacompany/index.htm");
break;
default:
Response.Redirect("queryerror.htm");
break;
}

[wbird]

少了一步sqlConnection1.ConnectionString="...."
在sqlConnection1.Open();前边

[yohomonkey]

你的sqlConnection1有没有用new啊！
SqlConnection sqlConnection1 = new SqlConnection(myConnString);
是不是楼了！

[caiter]

楼上对！少了数据库连接！！

[spring_ok]

string connectionstring = "你连接数据库的连接串";
string uid , pwd;
int iLoginPass = -1;

uid = TextBox1.Text;
pwd = TextBox2.Text;
string sQueryUser = "Select count(*) as iCount from UserAccount where UserID = "+uid+" .and. pssword = "+pwd+"";

SqlConnection sqlConnection1 = new SqlConnection(connectionstring);
SqlCommand sqlCommand1 = new SqlCommand(sQueryUser, sqlConnection1);

sqlConnection1.Open();
iLoginPass = (int)sqlCommand1.ExecuteScalar();
sqlConnection1.Close();

switch(iLoginPass)
{
case 0:
Response.Redirect("error.htm");
break;
case 1:
Response.Redirect("/zidacompany/index.htm");
break;
default:
Response.Redirect("queryerror.htm");
break;
}

[WebmasterC]

问题解决了，谢谢大家支持，不过都不是你们说的原因，是数据库的语句错了