Printable View
Anyone know a good VB.Net & MSSQL Desktop Tutorial?
I want all the basics. From the ground up. Not including instalation of either.
Just creating a mssql table.
Making the Connection.
Inserting / Deleting / Updating / Navigation / Searches
All that good stuff.
If there is an article in this forum that would be just as helpfule.
Thanks vbforums
check the 101 vb.net examples.. there are a number of apps that deal directly with using the SQLClient classes, which is what you would use to connect to that type of database...
you can also check www.connectionstrings.com for a number of various different configuations for connecting to it (like timeouts, different than default ports, etc...)
I do think you need northwind installed for the DB examples in the 101 examples apps, but you should have that right?
Yes sir i got it.
Thanks kleinma!
:wave:
I just got an error while i tried to generate a dataset for the sql dataconnection.
error
Quote:
retrieving the schema for sqldataadapter1 failed
sql server does not excist or access is denied.
Is there somewhere i need to set permissions?
you may want to browse the DB forum on here to as you will find that many individual situations have been posted and resolved there.. as with many things in programming, there are often multiple ways to do the same thing... and some will be faster, some will be more efficient, some will be easier to code... so its good to learn about the different ways to do things.
One common thing I see people doing is connection to a SQL database using the OLEDB provider classes, which works, but MS included a whole library of SQL classes that are optimized for connecting to a SQL database, where as OLE is designed to handle any database that you have a driver to...
Thank you... ill do that.
I know that this ended up being more db than vb... lol
You can move it if you want of course.
Im gonna go look over in the db cave for a bit...
Gonna go Spelunking... :bigyello:
I can leave it here for now... however if you want help with the error you got, then please post the code you wrote up for that part.. it may be a very simple fix