如图一,是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