我们如何在c#中过滤数据表？

发布于 2024-08-20 08:46:15 字数 402 浏览 3 评论 0原文

我对数据表有特定的要求，但我无法得到。请帮助我解决我的问题。我的查询如下

我的数据表是

<前><代码> C1 C2 C3 C4 C5 R1 1 2 3 4 25 R2 6 7 8 24 10 R3 11 22 13 14 15 R4 16 17 23 19 20 R5 21 7 18 9 5

在输出中，我希望每个列的最大值与行和列的位置（索引）如下

值行列
21 R5 C1
22 R3 C2
23 R4 C3
24 R2 C4
25 R1 C5

谁能帮助我，我应该如何取得结果？

原文

I have specific requirement with datatable which i am not able to get. Please help me to solve my problem. My query is as below

The datatable i have with data is

       C1  C2  C3  C4  C5
R1    1   2   3   4   25
R2    6   7   8   24  10
R3    11  22  13  14  15
R4    16  17  23  19  20
R5    21  7   18  9   5

In output i would like to have max value from each colum with position (index) of row and colum as following

Value  Row Column
21    R5  C1
22    R3  C2
23    R4  C3
24    R2  C4
25    R1  C5

Can anyone please help me, how should i achieve result?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

岁月静好 2024-08-27 08:46:15

假设列名称为 C1、C2、C3、C4、C5。

伪代码/算法。

int C1_MaxValue, C2_MaxValue, C3_MaxValue, C4_MaxValue, C5_MaxValue;
string C1_Row, C2_Row, C3_Row, C4_Row, C5_Row;

//Initialize row1 values as max values.
C1_MaxValue = DataTable.Rows[1]["C1"];
C2_MaxValue = DataTable.Rows[1]["C2"];
C3_MaxValue = DataTable.Rows[1]["C3"];
C4_MaxValue = DataTable.Rows[1]["C4"];
C5_MaxValue = DataTable.Rows[1]["C5"];

//Set R1 as row for max values.
C1_Row = C2_Row = C3_Row = C4_Row = C5_Row = DataTable.Rows[1][Row1];

For (i=2 to RowCount -1)

 if(Datatable.Rows[i]["C1"] > C1_MaxValue) 
 {       
      C1_MaxValue = Datatable.Rows[i][C1]; 
      C1_Row = Datatable.Rows[i][0];
 }
 //Do the above for all other columns.
End For

最后，上述变量应包含最大值和相应的最大行数。

Assuming column names are C1, C2, C3, C4, C5.

Pseudo code/Algorithm.

int C1_MaxValue, C2_MaxValue, C3_MaxValue, C4_MaxValue, C5_MaxValue;
string C1_Row, C2_Row, C3_Row, C4_Row, C5_Row;

//Initialize row1 values as max values.
C1_MaxValue = DataTable.Rows[1]["C1"];
C2_MaxValue = DataTable.Rows[1]["C2"];
C3_MaxValue = DataTable.Rows[1]["C3"];
C4_MaxValue = DataTable.Rows[1]["C4"];
C5_MaxValue = DataTable.Rows[1]["C5"];

//Set R1 as row for max values.
C1_Row = C2_Row = C3_Row = C4_Row = C5_Row = DataTable.Rows[1][Row1];

For (i=2 to RowCount -1)

 if(Datatable.Rows[i]["C1"] > C1_MaxValue) 
 {       
      C1_MaxValue = Datatable.Rows[i][C1]; 
      C1_Row = Datatable.Rows[i][0];
 }
 //Do the above for all other columns.
End For

At the end of this for the above variables should contain the max values and corresponding max rows.

回复收藏 0 原文

~没有更多了~