How to create login form with ms-access database in vb.net

Поделиться
HTML-код
  • Опубликовано: 11 сен 2018
  • VB.NET Video tutorial about creating login form in visual studio using ms-access database
    for adding more accounts into database follow given link below
    • VB.NET | How to create...
    Here's a complete module in vb.net login module(login+registration+checkduplicate number using access database)
    • VB.NET - Create login ...
    After you found this one is helpful Dont Forget to LIKE-SUBSCRUBE and SHARE.
  • НаукаНаука

Комментарии • 101

  • @alphaq808
    @alphaq808  4 года назад +6

    If you need any other help about visual basic coding just feel free to ask in the comments section. surely you'll get a helping hand. :) Thank you...

    • @sandwitch00
      @sandwitch00 4 года назад +5

      hye..i got problem with dim count = convert.toInt32(cmd.ExecuteScalar())..
      can you help me?

    • @alfredanero9686
      @alfredanero9686 4 года назад

      @@sandwitch00 same to my problem.

    • @sandwitch00
      @sandwitch00 4 года назад

      @@alfredanero9686 so what the solving

    • @sandwitch00
      @sandwitch00 4 года назад

      @@alfredanero9686 did you already got it?

    • @alfredanero9686
      @alfredanero9686 4 года назад

      @@sandwitch00 i dont know how.

  • @DeagleDamo
    @DeagleDamo 5 лет назад

    Hi mate, Just followed this through step by step after watching hours of tutorials that dont work and this one worked and is amazing!, thank you dude!

  • @mizanzlk
    @mizanzlk 3 года назад +1

    Thank you so much. Works like a charm! Just need to change the table name in the coding to mine in Access and good to go.

  • @mannukim
    @mannukim 5 лет назад

    hey ALPHA you've helped a lot thanks.

  • @mohammedsaeeddowelbite386
    @mohammedsaeeddowelbite386 4 года назад

    thank you very much good lecture that I benefit from it

  • @gabo7966
    @gabo7966 2 года назад

    Very helpful thank you!

  • @startpointcorporation9203
    @startpointcorporation9203 4 года назад

    Thanks! Great Tutorial

  • @kh-music2328
    @kh-music2328 4 года назад +5

    help me. System.InvalidOperationException: 'ExecuteScalar requires an open and available Connection. The connection's current state is closed.'Dim count = Convert.ToInt32(cmd.ExecuteScalar())
    If (count > 0) Then

  • @janakahewage8327
    @janakahewage8327 2 года назад

    Thank You so much its work Nicely

  • @adamwhite1971
    @adamwhite1971 4 года назад

    Easy to follow and fast, thank you very much!

  • @dweignharly3988
    @dweignharly3988 4 года назад

    Thankyousomuch! Godbless

  • @starlova2444
    @starlova2444 5 лет назад

    Great job thank you

  • @stxz003
    @stxz003 3 года назад

    thank you bro !!!!!

  • @kentesver8107
    @kentesver8107 5 лет назад

    Hello. Can you please help me? I just followed the steps but unfortunately it doesnt work on me it says that "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll" please help me.

  • @ThaidrillLao
    @ThaidrillLao 3 года назад

    thank you so much

  • @adeeghayemarket
    @adeeghayemarket 4 года назад

    Thank you very much how i can use module to connect access 2019 and visual studio 2019 thanks again

  • @jahzielperalta484
    @jahzielperalta484 4 года назад

    Nice background bro

  • @anishazadmusical5821
    @anishazadmusical5821 2 года назад

    great great and great😭

  • @scorphack9190
    @scorphack9190 5 лет назад

    thanks

  • @kalbaryo-chika-gaming
    @kalbaryo-chika-gaming 3 года назад

    System.Data.OleDb.OleDbException: 'The Microsoft Jet database engine cannot find the input table or query 'login'. Make sure it exists and that its name is spelled correctly.'
    i have this problem can you help me?

  • @bhoomisamadhiya382
    @bhoomisamadhiya382 3 года назад

    Getting an error system.data.oledb.oledbException for connection.open() , what I should do?

  • @mcbryan2243
    @mcbryan2243 2 года назад

    currently using vs 2019, why am i missing the oledDbConnection

  • @thethornface1485
    @thethornface1485 3 года назад

    why my connection.open() has an oledb exception "Invalid authorization specification"

  • @marbasnoviedamee.5960
    @marbasnoviedamee.5960 3 года назад

    It says that may dim count =Convert.ToInt32(cmd.ExecuteScalar())
    Has no value given for one or more required parameters. why is that?

  • @kgosimagano8966
    @kgosimagano8966 3 года назад

    Thanks so much for this video, it really helped me with my college assignment! Now going off-topic here, what's the name of the background music at 2:08 ?

    • @crazi657
      @crazi657 3 года назад

      Song
      Rise Up (Radio Edit)
      Artist
      Yves Larock feat. Jaba
      Album
      Yves Larock's Classic

  • @CodingXpert
    @CodingXpert 3 года назад

    The Microsoft Access database engine cannot find the input table or query login ....this error come

  • @w4tchmonk3y51
    @w4tchmonk3y51 4 года назад

    kuys may tanong ako. pag ka login ko gusto ko kasi sya automatic mag close yung login form pag nag show yung kasunod nyang dialog box

  • @nigelmasiya423
    @nigelmasiya423 3 года назад +1

    having a problem when l click login the problem will be indicating >>{(cmd.ExecuteScalar())}

  • @kyrollosemad5319
    @kyrollosemad5319 4 года назад +1

    help me. i can not add the database after clicking the "new connection" button and browse the database when i click test connection it appears this message box "unrecognized database format" and the location of the file

    • @alphaq808
      @alphaq808  4 года назад

      What's the version of ms office you are using ?

    • @mrblackblade9217
      @mrblackblade9217 4 года назад

      @@alphaq808 Office 365

    • @mrblackblade9217
      @mrblackblade9217 4 года назад

      @@alphaq808 Does it not work with newer versions?

    • @kyrollosemad5319
      @kyrollosemad5319 4 года назад

      @@mrblackblade9217 i've finally found the solution! 😎😎
      you have to download and install the Microsoft Access Database Engine 😃
      you can use this link: 👇👇👇👇👇👇👇
      www.microsoft.com/en-us/download/details.aspx?id=54920

  • @09-poonamkhandagale92
    @09-poonamkhandagale92 2 года назад

    It showing exception unhandled, What should I do ?

  • @DeagleDamo
    @DeagleDamo 5 лет назад

    At the moment this only gets the one user name and password from the database, do you know howi could add more usernames and passwords in and use more accounts?

    • @alphaq808
      @alphaq808  5 лет назад +1

      Create sign up page to add more Accounts in Database.

  • @sumathivelmurugan4708
    @sumathivelmurugan4708 3 года назад

    I got test connection failed and i am getting this error microsoft.ace.provider is not registered on local machine. how to solve this issue

  • @priyadharsinir1469
    @priyadharsinir1469 4 года назад

    When I give a password field value as integer it doesn't show any error msg... Bt when I give a password field value as date format it shows a error msg at Dim count = convert.ToInt32(cmd.ExecuteScalar()) what should want to do??? Did I want to change a code for that particular line..... Can u help me??

    • @alphaq808
      @alphaq808  4 года назад

      Mate, can you be more specific about error? What is the error msg ?

  • @shasvatasyivaan9869
    @shasvatasyivaan9869 4 года назад

    "An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dll " this shows at the connection state which has connection Closed and connection Open

    • @alphaq808
      @alphaq808  4 года назад

      Varify code again, you'll get the missing point.

  • @tarunkumar6181
    @tarunkumar6181 4 года назад +2

    please do us a favor and kindly remove the background music. its pretty loud and drowns out your words

  • @michaelmothiba465
    @michaelmothiba465 3 года назад

    How can i fix the system.missingmemberexception error

  • @frogt6931
    @frogt6931 4 года назад

    Can u make this video by using 2 form which are login and register use the access?

    • @alphaq808
      @alphaq808  4 года назад

      Why not, just give me a day and I'll give you a link of new video. :)

    • @frogt6931
      @frogt6931 4 года назад

      Hope u can make it more easier, thank you

    • @alphaq808
      @alphaq808  4 года назад +1

      ruclips.net/video/qlKAyKEfqHg/видео.html, hope, you'll get what you asked for.

  • @fategaming123
    @fategaming123 Год назад

    Was trying to watch.. But the background music. Loud af

  • @merlingracy9588
    @merlingracy9588 4 года назад

    How to solve connection string property has not initialized error

    • @alphaq808
      @alphaq808  4 года назад

      Assign the connection string to the connection object .

  • @CodingXpert
    @CodingXpert 3 года назад

    In my pc error come after run

  • @sonalnehare3128
    @sonalnehare3128 4 года назад

    Plz tell the coding for login without using database.. simple codeing

    • @alphaq808
      @alphaq808  4 года назад

      Store the user values in resource strings...

  • @daraorn7058
    @daraorn7058 4 года назад

    erro ExecuteScalar requires an open and available Connection. The connection's current state is closed.

    • @alphaq808
      @alphaq808  4 года назад

      Kindly, check your code again and make sure you wrote the if condition to check connection state, if not then write it...
      exp
      If connection.state = ConnectionState.closed then
      connection.open()

    • @daraorn7058
      @daraorn7058 4 года назад

      @@alphaq808 Thank u

    • @daraorn7058
      @daraorn7058 4 года назад +1

      System.Data.OleDb.OleDbException: 'Syntax error (missing operator) in query expression 'count(*) form tbluser where username=? and password=?'.'

    • @markdelatorre3888
      @markdelatorre3888 3 года назад

      same problem

  • @samruddhidhoke9186
    @samruddhidhoke9186 5 лет назад +1

    connection string property has not been initialized????

    • @alphaq808
      @alphaq808  5 лет назад

      check your connection string is assigned to the connection object or not.
      i can only say this without reviewing actual code.

    • @samruddhidhoke9186
      @samruddhidhoke9186 5 лет назад

      @@alphaq808 sir connection string problem solve but Dim count = Convert.ToInt32(cmd.ExecuteScalar())
      If (count > 0) but count value is 0 and count value is not changed and database username password not show

    • @samruddhidhoke9186
      @samruddhidhoke9186 5 лет назад

      @@alphaq808 hi sir my error is solve thanks

    • @MicRodrgz
      @MicRodrgz 5 лет назад

      ​@@samruddhidhoke9186 same error.. how d yyou fix that??

    • @mamamagagaga3519
      @mamamagagaga3519 5 лет назад

      same problem can u help me too?

  • @rohitangadi3764
    @rohitangadi3764 2 года назад

    System. Data. Oledbexception syntex error in FORM clause

  • @jeinsenmirasol5559
    @jeinsenmirasol5559 4 года назад +2

    i am having error " Dim count = Convert.ToInt32(cmd.ExecuteScalar())" what can i do ?

  • @rohitangadi3764
    @rohitangadi3764 2 года назад

    Exception thrown window occurred

  • @rajkhalkho9564
    @rajkhalkho9564 4 года назад

    Data type mismatch bol rha hai sir

    • @alphaq808
      @alphaq808  4 года назад

      Make sure database column datatype set to Text.

    • @rajkhalkho9564
      @rajkhalkho9564 4 года назад

      Sab check kr liya sir fir bhi nhi ho rha hai

  • @haridasvasudevan1826
    @haridasvasudevan1826 2 года назад

    Back ground music is very boring

  • @THEBRIDEOFJESUS23
    @THEBRIDEOFJESUS23 Год назад

    HEY THIS CODES WILL NOT WORK DON'T WATS UR TIME DOING IT
    IT WILL GVE YOU ERROR AT THE END MXXXXMMMMMMM WASTED MY TIME FOR NOTHING

  • @loisarcangeles3954
    @loisarcangeles3954 Год назад

    System.Data.OleDb.OleDbException: 'The Microsoft Access database engine cannot find the input table or query 'TB_Admins'. Make sure it exists and that its name is spelled correctly.'
    why does my code does that after i run the program?