Displaying data from a Query (Views)

  • Thread starter Thread starter Carl
  • Start date Start date
C

Carl

How can create a DataReader to call a Query in a MS Access2000 and bind the
result to a Datagrid.

in SQL Server:

Dim dr As sqlClient.SqlDataReader
SqlConnection1.open()
dr = sqlCommand1.ExecuteReader()

what about in MS Access database how can i do this?

iv'e try using
dr = OleDBDataSelectcommand1.ExecuteReader()

but it seems got a problem.thanks in advance
 
Carl said:
How can create a DataReader to call a Query in a MS Access2000 and bind
the
result to a Datagrid.

in SQL Server:

Dim dr As sqlClient.SqlDataReader
SqlConnection1.open()
dr = sqlCommand1.ExecuteReader()

what about in MS Access database how can i do this?

iv'e try using
dr = OleDBDataSelectcommand1.ExecuteReader()

but it seems got a problem.thanks in advance

Have you changed your ConnectionString to tell ADO.NET to point to your
Access database instead of your SQL Server database?

http://www.connectionstrings.com/
 
Back
Top