病急乱投医!!!!!
我也不知道我问的问题是不是这个板块的,但我用的软件是vb.net对web的,所以就上来问了。
我做的一段用户登陆代码,调试通过了,但要求把对库进行操作的语句,写到类中,
想了一个下午,也没有什么结果,请各位帮忙啊!
Dim TempPassword As String
Dim TempUser As String
TempUser = Trim(TxtUserID.Text)
TempPassword = Trim(TxtPassword.Text)
If Page.IsValid Then
Dim StrConn As String = "user ID = sa; password =;"
StrConn += "database = bugs; server = (local);"
StrConn += "connect timeout =60"
Dim Conn As New SqlConnection(StrConn)
If Conn.State <> ConnectionState.Open Then
Conn.Open()
End If
Dim StrSql As String = "SELECT * FROM muser WHERE userid ='" & TempUser & "'AND passwd='" & TempPassword & "'"
Dim Cmd As New SqlCommand(StrSql, Conn)
Dim Dr As SqlDataReader = Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Dim ReadTrue As Boolean = False
If Dr.Read() = True Then
Dim TempStr As String
TempStr = Dr("sect")
Response.Write("SECT:" & TempStr & "<br>")
End If
Dr.Close()
If Conn.State <> ConnectionState.Closed Then
Conn.Close()
End If
If ReadTrue = True Then
Conn = New SqlConnection(StrConn)
If Conn.State <> ConnectionState.Open Then
Conn.Open()
End If
StrSql = "SELECT msg,msgid FROM mmsg WHERE msgid = 'msg001'"
Cmd = New SqlCommand(StrSql, Conn)
Dr = Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
If Dr.Read() = False Then
Else
Session("msgid") = Dr("msgid")
Response.Write("MSGID:" & Session("msgid") & "<br>")
Session("msg") = Dr("msg")
Response.Write("MSG:" & Session("msg") & "<br>")
End If
Dr.Close()
If Conn.State <> ConnectionState.Closed Then
Conn.Close()
End If
End If
Response.Redirect("PCom002.aspx")
End If
If CInt(lbltemp.Text) = 3 Then
Response.Write("You have no change to enter!")
TxtUserID.Enabled = False
TxtPassword.Enabled = False
Else
TxtUserID.Text = ""
TxtPassword.Text = ""
Response.Write("Id or password error!")
Dim TempInt As Integer = 1
TempInt += CInt(lbltemp.Text)
lbltemp.Text = TempInt
End If
我做的一段用户登陆代码,调试通过了,但要求把对库进行操作的语句,写到类中,
想了一个下午,也没有什么结果,请各位帮忙啊!
Dim TempPassword As String
Dim TempUser As String
TempUser = Trim(TxtUserID.Text)
TempPassword = Trim(TxtPassword.Text)
If Page.IsValid Then
Dim StrConn As String = "user ID = sa; password =;"
StrConn += "database = bugs; server = (local);"
StrConn += "connect timeout =60"
Dim Conn As New SqlConnection(StrConn)
If Conn.State <> ConnectionState.Open Then
Conn.Open()
End If
Dim StrSql As String = "SELECT * FROM muser WHERE userid ='" & TempUser & "'AND passwd='" & TempPassword & "'"
Dim Cmd As New SqlCommand(StrSql, Conn)
Dim Dr As SqlDataReader = Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Dim ReadTrue As Boolean = False
If Dr.Read() = True Then
Dim TempStr As String
TempStr = Dr("sect")
Response.Write("SECT:" & TempStr & "<br>")
End If
Dr.Close()
If Conn.State <> ConnectionState.Closed Then
Conn.Close()
End If
If ReadTrue = True Then
Conn = New SqlConnection(StrConn)
If Conn.State <> ConnectionState.Open Then
Conn.Open()
End If
StrSql = "SELECT msg,msgid FROM mmsg WHERE msgid = 'msg001'"
Cmd = New SqlCommand(StrSql, Conn)
Dr = Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
If Dr.Read() = False Then
Else
Session("msgid") = Dr("msgid")
Response.Write("MSGID:" & Session("msgid") & "<br>")
Session("msg") = Dr("msg")
Response.Write("MSG:" & Session("msg") & "<br>")
End If
Dr.Close()
If Conn.State <> ConnectionState.Closed Then
Conn.Close()
End If
End If
Response.Redirect("PCom002.aspx")
End If
If CInt(lbltemp.Text) = 3 Then
Response.Write("You have no change to enter!")
TxtUserID.Enabled = False
TxtPassword.Enabled = False
Else
TxtUserID.Text = ""
TxtPassword.Text = ""
Response.Write("Id or password error!")
Dim TempInt As Integer = 1
TempInt += CInt(lbltemp.Text)
lbltemp.Text = TempInt
End If
...全文
相关推荐
芯片项目投资不可病急乱投医.pdf
芯片项目投资是一项高风险、高技术要求的投资行为,特别是在全球半导体产业高度专业化和全球化的背景下,对于投资决策和资金投入必须进行严谨的评估和规划。本文将深入探讨芯片项目投资的相关知识点,以期为投资者提供参考
ENVI技术在水利遥感中的应用实践.pdf
很多时候各市也不清楚如何通过信息化手段来支撑业务目标,信息化工作通常都是采用病急乱投医的手段,迫切需要系统化统筹信息化目标;信息
中科山水-esri用户大会演讲材料 1.pdf
很多时候各市也不清楚如何通过信息化手段来支撑业务目标,信息化工作通常都是采用病急乱投医的手段,迫切需要系统化统筹信息化目标;信息
【精品】华为智慧水利行业实践及理解.pptx
很多时候各市也不清楚如何通过信息化手段来支撑业务目标,信息化工作通常都是采用病急乱投医的手段,迫切需要系统化统筹信息化目标;
江河瑞通-基于人工智能的智慧水务解决方案-20180919.pdf
很多时候各市也不清楚如何通过信息化手段来支撑业务目标,信息化工作通常都是采用病急乱投医的手段,迫切需要系统化统筹信息化目标;信息


