How can I generate query from datatable ?

Question

0.00/5 (No votes)

See more:

I have got a dataTable from database through query. Now I need to write a function to form another query using this dataTable. Every row of dataTable has all the information and condition about how my new query will be formed. How can I make a query string using this information and condition of datatable.

SampleDataTable:

ReportID DatasrceOrder DataSourceID GlobalClassID DataName AggregationValue
Test_Report 2 Balance_Agreement Test_Report_Class CustomerID
Test_Report 1 Balance_Agreement Test_Report_Class Agreement ID
Test_Report 1 Balance_Query Test_Report_Class LastUpdate
Test_Report 1 Balance_Query Test_Report_Class Balance sum

Example of Query:

Select Balance_Agreement.CustomerID,
Balance_Agreement Agreement ID,
Balance_Agreement.LastUpdate,
sum(Balance_Query.Balance)

FROM Balance_Agreement,Balance_Agreement

Posted 12-Feb-14 18:15pm

sachi Dash

Updated 12-Feb-14 22:48pm

v5

Add a Solution

Comments

Prasad Avunoori 13-Feb-14 0:46am

Sachi, It's not clear.

Can you please post sample row from your datatable?

Thomas ktg 13-Feb-14 1:11am

Do you mean to use like this? Please refer here.
http://msdn.microsoft.com/en-us/library/det4aw50%28v=vs.100%29.aspx.

soma naveen 13-Feb-14 1:15am

datatable dt=new datatable();

DataRow[] foundRows = dt.Select("column_name='columndata'");

Dinesh.V.Kumar 13-Feb-14 1:53am

Need more info Sachi!!Can you post what you have done so far and also the code if possible

Regards

sachi Dash 13-Feb-14 1:59am

you know query has different part like
Select:
FROM:
WHERE:
GroupBy:

Every row tell me what is my select option, what table is used in from condition, Is there any where condition or not, is there any groupby condition or not.

Vedat Ozan Oner 13-Feb-14 3:49am

what don't you have a field which contains all query text with some replacement parameters. then you simply replace them in your c# code. for example:
"select --F1--, sum(--F2--) as --COL_NAME-- from --TABLE_A-- group by --F1--", and all you need to do is replace --F1--, --F2--, --COL_NAME-- and --TABLE_A--

sachi Dash 13-Feb-14 4:42am

ReportID DatasrceOrder DataSourceID GlobalClassID DataName AggregationValue
Test_Report 2 Balance_Agreement Test_Report_Class CustomerID
Test_Report 1 Balance_Agreement Test_Report_Class Agreement ID
Test_Report 1 Balance_Query Test_Report_Class LastUpdate
Test_Report 1 Balance_Query Test_Report_Class Balance sum

Example of Query:

Select Balance_Agreement.CustomerID,
Balance_Agreement Agreement ID,
Balance_Agreement.LastUpdate,
sum(Balance_Query.Balance)

FROM Balance_Agreement,Balance_Agreement

I need to write a common function to form this kind of query.

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)

Silent Guardian · Answer 1 · 2014-02-13T00:26:00

Solution 1

u can use DataTable.Select for selecting any data based on condition.(example)
or u can use linq.(example)

Posted 13-Feb-14 0:26am

Silent Guardian