怎么不会执行了？

[rainstar508]

private void Button1_Click(object sender, System.EventArgs e)
{
string strConn="server=Localhost;uid=rainstar;pwd=xsh731620;database=dyxt";
string strCmd="select * from usr where(UserID like '"+TextBox1.Text+"'and UserPwd like '"+TextBox2.Text+"')";
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = strConn;
SqlCommand myCommand = new SqlCommand(strCmd,myConnection);
myConnection.Open() ;
SqlDataReader dr = myCommand.ExecuteReader();

if(dr.Read()==true)
{
Session["UserID"] = TextBox1.Text;
if((string)dr["UserPart"] == "00")
Response.Redirect("admin.aspx");
else if((string)dr["UserPart"] =="01")
Response.Redirect("teacher.aspx");
else
Response.Redirect("student.aspx");
}

else
{

TextBox2.Text="";
Response.Write("<script language='javascript'>alert('错误的用户名或密码，请您重新输入。')</script>");
}

myConnection.Close();


}
}

[yuanxianping]

哪里的问题啊

[uffeng]

问题 1 string strCmd="select * from usr where(UserID like '"+TextBox1.Text+"'and UserPwd like '"+TextBox2.Text+"')";
sql语句用like 不合适吧！！
2 查看数据库连接语句