62,046
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = new DataTable();
dt.Columns.Add("ID");
dt.Columns.Add("Name");
dt.Rows.Add("a", "张三");
dt.Rows.Add("b", "李四");
dt.Rows.Add("c", "王五");
dt.Rows.Add("d", "赵六");
dt.Rows.Add("e", "刘七");
DataTable resultDt = dt.Clone();
Enumerable.Range(0, dt.Rows.Count).OrderBy(x => Guid.NewGuid()).ToList().ForEach(x => resultDt.ImportRow(dt.Rows[x]));
GridView1.DataSource = resultDt;
GridView1.DataBind();
每次运行都会有不同结果。
Random rdm = new Random();
int r = rdm.Next();
Repeater1.DataSource = SqlHelper.ExecuteDataTable("select * from Words where zongclassID=@zongclassID order by Rnd("+r+")"
, new OleDbParameter("@zongclassID", zongclass));
Repeater1.DataBind();
请教下,为什么我这样生成的列表的顺序总是不变的,r为随机数,把这个随机数种子给了rnd()函数了啊
SELECT TOP n * FROM tanblename ORDER BY NEWID()