Connecting database using VB6

[Awais Ali]

Can anyone help me by giving out a complete tutorial on the step by step way a connecting to a database using VB?

[M.Waqas Aslam]

hello Awais
try this code

Dim cn As ADODB.Connection 'ADODB Connection Object
        Dim rs As New ADODB.Recordset 'Recordset Object
        Dim sqlStr As String ' String variable to store sql command
        
        Set cn = New ADODB.Connection
        
        cn.ConnectionString = "Provider = MSDASQL;" & _
            "Data Source=LocalServer;" & _
            "Initial Catalog=sample;" & _
            "Login ID=SERVANT;" & _
            "Driver=SQL Server;"

        cn.Open
 'your code        
        cn.Close

[kannadhasan]

Note that is for connect ur frontend with sql database server

hi awaise ali,

to connect vb.net with data base first we need the sql connection.

so we write a connection string. to write a connection string first creat a connection variable like this

dim con as new sqlconnection

next we need the connection string that indicate the sql server

that is like
dim costring as string

constring="server=servername;userid=your suer id;password=your password;database="your database name"

after this you need to connect with the server

con=new sqlconnection(constring)

now u r connected with the data base server

after this
con.open() 'for open the connection

do your command here

con.close()