connect VB with SQL Server !!

[mse07]

hi for every one
i have SQL Server database and i want to connect with visual basic forms
because i want to query about specific data from some tables
and i want to use the forms to do that


1- how can i connect vb with SQL Server?
2- how can i show records for some tables?
for exampl:
i use Data component when i connecting with access and i can see any records from any table in database .
what componenet can i use with SQL Server

thank you .

[Fazi]

For connection strings pls visit http://www.connectionstrings.com/

To display records, you can use

MS Datagrid
MS FlexGrid
List View
etc. controlls.

[RobDog888]

This is not a single post answerr. Its a large topic. Your best bet is to check the database forum's FAQ for beacons ADO tutorial.