Linked Questions

How can I convert the result of a LINQ query where I select some columns of a DataTable to a DataTable again? DataTable dtN = new DataTable(); dtN.Columns.Add("Id"); dtN.Columns.Add("Name"); dtN....

I have a linq to sql database. Very simplified we have 3 tables, Projects and Users. There is a joining table called User_Projects which joins them together. I already have a working method of ...

I have created a web service using JSON and REST. What I want to know is how to output contents of a local database using the service? I am using Visual Studio 2015, ASP.NET Web Forms and LINQ ...

I have a linq query which is calculating particular data. Now I want that query to be typecasted to DataTable. Here is the query : var query = dt.AsEnumerable() .GroupBy(row => new { ...

The linq query is returning result in form of {DataRow Job1, DataRow Run}. How can i convert JoinResult into a DataTable . var JoinResult = (from Job1 in Jobdata.AsEnumerable() join ...

For Example, If I have the following datatable, Location First name Pincode Manager Sydney John 123 Brian New York Larry 456 Sherry Chicago Meg 789 Linda Dallas Mark 012 Cooper Sydney Jack 123 Brian ...

I have this query: var smallExchangeReport = from ex in exchangeProgReport where !string.IsNullOrEmpty(ex.comment) group ...

I want to collect all rows and pass it to datatable. My linq query: var queryAll = from all in db.tblMake select all ; DataTable dt = new DataTable(); How can i pass the queryAll into datatable dt? ...

I have problem when copy query linq to same datatable. DataTable dt_result = filterkontrak.CopyToDataTable(); var query = from q in dt_result.AsEnumerable() select ...

enter image description hereI have this code for grouping and suming column: var groupedData = from b in showit.AsEnumerable() group b by b.Field<string>("Key") into g ...