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-xy9yf29 күн бұрын
Could you create also a sign up then connect this??
@guillerjamesmantala77306 ай бұрын
THANKYOUSOMUCH MASTER
@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.46446 ай бұрын
Can you help me? SQL server doesn't show up in Server Explorer even if the database is connected. What do I do??
@RunCodes6 ай бұрын
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!
@ezikielpesquiza7684 ай бұрын
can you help me i cant see the system.data.sqlclient in nuget package how can i able to see that?
@RunCodes4 ай бұрын
Watch the tutorial carefully, you have to select browse tab in nuget
@ezikielpesquiza7684 ай бұрын
@@RunCodes i already select the browse tab and search for the nuget package system.data.sqclient is not appearing