How To Sort By Columns In A Datatable

Sep 1, 2011

I currently have a datagridview that is built from a datatable So lets say we have 6 columns

A B C D E G

So the users will select there data from another program and paste into the the table. So lets assume that the data that is pasted is; (the column names are automatically put in)

A B C D E G
123 456 789 101 112 134

So the table will now look like following (I remove the first row because its the same as the column name)

A B C D E G
A B C D E G
123 456 789 101 112 134

My problem is that the users can rearrange thier tables(column index) so lets say user A has the table in this format

A B D E C G
123 456 101 112 789 134

So when they paste into the program, it will look like

A B C D E G
A B D E C G
123 456 101 112 789 134

So now "C" "D" "E" are incorrect and i need to swap those columns to be the same as the column name. I'm not sure how to attack this problem.My thoughts were to paste the data as is, than see what the first row in each column equals.so if it equals "A" assign it an index 0

B 1
C 2

This seems theres too many steps and will slow down the app...

View 2 Replies


ADVERTISEMENT

Assign A Populated Datatable's Columns To Another Empty Datatable?

May 28, 2007

Is there a simple way to assign a populated datatable's columns to another empty datatable? That is, I want to copy a datatable's structure only but not its data.

View 6 Replies

Sort Dgv By 2 Columns?

Dec 10, 2009

I'm sure this has been asked here before but i couldn't find it, anyway my issue is i have filled a dgv using a LINQ query and i need to sort my results by 2 columns, i.e. type and cost so that it lists items by each type in creasing cost[code]...

View 10 Replies

Sort A Datagridview By Several Columns?

Nov 30, 2009

How do i sort a datagridview by several columns?

I want to sort the data in my DataGridView by the Title, Location and Reference, i have the following to sort the DGV by title, how can i include the two other columns in the sort?[code]...

View 11 Replies

Sort Out Two Columns So When Click Them?

May 26, 2012

how would you sort out two columns so when you click them, it either sorts the listed items in Ascending/Descending order. I have named Name column to colName and Mobile column to colMobile

View 10 Replies

Original DataTable Object Has Columns Added When Variable Has Columns Added?

Oct 6, 2011

I have a datatable property called prpParametersTable in a class called clsBatch. I have a procedure that sets a datatable variable called dtP equal to prpParametersTable at the beginning of the procedure. I then add three new columns to dtP.Here is my problem. When I add the three new columns to dtP my original table prpParametersTable also gets those columns added to it, why? I only want to add the three columns to dtP and not prpParametersTable. How can I do that?

Private Function prvfnc_InsertBatchParameters(ByRef cnn As SqlConnection, ByRef trans As SqlTransaction) As String
' set new columns that have BatchID, Insert DateTime, and UserID for the SQLBulkCopy method below
Dim clm As DataColumn
Dim dtP As DataTable = clsBatch.prpParametersTable

[code]....

View 1 Replies

C# - Sort On Multiple Columns In WPF Datagrid?

Jun 24, 2011

How can I set up my WPF datagrid to sort on multiple columns similar to having two sortable columns, clicking on the header of the first column for a primary sort and then SHIFT clicking on the header of the second column for a secondary sort. I would like the multiple column sort to happen automatically when the user clicks on the header of the first column without having to SHIFT click on the second column header. Is there a way to do this entirely in the xaml? If not how can I do this in the code behind? Currently using VB.Net but a C# snippet is acceptable if you have one.

View 2 Replies

Sort Datagridview By Multiple Columns?

Jul 19, 2011

How do I sort a DGV by multiple columns.

View 1 Replies

Sort Different Columns Of Different Type Of Listview ?

Apr 16, 2012

Using Microsoft Visual Studio 2010 Ultimate - VB.Net

I'm writing an application where as many of other applications fulfill the requirements to be as an app , having it's statistics schema. Thus I made a form where I have a combox(of query category), a textbox(as searchfield), two datetimepickers(from and to) a listview and a button to fire the event with functions in it. I'm all set except for a minor issue I've encountered during my very first experiments with ListView control. Thus far I didn't know that VB users are stuck with that control's property options (whereas DataGridView has way too many), especially when it came to Column reordering/s. With the simple but not satisfying property Sort I couldn't find a proper solution to my issue.

when I click on of the columns in the listview to do a Number/Date/Text reordering (descending>ascending, via-verse). Not to forget to mention there a limited number of columns most likely 2-4 max.

The listview control has lvResults name and has for now columns inserted as "Country" and the other for subitems "Total Spent".

One e.g. of the values inserted to it is like this :

[Code].....

If pressed on Total Spent, should reorder from highest to the lowest number and via-versa. If pressed on Country should reorder from A to Z or via-versa.

View 3 Replies

VS 2008 : DataGridView Sort By 2 Columns?

Mar 26, 2009

How do I sort a DGV by 2 columns? The DGV is not bound.

View 4 Replies

VS 2008 : Sort Columns In Listview?

Apr 16, 2009

I'm trying to set something up where the user can sort each column by clicking on the header... i've looked at some other examples and they seem pretty longwinded..so far i have the below...

VB
Private Sub resultsListView_ColumnClick(ByVal sender As Object, ByVal e As System.Windows.Forms.ColumnClickEventArgs) Handles resultsListView.ColumnClick
Dim oldsort As SortOrder

[code]....

which works fine... but only for the first column in the list view.Is there a way of specifying which column to sort based on which is clicked?

View 8 Replies

Asp.net - Sort Gridview Columns Ascending And Descending

Jul 25, 2011

I am trying to program my page in vb.net and asp.net so that when a user clicks on a column heading of a gridview, the data is sorted either in ascending or descending order. note that my data is coming from an SQL Server Express database. So far, I have done it so that the gridview can be sorted:

[Code]...

View 2 Replies

Ranking Excel Columns Based On A Sort?

Mar 23, 2012

I fought through a good amount of this and have gotten to the point where I can sort my arrays. What I need to do now is take the following code and sort the elements in descending order instead of ascending order. I don't know how to do that with the two arguments in the code:

Dim Cols(3) As Int16
Cols(0) = ColumnNumber + 1
Cols(1) = ColumnNumber + 2
Cols(2) = ColumnNumber + 3

[Code].....

View 1 Replies

Sort The Data By Columns In A List View?

Jun 22, 2010

how do you sort the data by columns in a list view, for example, clicking the title of the column to sort by ascending order.

View 3 Replies

How To Sort A DataTable

Jun 22, 2010

I'm trying to sort a DataTable using the following code:

Private Function sortDataTable(ByVal dTable As DataTable) As DataTable
Dim dView As New DataView(dTable)
dView.Sort = "Field ASC"
Return dTable
End Function

But it doesn't work. What is wrong? How can I sort the DataTable?

View 1 Replies

.net - Sort Datagridview Columns When Datasource Binded To List(Of T)?

Feb 4, 2011

I have a datagridview with its datasource binded to a List(Of T). Now i would like to sort on any of the columns.My code:

'Database access : items = List(BlogPost)
dgBlogPosts.DataSource = items
'My BlogPost Class
Public Class BlogPost

[Code]...

View 1 Replies

.net - DataTable Sort Test?

Jul 22, 2010

I was asked this question recently in a test, which I didn't pass. For the life of me, I couldn't spot what the problem was. It's probably something really obvious as well, but even a colleague of mine couldn't spot it either. The best I could come up with was issues with bottlenecks and naming inconsistencies of parameters! I blame it on the fact I've not done any vb.net for years, I've been doing C# mostly these days

[Code]...

The question: This function, although it will successfully sort a datatable, has a major problem with it.What is the problem? Re-write the function in either C# or VB.Net using LINQ.

View 2 Replies

Sort A Datatable Before Filtering?

May 7, 2010

I have a piece of code that filters a datatable based upon the cumilative value of records in a particular field. In short i specify a number and the filter counts through the records (rows) in the datatable and select the records that together are either exactly equal to or do not exceed a specified value (defined in a combo box on a form).[code]...

View 1 Replies

Creating A Sort Expressions For Datatable?

Feb 2, 2010

I have got a datatable which contains many columns in which three are main:

hotelid
dshotelid
hotelname

Some hotels contain only dshotelid, some contains only hotelid and some contain both dshotelid and hotelid.

I need sort in such way so that those hotels who got both dshotelid and hotelid should be on top and then those hotels who have got only dshotelid and at last those hotels who have got only hotelid...

create such a sort expression.

I created this :

dtmaintable.DefaultView.Sort = "dshotelid, hotelid"

but it Is not giving me desired output.

View 2 Replies

Sort A Combobox Binded To An Datatable In Wpf?

Apr 3, 2009

I have some comboboxes that are binded to some fields in a datatable

is it possible to sort each single combobox without soting the datatable?

View 1 Replies

Conditional OrderBy - Number Of Columns User Can Sort By (Name, County, Active)

Jun 17, 2010

I've got a number of columns the user can sort by (Name, County, Active) and that's easy but messy. Looks something like this...

Select Case e.SortExpression
Case "Name"
If (isDescending) Then

[CODE]...

What I would LIKE to do, is something more ... like this

Private Function SortThatList(ByVal listOfStuff As List(Of Stuff), ByVal isDescending As Boolean, ByVal expression As Func(Of Stuff)) As List(Of Stuff)
If (isDescending) Then

[CODE]...

But it doesn't like the datatype (Of TKey) ... I've tired Func(Of stuff, boolean) (got something in c# that works nicely like that) but can't seem to get this one to do what I want.What's the magic syntax?

View 2 Replies

Datatable Ascending Order Without Sort Method?

Jun 5, 2011

how to create ascending order datatable in asp.net without sorting method

View 3 Replies

Sort Datatable In .net With Linq By Column Index?

Mar 23, 2012

I need to sort a datatable. I do it with linq this an example

Dim query = From c In dt.AsEnumerable _
Order By c.Field(Of DateTime?)("LastPurchaseDate"), _
c.Field(Of String)("LastName") Descending
Dim dv As DataView = query.AsDataView

But my problem is that i need to sort the fields not by passing the name of the column but the index of that.

View 2 Replies

VS 2008 Sort Datatable Column(0) Alphabetically

Dec 10, 2010

I want to sort my datatable column(0) alphabetically, but cant seem to find a way to do it. Just to give you an idea:

[Code]...

View 2 Replies

Add Columns To Datatable?

Nov 26, 2010

i have a datagridview table ("Bookingen") that is bound to an acces datatable

this table ("Bookingen") has columns

an i also have another form that alows people to add info like a registerform

what i would like is that when adding the info by button click

a column with the name of the person from registerform displayes in datagridview ("booking")

this my code so far

Public Class nieuw_personeel_invoer_code_
Private stroledb As String = "SELECT* FROM Loginnummer"
Private strconnection As String = "provider= Microsoft.ACE.OLEDB.12.0; Data Source=D:clifs project21.accdb; persist security Info=false;"

[Code].....

View 2 Replies

C# - Sum Columns In A DataTable?

Apr 8, 2011

How can I get a sum for all the columns in a datatable? Say I had the following table. How can I calculate the "total" row? It should be easy to add total row to a datatable.

Columns hits uniques sigups, etc...
Rows
1 12 1 23
2 1 0 5

[Code].....

View 3 Replies

VS 2005 Sort Data New Column Added To DataTable?

Feb 21, 2011

I am creating a datatable and then adding a column to it which is filled with data from existing column and parsed into correct format DateSold is my existing column from my datafile and I create NewDateSold by adding the column to the existing table and then parsing the information in date format.

This is added to a binding source which then is used to populate a combobox I want to be able to sort the combo box by NewDateSold Desc I was able to this on the original column by simply using the "order By" in my query, it seems now that I added new column it is no longer sorted? I am finding different solution such as using dataview and wish to know the best way to do this

View 14 Replies

Adding Columns To DataTable?

Jun 2, 2011

I have a DataTable oDT. oDT is populated from SQL Server with 6 columns including a column "bAAA" of varbinary(200) I have a function fx(ByVal byteArray As Byte()) as String I would like to add a calculated column to oDT something like this:

oDT.Columns.Add("sAAA", GetType(String), fx(bAAA))
'bAAA is not declared
oDT.Columns.Add("sAAA", GetType(String), fx("bAAA".ToArray))

[Code].....

View 2 Replies

Array From 2 Datatable Columns?

Sep 28, 2011

Since now, I have the following:

vb
Dim x = ( _
(From row In _Obj_DataSet.Tables(TableName).Rows() _

[code]....

View 3 Replies

How To Fill DataTable With 11 Columns And 1 Row

Dec 30, 2011

I fill a data table with 11 columns and 1 row.
Columns/ User Pass
Row / **User2054** 1234
I have a Label named lblUser and I want to put the value=User2054 from my Table(Collumn[0], Rows[0]). How I can fill it?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved