To get data into a Datarow from Datatable.select

Question

0.00/5 (No votes)

See more:

HI,

i want to use below quey in the vb.net code

query:

select count(*)As count,TLA_ITEM_NUMBER, MODEL_NUMBER from ace_cfg_blackbox where  CFG_ORDER_ID ='9052' and  CFG_PSI_ID IN ('17208') AND ENCLOSURE_ID > 1 AND SYSTEM_ID = 1 Group by TLA_ITEM_NUMBER, MODEL_NUMBER--And rownum <=1

Vb.Net Code

m_blackBoxTable.Select("count(" + "*)As Count" + ", TLA_ITEM_NUMBER, MODEL_NUMBER " + "CFG_ORDER_ID =" + orderRow.Item("CFG_ORDER_ID").ToString + " AND CFG_PSI_ID IN (" + lstrReleasedPsi.ToString + ") AND ENCLOSURE_ID > 1 AND SYSTEM_ID = " + systemRow.Item("SYSTEM_ID").ToString + "Group by TLA_ITEM_NUMBER, MODEL_NUMBER")

but its giving runtime exception as below

Run-time exception thrown : System.Data.SyntaxErrorException - Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier.

pls help me out from this.

if there is any syntax error in the above code,pls let me know.

Thanks in Advance.
subhash G.

Posted 20-Sep-11 20:52pm

subhash04573

Add a Solution

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)

sachin10d · Answer 1 · 2011-09-20T21:50:00

Solution 1

You cannot write entire sql statment in filter string.

syntax for dataTable.Select(string filterexpression)

filterexpression will containt only the part on where clause
It can also containt a sort order as second parameter.

http://msdn.microsoft.com/en-us/library/det4aw50.aspx[^]

What you are trying can be achieved using LINQ

Posted 20-Sep-11 21:50pm

sachin10d

Updated 20-Sep-11 21:51pm

v2

Comments

subhash04573 21-Sep-11 3:52am

then what about count ?