如何获得列的值的总和。 [英] How Do I Get Sum Of Column's Value At End.
本文介绍了如何获得列的值的总和。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
hiiii,
i有写代码lyk这个
protected void Page_Load( object sender,EventArgs e)
{
if (!this.IsPostBack)
{
double lowerrange = 0 。 1 ;
double upperrange = 3 。 0 跨度>;
double lobound = 0 。 1 跨度>;
double upbound = 0 。 5 跨度>;
DataTable dt = new DataTable();
dt.Columns.Add( 随机数, typeof ( double ));
dt.Columns.Add( loss, typeof ( double ));
Random random = new Random(Guid.NewGuid()。GetHashCode());
for ( int i = 0 ; i < 1000 ; i ++)
{
DataRow dr = dt.NewRow();
dr [ 随机数] = random.NextDouble()*(upperrange-lowerrange) )+低范围;
dr [ loss] = random.NextDouble()*(upbound - lobound) + lobound;
dt.Rows.Add(dr);
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
并生成随机数coloum,现在我想添加此列的值并在最后得到该值的总和plz help我这个
和
我怎样才能获得收益
i有等式增益=(randono / loss)* 100.
并希望在每行的第三列显示。
plz帮助我......
解决方案
// 对于一列的所有值的总和,使用以下代码
var sumOfLoss = dt.Select()。Sum(dr = > Convert.ToDecimal(dr [ loss]));
var sumOfRandom = dt.Select()。Sum(dr = > Convert.ToDecimal (dr [ 随机数])); / / (丢失,随机数)您的专栏名称
如果有任何问题请告诉我
- > M.U
hiiii,
i have write code lyk this
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
double lowerrange = 0.1;
double upperrange = 3.0;
double lobound=0.1;
double upbound=0.5;
DataTable dt = new DataTable();
dt.Columns.Add("Random Numbers", typeof(double));
dt.Columns.Add("loss", typeof(double));
Random random = new Random(Guid.NewGuid().GetHashCode());
for (int i = 0; i < 1000; i++)
{
DataRow dr = dt.NewRow();
dr["Random Numbers"] = random.NextDouble() * (upperrange-lowerrange) + lowerrange;
dr["loss"] = random.NextDouble() * (upbound - lobound) + lobound;
dt.Rows.Add(dr);
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
and generate to random number coloum and now i want to add this column's value and get sum of that value at the end plz help me for this
and
also how can i get gain
i have equation gain = (randono/loss)*100.
and want to display in third column for each row.
plz help me......
解决方案
//for sum of all values of one column, use following code var sumOfLoss = dt.Select().Sum(dr => Convert.ToDecimal(dr["loss"])); var sumOfRandom = dt.Select().Sum(dr => Convert.ToDecimal(dr["Random Numbers"]));//(loss,Random Numbers) your column name
if any issue then let me know
-> M.U
这篇关于如何获得列的值的总和。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文