access 分组序号_Access 分组统计

public string countNotice(string ageUserName1)//不错，分组统计

{

int count1 = 0 ;

c.OpenData4();

string sql = "select distinct ageUserName,sum(viewCount) as ViewCount1 from noticeCount where ageUserName='"+ageUserName1+"' group by ageUserName";

//select   distinct   代码,sum(   数量1),sum(数量2)   from   表名   group   by   代码

OleDbCommand cmd  = new OleDbCommand(sql,c.mdbconn4);

OleDbDataReader dr = cmd.ExecuteReader();

if(dr.Read())

{

count1 = Convert.ToInt32(dr["ViewCount1"].ToString());

}

dr.Close();

c.mdbconn4.Close();

if(count1!=0)

{

return ""+count1.ToString()+"";

}

else

{

return "0";

}

}