如何显示存储过程的结果包含多个数据表，所以我想在Datagird中显示一些左侧，一些右侧为利润&损失账户 [英] How to display the result of stored procedure contains multiple data tables so i want to display in Datagird some of the Left side, some of the Right side as profit & loss account

问题描述

如何显示存储过程的结果包含多个数据表，所以我想在Datagird中显示一些左侧，一些右侧作为损益帐户

How to display the result of stored procedure contains multiple data tables so i want to display in Datagird some of the Left side, some of the Right side as profit & loss account

推荐答案

您需要对数据进行整形，使其在网格环境中有意义。您的网格知道如何迭代行并显示它们。修复你的数据，使其符合网格所需的格式，并且工作正常。

You need to shape your data so that it makes sense in the context of a grid. Your grid knows how to iterate over rows and show them. Fix your data so it''s in a format the grid wants and it will work fine.

你必须在存储过程中编写多个SELECT语句。每个表的一个SELECT查询。然后执行存储过程并将结果存储在数据集中。这将为您提供一个包含多个表的数据集，您可以根据需要使用这些表。



希望它有所帮助。如果需要澄清，请写评论。

you have to write multiple SELECT statements in your stored procedure. One SELECT query for each table. Then Execute stored procedure and store the result in a dataset. Which will provide you a dataset with multiple table, and you can use those table as you like.

hope it helps. If any clarification needed, please write a comment.

这篇关于如何显示存储过程的结果包含多个数据表，所以我想在Datagird中显示一些左侧，一些右侧为利润&损失账户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！