how to select from a table in access with a string variable

Question

I have a database in ms-access and wanted to select from it,

I know my question is very simple but I couldn't find the solution for it

this is how I want to select:

public static void SearchRationCreatorName(string RationCreator)
    {
        string StrCon = System.Configuration.ConfigurationManager....
        OleDbConnection Connection = new OleDbConnection(StrCon);
        OleDbDataAdapter DataA = new OleDbDataAdapter
("Select * from tRations where tRations.RationCreator= [RationCreator]", Connection);

        DataTable Dtable = new DataTable();
        DataA.Fill(Dtable);

but instead of selecting one row it select all of records in that table

Shannon Holsinger · Accepted Answer · 2016-09-04 22:06:56Z

2

That didn't show up well in the comment. I think you mean

"Select * from tRations where RationCreator= '"+RationCreator+"'"

The way you worded your title suggests you may want to use a string in place of a tablename but your code suggests otherwise. IF you wanted to know how to select from a dynamic table, let me know.

Also, this will select all rows that match rationcreator. If you only want one row, use:

"Select TOP 1 * from tRations where RationCreator= '"+RationCreator+"'"

with or without an ORDER BY predicate

answered Sep 4, 2016 at 22:06

Shannon Holsinger

2,3811 gold badge17 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Shannon Holsinger Over a year ago

In Access, you use a single quote to show text, and the # sign to show date. So a number is WHERE myNum = 6. Text is WHERE fName = 'Bill' and date is WHERE myBirthday=#04/08/2000#

SaraniO Over a year ago

that was all I need now and in the future, tanks for your very complete answer, it helped a lot

Shannon Holsinger Over a year ago

Glad to help... take care!

Collectives™ on Stack Overflow

how to select from a table in access with a string variable

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related