I have a .Net 4.0 WPF application using a data grid. Currently after sorting by a column, the scroll position of the grid stays where it was before the sort.For this application, I need to scroll to the top of the grid after any sort.I've tried handling the sorting event like this
[code]...
But this appears to fire before the sorting takes place and doesn't perform the scroll.
how can i programitacly scroll down to the bottom row on a dataGrid.[code]
View 1 Replieshow can i programitacly scroll down to the bottom row on a dataGrid.i tried this
0
grid.rows(ds.tables("x").rows.count).selected=true
didn't scroll down
how to make a datagrid auto scroll to the bottom when data is added. Does anyone know how to scroll a datagrid to the bottom when data is added??
View 1 RepliesIn my form I have several datagrids.
View 2 RepliesHow 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 RepliesI know how to set sorting direction on each column in datagrid programatically, but I wonder how to do the opposite: obtain the sorting direction for a particular column.
View 1 RepliesDim cn As String = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database genk.mdb;")
[Code]...
I am trying to use bubble sort to sort to sort the deatils shown on the datagrid. The buuble sort code is there and the data grid view code is there which retrives the product details in my databse. How would i link the two together so that when the user clicks the button it uses the bubble sort code to sort and view the product deatils in order of the selected coulmn name selected by the user through a combo box?
I have use this code to view my database into my datagird
Dim dbPath As String = "Provider=Microsoft.Jet.Oledb.4.0; Data Source=../VG.mdb;Persist Security Info=False"
Dim dt As New DataTable
Dim ds As New DataSet
Dim da As New OleDbDataAdapter
da = New OleDbDataAdapter("Select * from Marriage", dbPath)
ds.Tables.Add(dt)
da.Fill(dt)
Now every time I visit that form I have to manually click the column header of "EventDate" to that it will sort Descending. Is there a way to automatically sort it every time I visit this form?
I have a table with two columns, date and time. I am using the following code to sort in descending date order.
VB
If historydataGrid.Rows.Count > 0 Then
'if there are rows, sort by date (most recent first)
historydataGrid.Sort(historydataGrid.Columns(0), System.ComponentModel.ListSortDirection.Descending)
End If
Where Columns(0) is the Date. However, how difficult is it for me to then sort secondarily by time. So that the grid will sort by most recent date and time.. Working down from the most recent time on the most recent date, and then moving backwards towards the oldest date with the oldest time.
I am using vb.net2010. (express)
I am currently writing a bit of software for myself and need guidance.
I have a datagridview on a form with a date column. (column0)
I am trying to sort this by date desending but it will only sort by the day (dd) and not the whole date (dd/mm/yyyy) which leaves the months and years unsorted.
(example of output):
#1 - 01/03/2012
#2 - 02/01/2010
#3 - 03/02/2011
[Code]....
I have been told " Make sure the Date column is a date type and not a string " which i have taken as the access database column type. I have set this as Date but it still won't sort the column in datagrid view by the whole date.
How to sort numbers from lowest to highest in my datagrid table?
View 1 RepliesStill experimenting with datagrids and ran into another problem...I'd like to sort a column displayed in a datagrid bound to an Access table programmatically. The field is a date ime type and is sorted in descending order in Access. I can manually sort it at run time but i'd like to know how to sort it with code.
View 1 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]....
I have a tab control with two tab pages. One page has the auto scroll enabled since there is to much content in the page. The middle mouse wheel doesn't scroll the scroll bar; I have to actually click and hold the scroll bar and drag it down to scroll. Is there a property to allow this?
View 2 RepliesI am having an odd problem with the Horizontal Scroll Control in my program.I am using it to scroll a series of panels across a form.This is my code:
Private
Sub scrHoriz_Scroll(ByVal
sender As[code]....
The problem is that this works perfectly if I use the left and right arrows and it also works perfectly if I use the scroll bar's slider SLOWLY. If I scroll using the slider and move it quickly then the scroll gets out of sync.The small change and large change are both set to 1 and maximum is set to 8
I have a DataGridView with a panel above it, that contains a group of textboxes above each column. My DataGridView has a horizontal scroll bar. What I want to do is when the DataGridView scrolls horizontally, scroll the panel with textboxes above it, so they stay aligned.I tried handling the DataGridView's scroll event, but I'm not sure what to do with it.
View 1 RepliesI am loading several command buttons into it (one in each grid box). I have the panel set to autoscroll. When TableLayoutPanel is set to AddColumns, all works well. However, I dont want horizontal scroll, I want vertical. When I set TableLayoutPanel to AddRows, a vertical scrollbar will not appear.
View 4 RepliesHow would I leave the vertical scroll position as it is and set the horizontal scroll position all the way left if it isn't already in that position? I've been using Me.AutoScrollPosition and have come up with code that is satisfactory but I haven't been able to always leave the vertical scroll position exactly as it is and just move the horizontal scroll position to the left limit.
View 4 RepliesI have a textbox that shows events on a program, which I add. I use the 'scroll bar' option on the textbox to show the vertical scroll bar, but how do I make it stay at the bottom most possible? I am using this code while I am trying to learn how to do what I want the scroll bar to:[code]But how do I get it so the scroll bar will stay at the bottom-most it can? I'd like the newest, most recent events to appear at the bottom of the textbox, and to have the user not have to scroll down every time something new is added.
View 2 Repliesi have 2 controls on a form. Panel1 and picturebox. I am using the following code to zoom in.
PicBox.Width = PicBox.Width + 100
PicBox.Height = PicBox.Height + 75
'PicBox.Left = PicBox.Left - 50
'PicBox1st.Top = PicBox.Top - 20
i am also using the following code to try and scroll whilst zoomed in
Inherits System.Windows.Forms.Form
Private m_PanStartPoint As New Point
Private Sub picbox_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles PicBox.MouseDown
'Capture the initial point
[code]....
I have set the panel to autoscroll and added scroll bars but they do not scroll far enough... They only scroll about 2cm.
Following default the datagridview will scroll following vertical. How can i do that. I tried :
DataGridView1.ScrollBars = ScrollBars.Horizontal but not work
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].....
Is it possible to write code to make a scroll bar scroll? I have a working scroll bar on my form.
I am using voice in my application and I just want to know if there is code that I can write to make it scroll so that I can add that code with a voice command so it will scroll.
Sub Sort()
ReDim RollsCC(NumOfPlayers - 1)
For N As Integer = 0 To (NumOfPlayers - 1)[code]....
Here I am creating a temp single dimensional array, merging my 2d array into it, and then attempting to sort it by Rolls(N,1), which is a integer 1-6, Everything seems to be working right with the exception of this.
RollsCC.Sort(RollsCC, 0, 1)
How would one specify a numeral sort based on the first character in the string? im aware that I am switching Rolls(n,1) and Rolls(n,0) information during the sort.
Currently my ListView sorts items by image.index. So 0 is at the top, then 1, 2 and so on. Think of it as an IRC chat room nick list. Ops at top then the rest are sorted alphabetically
[Code]....
I am trying to sort an arraylist using .Sort() but am not sure what to put in the () for the field/column I want to sort on. Here is the portion of my code that creates the array from a SQL Query
[Code]...
I am using the Array type .Sort function to sort my array.By default it places the result Array into Ascending order Least to Greatest How do I change that to Descending order Greatest to Least?and How do I change it to Closest to logic? or does that not exist?Assume there is an Array of Numbers 0,13,21,-2,4,5,1.34 and I want them to sort closest to 0 or some other arbitray value; the Output should look similar to:
0,1.34,-2,4,5,13,21
I have a datagridview with transaction bindingsource I want the datagrid to show the sorted rows only not all the records when i enter a value into a textbox and click button sort.
View 1 Replies
