VS 2008 : DataGridView Sort By 2 Columns?
Mar 26, 2009How do I sort a DGV by 2 columns? The DGV is not bound.
View 4 Replies
ADVERTISEMENT
Sort A Datagridview By Several Columns?
Nov 30, 2009How 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]...
Sort Datagridview By Multiple Columns?
Jul 19, 2011How do I sort a DGV by multiple columns.
View 1 Replies.net - Sort Datagridview Columns When Datasource Binded To List(Of T)?
Feb 4, 2011I 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]...
VS 2008 : Sort Columns In Listview?
Apr 16, 2009I'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?
VS 2008 - Sort Datagridview By Dragging?
Sep 28, 2011I have a datagridview showing data from an Access database. I have dragged the datagridview from "Data Sources" window - and not written any code. In bindingsource I have choose to sort on an autonumber field. Is it possible to let the user use the mouse to change the order, and the database to remember this the next time the user starts the application.I guess I have to have a number field in the database, and write code to change the value in number field as the user change order - and then save this back to the database? Does the datagridview support changing order by mouse at all?
View 1 RepliesSort Dgv By 2 Columns?
Dec 10, 2009I'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 RepliesVS 2008 DataGridView - Refresh Without Changing Sort Order
Nov 15, 2009Asset Database, with DataGridView that is populated with desktop and laptop PC's by 'Office' and 'PC Type' (Combos). You can double-click a row to open an editing screen to edit the PC details eg: assigned user, purchase date, serial number and so on. The problem
[Code]...
How To Sort By Columns In A Datatable
Sep 1, 2011I 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...
Sort Out Two Columns So When Click Them?
May 26, 2012how 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 RepliesVS 2008 : Resize Columns In DataGridView?
Apr 1, 2009Because I have been trying for ages, and each time it returns to default. Under the 'Properties' window, I have taken this image to show what I have done. I have also tried resizing it as it is running, but the next time it is opened it returns to default size.[URL]
View 2 RepliesVS 2008 DataGridView Columns Spacing?
May 18, 2010what's the best way to add some space between some columns, just to aid the user to read/understand the data (i have more than 50 columns).In this particular case i'm using a data bound dgv and one approach that i'm using currently, it's in the SQL statement add a new column named SPACE1, SPACE2, etc...Something like:
SQL
SELECT col1,col2,NULL AS SPACE1,col3,NULL AS SPACE2...
I know that i can add columns at runtime, and handle the cell paint event to change the left and rigt margins... But i don't know what option should i use, does anyone know a better way or in the above three it's the best one?
VS 2008 DataGridView ComboBox Columns?
Nov 9, 2010So i have a datagridview with two combos, when the form it's created i fill the first one with all the MainValues, and the second one with all possible values for the MainValues (called SecondValues) (1..N).Now my issue, when the user selects one value from the first combo i want to fill the second combo with all values related to the selected MainValue, i can do this for example by filling the datatable again with a parameter that filters the data, but if the previous rows have different main values, the dgv throws errors because it doesn't find the binded ones in the new filtered datatable.
How can i handle this? One datatable for each line?! Other thing, i'm using the SelectionChangeCommited event for handling the values change (in theEditingControlShowing), but if the user uses the keyboard to select the values the event doesn't behave in the same way or the way that i need. The values in the combo are numeric values (1001,1020,2010,3010), when the user select one of the values, i need to fill another cell in the same row with the number selected plus some string, example combo:1001 cell:1001XPTO. So if the user presses 1 in the keyboard the combobox selects the 1001 and fills the cell with 1001XPTO, but if i keep pressing the keyboard to select the 1020, by pressing 0 and 2, i get the 1020 selected in the combo, but the cell remains with the 1001XPTO.
Display And Sort Data In DataGridView Control In Program 2008?
Jan 24, 2010I've been asked by a local window cleaner to design a small utility that can display a grid of customer data, sort them, and then export it out as a formatted .txt or rtf file.
View 1 RepliesDataGridView, Set Up Columns, Populate Data Table, Bind, But Not Using Columns Created In Code?
Oct 26, 2011I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
C# - Sort On Multiple Columns In WPF Datagrid?
Jun 24, 2011How 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 RepliesSort Different Columns Of Different Type Of Listview ?
Apr 16, 2012Using 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.
VS 2008 Datagridview With Unbound Combobox Columns?
Dec 14, 2010I am working with an Unbound DataGridView. I would like to vary the contents of a second combobox based on what is selected in the first. I have code to add the columns and populate the first combobox, but I can't figure out how to do the second one since it can (and usually will) have a different list for each row AND the list must change when the selection in the first is changed.
View 1 RepliesAsp.net - Sort Gridview Columns Ascending And Descending
Jul 25, 2011I 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]...
Ranking Excel Columns Based On A Sort?
Mar 23, 2012I 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].....
Sort The Data By Columns In A List View?
Jun 22, 2010how 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 RepliesVS 2008 - Show Vertical Columns Lines For Datagridview
Jan 4, 2012Is it possible to show vertical columns lines for datagridview, also for empty area, as VFP grid,as in image?
View 2 RepliesVS 2008 DataGridView, Partially Filling Columns Automatically?
Mar 5, 2010I am entering data in a dataGridView, I have a column named with 6 characters.The first 3 characters are always "HHH"When I enter in this cell, Is there any way to put automatically these 3 characters and start to write in the fourth one?
View 2 RepliesVS 2008 Insert Data In DatagridView With Predefined Columns?
Mar 6, 2010I can't seem to add data in my DatagridView by having set the Columns, this what my datagridView looks like:he combobox you see where filled by this
ReaderQuery("Select ChargType from ChargeType")
cmbCharge.Items.Clear()
While dr.Read
[code].....
VS 2008 : Programmatically Send Information From A Text Box Into Specific Columns In A DataGridView?
Jun 15, 2009Is there a way to programmatically send information from a text box into specific columns in a DataGridView? I tried
vb.net
Column1.Text = TextBox1.Text
and it obviously does not work.
VS 2008 Have A Dozen Or So Text Boxes Be Emptied Into Separate Columns In A Row Of A Datagridview?
May 13, 2009I want to be able to have a dozen or so text boxes be emptied into separate columns in a row of a datagridview. This way the text boxes can be cleared and have new values entered then save the new values as a second row in the datagridview. This is so my VB gui which which runs everything through an old cmd line program, can do batches instead of one run at a time.
The problem is I have absolutely no idea how datagridview works. I've tried searching google and only found some vague things and stuff about databases. I also tried the MSDN library and that was of no help either, couldn't find anything on simply adding stuff and if I had it'd probably be to complicated to be of use to me.
Conditional OrderBy - Number Of Columns User Can Sort By (Name, County, Active)
Jun 17, 2010I'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?
Sort DataGridView Numbers (when Clicking The Datagridview Column Header Text)
Mar 11, 2010A datagridview is sorting numerical values (when clicking the datagridview column header text) in the wrong order based on the initial digit:
[Code]....
Sort Not Working Datagridview Gives "DataGridView Control Must Be Bound To An IBindingList Object To Be Sorted?
Dec 4, 2009I have a few classes, one is a form, the other is the source of the datagridview. I want to be able to sort the columns of the datagridview by clicking on the header. Here are the classes that I am dealing with:
Imports DiscoveryByte.AddTools.Misc_Tools
Public Class ViewDiscoveryFlashCards
Private DBBindingSource As New BindingSource
[code].....
.net - DataGridView Sort Does Not Work
Nov 9, 2010Visual Studio 2010 VB.NET
I have a DataGridView.DataSource set to a Collection of custom objects. The columns use read only properties from the custom object for display, this dialog is for display only. The properties all return String objects. I set the columns all but 2 of them to sortmode automatic (the ones that are not set is a button or a checkbox). Yet it does not sort. I have googled around and most people use sql or binding sources but I am using a trivial vb collection. Some say I should implement IComparable but isn't String already IComparable?
Per a request here are some code snippets.
This method defines the columns in detail from columns I designed in the designer.
The column names are called pSelected or pCustomer and corresponds with a property by the same name that the column definition ties to.
Protected Sub UpdateDGVUS()
If Not USColumnsInitted Then
USColumnsInitted = True
[Code]....