ASP如何统计表里面的记录并且显示字段内容

如图一,是ACCESS数据表

图片说明

图二是效果,如何得出图二效果

图片说明

本人是新手,纯新手,**请给出完整的源码,完完整整的**,谢谢了,马上给分

 select name, count(id) as num from biao group by name

图片说明

        protected void Button1_Click(object sender, EventArgs e)
        {
            OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test.mdb");
            con.Open();
            OleDbCommand cmd = con.CreateCommand();
            string sql = "SELECT name, count(ID) as cishu from biao group by name ";
            cmd.CommandText = sql;
            OleDbDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {

                Response.Write(reader.GetString(0));

                Response.Write(reader.GetInt32(1));
            }
                con.Close();
        }


    set conn=server.CreateObject("adodb.connection")
    conn.Open "provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("/xxx.mdb")'注意修改这个路径,如果你的mdb数据库不在根目录下,如在data目录下改为 /data/xxx.mdb,xxx是你数据库名称
    set rs=conn.Execute("select name, count(id) as num from biao group by name")
    while not rs.eof
      response.Write rs(0)&"  "&rs(1)&"<br>"'输出
      rs.movenext
    wend
    rs.close:set rs=nothing
    conn.Close:set conn=nothing