如何在C#中对数据表数据进行数据处理 [英] How to do data manipulations on data table data in C#
问题描述
存储过程返回一组数据列,如名称,年龄和高度。在应用程序级别,在c#中我们如何应用聚合函数来获得数据的平均高度,最小年龄和最大年龄。
实际上我可以存储任何内容在这一点上执行的过程中出现了不同的列,在该数据表的顶部,我可能必须应用聚合函数。请建议
我的尝试:
我知道的方式处理它,如果我只需要执行一个proc,但此时我不知道什么是我的proc的返回列
Stored procedure is returning set of columns of data like name, age and height. At the application level, in c# how can we apply the aggregate functions to get average height, min age and max age on the data.
Actually i can have any stored procedure getting executed at this point with varied columns coming out, on top of that data table i might have to apply the aggregate functions. Please suggest
What I have tried:
I know the way to handle it if i have to execute only one proc, but at this point i am not aware what would be the return columns for my proc
推荐答案
DataTable dt = new DataTable();
dt.Columns.Add("name");
dt.Columns.Add("age");
dt.Columns.Add("height");
dt.Rows.Add("AA", 25, 5.2);
dt.Rows.Add("bb", 26, 4.2);
dt.Rows.Add("cc", 28, 6.2);
dt.Rows.Add("dd", 30, 7);
var average = dt.Rows.OfType<DataRow>().Select(k => Convert.ToDouble(k["height"])).Average();
var ages = dt.Rows.OfType<DataRow>().Select(k => Convert.ToInt32(k["age"]));
int minage = ages.Min();
int max = ages.Max();
这篇关于如何在C#中对数据表数据进行数据处理的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!