No announcements
Found 3182507 threads
-
0 VotesFrom a VB multi-column DataTable select a single column of Sorted Distinct values copied to another DataTable
The True "distinct" in that case would mean distinct for all columns, but I know you just wanted one column.Answered | 3 Replies | 2723 Views | Created by PJ at StertilUK - Wednesday, September 9, 2015 2:09 PM | Last reply by BonnieB - Thursday, September 10, 2015 2:01 PM
-
0 Votes
sort a datatable using an array of values for a column
' COST dt has CostDate & Vendor columns.Answered | 4 Replies | 2230 Views | Created by Tom R.1956 - Sunday, September 23, 2012 4:39 PM | Last reply by Tom R.1956 - Monday, September 24, 2012 2:44 AM -
3 Votes
Sorting DataTable on multiple columns with Linq
Thank you, this is another way to do it.Answered | 5 Replies | 4986 Views | Created by Gabriel.B - Friday, July 31, 2020 6:23 PM | Last reply by Gabriel.B - Wednesday, August 12, 2020 7:36 PM -
0 Votes
DataTable column sorting
do a sort first.Answered | 5 Replies | 3412 Views | Created by Waz33 - Friday, December 30, 2011 1:24 AM | Last reply by Neddy Ren - Monday, January 2, 2012 5:38 AM -
1 Votes
DataTable: Is it possible to reshuffle columns in a datatable without using another datatable
The datatable 'A' is filled from 2 other datatables 'B' and 'C'.Answered | 2 Replies | 3374 Views | Created by Sunita_devp - Wednesday, February 8, 2012 11:27 AM | Last reply by Sunita_devp - Thursday, February 9, 2012 3:55 AM -
0 Votes
datatable to datagridview with columns
Bind each columns (ID, Name, Quantity, other) by typing the field name (item_id, item_name, item_quantity) respectively from your query in ...Answered | 4 Replies | 1883 Views | Created by pk.yadav - Saturday, September 8, 2012 5:53 AM | Last reply by pk.yadav - Monday, September 10, 2012 5:26 AM -
0 Votes
Compute Median of values in a DataTable Column
Here a solution <summary> /// Return median from a given column of a datatable /// </summary> /// ...Answered | 4 Replies | 10483 Views | Created by Job Lot - Friday, July 8, 2005 5:35 AM | Last reply by JLopezB - Friday, August 24, 2012 9:41 PM -
0 Votes
how can add a column's value to use in an expression of another datatable's column
Hello, Strictly speaking functionality of a DataColumn Expression you can only do this where all tables have a master detail relationship which allows you to access columns ...Answered | 1 Replies | 681 Views | Created by pooya.mahmoodi - Thursday, June 6, 2013 3:55 AM | Last reply by Kareninstructor - Thursday, June 6, 2013 4:05 AM -
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 | 3165 Views | Created by SandwichesForLunch2017 - Sunday, January 15, 2017 5:13 AM | Last reply by Magnus (MM8) - Sunday, January 15, 2017 5:37 PM -
0 Votes
convert datatable column values double[]
Convert.ToDouble(x.Field<String>("Value"))).ToArray();Answered | 4 Replies | 13727 Views | Created by Born2Achieve - Friday, February 7, 2014 5:14 PM | Last reply by IdahoSixString - Friday, February 7, 2014 8:36 PM -
0 Votes
DataTable Column Filtering
Meanwhile, please refer to the following links: DataView.ToTable Method (Boolean, ...Answered | 6 Replies | 15165 Views | Created by Arvin Granados - Thursday, January 26, 2012 7:29 AM | Last reply by Dummy yoyo - Monday, January 30, 2012 3:04 AM -
1 Votes
DataTable - sum values of a column
Hi, You can do SUM by using LINQ in one step var sum = datatable.Answered | 4 Replies | 4784 Views | Created by himo - Tuesday, December 30, 2008 10:52 AM | Last reply by Syed Shakeer Hussain - Friday, June 15, 2012 6:43 PM -
1 Votes
Sorting each columns in the table individually in a datatable
Make a table from the arrays.Answered | 8 Replies | 686 Views | Created by roma_victaa - Sunday, August 9, 2015 8:42 AM | Last reply by roma_victaa - Wednesday, August 12, 2015 4:47 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 | 6965 Views | Created by HJohn2 - Friday, January 11, 2013 5:41 PM | Last reply by HJohn2 - Saturday, January 12, 2013 1:30 AM -
0 Votes
Split Datatable by columns to other Datatables
DataTable[] dts = new DataTable[dt.Columns.Count]; for(int ti=0;ti<dts.Length;ti++) { dts[ti]=new DataTable(); ...Answered | 1 Replies | 3147 Views | Created by Angelica_gr - Wednesday, January 13, 2010 10:44 AM | Last reply by Yasser Zamani - Mr. Help - Wednesday, January 13, 2010 8:48 PM -
0 Votes
DataTable Column is ReadOnly, why?
This seems like a lot of processing to display a datatable.Answered | 6 Replies | 9483 Views | Created by Ryan0827 - Thursday, August 16, 2012 2:27 PM | Last reply by Mike Feng - Friday, August 24, 2012 7:36 AM -
0 Votes
select in datatable
and if your value column all has integer values why not you typecast over there by using int.Parse() method and get the distinct values?Answered | 2 Replies | 1725 Views | Created by azolfaghari - Thursday, May 10, 2012 1:57 PM | Last reply by Kris444 - Thursday, May 10, 2012 6:46 PM -
0 Votes
Datatable Select method - blank column only
I know it from the past that this does not work.Answered | 16 Replies | 12594 Views | Created by Amey0072 - Friday, September 9, 2011 7:47 AM | Last reply by Armin Zingler - Saturday, September 10, 2011 10:36 AM -
1 Votes
Merge columns in datatables
You could add columns E,F,G,H to first DataTable and then populate them in a foreach or for loop.Answered | 2 Replies | 8014 Views | Created by Build Master - Friday, February 25, 2011 6:17 AM | Last reply by lucy-liu - Monday, February 28, 2011 10:18 AM -
6 Votes
re-order columns in a DataTable
I only wanted to shift the index order of the columns in a DataTable.Answered | 5 Replies | 34229 Views | Created by spanky4_3 - Sunday, October 1, 2006 1:24 PM | Last reply by MilanWarik - Wednesday, October 11, 2006 10:49 AM - Items 1 to 20 of 3182507 Next ›
No announcements
