No announcements
Found 3490901 threads
-
1 VotesLinq Except Method on DataTables
The deeper I got into the the DataTable object the more I discovered that the DBA had been making Column Datatype changes on SQL side that did not match up with ...Answered | 4 Replies | 17462 Views | Created by BKThomson - Wednesday, March 23, 2011 8:01 PM | Last reply by BonnieB - Saturday, April 2, 2011 4:57 PM
-
4 Votes
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
(or even c#) I've built several projects now using LINQ to SQL, and in each one of them resorted to manually building datatables/datasets, and ...Answered | 17 Replies | 62094 Views | Created by StevePuri - Tuesday, January 15, 2008 11:08 AM | Last reply by William Steele - Friday, July 13, 2012 11:47 PM -
1 Votes
LINQ to SQL with multiple StartsWith
You know what you want from SQL.Answered | 4 Replies | 8807 Views | Created by Sarel j - Wednesday, December 3, 2008 10:07 AM | Last reply by David Buchanan - Friday, December 5, 2008 4:08 PM -
0 Votes
Selecting records from multiple table in c#
If you provide the code used by the view profile click event it would be helpful but you want to do something along the lines of using one of the posted SQL commands to ...Answered | 6 Replies | 18054 Views | Created by PakeMoBa - Wednesday, May 9, 2012 4:25 PM | Last reply by Nick_Sandel - Thursday, May 10, 2012 8:58 AM -
2 Votes
How can I grab two columns from a table in LINQ?
Hi, First the Select() in your linq query is not meant for selecting multiple columns.Answered | 3 Replies | 44501 Views | Created by B. Clay Shannon - Saturday, December 29, 2012 4:20 AM | Last reply by B. Clay Shannon - Wednesday, January 9, 2013 1:22 AM -
0 Votes
Dynamic LINQ expression against Datatable
Hi Veeru, What Ramesh provide is a goof reference, and you could also have a look at these: Dynamic Linq Query using ...Answered | 2 Replies | 10696 Views | Created by Veeru81 - Thursday, March 25, 2010 9:17 PM | Last reply by Alex Liang - Monday, March 29, 2010 7:24 AM -
1 Votes
DataTable Column to List(of Integer)
Could also probably do (without LINQ): Public Function GetPartIds(ByVal PartsTable As DataTable) As List(Of Integer) Return Array.ConvertAll(Of DataRow, ...Answered | 3 Replies | 7167 Views | Created by HJohn2 - Friday, January 11, 2013 5:41 PM | Last reply by HJohn2 - Saturday, January 12, 2013 1:30 AM -
0 Votes
Insert selected column from multiple excel sheet ????
Dear Sir, I have idea of loading al the diffrent excel shee in diffrent table using foreach loop will explain or post me steps or any link where i wil get ...Answered | 8 Replies | 2955 Views | Created by Vipin jha - Thursday, July 5, 2012 8:48 AM | Last reply by Vipin jha - Friday, July 6, 2012 5:17 AM -
3 Votes
Select from datatable into a csv
If you need to transfer data from SQL Server into CSV then you could use SQL Server DTS (in SQL Server 2000) or Integration ...Answered | 7 Replies | 5489 Views | Created by rowter - Thursday, May 19, 2011 7:12 PM | Last reply by Helen Zhou - Friday, May 20, 2011 8:24 AM -
0 Votes
LINQ to DataTable, DataView, and Updating SQL Server
string s = drc.DataSource.ToString(); DataView dt = drc.DataSource as ...Answered | 1 Replies | 5573 Views | Created by damianrflynn - Monday, November 30, 2009 2:41 AM | Last reply by Haripraghash - Monday, November 30, 2009 5:49 AM -
1 Votes
select only 10 rows from a dataTable
Can you please clarify how we get only 10 rows from this method.Answered | 6 Replies | 56397 Views | Created by motevallizadeh - Tuesday, July 19, 2011 6:46 AM | Last reply by Vikasumit - Wednesday, August 3, 2011 11:37 AM -
0 Votes
Linq query to DataTable
i think he means something like this (doesnt work by the way), where the table or resulttype isnt defined/contained in the datacontext and he wants to return something a little more complex than a ...Answered | 2 Replies | 7470 Views | Created by SP Ninja - Monday, August 23, 2010 6:31 PM | Last reply by Vernard - Tuesday, January 25, 2011 7:18 PM -
2 Votes
datatable linq remove rows where not in array
Please replace dataTableInstance with the actual instance name of the datatable, DataTypeOfCol1 with the actual data type that the column is holding, and col1 with the actual ...Answered | 6 Replies | 32637 Views | Created by want 2 Learn - Thursday, June 27, 2013 11:02 PM | Last reply by Fernando Soto - MCSD - Saturday, June 29, 2013 12:33 PM -
1 Votes
Select Specific Columns from Dataset
Do you mean how to query a DataSet and/or a Datatable?Answered | 12 Replies | 17058 Views | Created by Himyar AlJabri - Thursday, April 9, 2009 5:17 AM | Last reply by Himyar AlJabri - Wednesday, April 15, 2009 4:35 AM -
1 Votes
LINQ to SQL question about updating
By the way, you can use LINQ to query the DataTables.Answered | 6 Replies | 3066 Views | Created by andersonEE - Saturday, August 1, 2009 3:39 PM | Last reply by JohnGrove - Saturday, August 1, 2009 5:44 PM -
0 Votes
How can I select individual values from a datatable?
I really appreciate you writing that out for me though and have learnt useful stuff from you.Answered | 11 Replies | 3152 Views | Created by Woodie_Woodpeck - Wednesday, July 1, 2009 5:12 PM | Last reply by Woodie_Woodpeck - Thursday, July 2, 2009 5:10 PM -
1 Votes
Remove Columns From DataTable
You could remove a column by its name: dt1.Columns.Remove("str1"); ...or by index, where 0 is the first column, 1 is the ...Answered | 3 Replies | 3272 Views | Created by SandwichesForLunch2017 - Sunday, January 15, 2017 5:13 AM | Last reply by Magnus (MM8) - Sunday, January 15, 2017 5:37 PM -
3 Votes
SQL select statement to eliminate a column from the selection
You can create a view without that particular column 2.Answered | 4 Replies | 8637 Views | Created by tsk238 - Friday, December 9, 2011 4:52 PM | Last reply by Hasham Niaz - Saturday, December 10, 2011 6:49 PM -
1 Votes
selecting multiple rows from datagridview via DataGridViewCheckBoxColumn and updating a columns data
First GetMockedData returns a DataTable as mentioned above to simulate loading data from a database.Answered | 3 Replies | 5729 Views | Created by tolgasenol - Friday, January 6, 2012 10:20 AM | Last reply by tolgasenol - Thursday, January 12, 2012 10:59 AM -
0 Votes
Multiple LINQ aggregates
Hi , In the above example, If Data Type for field A ( Integer / Decimal ) only know @ run time, How would I cast the column dynamically?Answered | 5 Replies | 10832 Views | Created by GarlicRice - Thursday, March 12, 2009 10:18 AM | Last reply by Costas2 - Friday, January 21, 2011 12:41 PM
No announcements
