|
Running Queries in Access Database using ADO.NET -- dlee --
I have an Access DB with saved "Queries". I want to use ADO.NET to run these queries. How do I directly run these queries? If that is not possible, how do I retrieve the SQL commands of these queries so that I can construct an OleDbCommand object out of them and run them that way? I am talking about the "Queries" object inside an Access file. That is, when you open the database file using Access, you see the objects "Tables", "Queries", "Forms", "Reports", "Pages", "Macros", and "Modules". I am talking about the second type of objects. The file my program trying to read was sent to us by another company, with the queries already created and saved. Any help is appreciated. Thanks. dl |
|
-- Munir Hussain --
You can use OleDbCommand Object to run these queries. Set CommandType to "StoredProcedure", initialise input and out put parameters and execute it (standalone or thru Data Adapter) dlee I have an Access DB with saved "Queries". I want to use ADO.NET to run these queries. How do I directly run these queries? If that is not possible, how do I retrieve the SQL commands of these queries so that I can construct an OleDbCommand object out of them and run them that way? I am talking about the "Queries" object inside an Access file. That is, when you open the database file using Access, you see the objects "Tables", "Queries", "Forms", "Reports", "Pages", "Macros", and "Modules". I am talking about the second type of objects. The file my program trying to read was sent to us by another company, with the queries already created and saved. Any help is appreciated. Thanks. dl --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs.Try it free. |
|
-- Cerebrus --
Access "queries" are analogous to SQL Server Stored procedures. Use in the same way. |