如上图,红色部分是我想实现的效果,
数据层:
public DataSet EquipAll()
{
try
{
string sql = "select s.id as 编号,p.XZ_Name as 所属派出所,s.bus as 汽车,s.bike as 自行车,s.computer as 计算机,s.saomiaoyi as 扫描仪 from equip as s,paicusu_table as p where p.id=s.paicusu_id";

SqlDataAdapter da = new SqlDataAdapter(sql, con);
da.Fill(ds, "equip");
}
catch (Exception ex)
{

throw ex;
}
return ds;
}
表示层:
this.dataGridView1.DataSource = ds.Tables["equip"].DefaultView;
ds.Tables["equip"].DefaultView.AllowNew = false;//去掉空行
请帮我修改一下要如何实现这种效果,急,谢谢!!

用DataSet模拟了一个你的表结构，答案就在下面自己看吧

谢谢,搞定,再麻烦一下,如果要生成报表怎么写,没做过报表!!!!

用水晶报表吧

转贴guoxhvip的包中的代码,以便有和我一样想看代码的学习:
private void Form1_Load(object sender, EventArgs e)
{
ds = new DataSet();
ds.Tables.Add("policeStation");
ds.Tables["policeStation"].Columns.Add("编号",typeof(string));
ds.Tables["policeStation"].Columns.Add("所属派出所",typeof(string));
ds.Tables["policeStation"].Columns.Add("汽车", typeof(int));
ds.Tables["policeStation"].Columns.Add("自行车", typeof(int));
ds.Tables["policeStation"].Columns.Add("计算机", typeof(int));
ds.Tables["policeStation"].Columns.Add("扫描仪", typeof(int));
ds.Tables["policeStation"].Rows.Add(new object[] {"1","龙头派出所",1,1,1,1});
ds.Tables["policeStation"].Rows.Add(new object[] {"2","新可镇派出所",12,12,12,3});
ds.Tables["policeStation"].Rows.Add(new object[] {"3","贤官镇派出所",12,21,0,0});
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
}

private void btnAdd_Click(object sender, EventArgs e)
{
object[] newRow = new object[6];
int[] sum = new int[4];
foreach (DataRow row in ds.Tables[0].Rows)
{
sum[0] += int.Parse(row["汽车"].ToString());
sum[1] += int.Parse(row["自行车"].ToString());
sum[2] += int.Parse(row["计算机"].ToString());
sum[3] += int.Parse(row["扫描仪"].ToString());
}
int i = 0;
newRow[i++] = "";
newRow[i++] = "统计";
newRow[i++] = sum[0];
newRow[i++] = sum[1];
newRow[i++] = sum[2];
newRow[i++] = sum[3];
this.ds.Tables[0].Rows.Add(newRow);
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;

[此贴子已经被作者于2007-11-21 11:53:34编辑过]