Select query for retrieve data from temporary DataTable?

Question

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 =?

ketan borsdiya · 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 Singh · Answer

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