我想把LISTVIEW里面每一列里面的数值都统计下,
#region private void AllSumRoom() 房间数合计
/// <summary>
/// 房间数合计
/// </summary>
private void AllSumRoom()
{
DataSet myDataSet=new DataSet();
IBaseBlock myblock = BlockFactory.Creator();
myblock.Open();
myblock.Fill(myDataSet,"SELECT * FROM Rooms join CompaniesRooms on Rooms.RoomID = CompaniesRooms.RoomID and CompaniesRooms.CompanyID="+comboCompanyName.SelectedValue.ToString() +" order by Rooms.roomid","CompaniesRooms");
myblock.Close();
}
#endregion
这个是房间数的合计~~
但是住入人数是有不同,要统计的是所有
#region private void AllSumRoom() 房间数合计
/// <summary>
/// 房间数合计
/// </summary>
private void AllSumRoom()
{
DataSet myDataSet=new DataSet();
IBaseBlock myblock = BlockFactory.Creator();
myblock.Open();
myblock.Fill(myDataSet,"SELECT * FROM Rooms join CompaniesRooms on Rooms.RoomID = CompaniesRooms.RoomID and CompaniesRooms.CompanyID="+comboCompanyName.SelectedValue.ToString() +" order by Rooms.roomid","CompaniesRooms");
myblock.Close();
}
#endregion
这个是房间数的合计~~
但是住入人数是有不同,要统计的是所有
int sum = 0;
foreach (ListViewItem lvi in listView1.Items)
{
sum += Convert.ToInt(lvi.SubItems[0].Text);
}
textBox1.Text = sum.ToString();根据需要填入需要求和的列索引,从0开始.
textbox1输出结果.