Select query for retrieve data from temporary DataTable?

Abhilash J A

Sir,

How can I write this inline sql (That is,cmdstr) query to datarow c#?

string cmdstr = "select top 5 First_name, COUNT(Department) [Department] from Employee group by First_name";

DataTable dt = new DataTable("Employee");
dt.Columns.Add(new DataColumn("Id", typeof(int)));
dt.Columns.Add(new DataColumn("First_name", typeof(string)));
dt.Columns.Add(new DataColumn("Department", typeof(int)));

dt.Rows.Add(1, "Jerry", 1);
dt.Rows.Add(2, "Mudassar", 1);
dt.Rows.Add(3, "Mathews", 1);
dt.Rows.Add(4, "Robert", 1);
dt.Rows.Add(5, "John", 1);

DataRow[] result =?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

ketan borsdiya10y ago
Accepted answer
Hi Abhilash,
Use like,
var result = from row in dt.AsEnumerable()
group row by row.Field("First_name") into grp
select new
{
First_name = grp.Key,
Department = grp.Count()
};
foreach (var t in result)
MessageBox.Show(t.First_name + " " + t.Department);
Vinay Singh10y ago
Hi
Try the below link
http://stackoverflow.com/questions/204933/using-temporary-table-in-c-sharp
http://stackoverflow.com/questions/1933855/how-can-i-retrieve-a-table-from-stored-procedure-to-a-datatable
http://stackoverflow.com/questions/18758396/c-sharp-select-into-explaination-temporary-tables