using System.Data; //Namespace   DataTable dt = new DataTable();  var rand = new Random (); var result = dt.AsEnumerable()...

select n random rows from datatable in C#

5:06 AM Raghunatha 4 Comments

using System.Data; //Namespace  

DataTable dt = new DataTable(); 

var rand = new Random();

var result = dt.AsEnumerable().OrderBy(r => rand.Next());

DataRow dr1;

dr1 = result.First();

in dr1 the random row values will be there