Datatable with multiple select columns

Question

1.00/5 (3 votes)

See more:

Iam accessing datable with multiple columns using select method. But iam returning value as

{System.Data.DataRow[0]}

DataRow[] row = datatablename.Select("KEY = '"+ SKEY + "' AND COLUMN_NAME = '"+ item[0].tostring() + "'");

i need value in datarow[] and loop through it.

What is the problem with this code.

What I have tried:

C#

DataRow[] row = datatablename.Select("KEY = '"+ SKEY + "' AND COLUMN_NAME = '"+ item[0].tostring() + "'");

Posted 7-Jul-18 9:49am

Vinodh Muthusamy

Updated 8-Jul-18 3:52am

Nelek

v3

Add a Solution

Comments

Bryian Tan 8-Jul-18 1:28am

Did you verify if the skey and item[0] in the datatable?

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)

#realJSOP · Accepted Answer · 2018-07-08T03:52:00

First, tostring() should be ToString(). Second, you should be using a lambda expression. The following code should work (may need some massaging) as long as you previously verified that the KEY and COLUMN_NAME columns exist in the dataset.

C#

var rows = datatable.Rows.Where(x => x.GetInt32("KEY") == SKEY && 
                                     x.GetString("COLUMN_NAME") == item[0].ToString());

You'll end up with an IEnumerable collection of DataRow items that meet the specified criteria, or a null result if no matches were found.

I personally don't like working directly with datatables, and instead prefer to move the datatable contents into a list of strongly typed objects because things are much more controllable that way. But that's just me.

Finally, try to avoid using SQL reserved words (such as KEY) for column names. It doen't really hurt anything, but it's bad practice.