我这个代码为什么老显示出错了而不显示其他两个?(用户登陆)Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
Dim strID As String, strPW As String
strID = Request.Cookies("strID").Value
strPW = Request.Cookies("strPW").Value Dim strConnection As String
Dim strSQL As String strSQL = "Select * From user Where ID='" + strID + "';"//ID是user表里的一个字段
strConnection = "server=(local);database=Web;user id=sa;password=123" Dim objConn As New SqlConnection(strConnection)
Dim objCommand As New SqlCommand(strSQL, objConn)
Dim objReader As SqlDataReader
Try
objConn.Open()
objReader = objCommand.ExecuteReader
If objReader.Read = False Then
lblShow.Text = "该用户名不存在!"
Response.End()
Else
lblShow.Text = "系统载入中请稍候"
End If
Catch a As Exception
lblShow.Text = "出错了!"
End Try
End Sub
'在此处放置初始化页的用户代码
Dim strID As String, strPW As String
strID = Request.Cookies("strID").Value
strPW = Request.Cookies("strPW").Value Dim strConnection As String
Dim strSQL As String strSQL = "Select * From user Where ID='" + strID + "';"//ID是user表里的一个字段
strConnection = "server=(local);database=Web;user id=sa;password=123" Dim objConn As New SqlConnection(strConnection)
Dim objCommand As New SqlCommand(strSQL, objConn)
Dim objReader As SqlDataReader
Try
objConn.Open()
objReader = objCommand.ExecuteReader
If objReader.Read = False Then
lblShow.Text = "该用户名不存在!"
Response.End()
Else
lblShow.Text = "系统载入中请稍候"
End If
Catch a As Exception
lblShow.Text = "出错了!"
End Try
End Sub
解决方案 »
- 判断是否手机号码,我这段代码该怎样改
- 怎样用Javascript在treeview某一节点前面插入一个新节点
- 将数据导入Excel的时候,出现多个Excel进程如何杀死?
- 为什么iis中一配上ip地址浏览器就访问不了aspx页呢?有谁碰到过这种情况吗?
- 今天面试了几道题,大家看看能答对几道哦!!要英文回答哦!!! (刚才帖子忘记给分了,现在补上)
- 怎样使DataGrid默认的每一列都变成不自动换行?
- 用户控件问题,如何让控件的属性可以在设计器中显示出来?(*.ascx)
- 又问
- 请各位,帮我看一下vs2005中的类找不到textbox对象应当怎样声明,急急急!
- 怎样强行关闭窗口?
- 请教该技术的实现?
- datagrid中关于动态改变某个Cell背景颜色的难题?
strID = Request.Cookies("strID").Value
要确保你的strID有值。负责有异常抛出噢
3楼:我在前面页面做了一个判断:
If txtID.Text = "" Then
Response.Write("<script language=jscript>alert('请输入用户名!');</script>")
Response.End()
End If
4楼:把列名改成U_ID仍然有误,不过受到您的启发,我把user表名改成users,把表里的字段全改成 U_*,结果成功了!