Parameter Access Queries

  • Thread starter Thread starter Jim Heavey
  • Start date Start date
J

Jim Heavey

If I trying to write code which is not dependant on which database I am
using. I have developed the code for SQL Server and it is working just
fine, and now I have created the same data in MS Access. I am currently
running all stored procedures. I know that I have run "procedures" in
access, but I do not quite remember how to set this up. When I build the
query in Access, how do I identify a parameter value is required and where?
Do I create "command parameters" for these parameters in C#?

If I have written my application code taking advantage of SQL's ability to
pass multiple answer sets, will I be able to get Access to pass multiple
answer sets as well, or have I made my code database specific?

Does Access have a "@RETURN_CODE"? How do I check the success of an Access
query?

Thanks in advance for your assistance!!!!!!!!
 
Jim
If you are using SqlClient for accessing SQL Server, then you will find that the code is not going to work for Access. You use ODBC to access Access database. As far as command parameters, you would do the same that you would for SQL Server, but note that the ODBC provider is positional

Tu-Thac

----- Jim Heavey wrote: ----

If I trying to write code which is not dependant on which database I am
using. I have developed the code for SQL Server and it is working just
fine, and now I have created the same data in MS Access. I am currently
running all stored procedures. I know that I have run "procedures" in
access, but I do not quite remember how to set this up. When I build the
query in Access, how do I identify a parameter value is required and where
Do I create "command parameters" for these parameters in C#

If I have written my application code taking advantage of SQL's ability to
pass multiple answer sets, will I be able to get Access to pass multiple
answer sets as well, or have I made my code database specific?

Does Access have a "@RETURN_CODE"? How do I check the success of an Access
query

Thanks in advance for your assistance!!!!!!!
 
Back
Top