62,025
社区成员
发帖
与我相关
我的任务
分享
private DataTable GetData()
{
SqlDataAdapter da = new SqlDataAdapter("select count(paper_deptid),paper_deptid from papers group by paper_deptid", con);
DataSet ds = new DataSet();
da.Fill(ds, "kw");
DataTable tableInfo = new DataTable();
DataColumn dcCity = new DataColumn("City", Type.GetType("System.String"));
DataColumn dcCount = new DataColumn("Count", Type.GetType("System.String"));
tableInfo.Columns.Add(dcCity);
tableInfo.Columns.Add(dcCount);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = tableInfo.NewRow();
dr["City"] = ds.Tables[0].Rows[i]["paper_deptid"].ToString();
//dr["Count"]=ds.Tables["paper_deptid"].Rows.Count;
dr["Count"] = ds.Tables[0].Rows[i]["count(paper_deptid)"].ToString();
tableInfo.Rows.Add(dr);
}
return tableInfo;
}