linq-to-dataset Questions
6
Solved
Using linq to query a datatable returns the following error: CS0117: 'DataSet1.map DataTable' does not contain a definition for 'AsEnumerable'
Project includes reference for System.Data.Datasetexte...
Simian asked 9/2, 2012 at 19:18
3
Solved
hi how i can filter a datatable with linq to datatable?
I have a DropDownList and there I can select the value of the Modul Column. Now I want to filter the DataTable with this Modul Column.
her...
Piggott asked 18/10, 2013 at 12:15
5
Solved
Just wanted to check if there is way to do distinct by multiple columns. Thanks in advance!!!
BTW, I found a great LINQ extension here but need some guidance to use it for multiple columns
Cumin asked 1/4, 2009 at 18:45
4
Solved
i am using the below code
IEnumerable<DataRow> query = from c in at.appointmentcalendars.AsEnumerable()
select c;
DataTable dt = query.CopyToDataTable();
But i am getting the below err...
Twerp asked 13/6, 2013 at 13:49
6
Solved
I am trying to get distinct rows based on multiple columns (attribute1_name, attribute2_name) and get datarows from datatable using Linq-to-Dataset.
I want results like this
attribute1_name att...
Selfheal asked 14/7, 2010 at 2:5
1
Solved
I have a datatable with dynamic set of columns and want to aggregate the numeric based columns and keep the final rows into new datatable.
DataTable Sample:-
PartnerName CreditCol DebitCol Amount...
Counter asked 8/5, 2014 at 8:57
1
Solved
So I have two DataTables that have the same schema, but different data. I want to join the two tables together where two fields, id3 and print and the same. How would I write this in LINQ?
Right n...
Haemophilia asked 6/11, 2013 at 13:44
2
Solved
I have a data table like this:
Category Description CurrentHours CTDHours
LC1 Cat One 5 0
LC2 Cat Two 6 0
LC3 Cat Three 18 0
LC1 Cat One 0 9
LC2 Cat Two 0 15
LC4 Cat Four 0 21
That I nee...
Chlorous asked 25/6, 2013 at 14:11
1
Solved
I'm trying to apply a left outer join using LINQ on two data tables. I'm receiving the exception listed below when I try to debug and view data contained in result variable:
System.ArgumentExcep...
Wieren asked 19/6, 2013 at 20:56
2
Solved
This is very confusing, I use AsDataView to bind query result to a dgv and it works fine with the following:
var query = from c in myDatabaseDataSet.Diamond where c.p_Id == p_Id select c;
dataGrid...
Anastatius asked 6/3, 2010 at 16:39
3
Solved
I have a method that determines the min and max of a column in a DataTable:
public void GetMinMaxRange( DataTable data, string valueColumnName )
{
var min = data.AsEnumerable().Min(m => m.Fiel...
Tao asked 12/9, 2011 at 16:11
3
Solved
I've recently upgraded to VS 2010 and am playing around with LINQ to Dataset. I have a strong typed dataset for Authorization that is in HttpCache of an ASP.NET WebApplication.
So i wanted to know...
Janejanean asked 5/4, 2011 at 11:45
1
Solved
i recently upgraded VS 2005 to 2010 and am fairly new to LinQ. Maybe somebody can put me in the right way.
Background:
I have a typed dataset and have the standard SQLMembershipProvider extended ...
Squamulose asked 1/4, 2011 at 20:54
2
Does anyone have experience using PLINQ with ASP.NET? Is this a good combination, or something to avoid in most situations?
I develop an intranet ASP.NET site for a lawfirm (~100 users). Several p...
Surround asked 29/12, 2009 at 18:2
2
I am using Linq to DataTable. How I can apply like operator in where clause. I want to do a search on data just as we have like operator in SQL.
I searched and tried the following code but got an ...
Brill asked 16/12, 2010 at 17:34
3
Solved
Just getting my head around all this LINQ stuff and it seems I'm stuck at the first hurdle.
I have a datatable as such:
OrderNo LetterGroup Filepath
----------- ----------- ----------------------...
Tiro asked 13/12, 2010 at 20:49
1
Solved
I have the following VB.NET code that I am using to sort a Data.DataTable by column count.
For Each dtTarget As Data.DataTable In _
From x In Target.Tables _
Where DirectCast(x, Data.DataTable)....
Hebert asked 18/8, 2010 at 19:30
1
Solved
I have a SQL Compact Edition Database that I update periodically (via web services).
The part where I write to the database is taking way too long. I am currently doing it with Linq to Datasets (a...
Ebbie asked 1/7, 2010 at 21:40
3
Solved
Does any one know of an example on how to store an image in a SQL Server CE database?
What data type should the column be? (I am guessing binary.)
I use Linq-To-Datasets. Is it possible using tha...
Kant asked 14/4, 2010 at 14:38
1
Solved
I have a mobile app that is using LinqToDatasets to update/insert into a SQL Server CE 3.5 File.
My Code looks like this:
// All the MyClass Updates
MyTableAdapter myTableAdapter = new MyTableAda...
Giesser asked 10/3, 2010 at 17:36
6
Solved
I am new to Linq world and currently exploring it. I am thinking about using it in my next project that involves database interaction.
From whatever I have read, I think there are 2 different ways...
Alessandraalessandria asked 6/3, 2009 at 12:35
1
Solved
I have a requirement to extract a distinct subset of rows from a DataTable, and thought LINQ2DataSets may be a useful and clean way to do this, however it appears that it is not possible to simply ...
Micrometeorology asked 14/11, 2008 at 1:30
1
© 2022 - 2024 — McMap. All rights reserved.