Using select in linq with parameter

Question

0.00/5 (No votes)

See more:

Can somebody please tell me if something is wrong with this line it gives this error

C#

Syntax error: Missing operand after 'name' operator."

DataRow[] rows = table.Select(columnY +"='"+ columnYValue +"'");

The table contains the supposed rows.

Posted 19-Nov-15 9:23am

Member 12081613

Add a Solution

Comments

Member 12081613 19-Nov-15 15:58pm

My coloumn name here has a space between. if that could be the issue then How to fix it?

BillWoodruff 19-Nov-15 17:21pm

show more of your code ... show the part where the "parameters" are defined.

BillWoodruff 19-Nov-15 21:56pm

Without detailed information from you, we can only guess what you are doing. So, please, provide that information.

2 solutions

Solution 2

This is not LINQ (as you state in the tags) what you show here. LINQ would return an IEnumerable<T> and the Select method requires a delegate, usually given as a lambda expression.
What exactly do you want to select? All elements of a table? Do you want to apply any filter (e.g. a Where call)?
Regards
Andi

Posted 19-Nov-15 10:41am

Andreas Gieriet

Comments

Member 12081613 19-Nov-15 16:46pm

I want to select rows where ColumnY=columnYValue.

Member 12081613 19-Nov-15 16:51pm

Both are strings

Member 12081613 19-Nov-15 16:58pm

Please, if this isnt right show me how to?

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)

Matt T Heffron · Accepted Answer · 2015-11-19T10:38:00

Solution 1

Does the value of

C#

columnY +"='"+ columnYValue +"'"

contain a valid filter?

The space in the column name should be fixable by enclosing the column name in square brackets []

C#

string.Format("[{0}]='{1}'", columnY, columnYValue)

See: https://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression(v=vs.100).aspx[^]

[Edit: MTH]
This is assuming that table is a System.Data.DataTable

Posted 19-Nov-15 10:38am

Matt T Heffron

Updated 19-Nov-15 10:52am

v2

Comments

Member 12081613 19-Nov-15 16:55pm

Yes, it is but I dont get where to use the string.format line

Matt T Heffron 19-Nov-15 17:25pm

exactly instead of the
columnY +"='"+ columnYValue +"'"

Matt T Heffron 19-Nov-15 20:43pm

Did it work?

BillWoodruff 19-Nov-15 21:55pm

With this question, I don't think we have enough information about what the OP is doing to do anything but ... guess.

Member 12081613 20-Nov-15 2:11am

OMG string.Format("[{0}]='{1}'", columnY, columnYValue) worked. Thanks a million Matt

Matt T Heffron 20-Nov-15 12:26pm

You're welcome!