What is the correct way of writing this?
Me.QuickViewTableAdapter.Fill(Me.PVDBDataSet.QuickView.OrderBy(0))
I'm trying to control the order of a specified column. But I need to this in code, not through the designer.
I want to replicate what I have with a Mac application. I want to fill the background area of a
PictureBox with grids as shown in the following screenshot (right below the blue arrow).What I have is a simple translation of the code that I use with this Mac application to create the background area, which doesn't quite work.Private Sub PictureBox1_Paint(ByVal sender As System.Object, ByVal e
As System.Windows.Forms.PaintEventArgs) Handles PictureBox1.Paint
Dim g As Graphics = PictureBox1.CreateGraphics()
Dim i, j As Integer
For j = 0 To Math.Ceiling(PictureBox1.Height / 20)
[Code]...
Onion is a recent refuge from Mac OS X and hates Mac App Store. System: Windows 7 x64
I dont think I am writing the values to the object. Not sure if this is the best way to do this with multiple values.Public Function ListDMR() As DMRDataLists
[Code]...
I'm new to Linq, what's the syntax for orderby in VB? [code]Select distinct state from zipcodes order by State
View 2 RepliesI am currently reading Pro LINQ c# 2008, and in page 87 the guy says OrderBy and OrderByDescending are stable. But he says exactly the opposite in page 96. It looks to me as he is referring to exactly the same functions, so I don't get it. Are they stable or not?
View 2 RepliesI have a grid view with a lot of columns, all need to be sorted on. I have seen a few snippets out there, but I cannot get any of them to work with my example. Here is what I have so far.
Protected Sub gvSearch_OnSorting(ByVal sender As Object, _
ByVal e As GridViewSortEventArgs)
If Not Session("sort") Is Nothing Then
[code].....
m_ListOfsAllFields.OrderBy(Function(x) x.DisplayOrder)
here I have DisplayOrder = 0 for 2 fields, so orderby is messing up and not ordering properly. How can I use orderby to order this collection?
I've got the following to sort entities by their job position. The desired order ist defined in another array. In C# this code works:[code]However I will have to convert this to VB.net. I read the equivalent would be something like the following:[code]This does not compile, gives me "Expression expected" right after the Function(x). What am I doing wrong?
View 1 RepliesI'm having a problem implementing Scott G's Dynamic.vb extension at [URL] in my vb solution. I've searched StackOverflow (80+ Q&As) and numerous other sites without much luck. I'm using VS 2010.I've included Dynamic.vb in a problem with no root namespace, and then added a reference to that project in my main one. I'm getting intellisense for 4 overloads (rather than 2) so I'm pretty certain that the extension is in scope.I was having a tough time with clauses, especially the OrderBy as Scott demonstrated. If I simply pass a string as Scott's VB example did I get the error "Overload resolution failed because no accessible 'OrderBy' can be called with these arguments."
The line of code is:
Dim FilteredComponentList = From Component As MX.Component In ComponentList.AsQueryable _
.OrderBy("Name")
So I found other references that stated to pass a Lambda expression. So I tried this and at least I get no error, even if the sort function still doesn't seem to work. Here is the code that compiles and executes.
Private Sub SortByColumn()
If Not cmbComponentFilter.SelectedItem.ToString = "All" Then
Dim FilteredComponentList = From Component As MX.Component In ComponentList.AsQueryable _
[code]....
When I interrogate the dgvComponents.Columns(e.ColumnIndex).Name it gives the objects property I wish to sort by, but the sort still isn't working. I'm concerned why I can't get Scott's implementation to work, but I've heard his keynotes and read his blogs, so I'm guessing the problem lies with my implementation.
I'd like either to work but need to understand why as well. Why doesn't passing a string work? Isn't the PARAMARRAY declared in the function optional?
I'm trying to sort a IQueryable dynamicaly.
Dim activities =From a In db.VW_Activities Select a
activities = activities.OrderBy(Function(a)
New ActivityComparer(SortFields(0).Sort))
definition of SortFields:
[Code]...
I am trying to pass a lambda function to Linq's orderby and cannot get it to work.
The relevant code is:
Dim myordering = Function(m) m.Count
If isAlphaOrder Then
myOrdering = Function(m) m.Key 'Order by Alphabet
[Code].....
I'm getting my feet wet with Lambda expressions and it's rather overwhelming.I have a UserPrincipal object called SelectedUser. I wish to get a sorted list of the user's groups This is what I have so far but when I include that code my application's form flashes a few times and closes! Also, what is the significance of the "r" in the "Return From r" statement?
Dim SortedGroups As PrincipalSearchResult(Of Principal) = GetSortedGroups(Me.SelectedUser.GetGroups())
Private Function GetSortedGroups(ByVal psp As PrincipalSearchResult(Of Principal)) As PrincipalSearchResult(Of Principal)
Return From r In psp.OrderBy(Function(t) t.Name)
End Function
I have a method in a webservice that has parameter with which users can decide how they want to order their results. This is a List(Of String) with the names of the fields in the order they want to sort them. I know I can normally order on multiple columns by doing the following
Dim test = Bars.OrderBy(Function(x) x.Foo) _
.ThenBy(Function(x) x.Bar) _
.ThenBy(Function(x) x.Test)
However in this case this won't work since I can't chain the ThenBy function because I'm adding the sorting orders in a loop. To use ThenBy I need an IOrderedQueryable collection. This is how I would want it to work
Dim sortColumns = {"Foo", "Bar", "Test"}
Dim query = From b in Bars
For each column in sortColumns
Select Case column
Case "Foo"
query = query.Orderby(Function(x) x.Foo)
[Code] .....
I need to return an a generic list in the correct order for my project, and I'm getting InvalidCastException errors. Here is the code:
Dim lDt As List(Of Comment) = RemapCommentsForE1(so.CommentList). _
OrderBy(Function(x) x.CreateDate.Value). _
ThenBy(Function(x) x.Sequence). _
[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?
winforms .net 3.5 Ultrawingrid 9.2 In my subclass of Ultrawingrid.Ultragrid :
[Code]...
This works fine. But when the grid is dropped on a TabControl tabpage, the ctrl-tab looks very different to the sub above. e.keycode is seen as controlkey {17} I realize that by default cntrl-Tab moves between tabpages. I need to override this behavior. My thought is I probably need a subclass of the tabControl which will pass the keycombo through just as the form does but I confess to being clueless as to how to accomplish that. I tried to override the onkeydown of a tabcontrol subclass and just issuing a return and not and base call to onkeydown if the ctrl-tab combo was pressed but it seemed to see the e.keycode as controlkey as well.
[Code]...
i'm using the MVCContrib grid trying to override the start of a row and the end of a row. It's not working as advertised. This is an extract from my MVC2.0 view.
<div id="chargestable">
<br />
<% With Html.Grid(Model.InvoiceListingInformation)
.Columns(Function(column)
[code]....
The stuff i put in the begin row and end row functions is being rendered above the grid entirely.(PS i can't just use the attributes as i need to wrap the row in another html element)
i have a prob that i have a gridview on the parent window. when i open a child window using showmodaldialog, i enter some data in the textboxes. now when i close my child window i want to display the text entered by me in the grid. i want to know how can i access the grid in child window
View 1 RepliesTrying to understand the basics of grid design so how would I make a over sized grid or a grid larger then whats viewable on my screen resolution? Below is a simple chart describeing what i want to make roughly. I would like to build the grid in "blocks".[URL]..
View 16 RepliesThe below code was written to bind the datatable to the grid, but i am unable to fill the grid.I am unable to fill the datagrid. [code]
View 1 RepliesI have UltraGrid and i need when i click on grid row to get content from specific column of that grid. For example if I click in cell of fourth column then i need to get value of first column of the same row where i clicked.
View 1 RepliesThis is a VB .NET application where we are showing the output of a SQL statement in a Datagrid view. using .NET 2005.We need to get the seperators of the headers on the grid control to be the same colors as the GridColor on the form. See the picture below:We've tried looking through all of the properties of the DataGridView control, and found some interesting things that looked promising such as the DataGridViewAdvancedHeaderStyle, and DataGridViewHeaderBorderStyle, but none of it seems to allow you to change the colors on it.Does anyone know how to do this without remaking the entire thing with a GDI+ control?
View 2 Repliesneed to have a summation field in each row of a grid in visual basic. Each row needs to calculate the remaining quantity of its row and all other rows beneath it. Thus the subtotal field in the 1st row would equal the sum of the shown quantity field for the entire grid.The next row would include its value and all those beneath it. Its subtotal value would be less than the subtotal of the row above it (by the quantity value of the 1st row). My code for the grid is very simple I just can't figure out how to add this iteration.
View 3 RepliesI have an Idea but im not sure how to get started... Its a map maker... There will be a panel on the side for items and it will draw a grid and you can make a map using the items on the grid.
View 5 RepliesAs I understood , The property grid is given an object which it can manipulate by extracting its Properties using reflections.
My problem is that I have a set of Parameters that is determined during run-time , thus I can't staticly compose a class with properties to represent this set.
I have two idea in mind to solve this problem but both are complex and will probably consume lot of time , infact i will say they are not practical under my time constraints. One is to use Reflection Emit in order to define a class dynamically and the other is to dynamiclly build a C# source file and then compile it using CodeDom.
Can Property grid behave in a different manner( other then extracting the Properties of an object using reflections ) that can suite my problem?
I want to say that the reason I went to the property grid from the begining was its ability to provide realy nice Data Retrieval UI for common types.For color you autometically get a palette , For dataTime you automatically have a nice calender. I would like to get those things automatically If possible.
Visual Basic 2005 I have a DataGridView on a form. It's bound to a DataSet, and I'm working by way through the dataset doing various things to the records based on the "status". What I would like to do is scroll the grid, so that the row that the program is 'looking at' is in the middle of the grid.
View 1 RepliesI have the below code that i am trying to have two datagrids with a grid splityter in the middle. The split seems to be working fine but the issue i am having is when I populate the datagrid it is growing in height and changing the splitter instead of leaving the height alone and adding scroll bars.
What simple thing am I overlooking?
<Grid x:Name="gdHistory" Grid.Column="0" Grid.Row="2" >
<Grid.RowDefinitions>
[code].....
I have a few problems with making a map editor, how to make one reply and ill give you my msn well actually this problem: its not making the grid invisible if you de-deselect the option "Grid On" because the rect's have already been drawn. So I need to know how you can delete them.
[Code]...
I have a FlexGrid control in my Windows application that contains a row of data. The data in this row is related to even more data that won't all fit on the same row. For Example:The main data row contains Username, Last Name, First Name, Middle Name, E-mail Address, Phone Number, etcA secondary row to this might contain user permissions to certain resources, such as File Server Access, FTP Access, Remote Access, etc.Now, I can use the subtotal and outline capabilities of the VSFlexGrid to make a second row, but the column widths are still bound by those set for the main data row. Additionally, I can't put real "headers" on the supplemental data. I have to fake it by creating an additional row, setting the background color of that row to gray, putting the header strings into those fields, and then adding the next row with the actual details.
What I would like to do is create separate grids for these secondary rows and "embed" them in a blank row of the existing FlexGrid control directly under the related main data row. This would give me the ability to use a different number of columns, to format these columns independently of the "parent" FlexGrid settings, as well as put a new header row for the new grid that identifies its data.In other words, I'd like to somehow make a "child" grid that's related to a particular row of the "parent" grid (not the entire grid itself). I don't know if this is possible, and if there is another way for me to accomplish this goal, I'm all ears. However, if it IS possible, I'd love some advice on how to implement it.
I have students who will be enrolled into a course. The student grid view has many columns like client_no, student_name, date_of_birth, address, etc. There are over 100000 students so I will need to filter the student grid view to find the correct student to enroll in the course. Once they are found, the user selects them and somehow moves them to the enrolled grid view. If a student drops out then they would be removed from the enrolled grid view.This process needs to be easy to understand and use. Are there any examples available or other suggestions on how to do this?
View 1 Replies