且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

检查vb2010中的用户名可用性

更新时间:2022-12-18 21:58:05

尝试一下
检查用户可用性
Try this
Check user availability


'START .
        Dim conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" & _
    "Data Source=" & Application.StartupPath & "\DBase.accdb;")
        conn.Open()
        Dim Str As String
        Str = "SELECT * FROM DB WHERE [Username] = '" & UsernameTextBox.Text & "'"
        Dim cmmd = New OleDbCommand(Str, conn)
        Dim dr As OleDbDataReader
        dr = cmmd.ExecuteReader()

        If Not dr.HasRows Then
            MsgBox("Username available.")
            'REST OF THE PROGRAM

        Else
            MsgBox("Username already taken. Try another.")
        End If

        'END