如何从datatable生成查询? [英] How can I generate query from datatable ?
问题描述
我通过查询从数据库获得了dataTable。现在我需要编写一个函数来使用此dataTable形成另一个查询。 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_Agreement.CustomerID,
Balance_Agreement协议ID,
Balance_Agreement.LastUpdate,
sum(Balance_Query.Balance)
来自Balance_Agreement,Balance_Agreement
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
推荐答案
你可以使用DataTable.Select进行选择基于条件的任何数据。(示例)
或你可以使用linq。(< a href =http://matijabozicevic.com/blog/csharp-net-development/csharp-using-linq-to-query-datatable>示例)
u can use DataTable.Select for selecting any data based on condition.(example)
or u can use linq.(example)
这篇关于如何从datatable生成查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!