int SumMoney=0;
foreach(DataRow row in dataSet.Tables[0].rows)
{
if (row["Name"].ToString().Trim() == Textbox.Text.Trim())
{
SumMoney = SumMoney + Double.Parse(row["MONEY"].ToString());
}
}
不知道是不是你想要的~~
foreach(DataRow row in dataSet.Tables[0].rows)
{
if (row["Name"].ToString().Trim() == Textbox.Text.Trim())
{
SumMoney = SumMoney + Double.Parse(row["MONEY"].ToString());
}
}
不知道是不是你想要的~~
如果是LISTBOX呢,我想新建一个表包括NAME,SUM
NAME与LISTBOX的ITEMS相对应,SUM为原表中与NAME对应的MONEY的合计值
下面是我写的部分程序
//为NAME列赋值
int m = listBox2.Items.Count;
DataView dv = ds.Tables["Project"].DefaultView;
for(int j = 0; j < m; j++)
{
FilterS += "NAME='" + listBox2.Items[j].ToString().Trim() + "' or ";
}
FilterS = FilterS.Substring(0,FilterS.Length - 4);
dv.RowFilter = FilterS;
//增添合计列
DataColumn SubC = new DataColumn();
SubC.DataType = Type.GetType("System.Decimal");
SubC.ColumnName = "SUM";
ds.Tables["Project"].Columns.Add(SubC);
dataGrid1.DataSource = dv;
//给合计列赋值
我不知道怎么继续往下写了
向大家求教
foreach(DataRowView drv in dv)
{
try
{
sum+=Convert.ToDecimal(drv["money"])
}
catch
{
}
}
dr=ds.Tables["Project"].NewRow();
dr["SUM"]=sum;
ds.Tables["Project"].Rows.Add(dr);