gv是前台gridview ,目的让重复列显示在一行如本例中 5,5,5
DataTable dt = new DataTable();
dt.Columns.Add("analyseValue", typeof(string));
DataRow dr = dt.NewRow();
dr[0] = "5";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "2";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "3";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "4";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "5";
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "5";
dt.Rows.Add(dr);
DataView dv = dt.DefaultView;
dv.Sort = "analyseValue";
DataTable dt2 = dv.ToTable(true);
foreach (DataRow dr2 in dt2.Rows)
{
DataRow[] fdr = dt.Select("analyseValue='" + dr2[0].ToString() + "'");
int c = fdr.Length;
string str = "";
for (int i = 0; i < c; i++)
{
str += dr2[0].ToString() + ",";
}
dr2[0] = str.Trim(',');
}
gv.DataSource = dt2;
gv.DataBind();