database connectivity

[abhi.ashok]

hi all,
actually i want to connect my sql server database with visual basic application through coding.any body .
anybody can suggest me the step by step process of database connectivity with sql server.
give me proper answer.
regards,
abhishek

[Asgorath]

In vb.net theres a class called SqlConnection that opens a connection to sql server.

[yadavrahul143]

Hi Abhi

Use this code to connect to SQL Server in VB.6.0

'General Declaration
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset

Private Sub Form_Load()
    con.Open "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Data Source=ASHOK"
    rs.CursorLocation = adUseClient
    rs.Open "select * from Employee", con, adOpenDynamic, adLockReadOnly
    Set DataGrid1.DataSource = rs
End Sub

This will Help u out...

[kxcntry99]

If you are using .Net there is a great tutorial in my signature...