DataTable.Compute Cannot find coloumn

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

I am trying to compute results from a column loanGiven from a table empLoan WHERE empID = empID variable. Following is the code

XML

sumObject = this.shahiemsDataSet.empLoan.Compute("SUM(loanGiven)", "empID = " + empID)

The variable empID gets value from datagridview cells.(Works fine)

I get the following error 'Cannot find Coloumn[EMP005]'.

Yes the record exists in the database.
Yes I have checked without filter. (It works fine).

Posted 22-Jan-15 23:12pm

Member 10437864

Add a Solution

2 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)

Member 10437864 · Answer 1 · 2015-01-22T23:38:00

Solution 1

Found the solution.

sumObject = this.shahiemsDataSet.empLoan.Compute("SUM(loanGiven)", "empID = ' " + empID"'")

Posted 22-Jan-15 23:38pm

Member 10437864

Santosh K. Tripathi · Answer 2 · 2015-01-22T23:50:00

Please see https://msdn.microsoft.com/en-us/library/system.data.datatable.compute%28v=vs.110%29.aspx[^]

C#

public Object Compute(
    string expression,
    string filter
)

it means you have to pass both parameter as string But you are passing string, string+int

C#

public Object Compute(
    string ,
    string +int
)

your second parameter also should be string type as

"empID = " + empID + "'"