I'm having a heck of a time with transforming a simple SQL Query into a LINQ query(using vb btw)
Here is my SQL:
SELECT USRDEFND5
FROM int_gp_employee
GROUP BY USRDEFND5
[Code]...
I've tried a number of different variations of the LINQ. My current statement is:
From b In xmlFile...<row> Group b...<usrdefnd5> By b...<usrdefnd5> INTO group when I foreach through the resulting collection, EVERY line (17000) shows up.
I've a large table of Items and I need to organize them by Category, then by Year and then by Month.Item has CategoryID and Dated properties.I got this far:
Dim Items = From Item In DB.Items _
Group By CategoryID = Item.CategoryID _
Into Categories = Group _
Order By CategoryID
But where I put the:
Group By Year = Year(Item.Dated)
and the
Group By Month = Month(Item.Dated)
The final result should be something like this:
For Each Category in Categories
For Each Year in Category.Years
[code].....
I'm completely dense here, but I'm trying to get some stats from a DataTable. One of the columns in the datatable is called "colour".I need to find out how many of each instance of "colour" are in the datatable.
I'm trying:
Dim q = From p In PGWorkingDataTable _
Group p By p("colour") Into Group _
[code].....
I have a table called Ordersthe table has many rows but im only interested in two in particular.I want to query the table so it returns the average ordered count of each producti want to know what is the average count of the ordered products, but now in total but per productID instead.
View 1 RepliesI need to take a collection and group it via Linq but all the examples I've seen fail in some manner or other with some syntax difference that I can't quite lick.
My collection:
Dim a As New List(Of ProcessAlert)
a.Add(New ProcessAlert("0000112367", "5551110000@txt.att.net", "Alert", 2))
a.Add(New ProcessAlert("0000112367", "5551110000@txt.att.net", "Document", 2))
[Code].....
I am struggling with a nullable datetime column [DateInsp] in an ASP.NET app which uses SubSonic3, Linq, MS SQL Server 2005.I had this all working when the datetime column [DateInsp] did not allow nulls. A new requirement forced me to set the [DateInsp] column to allow nulls and now I am struggling getting this piece of functionality to work properly again.
Problem 1:I need to first render a dropdown list of the 7 most recent inspection dates for a given inspector (this is a grouped list of the 7 most recent dates for the inspector). Here is the TSQL that I need to convert to Linq syntax:
declare @InspectorID varchar(5)
set @InspectorID = 'GPA'
select top 7 convert(nvarchar(30), [DateInsp], 101) InspectedDate
[code]....
If I can't get this work properly using Linq, BUT I can/could build a stored proc to return the list of dates and throw that into a dropdown. Fair enough. I've been fighting with the Linq syntax?
Problem 2: I need to use the selected date in the dropdown mentioned above to pull the correct records for this inspector and the correct date. Again, this is a nullable datetime field and this is real sticking point for me.
Here was the original Linq syntax that accomplished the requirement before I had to change the datetime field to allow Nulls:
Dim query = (From i In db.IncomingInspections _
Where i.InspectorID = User.Identity.Name _
Group By Key = New With {i.DateInsp} Into Group _
[code]....
For some reason I can't use the .Value property; I get: The member 'Value' is not supported I get: "Incorrect syntax near '<'." if I try to add the date comparison to the where clause too.
I have the following table structure. I want to select distinct CustomerId and CustomerName, TotalCost.[code]
View 2 RepliesI'm very new to linq and I'm trying to come up with a linq query against a dataset that will return a max count value based on grouping records.[code]...
View 1 RepliesI'm having trouble getting my head around converting a traditional SQL aggregate query into a LINQ one. The basic data dump works like so:
Dim result =
(From i As Models.InvoiceDetail In Data.InvoiceDetails.GetAll
Join ih As Models.InvoiceHeader In Data.InvoiceHeaders.GetAll On i.InvoiceHeaderID Equals ih.ID
[CODE].....................
What I need to really be getting out is ih.Period (a value from 1 to 12) and a corresponding aggregate value for i.ExtendedValue. When I try to Group ih I get errors about i being out of scope/context.
I've got the below, where I'm grouping a collection by a propery, then wanting to access the properties of my group. Problem I have is with the anonymous typing. Because of option strict I have to give an explicit type but I can't work out what the type should be. The below doesn't compile because t.HeadAccountKey isn't a value (as t has a type of object). So either I need do some casting or my linq selector is wrong,
[Code]....
My VB.net application has a lot of application settings, is it possible to group them somehow(other than having a common name)?For example, my application has a lot of winforms each of which needs to save some information about itself. Is it possible to use something like:
Form1.width = My.Settings.Form1.Width
Form2.width = My.Settings.Form2.Width
etc.
I am using a nice shopping cart I found online. I would like to translate this code to use a repeater or listview and dynamically retrieve my data, but I cannot seem to find a way to group my data correctly.I know the ListView can group by a certain amount of items, but I have not found a way to do it with this scenario.The shopping cart works by having a ul list of items, followed by their details in the div below. This process starts again by getting three more ul items, followed by three more details. How could I do this using a ListView or repeater? I have not found a way to repeat both of these sets of data I need in a group of three.[code]
View 1 RepliesI am trying to group various controls (of the same type, e.g., labels together, buttons together, etc.) on a form using a tag or a name of some sort so I can identify all those that belong to tag 'A' and those in tag 'B'. In the end I will have on a form a number of labels grouped as tag 'A' and some labels as tag 'B' so I can change their visible properties on/off.
View 4 RepliesIf a user has a few of my applications open and he/she minimises them I would like to group these in the task bar like MS Word for example.
Product Name - Application 1
Product Name - Application 2
Product Name - Application 3
Product Name - Application 4
Because all of my applications begin with the product in the Title bar can this be achived.
I have multiple sub's that i'd like to group together, however all of the groups need to be in the same class. They all work together, but it would help me organize the code and make it less confusing if I could group some of the different subs together for outlining purposes. Is there a way to do this? I tried to find answers online, but I couldn't find what I was looking for.
View 3 Repliesi've got a problem with dataset:
I've got two dataset from two different server but they have the same columns.
so it's like that:
First DataSet :
[code].....
I have a class called Trigger. within this class, I can perform a variety of functions, the main of which is to monitor a specific condition. In this class I have a bunch of class variables that are used to setup the condition as well as for information purposes after the condition has executed. All the conditions are stored in a database and when I start the program, I create a New Trigger class for each condition and store the variables (name, desc, action to perform once the condition is met, etc.) I was thinking about changing the class to create a Structure called Configuration where I would store all the variables. But then I would have to save the Configuration within the class so it could be used later on if needed correct?
[Code]...
but in looking at this i realized that I am creating a new structure and then creating a new trigger class where I am saving the Configuration structure which essentially seems the same as just using class variables as I was before. I also looked at creating a Configuration Class and a Trigger Class. then from the main class I would create all the Configurations and have a shared Trigger class that monitored all of them instead of having a single Trigger class for each Configuration. Using this method i could create a hash table that kept track of each configuration that was being monitored and stop it if required.
Does either method sound more appropriate over the other. I am just trying to understand when/why to do things a certain way.
I did attempt searching but it just gave me a "505 bad gateway error".So my issues is the grouping header isn't working lol.
ListView1 - name of the ListView control
3 columns added to lv
3 items added to lv
[code].....
My repeater is searching through dates in the SQL Server database and returning the first 3 letters of every month. Is there a way to show the repeater the way I want to? [code]
View 2 RepliesI am making a report using the reportviewer. I have grouped the data and the group works. But when I try to put some data in the group header, I get the following error:The Value expression for the textbox Dep_Name refers to the field Dep_Name. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
The data I am trying to display is from a different table then the one that I am using to group the data. Does this mean there is a problem with the relationship between the tables?
Is there any object that supports column grouping in VB.Net. Because I've been trying datagridview with no success.
View 3 RepliesI am trying to summarize a datatable based on a primary column and then add certain columns. For example this table
col-1 col-2 col-3
1 AA 2
2 BB
[Code].....
This simply doesn't do anything becuase it thinks the target table doesn't have a primary key.
How do I exclude one value from a grouping sum, based on a value of another field?ie I open Report=> Report Properties=>Code and insert my Custom Code, but how would I change the below code to exclude a numeric value of another field for the below case?
Public Function ChangeWord(ByVal s As String) As String
Dim strBuilder As New System.Text.StringBuilder(s)
If s.Contains("Others") Then
[code]....
I'm building an app that list information. It will have list of each object going vertically, with the information about the object going horz across that line. My issue is I need to scroll through these lines, however each line will contain text, images, scroll bar, button, etc. Just common control items. I first started off grouping them in a panel (panel being everything needed in that one line of information). I was thinking I could spawn more identical panels, one for each object listed. I also tried this using a UserControl (not sure if this is the right thing to do). I just need a simple panel or area that I can layout my controls as need, then create identical panels as needed for each line. Then I can just scroll through then using some script to mod there location. Panel? UserControl? I've tried the usercontrol, however I coudlnt get it to show on the form.
View 5 RepliesI vaguely remember something about a hotkey or menu that would group controls together at design time so you could drag 2 or more controls around and they would remain relative to eachother. You could work on something else and come back and the controls would still be grouped.
Does anybody know what this feature is called and how I can access it?
I have a program that opens a fixed length delimited file and process each line depending on what it starts with.
Sample Input:
101 000000000 0000000001010271255A094101National Payment Corp National Payment Corp
5200Happy Company ACH20101021-001.txt PPDDIR DEP 101105101105
[code].....
I have a table in my oracle database, with the following schema: student(studentNumber,name, dateOfCreation).
dateOfCreation is the date in which the student record was created.
In crystal reports, I have to group the records into the following groups, using the dateOfCreation field:
Older than 4 weeks(Records whose dateOfCreation is more than 4 weeks ago). Between 2 and 4 weeks (Records whose dateOfCreation is more than 2 weeks ago, but less than 4 weeks ago). Between 1 and 2 weeks(Records whose dateOfCreation is more than 1 week ago, but less than 2 weeks ago). Less than 1 week (Records whose dateOfCreation is less than 1 week ago).
I have tried grouping in specified order using group expert
I am trying to reduce the amount of code I have and make it more maintainable and flexible. (I.E Do it the right way). I have a bunch of (48) Form controls (text boxes) and when I click next on that form I save all their text values to some 48 global string variables. The names of these variables are the same as the Text Boxes but with "_saved" appended to them.
For any given operation instead of having a separate line for each control it's nice to just use a loop. I can easily write some code to operate on each Control (set visibility, enabled etc) by using Me.Controls and a For Each Loop. I can even make collections of fractional groups of the 48 controls. For example, If cntrl.name.startswith("sometext") collection.add or perform some other operation only on that subgroup etc.
I'd like to do something similar with my Saved Public String Variables. For example I would like to do the following loop somehow but don't know how to group Variables together and keep their name in a way where I can define that array or collection on 1 line or just a couple lines.
' But this next line only groups the values
Group_of_string_Variables = {Var1, Var2, Var3, Var4}
For Each Name_of_String_Variable In Group_of_string_variables
[Code].....
But I can not access the name of a variable or find a way to easily group in key/value 48 different ones without needing much more than 50 lines of code to make either a 2-dim array, a collection, or a hash.
I'm sure someone will tell me I should be doing it a completely different way. That would be ok as long as I don't have to change too much of my other code. I thought of making an object of some kind instead of a variable so I could access 2 object properties- name and value then I could group those objects in a collection as I have done before. But that seems like it would be many more lines of code and I'm not sure it would work.
I am using jquery mobile with asp.net mvc in vb trying to render a yes/no radio button group:
[Code]...
I used to have a nice little Visual Studio Add-In that allowed me to group files by simply right clicking on them.It used to modify the csproj file in the background and add the relevant attributes.
View 1 Replies