VB.net Database User Validation [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 10 years ago.

Improve this question

REAL PROBLEM: I am making a admin control panel for my mysql database. I just learned the most of the stuff in vb.net i know everything now learning query language and i run into this question. I want that there would be a user validator(detector) what i mean is lets say someone is creating an account and the username exist it would show a messagebox that the username already exist and cancel creating the account.

Here is my code:

Imports MySql.Data.MySqlClient
Public Class Deathlairregnu
    Dim MySqlConn As MySqlConnection
    Dim MySqlCmd As MySqlCommand
    Private Sub ButtonNUS_Click(sender As Object, e As EventArgs) Handles ButtonNUS.Click
        MySqlConn = New MySqlConnection
        MySqlConn.ConnectionString =
            "server=localhost;userid=root;password=CONSORED;database=syscore"
        Dim MySqlRea As MySqlDataReader

        Try
            MySqlConn.Open()
            Dim Query As String
            Query = "insert into syscore.normaluser (nusername,nemail,npass,nphone,ncity) values ('" & TextBoxNUsern.Text & "','" & TextBoxNEmail.Text & "','" & TextBoxNPass.Text & "','" & TextBoxNPhone.Text & "','" & TextBoxNCity.Text & "')"
            MySqlCmd = New MySqlCommand(Query, MySqlConn)
            MySqlRea = MySqlCmd.ExecuteReader

            MessageBox.Show("Registration has been completed")
            MySqlConn.Close()
        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MySqlConn.Dispose()
        End Try
    End Sub
End Class

OPTIONAL: Ok. I have another question maybe you can solve at the same time. How could i add guid generator when the register submit button is pressed if you know what i mean? i have it in my website asp.net that i made myself. Would be very nice and helpful.

Big thanks for those who will try to help me. I will check this topic every 5 minutes.

My important question is the username validator the guid is optional. — Martynuks Skirmants
– Martynuks Skirmants, Commented Feb 2, 2015 at 15:28

Community · Accepted Answer · 2017-05-23 12:12:40Z

0

Adding a uniqueidentifier column and adding the default to generate new guid

Downvotes probably because you didn't paste your code here, plus the fact that the question has been asked and answered many times. Did you search before asking?

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Feb 2, 2015 at 15:14

CottonHill

736 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Martynuks Skirmants Over a year ago

Yes i did search and i tried to paste the code here but it didin't work it was in wrong lines and messed up.

Martynuks Skirmants Over a year ago

Ok. Do you know how to validate the username?

CottonHill Over a year ago

stackoverflow.com/questions/15189724/… that has also been asked and answered here.

Martynuks Skirmants Over a year ago

I dont understand. I like when someone give me code example atleast to understand.

Adam Lear · Accepted Answer · 2015-02-03 19:35:36Z

0

I did the important part. Optional is not needed for me but would've been good. Here: https://www.youtube.com/watch?v=ovoVfHW3Q8Y.

edited Feb 3, 2015 at 19:35

Adam Lear♦

38.9k13 gold badges83 silver badges105 bronze badges

answered Feb 3, 2015 at 18:41

Martynuks Skirmants

12 bronze badges

Collectives™ on Stack Overflow

VB.net Database User Validation [closed]

2 Answers 2

4 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Linked

Related