rdlc报告表中的两个数据表 [英] Two Datables in a rdlc Report Form
问题描述
我正在设计一个rdlc文件,需要在单个数据集中显示来自两个不同表的数据。我怎样才能实现这一目标?
我想把一个字段从两个不同的DataTable绑定到一个rdlc文件中的TextBoxes。
谢谢和问候,
I am designing a rdlc file which needs to display data from two different tables in a single dataset. How can i achieve this?
I wanna bind Fields from two different DataTables to TextBoxes in a rdlc file.
Thanks and Regards,
推荐答案
您可以创建一个sql view / store-procedure 并将其设置为report-source
否则
您可以在为报告设置数据源时直接写 sql-query 。
Happy Coding !
:)
you can create a sql view/store-procedure and set it as report-source
else
you can directly write sql-query while setting data-source for your report.
Happy Coding!
:)
您可以使用自定义列创建DataTable类型对象,然后在查询数据时向这些列添加值:
You can create a DataTable type object with custom columns and then later add values to those columns when you query your data:
DataTable joinedData = new DataTable();
joinedData.Columns.Add("Name",typeof(string));
joinedData.Columns.Add("Address",typeof(string));
joinedData.Columns.Add("Salary",typeof(int));
这里也许姓名和地址在一个表中,也许薪水在另一张表上。
查询数据时,使用左连接或右连接来连接表在您的表中的Id或任何类型的列上,具体取决于您的架构。在创建连接语句并将数据存储在变量(例如var query)之后,然后遍历它并添加每行的数据,例如:
Here maybe Name and Address are in one table and maybe salary is on a different table.
When querying the data, use a left join or right join to join the tables based on Id or any type of column from your tables depending on your schema. After you make a join statement and store the data in a variable such as ''var query'', then iterate through it and add each row''s data like the example:
var query = //Type some form of join LINQ statement to left join the 2 tables and store it in in query variable.
foreach (var item in query)
{
joinedData.Rows.Add(item.Name,item.Address,item.Salary);
}
这篇关于rdlc报告表中的两个数据表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!