I have a Datagridview whose source is a BindingSource. The grid has columns Source,FormatShort, and Number among others. I would like to sort the grid's appearance according to the order below:
View 6 Replies
I want to sort the binding source column (Product Code) which formatted like (AA-AAA AAA AAAA)
but i do not want straight sort on product code column, i want the sort as :
substring of 1,2 + 8,3 + 3,3 and then the rest of the column.
I know i can do it in the table direct using the OrderBy and the substring function, but the problem is that sort is not static it is dynamic according to different status means it change the substring order.
I need to sort the rows in a bindingsource. When I sort by a field name, ASC, it works correctly, but when I sort in DESC mode, instead of being the opposite of ASC, it sorts the rows whose fields have the same value in ASC order. For example:
I've got a column with the values A, B, P, P, P and P
ASC: A B P(1) P(2) P(3) P(4)
DESC (as i want it to be): P(4) P(3) P(2) P(1) B A
DESC (as it sorts):P(1) P(2) P(3) P(4) B A
Is there any property in bindingsource which I can use to change this?
I am trying to display a football league table in datagridview. my code gets that data for each column from ms access and displays it in datagridview. I want to sort rows according to the value of the "pts" column.I've tried using using BindingSource.Sort = "pts" but this has had no effect.
[Code]...
how to sort a bindingsource basing on a column that has alphanumeric values
View 11 Replieskeep the listbox sort order
View 3 RepliesI want to sort from ascending order so i will know where will be the first priority but i dont know what is lacking in my code and whats wrong with it.
Here's my code for sorting i dont know if this is right. It say's IndexoutOfrangeException was unhandled i dont know what's the meaning of that. . . .
Dim p() As Integer = {TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text, TextBox5.Text}
Dim a, c, d, f As Integer
[Code]....
I am loading an array with data at form load from a text file. I then display that data in a label box. When a user clicks a button I want to sort the data in ascending order. I have a sort code right nowbut it is not correct at all! Another problem i dont know if it will correctly sort becuase the data from the input file is like this: C2 CA D4 S9 HA C4 CQ D3 DA DQ .....AND SO ON AND SO on up to 52 like a card deck, here is my
[Code]...
ListBox2.Items.Clear()
Dim list() As Integer
Dim count As Integer = ListBox1.Items.Count
[code].....
I am using VB.NET 2008 My DataGridView is bound to a DataSet. After adding a DataGridView row (from another form), I needed to sort the DataGridView in order to put the new row in the appropriate place. I needed to be able to identify the current sort column and the current sort direction (ascending/descending) but I was unable to find out how to obtain that information from the DataGridView properties. Consequently I had to do it the hard way via my own coding. The sort column name (or names) and the sort direction then became available to my program in the global variables.
[Code]...
I have a LINQ Query:
[Code]...
This works great and sorts on L_Name. But I am trying to allow the user to sort the gridview themselves so I am passing in the SortExpression as a string. But I don't know how to incorperate the SortExpression into the LINQ Query. I tried Order By c. & SortExpression but that did not work.
sorting a code into Ascending order
View 5 RepliesI am sorting a dataview by a date/time stamp. As of right now it is sorting it oldest to newest. How might I write it to write from newest to oldest?
[code]...
I am trying to do a bubble sort using arrays and i am trying to sort a word in its alphabetical order... and my problem is that. i could not assign a value into my array from my textbox and get the length of the word from the text box... i do have this alogorithm'dim asd () as string'asd() = Text1.text'Len(asd()) but it seems that it doesn't work that way as what i am thinking.how to do it? it has been bothering me for days now and even if i do a lot of library sessions for this but still i could not find what i want to know.
View 8 RepliesI have 1 column of buttons that have names in them. i just want to be able to see the in alphabetical order A to Z down. at the moment they just list randomly down. they also have a unique id in the .tag field. How to achieve this alphabetical sort? i am using Visual Basic 2010 Express.
Here is the code that creates the buttons under one another.
HTML
Buttons(i) = New Button 'Create a new button object in the array element
With Buttons(i)
.AutoEllipsis = True
[CODE]...
i have lines like this
1.0 28 Blue [B3-T1 ] (2 16.00 43.0) 10000 -10000 72111 23275
1.0 28 Blue [B3-T2 ] (2 17.00 43.0) 11000 -10000 72111 30275
1.0 28 Blue [B3-T3 ] (2 16.00 44.0) 12000 -10000 70611 23275
[Code].....
Let say the columns that i highlighted is X and Y. I have to arrange the small Y first which is -10000 then arrage big Y which -11000 then arrange again samall Y followed by big Y. Here i only have -10000 and -11000. but let say i also have -12000 so i have to arrange -10000 first then -11000 then -12000. But i also have to look at X column. If let say x value is same next line so it should side by side like i higlighted the two row.
the lines should be identified by [B3] as it will be one group. Can we use IComparer methode here? How to arrange the lines in order thet i want?
How to Sort List Box in decensing order? both alphabetic and numeric.
View 1 RepliesAfter updating a dgv , i want to again perform sort on the dgv with its already sorted column and the sort direction.
I am able to get the sorted column using 'SortedColumn' property, but how should i know the direction of the sort
[code].....
View 10 RepliesI have a generic list, like this:
System.Collections.Generic.List<Question> myquestions = new System.Collections.Generic.List<Question>();
And I have a paging example, using a LINQ table acquried from database, doing this for paging:
var questions = context.Questions
.OrderBy(sidx + " " + sord)
.Skip(pageIndex * pageSize)
.Take(pageSize);
Right now, for paging my populated from code list, I have:
var questionss = myquestions
.OrderBy(x => x.Id)
.Skip(pageIndex * pageSize)
.Take(pageSize);
And what I want is being able to order "myquestions" by a string as in the above example. Is that possible?
how to create ascending order datatable in asp.net without sorting method
View 3 RepliesI am trying to do two different things in one giant query. I am trying to specify a custom sort order which i have working in the following query:
Code:
SELECT Count(*), Status, 1 as OrderCol FROM tblSurvey WHERE Status = 'Complete - CD Sent to Customer' AND SurveyTable = 'tblSurveySoVA' GROUP BY Status
[code].....
how do I sort a list properly so the numbers are truly in order?
BAD GOOD
1 1
10 2
11 3
[code]....
sort a text from a textbox to see if it is in alphabetical order!
View 2 RepliesDrag treeview named TreeView1, textbox named TextBox1,button named Button1.I m adding nodes programmatically. Select the node,Enter text in TextBox1 & then click on Button1 to add the node.Mine code is doing this, I want that when the user add nodes it automatically sorts.
Suppose user selects All(node) that is added on form_load,enter 1 in textbox1, click on buuton1,node added.Second time again user selects All,enter 3 in textbox1,click on button1, node added.Now the user enters 2 in textbox,click on button,node added. I want that nodes are automatically sorted after adding.I want
ALL
1
2
3
Currently i m getting output
ALL
1
3
2
[code]....
I have a dictionary with the keys being integer and the values being string. I was wondering how can I sort the dictionary in DESCENDING order using its keys.
View 6 RepliesI have been experimenting with datagridview by designing a bill tracking program. The first challenge I haven't been able to solve myself is how to sort it. I managed to figure out how to save and update from xml but I don't know how to put it in any particular order. Is this possible with it bound, or would I need to write particular code to custom-fill in the date grid? All I am looking for is an a-z sort.
View 2 RepliesI have a line like this
18N694 P321 117461, 50374 50MIL;
XTAL_X1 P253 116711, 66524 39MIL;
HR_ICH_HUB_CLK66_R P1567 109761, 68424 39MIL;
P64H2_CLK66_R P2177 110161, 68424 39MIL;
CPLD_NET2 P1151 4711, 90424 75MIL;
V3_3_MGMT_PWR_RST# P3482 4711, 90024 100MIL;
From the above line I have to look the last word MIL. Then I need to arrange the line in ascending orders according to 30MIL,50MIL, 75MIL and 100MIL. Can I use IComparer? Because here I dont know how I can reach the word MIL and sort.
Asset 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]...
I am getting data from an SQL Server database and displaying the data on a Windows form.How do I navigate through the data in a Sequential Order or Sort Order using the the REP_ID number? Example: When I use the navigation to move from one data to the other, can I go from; example: 100001 to 100002 and so on?
Finally is there any hint as to why I am getting the time with the dates? I know it is converted to text but not sure how to remove the time and just get the dates.Here is the entire project code:
Imports System.Data
Imports System.Data.SqlClient
Public Class frmBindingData[code]......
