CODEWITHSUNDEEP
c#databasems-accessselect
Greg Innes
Greg Innes

Reputation: 63

Access Database select more than one row in c#

I have been following this site for basic Access database implementation in C#

http://www.homeandlearn.co.uk/csharp/csharp_s12p12.html

I want to search more than one row. This code works for one row.

string searchFor = txtFurniture.Text;
returnedRows = ds1.Tables["Furniture"].Select("Finish='" + searchFor + "'");

How do I add in additional rows to check? I have tried something like

returnedRows = ds1.Tables["Furniture"].Select("Finish='" + "Style='" + searchFor + "'");

but this fails.

Upvotes: 3

Views: 540

Answers (3)

Lance U. Matthews
Lance U. Matthews

Reputation: 16596

As referenced in the documentation for the DataTable.Select method, the documentation for the DataColumn.Expression property describes the syntax to be used with the filterExpression parameter. In your case, use And to create a compound expression with your two conditions:

returnedRows = ds1.Tables["Furniture"].Select("Finish='" + searchFor + "' And Style='" + searchFor2 + "'");

...or more readably...

string filterExpression = string.Format("Finish='{0}' And Style='{1}'", searchFor, searchFor2);
DataRow[] returnedRows = ds1.Tables["Furniture"].Select(filterExpression);

Upvotes: 0

Guffa
Guffa

Reputation: 700222

You mean an additional field to check.

Make a condition that looks like this:

Finish='something' and Style='something'

using:

returnedRows = ds1.Tables["Furniture"].Select("Finish='" + searchFor + "' and Style='" + searchFor + "'");

Upvotes: 1

Pranay Rana
Pranay Rana

Reputation: 176896

you need to add and condition 

returnedRows = ds1.Tables["Furniture"].Select("Finish='" + searchFor +
                                           "' and Style='" + searchFor + "'");

In addition you can check this answer might help you to understand easily : Datatable select with multiple conditions

Upvotes: 1

Related Questions