Hi,
VB.Net uses the server explorer to manage your data connections. You need to browse to your data base or database server using the server explorer. Once you have found the required data store you can then make a connection using the Data Link Properties dialog. That will enable you to input your database login id and passwords/provider tyepe, etc, using the various tabs.
The connection manager is slightly different for SQL/Access and other database types, but without any information about this, I can only give you a general guide overview.
Once you have added a connection (and there are several options that you can configure on the way) you should be able to use server explorer to browse the various datasets/tables that your database has stored (e.g within Access).
These items will display in Server Explorer and you can then drag them directly from Server Explorer to the Design screen. This will create a connection of the appropriate type automatically. If you have already created Stored Procedures you can drag these to the Design window also. These will create the appropriate Command Objects, which can then be added to your code.
You need to ensure that your command objects reference the appropriate connection type, e.g your OleDbCOmmand (for Access) must use an OleDbConnection as its connection. Once these are in place you can then use appropriate Data Adapters and Data Reader methods to obtain the data that you want to interact with in your application.
Not too sure I can really help much more than that,m except by suggesting you get a book on ADO.Net or similar.
Good luck.
Gerard
Enter your message below
Sign in or Join us (it's free).