110,533
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = new DataTable();
dt.Columns.Add("组别");
dt.Rows.Add("TEAM9");
dt.Rows.Add("TEAM1");
dt.Rows.Add("TEAM5");
dt.Rows.Add("TEAM10");
dt.Rows.Add("TEAM11");
dt.Columns.Add("temp", typeof(int), "convert(substring(组别,5,3),System.Int32)");
dt.DefaultView.Sort = "temp";
dt = dt.DefaultView.ToTable(false, "组别");
GridView1.DataSource = dt;
GridView1.DataBind();
组别
TEAM1
TEAM5
TEAM9
TEAM10
TEAM11
DataTable dt = new DataTable();
dt.Columns.Add("组别");
dt.Rows.Add("TEAM9");
dt.Rows.Add("TEAM1");
dt.Rows.Add("TEAM5");
dt.Rows.Add("TEAM10");
dt.Rows.Add("TEAM11");
dt = dt.Rows.Cast<DataRow>().OrderBy(x => int.Parse(x["组别"].ToString().Substring(4))).ToTable();
GridView1.DataSource = dt;
GridView1.DataBind();
组别
TEAM1
TEAM5
TEAM9
TEAM10
TEAM11