How to create a Registration /Sign Up form in VB.Net

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ก.ย. 2024
  • Here.. in this video we are doing the registration or sign up form for the person to register for his email id and password with some details.. we are storing data into database. Code given Below.
    Try
    Dim con As New SqlConnection
    Dim cmd As New SqlCommand
    Dim dr As SqlDataReader
    con.ConnectionString = "Data Source=(LocalDB)\v11.0;AttachDbFilename=c:\users\ved prakash n\documents\visual studio 2012\Projects\FundaProjectVB\FundaProjectVB\FundaProject.mdf;Integrated Security=True"
    con.Open()
    cmd.Connection = con
    cmd.CommandType = CommandType.Text
    cmd.CommandText = "select * from register where email='" & email.Text & "' "
    dr = cmd.ExecuteReader
    If dr.HasRows Then
    MsgBox("Email Id Already Registered", MsgBoxStyle.Critical)
    con.Close()
    Else
    con.Close()
    con.Open()
    cmd = New SqlCommand("INSERT INTO register values('" & fname.Text & "','" & lname.Text & "','" & gender.Text & "','" & phone.Text & "','" & email.Text & "','" & password.Text & "')", con)
    If (fname.Text = "" And lname.Text = "" And gender.Text = "" And phone.Text = "" And email.Text = "" And password.Text = "") Then
    MessageBox.Show("Please enter the details")
    Else
    cmd.ExecuteNonQuery()
    MsgBox("Succerssfully Registered.", MsgBoxStyle.Information, "Success")
    Me.Hide()
    login.show()
    fname.Clear()
    lname.Clear()
    gender.Text = " "
    phone.Clear()
    email.Clear()
    password.Clear()
    End If
    con.Close()
    End If
    con.Close()
    Catch ex As Exception
    MsgBox("Error")
    End Try
    .

ความคิดเห็น • 71

  • @karlosmendoza7143
    @karlosmendoza7143 2 ปีที่แล้ว +2

    Dude you are a life saver. I have been watching a lot of videos about register/login but no one could explain like you just did.SUSCRIBED

  • @jerictayson5941
    @jerictayson5941 5 ปีที่แล้ว

    big thanks now i have project on our project salute!

  • @desmondgoldsmith2409
    @desmondgoldsmith2409 4 ปีที่แล้ว +1

    Thanks man
    You are the boss 🤩🤩🤩🤩

  • @global1450
    @global1450 5 ปีที่แล้ว +1

    Sir now got successful sir

  • @manikandandesperado9688
    @manikandandesperado9688 5 ปีที่แล้ว +1

    Big thanks for ur video

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      Thank you for supporting me. :-)
      Please Subscribe, like and share

  • @sarmientoninam.3434
    @sarmientoninam.3434 2 ปีที่แล้ว +1

    Thank you so much Sir❤

  • @YmLongRe
    @YmLongRe 5 ปีที่แล้ว

    wonderful video for registration

  • @emmanuelyusuf2004
    @emmanuelyusuf2004 2 ปีที่แล้ว +1

    Can someone please help me fix this error 'an attempt to attach an auto-named database for file" " failed. a database with the same name exists'

  • @jhosepelipeelpeluka191
    @jhosepelipeelpeluka191 4 ปีที่แล้ว

    Thanks for answering sir

  • @global1450
    @global1450 5 ปีที่แล้ว +1

    Sir it's my project sir
    My topic is visual learning memory game
    My frontend: vb. Net
    My Backend: my SQL
    I need any memory game in vb. Net with codings sir

  • @fatinharissa8419
    @fatinharissa8419 3 ปีที่แล้ว

    Why when i run , pop up msg box "Please Enter correct details" ,but i use microsoft access

  • @coder9091
    @coder9091 3 ปีที่แล้ว

    Thank You!!

  • @global1450
    @global1450 5 ปีที่แล้ว

    Sir it's my project sir
    My topic is visual learning memory game
    My frontend: vb. Net
    My Backend: my self
    I need any memory game in vb. Net with codings sir

  • @global1450
    @global1450 5 ปีที่แล้ว +1

    Sir in this you did show full coding sir please show full coding in registration form Imdetely sir

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      For this video.. I hv given the full code.. in description..
      Plz subscribe, like n share

  • @DivineZulu-x1o
    @DivineZulu-x1o ปีที่แล้ว

    After i run my program,when i enter all the requirements, the msgbox will display an error.whats wrong

  • @evanschit
    @evanschit 5 ปีที่แล้ว

    when I run the program and click on the register button it shows a popup "error". i.e the exception is handled there how can I fix

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem

  • @rizvicomputercodes3968
    @rizvicomputercodes3968 3 ปีที่แล้ว

    Can we drop it in google playstore please reply me sir i want your sir pleass

  • @JY0612-r2v
    @JY0612-r2v 3 ปีที่แล้ว

    Hi sir, there is an error when i run. It say SQL Server Error 26

  • @g10_de_coder
    @g10_de_coder 5 ปีที่แล้ว

    when I run the program and click on the register button it shows a popup "error". i.e the exception is handled there how can I fix . reply me fast its very important.

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem

  • @lakewameneshewa2755
    @lakewameneshewa2755 5 ปีที่แล้ว

    MY PROJECT is my best to add more informationsend to reistraal system

  • @syazwani3285
    @syazwani3285 3 ปีที่แล้ว

    i cant even add the new item? what i supposed to do?

  • @johnumoru9890
    @johnumoru9890 2 ปีที่แล้ว

    Please how do I get this and other videos? on my mail or

  • @timemast3r
    @timemast3r 2 ปีที่แล้ว

    When trying to test the registration I keep getting error when clicking the button please help sir

    • @maranonaprilrose345
      @maranonaprilrose345 2 ปีที่แล้ว

      Hi! How did you fix this? I keep having the same problem

  • @khuntharnaung4366
    @khuntharnaung4366 4 ปีที่แล้ว

    i'd see solution Explorer and i can't do it

  • @jhosepelipeelpeluka191
    @jhosepelipeelpeluka191 4 ปีที่แล้ว

    Sir funda, I cant change the 'Identity Specification' into true.
    I do it on my Microsoft Visual Studio 10

    • @ashwaq9936
      @ashwaq9936 3 ปีที่แล้ว

      How you fixed the problem ? I need help please

  • @global1450
    @global1450 5 ปีที่แล้ว

    Sir do visual learning memory game in vb. Net with codings sir please do imdetely sir

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      What is this ?. Visual learning memory game..!! ..
      Am nt able to get u..
      Try to give me some example... so I cn understand about ur requirement..

  • @global1450
    @global1450 5 ปีที่แล้ว

    For this form error showing sir

  • @patelhuda5542
    @patelhuda5542 5 ปีที่แล้ว

    It shows error on dr=cmd.executereader
    How can i resolve this?
    Please tell me

    • @gladwinmaphuti7703
      @gladwinmaphuti7703 5 ปีที่แล้ว

      Are you using WIN7?

    • @armanshariff4063
      @armanshariff4063 3 ปีที่แล้ว

      im facing the same error what do i do to fix it pls help sir

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      in the register the enter button Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem

  • @farahilyana9964
    @farahilyana9964 3 ปีที่แล้ว

    6:03 start to do table

  • @mamamagagaga3519
    @mamamagagaga3519 5 ปีที่แล้ว

    Sir why I can't create database
    there have a error message

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      If your visual studio databas is not working means... u can use seperate database.. like sql management studio system.. software for database

  • @saloni8899
    @saloni8899 3 ปีที่แล้ว

    Which tool have you used for phone number?

  • @jeronearanzado7430
    @jeronearanzado7430 5 ปีที่แล้ว

    It's show error to me how can I fixed it!!! :(

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem

  • @keenannaidoo1282
    @keenannaidoo1282 3 ปีที่แล้ว

    I need help

  • @global1450
    @global1450 5 ปีที่แล้ว

    Sir this registration form with coding in show in visual Studio 2010 in vb. Net

    • @global1450
      @global1450 5 ปีที่แล้ว

      Imdetily sir please sir

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      Same codes r used.. 2008, 2010 n 2012 n latest too..

  • @gladwinmaphuti7703
    @gladwinmaphuti7703 5 ปีที่แล้ว

    Error occured. Says "Error" from MsgBox("Error"). Cannot accept when I click Register

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem

    • @gladwinmaphuti7703
      @gladwinmaphuti7703 3 ปีที่แล้ว

      @@joshuapsalmochavillo708 that was 1year ago.
      I even lost the work

  • @RaenbowRenegade
    @RaenbowRenegade 5 ปีที่แล้ว

    9:16 what’s varchar for

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      Varchar accepts every alphabet number symbol etc...
      And about the field validation... I have done it seperately..

  • @christianrosales6285
    @christianrosales6285 5 ปีที่แล้ว

    it says error on the msgbox how to fix this problem??

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      Disable the try catch statement.. and thn run the code. N see what is d actual error.

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem

  • @gladwinmaphuti7703
    @gladwinmaphuti7703 5 ปีที่แล้ว

    Where is your LOG IN video?????

  • @global1450
    @global1450 5 ปีที่แล้ว

    Sir down coding show sir

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      Yes... I hv given d code.. down... the video.. u have to click on show more.. in d description .. thn only u cn see it..

  • @lilyandryliani3090
    @lilyandryliani3090 5 ปีที่แล้ว

    Upin ipin

  • @global1450
    @global1450 5 ปีที่แล้ว

    Sir in this you did show full coding sir please show full coding in registration form Imdetely sir

  • @ranmani2611
    @ranmani2611 5 ปีที่แล้ว

    when I run the program and click on the register button it shows a popup "error". i.e the exception is handled there how can I fix

  • @jeronearanzado7430
    @jeronearanzado7430 5 ปีที่แล้ว

    It's show error to me how can I fixed it!!! :(

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem

  • @jeronearanzado7430
    @jeronearanzado7430 5 ปีที่แล้ว

    It's show error to me how can I fixed it!!! :(.

    • @fundaofwebit
      @fundaofwebit  5 ปีที่แล้ว

      Go inside the code and disable the try catch statement, and then run the code.. and then.. you will come to know.. what is the actual error.

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      @@fundaofwebit Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem

    • @joshuapsalmochavillo708
      @joshuapsalmochavillo708 3 ปีที่แล้ว

      Replace the MsgBox("error") into:
      MsgBox(ex.Message) to find out whats the problem