{"id":460,"date":"2006-11-10T20:15:00","date_gmt":"2006-11-10T20:15:00","guid":{"rendered":"http:\/\/www.sincebirth.cn\/?p=460"},"modified":"2006-11-10T20:15:00","modified_gmt":"2006-11-10T20:15:00","slug":"aspnet20vbaccess%e7%9a%84%e8%87%aa%e5%ae%9a%e4%b9%89%e7%99%bb%e9%99%86%e9%a1%b5","status":"publish","type":"post","link":"https:\/\/niuduer.sincebirth.space\/?p=460","title":{"rendered":"ASP.NET2.0(VB)+ACCESS\u7684\u81ea\u5b9a\u4e49\u767b\u9646\u9875"},"content":{"rendered":"
\n

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Login.aspx.vb" Inherits="Login" %><\/p >\n

<!DOCTYPE html PUBLIC "-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN" "http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd<\/a >"><\/p >\n

<html xmlns="http:\/\/www.w3.org\/1999\/xhtml<\/a >" >
\n<head runat="server">
\n    <title>Login<\/title>
\n    <link href="Images\/style.css" rel="stylesheet" type="text\/css" \/>
\n<\/head>
\n<body>
\n    <form id="form1" runat="server">
\n    <div>
\n        <table style="width: 387px">
\n            <tr>
\n                <td style="width: 7px">
\n                    UserName<\/td>
\n                <td>
\n                    <asp:TextBox ID="TextBoxU" runat="server"><\/asp:TextBox><\/td>
\n                <td>
\n                    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBoxU"
\n                        ErrorMessage="*"><\/asp:RequiredFieldValidator><\/td>
\n            <\/tr>
\n            <tr>
\n                <td style="width: 7px">
\n                    Password<\/td>
\n                <td>
\n                    <asp:TextBox ID="TextBoxP" runat="server" TextMode="Password"><\/asp:TextBox><\/td>
\n                <td>
\n                    <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBoxP"
\n                        ErrorMessage="*"><\/asp:RequiredFieldValidator><\/td>
\n            <\/tr>
\n            <tr>
\n                <td style="width: 7px">
\n                <\/td>
\n                <td>
\n                    <asp:Button ID="Button1" runat="server" Text="Login" \/><\/td>
\n                <td>
\n                    <asp:Label ID="LabelErr" runat="server"><\/asp:Label>
\n                    <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~\/Register.aspx" Target="_self">Register<\/asp:HyperLink><\/td>
\n            <\/tr>
\n        <\/table>
\n   
\n    <\/div>
\n    <\/form>
\n<\/body>
\n<\/html>\n<\/p >\n

————————————————————————————————————————<\/p >\n

Imports System.Data.SqlClient
\nImports System.Data
\nImports System.Data.OleDb
\nPartial Class Login
\n    Inherits System.Web.UI.Page
\n    Public p As String   ‘\u4fdd\u5b58\u5bc6\u7801
\n    Public t As Integer   ‘\u4fdd\u5b58\u767b\u9646\u5c1d\u8bd5\u6b21\u6570
\n    Public c As String    ‘\u4fdd\u5b58\u6210\u5458\u8d44\u683c
\n    Public Id As Integer<\/p >\n

 <\/p >\n

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
\n        t += 1
\n        If t < 5 Then<\/p >\n

            Dim ss As String
\n            ss = System.Configuration.ConfigurationManager.ConnectionStrings("ilaConnectionString").ConnectionString<\/p >\n

\n            Dim conn As New OleDbConnection
\n            conn.ConnectionString = ss<\/p >\n

            Dim cmd As New OleDbCommand
\n            cmd.CommandText = "SELECT [Password],[Class],[Id] FROM [User] WHERE [Name] =?"
\n            cmd.Connection = conn
\n            ‘ Create a OleDbParameter for each parameter in the stored procedure.
\n            Dim userNameParam As New OleDbParameter("?", TextBoxU.Text)
\n            cmd.Parameters.Add(userNameParam)
\n            Dim reader As OleDbDataReader = Nothing<\/p >\n

            Try
\n                conn.Open()<\/p >\n

                reader = cmd.ExecuteReader
\n                reader.Read()<\/p >\n

                If reader.HasRows = False Then
\n                    reader = Nothing
\n                Else<\/p >\n

                    p = reader("Password").ToString
\n                    c = reader("Class").ToString
\n                    Id = reader("Id")
\n                End If<\/p >\n

            Catch ex As Exception
\n                Throw New Exception(ex.Message)<\/p >\n

            Finally
\n                If Not (reader Is Nothing) Then
\n                    reader.Close()
\n                End If
\n                If Not (conn Is Nothing) Then
\n                    conn.Close()
\n                    conn.Dispose()
\n                    GC.SuppressFinalize(conn)
\n                End If
\n            End Try<\/p >\n

            If p = TextBoxP.Text Then
\n                Session("User") = TextBoxU.Text
\n                Session("C") = c
\n                Session("Id") = Id
\n                Response.Redirect("Admin\/Default.aspx")
\n            Else
\n                LabelErr.Text = "Sorry,login failed!"
\n            End If
\n        Else
\n            LabelErr.Text = "You have failed more than five times."<\/p >\n

        End If<\/p >\n

    End Sub<\/p >\n

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
\n       t = 0<\/p >\n

    End Sub
\nEnd Class\n<\/p ><\/div>\n","protected":false},"excerpt":{"rendered":"

<%@ Page Language="VB" AutoEventWireup=&qu […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-460","post","type-post","status-publish","format-standard","hentry","category-all"],"views":1882,"_links":{"self":[{"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts\/460","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=460"}],"version-history":[{"count":0,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=\/wp\/v2\/posts\/460\/revisions"}],"wp:attachment":[{"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=460"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=460"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/niuduer.sincebirth.space\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}