How to use Filter in Select Method of DataTable

Question

0.00/5 (No votes)

See more:

Hello there

I have created a C# application.
The application runs fine but got stuck at one point.
I am using DataTable "Items" to fetch data from the database.
Currently my DataTable having two columns Item_Code,Item_Desc and it fetches around 500 rows from the database. Now I need to select only row corresponding to Item_Code ='BO97' and if this row is found, then it will be automatically store in the DataTable . Overall I want only one single row to be display in the DataTable "Items",if found.

Thanks in Advance

Posted 29-Apr-12 23:52pm

Mayank Topiwala

Updated 30-Apr-12 0:00am

v3

Add a Solution

3 solutions

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)

VJ Reddy · Answer 1 · 2012-04-30T01:07:00

The Select method of DataTable explained here
http://msdn.microsoft.com/en-us/library/b5c0xc84.aspx[^]
can be used to filter the Rows of the DataTable as follows:

C#

DataRow[] rows = items.Select("Item_Code ='BO97'",string.Empty, DataViewRowState.CurrentRows);

The second parameter can be used to Sort the rows returned by the method.
The Select method returns an Array of DataRows. Hence all Columns of DataTable are automatically present in the returned rows.

It is preferable to use DataViewRowState.CurrentRows as the third argument to the method, so that it will not return the rows which have been deleted by Row.Delete() method. Otherwise, it returns these rows also and while performing an operation on these rows an error will be thrown.
If the single row is required if found then

C#

if (rows.Length > 0) 
    //use rows[0]

Alternatively, the DataView can be used

C#

DataView itemsView = items.DefaultView();
itemsView.RowFilter= "Item_Code='BO97'";
if itemsView.Count > 0 then
    //itemsView[0].Row; can be used

nagendrathecoder · Answer 2 · 2012-04-29T23:54:00

Solution 1

You have to modify your select query.
Use something like this.

select * from Items where Item_Code='B097'

Posted 29-Apr-12 23:54pm

nagendrathecoder

Comments

Mayank Topiwala 30-Apr-12 5:57am

I can do this but the above question is just an example. I have different different datatable which select multiple data.

nagendrathecoder 30-Apr-12 5:59am

So what exactly do you need?
You have to where clause in your queries to fetch single record.

Prasad_Kulkarni 30-Apr-12 6:02am

See Mayank, this answer is relevant according to your question. If you are not getting expected result then use 'Improve question' widget add more details so CP experts can do needful for you. Some code snippets always works.

Mayank Topiwala 30-Apr-12 6:04am

ok here's the Sample :
(The Data is already get collected in Items Table, Now I want to filter for the one row)
foreach(DataRow row in Items.Select("Item_Code='BO97'")
{
//Here What should I do so the relevant data has been fetched in Items table.
}

nagendrathecoder 30-Apr-12 6:19am

pass a variable in place of actual value.

Mayank Topiwala 30-Apr-12 6:32am

That's not bother me. The loop will find the actual value and goes inside, main problem is to fetch row corresponding to actual value.

Nilesh Patil Kolhapur · Answer 3 · 2012-04-30T01:29:00

Solution 3

Hi,

if u want to filter datatable then
try following Code

SQL

DataRow[] drarray= objDataTable.Select("Item_Code='BO97'");

Hope this help u
Best Luck
Happy Coding:)

Posted 30-Apr-12 1:29am

Nilesh Patil Kolhapur