Help Connecting to MS SQL (MSDE) Database

[zekeman]

Asking if someone can give a link for instruction and samples of
using VB.Net Express to connect and read a MS SQL (MSDE) Database
that is located on a Server.

Can I use ADO.Net (Preferred) and if not how to use ODBC?

In regards to ODBC, I have already used a Client machine and set up through Admin Tools, an ODBC Data Source and I can use this Data Source to connect to the DB via Excel. Any help is appreciated.

I would rather not use a DataGrid.

Thanks in advance.

 

[cjard]

DW2 link below

 

[zekeman]

Thanks, the link help.

Also wondering if ADO.Net provides a way to retrieve the properties of a tables columns?

For example can I get the data type, for each column in the table?

Thanks

 

[zekeman]

Found my answer at this msdn site:

http://msdn2.microsoft.com/en-us/library/haa3afyz.aspx

The keyword is :

GetSchemaTable