Connecting to MSSQL server database VB.Net

[Nick_Net2004]

I am new to connecting to an MS SQL Server database I would like to know how to query a datatable from a database to get some values in it..

[inzo21]

Hey Nick - that depends.

 

When you query a database in .net, you can query the datasource directly or wrap it in datasets - which cache the information and store it so you can do processing with it on the client side (in a nutshell).

 

I'd suggest hitting msdn.microsoft.com and querying on either of those two keywords - datasets or ADO - possibly data adapter and see what comes up. There are a bunch of free code snippets and walk-throughs available.

 

inzo