VB.NET - How To Create Login Form With SQL Database Using Visual Basic .Net [with source code]

Sdílet
Vložit
  • čas přidán 8. 09. 2016
  • VB Net Login Form With Database
    Source Code: 1bestcsharp.blogspot.com/2016/...
    ----------------- Check out my VB.Net Projects! -------------------
    ▶ Inventory Management System - bit.ly/Vbnet_Inventory_System
    ▶ Students Information System - bit.ly/2MsvUp7
    ▶ Contacts Management System - bit.ly/2GzxnGQ
    ▶ Hotel Management System - bit.ly/VbnetHotelSystem
    ▶ Real Estate Management System - bit.ly/VBNet_RealEstate
    ▶ Library Management System - bit.ly/3A7hrXE
    ▶ All My Programming Projects Here - bit.ly/2HrU8hK
    ▶ My Source Code Store Here - bit.ly/2OsC0TU
    ---------------------------------- VB.NET PRODUCTS -----------------------------------
    ▶ Get VB.NET Projects Bundle - bit.ly/VBNetProjectsBundle
    ▶ Take VB.Net Course - bit.ly/2wnNiVt
    --------------------------------------------------------------------------------------------------------
    Programming Projects:
    1bestcsharp.blogspot.com/p/pro...
    visit our blog 1bestcsharp.blogspot.com/
    instagram: / 1bestcsharpblog
    facebook: / 1bestcsharp
    twitter: / 1bestcsharp_
    subscribe: goo.gl/nRjPKk
    C# And Java Programming Books
    1bestcsharp.blogspot.com/2015/...
    In This VB.NET Tutorial We Will See How To Make Login Window With Microsoft SQL DataBase And Visual Basic .NET Programming Language.
    subscribe for more tutorials
    VB.NET And SQL Server Database Tutorials:
    Connect SqlServer Database With Vb.net
    • VB.NET And SQL Server ...
    Select And Display Data From SQL Server Database Using Vbnet
    • VB.NET And SQL Server ...
    Insert Data Into SQLServer Database Using VB NET
    • VB.NET And SQL Server ...
    Update Data In Database Using Vbnet
    • VB.NET And SQL Server ...
    Delete Data From SQL Server Database Using Visual Basic .NET
    • VB.NET And SQL Server ...
    Search Values From SQL Server Database And Set It Into TextBox In Visual Basic .NET
    • VB.NET - How To Search...
    Populate ComboBox From SQL Values In VbNet
    • VB.NET - How To Popula...
    SQL Server Records Navigation Using Visual Basic.Net
    • VB.NET And SQL Databas...
    Datagridview Search Data Using VB.Net
    • VB.NET And SQL - Datag...
    Insert Update Delete
    • VB.NET And SQL - How T...
    Login Form With SQL Database
    • VB.NET - How To Create...
    VB NET Using SQL Stored Procedures
    • VB.NET - Using SQL St...
    Insert Image Into SQL DataBase
    Part 1: • VB.Net - Insert Image ...
    Part 2: • VB.Net - Insert Image ...
    Retrieve Image From SQL DataBase In Visual Basic.net
    • VB.Net - How To Retrie...
    Retrieve Images From SQL DataBase Into DataGridView In VB.net
    • VB.Net - Retrieve Imag...
    Inventory Management System in Visual Basic.Net:
    • VB.Net Inventory Manag...
    CZcams Channel
    ▶ / 1bestcsharpblog
    #vb #vbnet #visualbasic #visualbasicdatabase #Programming #Login #SQLServer #1BestCsharp

Komentáře • 126

  • @marioport4201
    @marioport4201 Před 4 lety +4

    THANK YOU, I had problems changing from Sql to OleDb, but it WORKED. THANK YOU SO MUCH. I've been researching this for over 2 months and finally, your video has helped me!!

  • @estrellaverbeck
    @estrellaverbeck Před 6 lety +4

    You're the best person in the whole word for (12:40 mins) thank you so much for this tutorial. I've spent 3days racking the internet for this. I'm very grateful. Remain blessed!

  • @tambayanniadam3110
    @tambayanniadam3110 Před 3 lety +2

    Thank you very much! Your code is way more simple than what my prof is teaching us before..

  • @napoleonboyles6657
    @napoleonboyles6657 Před 6 lety

    You sir really save my life.. thanks a lot !! looking forward to your posts..

  • @4323prince
    @4323prince Před 6 lety +2

    Thank you so much for the Tut it works really good but it seems when the Sql Server state has stopped i get the Adapter.Fill(table) error but turning it on then No error help please anyway to open the server on the click of the Login Button, thanks in advance...i would really appreciate

  • @priteshkothiya5263
    @priteshkothiya5263 Před 7 lety +5

    This Video Is Very Helpfull For Create Login From Thanks .......

  • @thamsanqajamella8022
    @thamsanqajamella8022 Před 7 lety +21

    What's up with mandatory VB.NET tutorials being on mute??? Like, we're a banished language when it comes to sound! :(

  • @ahmeddhaqan7951
    @ahmeddhaqan7951 Před 5 lety +2

    thanks man i liked the way you make it

  • @fireburnudown
    @fireburnudown Před 4 lety

    Im not sure what im doing wrong, its letting me login regardless if the username and password is correct or not. Im using a local mdf file created in visual studio if thats any different.

  • @Silver-nm2if
    @Silver-nm2if Před 4 lety +1

    sir can you please make a video explaining how to install this in client's machine? im using mysql... do i need to install mysql to clients machine too?

  • @sameerboipai2739
    @sameerboipai2739 Před 5 lety +1

    Thank you sir, it was really helped me out.

  • @broaxconde6302
    @broaxconde6302 Před 7 lety

    hey bro, did you try already logging in without typing the username and password?..

  • @jmagudom
    @jmagudom Před 6 lety +1

    Error adapter.Fill(table)...
    thank you for the tutorial but can you explain this?

  • @gemharlbalderas2647
    @gemharlbalderas2647 Před 7 lety +1

    adapter.Fill(table)-SQLException was unhandled
    Can you help me to fix this?

  • @ahmedelkhadragie
    @ahmedelkhadragie Před 5 lety

    please i need your help quickly , first : what is the difference between Username and @username in that SQL command ?
    second , can i do the same steps when it Local Database vb.net 2010 !?

  • @softarn5554
    @softarn5554 Před 6 lety +2

    Type 'VBNET_SQLInsert_Update_Delete' is not defined. Can someone help me?

  • @jananigandhiiasjana7645
    @jananigandhiiasjana7645 Před 6 lety +1

    thank you its very helpful for me...

  • @COYNEY
    @COYNEY Před 4 lety +1

    Excellent video worked perfect

  • @snehalcreations2124
    @snehalcreations2124 Před 6 lety

    Nice video, I have visual studio 2010, how can i get the sql server. In data connection how can i have my own database. Please explain.

  • @JJ-oc1vo
    @JJ-oc1vo Před 7 lety

    adapter.fill (table) was unhandled. When I removed , it runs but always Showing Usename or Password Are invalid even I input the right one based obn my Sql server. Can you Help me Sir? By the way this is for Soft Eng. Thanks

  • @marisollopezvelasco8815

    one question if i want know if the user or password is invalid, how can i send in a messeger i seying
    which one is wrong

  • @snehasish9954
    @snehasish9954 Před 5 lety +1

    thank you sir,You help me a lot.......

  • @YopilBuddy
    @YopilBuddy Před 6 lety

    please where i can get the SERVER ? i mean like the server samsung-pc ?

  • @virackbotjr666
    @virackbotjr666 Před 6 lety

    How to create user permission in VB.net.
    Example: Some user set on SQL is read is can only view can't control the button or edit
    , and some user set Write is can control button but can't view report.
    Thank before. Please reply....

  • @jomelcadiente5138
    @jomelcadiente5138 Před 4 lety

    There's an error to
    adapter.Fill(table)
    It says. Key must not be null
    Note: I don't have any parameter or column named parameter and yet the error keeps saying key must not be null

  • @samatarsam4514
    @samatarsam4514 Před 5 lety +2

    thanks man my hat's of for you .

  • @jeffdove7515
    @jeffdove7515 Před 5 lety +1

    Sir, can you upload video login with multiple access like admin or user?

  • @khalidabdeddaim3065
    @khalidabdeddaim3065 Před 7 lety +1

    eres el mejor muchas gracias

  • @besamahmed692
    @besamahmed692 Před 2 lety

    How can i permit only one user to log in into my application at the same time and update database, Access local database?, because when more than one user logs in at the same time only the first will have his data stored in Access database file and not the others. Do you have a solution for this issue pls?

  • @abdulmuqtadiryunus8989

    this really help me.

  • @sw8serinate
    @sw8serinate Před 6 lety

    what if every account have a different accountPIN inside the database and i want to see if the logged in account is for the admin? how can i save the value to a variable so i can compare it?

    • @1BestCsharpblog
      @1BestCsharpblog  Před 6 lety

      add "accountPIN" to your select and use if to check if the user is an admin or not

  • @yohannesfrance
    @yohannesfrance Před 5 lety +1

    big thanks brother...

  • @PurpleSoft2024
    @PurpleSoft2024 Před 7 lety

    I got an error adapter.fill(table) need help

  • @abhishekabhi6277
    @abhishekabhi6277 Před 5 lety

    How did you create connect_to_sql form

  • @AmrZeek
    @AmrZeek Před 4 lety +2

    thanks a lot you solved my problem may Allah bless you....

  • @nikhilsingnapure5170
    @nikhilsingnapure5170 Před 6 lety +1

    Prob: adapter.Fill(table)
    Soln:- Just go to your database table, drop old table or delete it and create new with entities with nvarchar to varchar(MAX) it will fix this error.Cheers!

  • @fazza9936
    @fazza9936 Před 5 lety

    how if use ODBC Connection dude?

  • @kaustubhkoshe1239
    @kaustubhkoshe1239 Před 3 lety

    I get error parameter is not member of string and value of type string can't be converted to sqlcommand

  • @tondev3859
    @tondev3859 Před 5 lety +1

    Thank you a lot

  • @SerDex_Adventures
    @SerDex_Adventures Před 5 lety

    adapter.Fill(table)
    ERROR! please help

  • @zxc723281
    @zxc723281 Před 7 lety

    如何別人的計算機上生成的EXE的工作?

  • @nadiamalik8805
    @nadiamalik8805 Před 4 lety

    Adapter.fill (table) error what should I do?

  • @ThatsDeXes
    @ThatsDeXes Před 6 lety

    Can u do retrieve plzz like when you want to make names generator and you click generate and it shows up in the text box?

  • @rajdeepsingh77729
    @rajdeepsingh77729 Před 2 lety

    Thanks sir
    Please Tell me which version of SQL server database

  • @imdolf7308
    @imdolf7308 Před 4 lety +2

    Well, thanks :)

  • @andykissearth4188
    @andykissearth4188 Před 4 lety

    sir why not try ordering system? thanks ;)

  • @JanPR1406
    @JanPR1406 Před 3 lety

    It wont let me login with the 2nd username & password, help?

  • @PrOHacK4FuN
    @PrOHacK4FuN Před 5 lety

    where is for registration ?

  • @enricojosephbarrera2409

    Table1TableAdapter.Update(Your_DatabaseDataSet.Table1) not working

  • @3noudalhzaa359
    @3noudalhzaa359 Před 7 lety

    thank you so mach

  • @jayantsuryavanshi7313
    @jayantsuryavanshi7313 Před 6 lety

    Sir blood bank management system se related kuch banayie na.

  • @firstlivetv8158
    @firstlivetv8158 Před 6 lety +1

    thanks

  • @gerardogonzalez184
    @gerardogonzalez184 Před 3 lety

    Muchas gracias por la ayuda

  • @Rizki_Indra19
    @Rizki_Indra19 Před 7 lety

    Sangat Membantu

  • @OhMyTito
    @OhMyTito Před 3 lety

    how you get the vbnet_sql_insert_update_delete

  • @JonathanIsmaila
    @JonathanIsmaila Před 5 lety

    Please why is there no sound. It would be better if we could hear voice instructions

  • @mdh2347
    @mdh2347 Před 2 lety

    hello thanks for the tutorial, but i encountered some Errors
    Error BC30002 Type 'SqlConnection' is not defined.
    Can you Help me with that errors? the type SqlConnection didn't show in the namesapaces
    Thank you

  • @nadiasadiq7827
    @nadiasadiq7827 Před 6 lety +1

    I am getting error on
    adaptor.fill(table)
    How to solve it?

    • @GopikiruthiGKE
      @GopikiruthiGKE Před 6 lety

      I am getting an error on adaptor.fill(table)...how to rectify it?

    • @ahmedabditahliil76
      @ahmedabditahliil76 Před 5 lety

      try to check your server name, database name thanks

    • @mequadesha
      @mequadesha Před 5 lety

      @@ahmedabditahliil76 Ahmed thanks a lot and i already name the database name Thanks HaHaHa

  • @saurabhsingh44
    @saurabhsingh44 Před 7 lety +5

    I'm getting error on
    adapter.Fill(table)
    SQLException was unhandled
    can anyone please help me???

    • @hafizzhishamm7221
      @hafizzhishamm7221 Před 7 lety +1

      me too , help pls

    • @Danc243
      @Danc243 Před 7 lety

      ad .ToString() at least cmd.Parameters.Add("@contrasenia", SqlDbType.VarChar).Value = txtLoginPassword

    • @NarutoUzumaki-jg6pw
      @NarutoUzumaki-jg6pw Před 7 lety

      Server= name of your server ; Database = name of your database; Integrated Security = true

    • @johangodinho
      @johangodinho Před 5 lety

      add ",conn' or the name of the variable holding connection information next your your query in the end

  • @EricBamTV
    @EricBamTV Před 6 lety

    can I use this source code for Mysql?

  • @bossepipes3917
    @bossepipes3917 Před 7 lety

    fist i input the invalid username then second input another wrong username and error comes out. saying "@username already decclared" help me please

    • @1BestCsharpblog
      @1BestCsharpblog  Před 7 lety

      i can't see your code
      but you can see the source code of this login form ( link in the description )

    • @bossepipes3917
      @bossepipes3917 Před 7 lety

      Same as your codes. By the thanks for your response

  • @yahye9909
    @yahye9909 Před 4 lety +1

    thank you very much

  • @liv3boy72
    @liv3boy72 Před 5 lety

    bhaii vb.net me sql connection create karke banao ye video to easy rahega connection ke saath

  • @jacjessie
    @jacjessie Před 6 lety +1

    I'm getting an error to adapter.Fill(table). Please help me. Please.

  • @schoolexcelwithkris7585
    @schoolexcelwithkris7585 Před 6 lety +2

    Adapter.Fill(table) error
    Cant log in. Please help.

  • @miraclesindecember6842

    Can u plz upload the source code of 2nd form for inserting n deleting????

  • @ruseldublin1235
    @ruseldublin1235 Před 7 lety

    the if statement got the wrong entry,,and the else statement got the correct entry... how about the vice versa

    • @1BestCsharpblog
      @1BestCsharpblog  Před 7 lety +1

      in this program
      if = login false,
      else = login true,
      you can change this by making the if statement check if the one row exists,
      and the else if no row exists

    • @ruseldublin1235
      @ruseldublin1235 Před 7 lety

      can you explain it in codes?

    • @1BestCsharpblog
      @1BestCsharpblog  Před 7 lety +1

      just go to the source code link and change the if condition ( source code link in the description )

  • @JC02official
    @JC02official Před 4 lety

    I learn better when people use their voice.

  • @gabrielavila953
    @gabrielavila953 Před 5 lety +1

    THANKS BUT HOW CAN I FIX
    Dim frm As New VBNET_SQL_Insert_Update_Delete()
    IS NOT WORKING ON ME

  • @princeabadi2889
    @princeabadi2889 Před 2 lety

    where to find server name? for you it is server = SAMSNG - PC... how do I know mine?

    • @1BestCsharpblog
      @1BestCsharpblog  Před 2 lety +1

      from google:
      In the window the window that appears on the bottom-left hand corner of your screen type the letters "cmd" into the "Open" field of the run menu. After you press enter, a new window should open. In this window, type "Hostname" and press enter. the name of your computer will be displayed.

    • @princeabadi2889
      @princeabadi2889 Před 2 lety

      @@1BestCsharpblog thanks alot

  • @minhangbinh9604
    @minhangbinh9604 Před 6 lety

    System.Data.SqlClient.SqlException at adapter.Fill(table)

    • @4323prince
      @4323prince Před 6 lety

      thank you for the help but i still don't understand

    • @ahmedabditahliil76
      @ahmedabditahliil76 Před 5 lety

      try to check your server name, database name thanks

  • @muhamadnabil6750
    @muhamadnabil6750 Před 7 lety

    wtf bro!!
    i'm still beginner, how can i know how to create database if you're didnt show me how..

    • @1BestCsharpblog
      @1BestCsharpblog  Před 7 lety +8

      instead of writing this stupid comment search on google, it's easy

  • @ahmedabditahliil76
    @ahmedabditahliil76 Před 5 lety

    Hello.... Fore those of you Who are Having Adapter.Fill(table) error try to check your server name, database name thanks ##1BestCsharp blog

  • @loquendo0330
    @loquendo0330 Před 4 lety

    NO FUNCIONA WE

  • @panhavisaltong7708
    @panhavisaltong7708 Před 7 lety

    It is not secure while it's code can be viewed :)

  • @dracula5736
    @dracula5736 Před 6 lety

    ProLzI

  • @shakeralqadhi7687
    @shakeralqadhi7687 Před 5 lety

    عربي

  • @user-ct2iv9gj3e
    @user-ct2iv9gj3e Před 4 lety

    Why connect to your localhost computer?
    Need remote access to the server remotely.
    You Login Form connect to - DB Table "Table_login" without password DB "TestDB? ^_^
    Why? MySQL TestDB without password? ^_^
    You Login Form - is NOT Login Form! You Login Form is WORK CHECK - DB Table "Table_login"
    Need - LOGIN FORM TO REMOTE ACCESS.

  • @imabishekk240
    @imabishekk240 Před 3 lety

    .

  • @unknownanonymous327
    @unknownanonymous327 Před 5 lety

    rip...

  • @anotidaishechimedza928

    YOU ARE COPYING AND PASTING CODES I DONT EVEN KNOW HOW TO CONNECT TO THE DATABASE THATS WHERE YOU SHOULD SHOW STEP BY STEP EVERYTHING NOT SHOW FROM SOMETHING THAT HAS ALREADY BEEN DONE I WANT TO KNOW STEP BY STEP HOW EVERY STEP IS DONE....I WILL LEAVE A LIKE

    • @1BestCsharpblog
      @1BestCsharpblog  Před 3 lety

      here's the video on how to connect to mysql - czcams.com/video/dObsPynYdO0/video.html