病急乱投医!!!!!

xzhy80 xzhy80 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
我也不知道我问的问题是不是这个板块的,但我用的软件是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
...全文

相关推荐

评论 7
收藏 已收藏
分享
返回顶部
xzhy80
VB 16,718 成员 110,520 内容