passing parameter to access query from c#

Question

4.00/5 (1 vote)

See more:

i have design an access query which seem like this:

SELECT Replace(names,'lion','kiss') AS Expr1<br />
FROM table1;

the two values that is lion and kiss, which are temporary, now i want these to be two variables, so that i can pass value to it from c#.
how to call this query from c# using oledb, and pass it two values.
I am using access 2007 and c#.
Thanks for your help :)

Posted 2-Mar-11 3:26am

bachasafyan

Updated 2-Mar-11 3:29am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DaveAuld · Answer 1 · 2011-03-02T03:28:00

Solution 1

Look at this article here; Scroll down to the section on SQL Parameters

Beginners guide to accessing SQL Server through C#[^]

Or for an access example;
How to link to an Access Database in a C# Application[^]

Posted 2-Mar-11 3:28am

DaveAuld

Updated 2-Mar-11 3:40am

v3

Comments

bachasafyan 2-Mar-11 9:30am

this is for sql server and i am using access. Thanks

DaveAuld 2-Mar-11 9:40am

Look at this article then; http://www.codeproject.com/KB/database/linkAccessInCSharp.aspx it surprisingly uses parameters as well!

bachasafyan 2-Mar-11 9:55am

this is about oledataadapter and i am using oledb :)

DaveAuld 2-Mar-11 11:01am

I think you need to go review the classes and objects and do some research, i think you will find that the objects and members of the various data access classes are very similarly structured.........