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.
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
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?
@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”
@@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
Configure Visual Studio 2022 for .NET, .NET Framework and .NET Core? Win Form | SQL Server Database ruclips.net/video/rOhuQYKE2iQ/видео.html check out this video i show you here!
Thank you so much very useful video. Future please make assign bus drivers for route by weekly or month getting details from SQL database.
Could you create also a sign up then connect this??
THANKYOUSOMUCH MASTER
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.
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
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?
@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”
@@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
Can you help me? SQL server doesn't show up in Server Explorer even if the database is connected. What do I do??
Configure Visual Studio 2022 for .NET, .NET Framework and .NET Core? Win Form | SQL Server Database
ruclips.net/video/rOhuQYKE2iQ/видео.html check out this video i show you here!
can you help me i cant see the system.data.sqlclient in nuget package how can i able to see that?
Watch the tutorial carefully, you have to select browse tab in nuget
@@RunCodes i already select the browse tab and search for the nuget package system.data.sqclient is not appearing
@ezikielpesquiza768 update your visual studio
@@RunCodes howw?
learn.microsoft.com/en-us/visualstudio/install/update-visual-studio?view=vs-2022
atleast post where u can download the SQL server
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