Tagged Questions
0
votes
1answer
30 views
Linq results to dataTable with copyToDataTable
I would like to have my Linq results in a dataset/datatable. The problem I have at the moment is the query variable doens't have the propperty copyToDataTable. I get this error.
The type ...
0
votes
2answers
42 views
Linq results to dataset
I use the entity framework together with Linq to get my data out of the database.
I would like to download this data in to an excel. The ExcelLibrary works with datasets.
is it possible to get the ...
0
votes
2answers
55 views
Creating XML from Datatable [duplicate]
I hava datatable with the following entries:
**Companyid Deptid Location Employeeid Employeename Employeeage**
001 D001 CA 0001 Jason Bourne 57
001 ...
1
vote
1answer
47 views
Merge two DataTables with LINQ
My question is similar too THIS
I have two DataTables:
DataTable 1:
Column 1: Date
Column 2: Requests 1
DataTable 2:
Column 1: Date
Column 2: Requests 2
I need the bellow result:
New ...
0
votes
2answers
35 views
DataTable Join all Rows Data
Actually,I have a DataTable containing 2000 rows with a ColumnName EMAIL.
Now,I want to show all emails from the DataTable and adding them to a TextBox by separating with a ,.
I am achieving this by ...
1
vote
2answers
37 views
How do I select the distinct row count of a column in a data table?
I have a data table:
DataTable table = new DataTable();
DataColumn column;
column = new DataColumn();
column.DataType = Type.GetType("System.String");
column.ColumnName = ...
0
votes
2answers
33 views
Datatable updating without using datarow loop
Is it possible to do the following:
I have the following datatable
=================================
ID || Width || Value ||
=================================
size-1 || 50 || ...
0
votes
1answer
27 views
Clear particular column values in DataTable
I have data table with Four fields Emp_No, AmountPaid, Amount_Adjusted, Adjustment_Reason
I want to clear the values of Adjustment_Reason column
I have tried the below code :
for (int i = ...
0
votes
1answer
35 views
Filtering Dataset based on similar column values
I have a Data in Dataset with 5 columns (ID, col1, col2, col3, col4). I have to filter rows and separate them from main Dataset based on the similar column values. ID column is unique. I have to check ...
2
votes
1answer
115 views
Split a Datatable into multiple Datatables based on a list of column names
I have a datatable that looks lik the following
ID Country Supplier
515 DE A
515 CH A
515 FR A
516 DE B
516 FR ...
0
votes
1answer
31 views
Merge 4 tables using Linq when Datatable.Merge Fails to merge rows
So I am not very strong in LINQ and Databases in general, so please understand i know i am a novice. I am trying to get information from a system about employees activity. Here is the issue, I have 4 ...
0
votes
1answer
41 views
How do I use LINQ to filter a datatable against a Lst of strings that need to be split?
I have a datatable and I want to use LINQ to filter against a List of strings, with each string delimited using the pipe ('|'), and contains two values.
The list (List Actions) of string looks like ...
0
votes
3answers
32 views
Can I Return Different Types From An Extension Method
I basically want to write a DataTable extension method to hide a generalized LINQ query. Lets say I have the DataTables below:
DataTable1
[ID] [NameOfThing] [DateOfThing]
1 ...
1
vote
2answers
39 views
DataTable group by seperated by comma
i have a datatable that looks like the following
cname tname text allowgroupping
A M good Yes
A M bad Yes
A M ugly Yes
B N sick ...
0
votes
1answer
25 views
How to execute Datatable Linq Union
I have a datatable that contains below data.
Table 1
880000000010747
880000000012235
880000000000010
880000000015086
880000000000028
Table 2
880000000014718
...
