How to Create a Login Form in VB.NET using SQL Server Database and Visual Studio 2022? [Source Code]

[@AI-CHET]

Thank you so much very useful video. Future please make assign bus drivers for route by weekly or month getting details from SQL database.

[@Jelo-xy9yf]

Could you create also a sign up then connect this??

[@mustafaachidri1363]

It's a great tutorial and thanks for that. But how can I open the SQL server.

[@RunCodes]

Configure Visual Studio 2022 for .NET, .NET Framework and .NET Core? Win Form | SQL Server Database kzbin.info/www/bejne/qIDLpoSPgKpln7M

[@Kevin1960Aus]

Hi, Great Video, i just have a small issue, and I'm sure it's something I am doing wrong. In the connection string, I had to remove the spaces between "Trust Server Connection=True, and this allowed the program to continue. However, when I hit the Login button I keep getting an error, and it says , System.InvalidOperationException: 'ExecuteScalar requires an open and available Connection. The connection's current state is closed.' Yet in the Server Explorer, its shows it as being open. Any guidance would be greatly appreciated. By the way, I am not a programmer, I know Basic via Access very well, and I am tinkering to learn more about VB.

[@Kevin1960Aus]

Its Ok, I found the problem, in the source code supplied I see that Dim.Open was declared on line 5, this was missed on the video, The video was great it helped my heaps, thanks again

[@Kevin1960Aus]

Hi Mate I have 2 more questions, how do I make the username and password case sensitive? and if I wanted to hard code in a master Username and password, how would I start that? ie "MasterUser" as a username and "3jmu&jJ2" as a password?

[@RunCodes]

@Kevin1960Aus try this for case sensitive: SELECT * FROM tbl_Account WHERE Username=@userName COLLATE SQL_Latin1_General_CP1_CS_AS AND Password=@userPassword COLLATE SQL_Latin1_General_CP1_CS_AS For hard code string username = “MasterUser” string password=“3jmu&jJ2”

[@Kevin1960Aus]

​@@RunCodesis thanks for that, I'll try to understand what the code does to make the password and username case sensitive, just so I under how and why, the hard code I'm still playing with, I'll keep trying it. Thanks again for your valuable assistance

[@zerosixteen.4644]

Can you help me? SQL server doesn't show up in Server Explorer even if the database is connected. What do I do??

[@RunCodes]

Configure Visual Studio 2022 for .NET, .NET Framework and .NET Core? Win Form | SQL Server Database kzbin.info/www/bejne/qIDLpoSPgKpln7M check out this video i show you here!

[@guillerjamesmantala7730]

THANKYOUSOMUCH MASTER

[@ezikielpesquiza768]

can you help me i cant see the system.data.sqlclient in nuget package how can i able to see that?

[@RunCodes]

Watch the tutorial carefully, you have to select browse tab in nuget

[@ezikielpesquiza768]

@@RunCodes i already select the browse tab and search for the nuget package system.data.sqclient is not appearing

[@RunCodes]

@ezikielpesquiza768 update your visual studio

[@ezikielpesquiza768]

@@RunCodes howw?

[@RunCodes]

learn.microsoft.com/en-us/visualstudio/install/update-visual-studio?view=vs-2022

[@leoesberto1168]

atleast post where u can download the SQL server

[@RunCodes]

SQL SERVER: www.microsoft.com/en-us/sql-server/sql-server-downloads SQL SERVER MGMT STUDIO: learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16