using LINQ to NHibernate does anybody know how to use group by and order by in the same expression. I am having to execute the group by into a list and then order this, seem that I am missing soemthing here ?
Example:-
Private function LoadStats(...) ...
Dim StatRepos As DataAccess.StatsExtraction_vwRepository = New DataAccess.StatsExtraction_vwRepository
return (From x In StatRepos.GetAnswers(Question, Questionnaire) _
[code]....
I came across the KEY_GENERATOR thing (as shown below) from one of the tutorial application in vb net. Its absolutely new to me and i wanna know why it is used and how it is used. I googled but didnt find anything about it
View 1 RepliesI have the following:
myFilteredContractors = (From c In myFilteredContractors
Join cc In myConClasses On c.ContractorId Equals cc.ContractorId
Where inClassifications.Contains(cc.ClassificationId)[code].....
This is properly ordering this list of contractors by the number of classifications that they have.I also want to order them by whether or not they have a field set (CompanyOverview), which if is an empty string should be below those contractors who have set their CompanyOverview. Also, after the CompanyOverview is ordered I want to order by Registration Date.So it should order by:
Number of Classifications
Whether Overview has been set (c.CompanyOverview)
Registration Date (c.AppliedDate)
Is it possible to all of this in LINQ?
How do I order by and group by in a Linq query?I tried..Dim iPerson = From lqPersons In objPersons Where Len(lqPersons.Person) > 0 Group lqPersons By key = lqPersons.Name Into Group Order By Group descending Select Group, key
For Each i In iPerson
tmp = tmp & vbNewLine & i.key & ", " & i.Group.Count
Next
[code].....
Suppose I have the following data
Key ID Data
A 1 Hello
A 2 World
B 2 Bar
B 1 Foo
I am looking to produce the result
A HelloWorld
B FooBar
I am struggling to get the syntax quite right - I was trying to use Aggregate, but I wasn't sure if I could (or should) use SelectMany
Dim data = result.Rows.
GroupBy(Function(r) r.Key).
Select(Function(g) g.OrderBy(Function(s) s.ID)).
[Code]....
I am trying to build a survey engine from an existing database design which is like this.
[Code]...
The line Order By Key.RecordOrder throws a null reference exception and I can understand why. Can someone advise on how to resolve this by just modifying this one query? I am fairly new to LINQ and the necessity to write this project
[Code]...
I'm trying to match up a specific group name and see if it exists for the currently logged in user using Active Directory roles. If the Group Name exists for the Current User, I want that group name to be displayed in a drop down list. Example: If current user is in BIG Group, display BIG in drop down list.Problem: All I am getting is SIDs and I'm not able to get anything to match up to the group name and nothing will show up in the drop down list.I also get the following Error:Error: Object variable or WIth block variable not set.How do I fix this?? here is the code I am using:
Private Sub GetMarketingCompanies()
' code to populate marketing company drop down list based on the current logged in users active directory group that
[code].....
Enumerate if an Active Directory group's member is user or another group
View 1 RepliesI am writing an application and I do not know how to reference a group of controls inside a group box. I will include the code I have written so far and a picture with a detailed explanation as to what I am trying to do. Feel free to comment on any discrepancies that you may notice in my code.
Code:
Public Class Form1
' The following class-level constants are used
' to calculate the price of the model
Const decCOUPE As Decimal = 18000
[code].....
I want to remove a group (include all items in this group) in ListView, but unsuccessful, the code is below, why?
ListView1.Groups("GroupName").Items.Clear()
ListView1.Groups.Remove(ListView1.Groups("GroupName"))
anyone have some quick code on how to do this?
wmi is not a option.
I have a combo box bound to a datasource. I need to change one combo box (of many) to order the items in descending order.I'm guessing I could order the collection in the dataset, but that will mean all my combo boxes will be reordered?
View 2 RepliesI have a databound Datagridview. The DGV is bound to a datatable of a strongly typed DataSet created using the wizard. Is there any way to re order the columns before displaying them eg: the Columns are displayed in the DGV in this other Col4, Col6, Col3, Col1,Col5, Col2
But I want to it to show as Col1, Col2, col3, Col4, Col5, Col6?
I realise that the display order followed the Column order in the database table and by extension, the datatable. I have re-arranged the columns in the Database but the Datatable still retains the old order.
This might not be so 'VB' as it is 'SQL using VB' I have an application with a built in MS Access DB. I have a table that has a column full of integers, I shoot the DB a SQL "order by 'column name' " string and it returns the table ordered by my column of integers.BUT it returns them like this, and I want them like this
0 6
1 5
2 4
[code]....
How do I get the OrderBY to do a descending list starting with the highest number?
I'm working on the exercise page 73 (VB 2010 in 24 hours). It's basically a form with 2 text boxes, 2 text labels and a command button. It's really simple and uses this loop to cycle through the items, and tell me the name of them in a Messagebox
[Code]...
I want to divide the content in my application to groups each group has its own rectangle border with the group name located at the top border, i've seen it before and i'm not sure what is the correct name of this control, anyone knows what I'm talking about ? EDIT: Ok, I found the Groupbox Control but how do i use it? should i just drag other controls inside it or i should add controls directly into it?
View 2 RepliesI have to order a table following a logical order but I cannot find the appropriate ORDER BY clause.To simplify I have 2 fields field1 and field2
1 record : field1 contains �2� and field2 contains �1�
2 record : field1 contains �1� and field2 contains �2�
3 record : field1 contains �2� and field2 contains �2�
[code].....
I have this code I've used multiple times to add and remove users from AD groups, but when I try to use it to remove an AD group from another AD group it fails with "The server is unwilling" [code]...
View 1 Repliesif a byte value can go up to 255 and two bytes are used to determine the length of packet payload data, how would I convert the two bytes to create one integer value?
State.buffer[13] = 5 and State.buffer[14] = 67
Dim PacketLengthHigh As Integer = state.buffer(13)
Dim PacketLengthLow As Integer = state.buffer(14)
[code]....
I have the following code in my vb.net:
Code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Start Bind PO Details and Trailers dsRepeater = RetrieveDCDetails(Session.Item("UserID"), Session.Item("DCNo")) dsRepeater.EnforceConstraints = False
[code].....
I'm trying to add a user to a group. This is a Novell user, but it should be similar to Active Directory. Here's the code I have, but it doesn't seem to work. It returns the user's name, but doesn't add them to the group.[code]...
View 2 RepliesI have the following LINQ statement, which performs a simple linq query and assigns the resulting values labels on an asp.net web form:
Dim db As New MeetingManagerDataContext
Dim q = From s In db.vwRoomAvailabilities _
Where s.MeetingID = lblMeetingID.Text _
[code]....
Originally, there was going to be only a single row result and you can see I'm using FirstOrDefault() to grab that single value which works great. But the design has changed, and multiple rows can now be returned by the query. I need to now Group By the MeetingID above, and SUM each of the selected columns (i.e. s.AllRequestedDoubles).
I am developping an installer class and I want to set specific permissions for all users. I know that this is possible with a code like this:
[code]...
Unhopefully I need this code to be valid for computers with different InstalledUICulture. For instance I know that in German it is sufficient to replace "Everyone" with "Jeder". Is it possible to call a method that permits to generalize the code for every language of the operating system?
Using VB
Say I have five checkboxes in a groupbox. I want to run an if then statement where if all boxes are not checked I would perform a certain action. I currently have it set to work using code similar to this
If box1.Checked = False And box2.Checked = False And box3.Checked = False And box4.Checked = False And box5.Checked = False Then
End If
Is it possible to reference the entire groupbox has having a false boolean property?
While doing this is managable - what if I had more check boxes?
I need some help with a LINQ query in VB.Net, please.[code]This works, and returns me the data I need to work with. Now I want to iterate through the groups, using a For Each construct. like this: For Each x In drivers Next...However, the compiler is barking at me, telling me that the "'x' is not accessible in this context because it is 'Friend'."
View 3 Replies[code]how can i group by SUM of the c.ct?
View 1 RepliesScenario: I need to create a report for the auditors for an ASP.Net application. I have a program that parses the XML of the web.config files in a directory for the authorization tag and creates a report providing which users have access to which folder in the site structure. The report is shown below.
UserName, Firstname, LastName, Directory, Roles, Access,
LastLoginDate
Problem: As you can see from the report some directories (the middle column with GISMO in it) show up twice, with both allow and deny for a user. I am wondering if there is a way to group the results in such a way that if there is a row that has allow for a directory then the deny's are not shown but otherwise they are.
Alternatively if this can be manipulated in VB.net/C# that is also an option. It comes back there and is pumped into an Excel spreadsheet.Edit: I should have explained better. I still need the deny rows to show if the user isn't allowed in the directory. But if they are allowed then there is no point showing the deny rows.
i was connect to my *.mdf file
when i use this code to select some data in my database
Dim da As New SqlDataAdapter("Select colums1, sum(colums2) From debts Where debts.colum3 ='somthing' group by somecolums", SQLConnection)
Dim ds As New DataSet("debts")
[Code]....
change my SQL connection string to work with "sum" and "group by"
how can check if a user is in a ad group?
View 3 RepliesI need to go through a list of strings and count the number of duplicates and then print the string with the number of occurrences in one line to a file. Here is what I have but I need to only print the string once and its count.
[Code]...