请各位帮忙看看！！

s3508 2003-04-03 11:11:03

<%@ import namespace = "System.Data" %>
<%@ import namespace = "System.Data.SqlClient" %>
<script language="C#" runat="server">

private void Page_Load(object sender, EventArgs e)
{
message.Text = "";

if ( IsPostBack )
{
userid.Text = "";
passwd.Text = "";
}
}

private void click_ok(object sender, EventArgs e)
{
string strConn = "user id = sa; passwd = sa; server = lzh; database = project1;";
string strSQL = "select emp.emp01, dept.dep02, emp.emp03, emp.emp04, emp.emp05 from emp, dept where emp.emp01 ='"
+ userid.Text + "' and emp.emp09 ='" + passwd.Text + "'" + " and emp.emp02 = dept.dept01";

SqlConnection myConn = new SqlConnection(strConn);
SqlCommand myCommand = new SqlCommand(strSQL, myConn);
myConn.Open();
SqlDataReader dr = myCommand.ExecuteReader();

if ( dr.Read() )
{
Session["UserID"] = dr.Item[0];
Session["UserDep"] = dr.Item[1];
Session["UserCName"] = dr.Item[2];
Session["UserEName"] = dr.Item[3];
Session["UserEmail"] = dr.Item[4];
Page.Response.Redirect("mainfunction.aspx");
}
else
message.Text = "用户ID或用户密码输入错误!请重新输入!";

myConn.Close();
}

</script>

<html>
<head><title>用户登陆</title>
</head>
<body>
<form runat = "server">
<table width="280" border="1" align="center">
<tr>
<td>用户ID</td>
<td><asp:textbox id = "userid" width = "200" runat = "server" /></td>
</tr>
<tr>
<td>用户密码</td>
<td><asp:textbox id = "passwd" width = "200" textmode = "password" runat = "server" /></td>
</tr>
<tr>
<td colspan="2" align = "center"><asp:button id = "ok" text = "确定" onclick = "click_ok" runat = "server" />
</tr>
</table>
</form>
<br><br>
<h3 align="center"><asp:label ID="message" runat="server" /></h3>
</body>
</html>

请问为什么会出错啊？Item怎么用错了，请前辈指点一下。先谢啦。

...全文