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


--------------------------------
From: joanne

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>dcf6iYNPo0ubp9ePrld2Ag==</Id>

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

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

Dim AccessConn As System.Data.OleDb.OleDbConnection

AccessConn = New System.Data.OleDb.OleDbConnection("Provider=Micros oft.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)