110,566
社区成员
发帖
与我相关
我的任务
分享
/*如果datagridview是用DataSource 绑定数据源的
this.dataGridView1.Rows.Add(1);//会报错的*/
DataTable dt = ds.Table[0]; //ds是DataSet
DataRow dr = dt.NewRow(); //在数据源上在追加一行
dt.Rows.Add(dr);
double total1 = 0;
for (int i = 0; i < dt.Rows.Count -1; i++) 应该循环DataTable
{
total1 += Convert.ToDouble(dt.Rows[i]["列名"].ToString())
//......
}
dt.Rows[dt.Rows.Count - 1]["列名"] = total1.ToString(); //不需要合计的列就给他""
//......列还没写完
datagridview1.DataSource = dt;
/*如果datagridview是用DataSource 绑定数据源的
this.dataGridView1.Rows.Add(1);//会报错的*/
DataTable dt = ds.Table[0]; //ds是DataSet
DataRow dr = dt.NewRow(); //在数据源上在追加一行
dt.Rows.Add(dr);
double total1 = 0;
for (int i = 0; i < datagridview1.Rows.Count; i++)
{
total1 += Convert.ToDouble(datagridview1.Rows[i].Cells["列名"].Value)
}
dt.Rows[dt.Rows.Count - 1]["列名"] = total1.ToString(); //不需要合计的列就给他""
datagridview1.DataSource = dt;
if (i == intArray.Length - 1)
{
this.dataGridView1.Rows.Add(1);
this.dataGridView1.Rows[i + 1].Cells[0].Value = all.ToString();
}
private void button3_Click(object sender, EventArgs e)
{
int[] intArray = new int[] { 4,6,7,1,3,9,8,2,5,0};
int all = 0;
for (int i = 0; i < intArray.Length; i++)
{
this.dataGridView1.Rows.Add(1);
this.dataGridView1.Rows[i].Cells[0].Value = intArray[i].ToString();
all += intArray[i];
if (i = intArray.Length - 1)
{
this.dataGridView1.Rows.Add(1);
this.dataGridView1.Rows[i + 1].Cells[0].Value = all.ToString();
}
}
}