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 RepliesI'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 RepliesI 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...
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]...
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 RepliesHow do I sort a DGV by multiple columns.
View 1 RepliesUsing 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.
How do I sort a DGV by 2 columns? The DGV is not bound.
View 4 RepliesI'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?
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]...
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].....
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 RepliesI 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]...
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?
I have coded my program so that when a user clicks on a column, the data is sorted in ascending/descending order.When I go to click on a column header, however, nothing actually happens.I dont get an error or anything.Here is the code that I am using to sort the records in the GridView:
Property GridViewSortDirection() As SortDirection
Get
If IsNothing(ViewState.Item("GridViewSortDirection")) Then
Return SortDirection.Descending
[code]....
Basically, I need to be able to click a row header to sort a datagridview, similar to how clicking a column performs a sort.
View 7 RepliesRight, I'm trying to sort a WPF listbox when a button is clicked, preferrably in pure xaml (otherwise VB). I'm having a hard time seeing as most samples are written in C#. Here's my code:
<Grid.Resources>
<CollectionViewSource x:Key="myCollectionView"
Source="{Binding Path=Query4, Source={x:Static Application.Current}}" >
<CollectionViewSource.SortDescriptions>
[Code]....
Now when this button is clicked, I'd like the listbox to sort by the field "First Name", I assume I have to change the sort description somehow? Again preferabbly in XAML, but if need be in VB could you try and keep it simple
I created a DataGrid by dropping a DataSource on my Form. When I run it in debug, it works great.
My question is:
When I click on a column to sort by, ascending or descending, how can I tell which column was clicked on, and whether it is ascending or descending?
how we can sort a listview by a column without click event?
View 1 RepliesI have a filtered gridview in an updatepanel.I want to allow to sort filtered data.How can this be done?When I click to sort a column it reloads the entire gridview.
View 1 RepliesI am writing an application using Visual Basic Express 2008 and I need the right and the left mouse click to both act like the left mouse click. That is the right mouse click should not display a menu of any sort and be able to select items just as the left mouse click.
View 3 RepliesHere's the issue in a nutshell (I can elaborate if you feel it's needed). In a DataGridView I want to capture the value of the row's key column so that when the user clicks on a column header to sort the data, I can reposition to the row that was selected prior to the click. The problem is that the sorting itself, once it's done, fires the same events (RowEnter for example) that I used to determine my key value, so it sets my variable to a new value and now
View 7 RepliesI am using Visual Basic.Net 2003 with an Access 2000 database.
An integral part of the program that i'm working on is a DataGrid which I am filling from three different queries, based on the user's input. The Grid properties are coded with specific requirements for each of the queries. I have two simple (hopefully) problems.
1) There is no scroll bar on the grid and I can't find a property or event that will allow me to add the Vertical Scroll Bar. How do I do that.
2) The grids contain only four columns each. I want the user to be able to click on a cell and populate four string variables.
I am using datagridview to show the data when the form load.Datagridview have a template checkbox column also where the user will select the class to attend.I want to loop the datagrid and find the selected row ro columns value when the user click the save button How i do this am using vb.net 2008?
View 8 RepliesIt seems that on clicking datagridview column header, the column will be automatically sorted based on the column type. I have a column showing some numbers. If column type is string, it sorts "1","20","3" into "1","20","3". If column type is double, it sorts into "1","3","20" which is the result that I want. However, there might be some erros in the numbers and error messages(text) will show in the cell instead of numbers. So I cannot set the column type as double. I want to ignore these error messages and sort all the numbers. How can I do this?
Also, I need to add some background colors to different rows in datagridview. So in the column header click event, I call the bkgColor Sub to achieve this. My question is that how can I override the sorting method in this event?
Private Sub DataGridView1_ColumnHeaderMouseClick(sender As Object, e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView1.ColumnHeaderMouseClick
Try
[code]....
How can I improve this bit below to make the items in the TreeView to sort faster or something totally different to sort them easier?
[Code]...
I have a MyObject; myObjects as List(Of MyObject) and a delegate Comparison(Of MyObject) that uses a lot of comparison functions (ByA, ByB, ByC etc) Ã la:
Shared Function CompareMyObjectsByName(x As MyObject, y As MyObject) As Integer
Return x.Name.CompareTo(y.Name)
End Function
[Code].....
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.
[Code]...
I have the below Linq query that is returning the data but I need to aggregate the columns to group on the Period and Sum the Count columns. How do I go about doing this?
LINQ
from t In tblTimes
join h In tblEngineeringDashboard_CADMachinesCounts on t.ID Equals h.TimeID
Order By t.Period
[code].....