microsoft.public.dotnet.framework.odbcnet

Paul Clement

3/16/2005 3:40:00 PM

On Tue, 15 Mar 2005 12:45:05 -0800, joanne via .NET 247 <anonymous@dotnet247.com> wrote:

&#164; What is the code in vb.net to run query stored in access (and display the result in a datagrid)?
&#164;

Dim AccessConn As System.Data.OleDb.OleDbConnection

AccessConn = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\db1.mdb")

AccessConn.Open()

Dim AccessCommand As New System.Data.OleDb.OleDbCommand("qryTable1", AccessConn)
AccessCommand.CommandType = CommandType.StoredProcedure

Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter

With da
.SelectCommand = AccessCommand
End With

Dim ds As New DataSet("QueryTables")
da.Fill(ds, "Table1")

DataGrid1.SetDataBinding(ds, "Table1")

AccessConn.Close()


Paul
~~~~
Microsoft MVP (Visual Basic)