Very Basic ADODB Question

Question

 

Hello all. I am using visual basic 8 express and sql server express.

 

I found this regarding to visual basic 6, on how to connect to my database, but the connect statments dont work with visual basic 8

 

Dim cn As ADODB.Connection
    Set cn = New Connection
    cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;" & _
        "Persist Security Info=False;" & _
        "AttachDBFileName=" & App.Path & "\northwnd.mdf;Data Source=server1\sqlexpress"
    cn.Open
   
    Dim rs As Recordset
    Set rs = New Recordset
    rs.Open "Select * from orders", cn
    Set MSHFlexGrid1.DataSource = rs

 

Any ideas?

 

Thanks alot!

Answer 1

    Dim cn = new System.Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=db_name;")
    cn.Open
    

    Dim adapter as System.Data.SqlClient.SqlDataAdapter
    Dim rs As New System.Data.DataSet

 

adapter= new System.Data.SqlClient.SqlDataAdapter("Select * from orders", cn)

adapter.fill(rs)

'add code to read rs; it will contain a dataset of the table

 

'db_name is the registered name of the database as seen by SQL Server

 

 

hope this helps

Answer 2

There is a good set of Instructional Videos at

http://msdn.microsoft.com/en-us/vbasic/bb466226.aspx

By: Beth Massi

you can download and watch follow at your own pace.

Answer 3

Thank you bothh