Group List And Return Only Cheapest One For Each Provider
Feb 2, 2012
I have an object called offer and it has sub object price as decimal and provider_ID as integer. What I need is I have list (of offer) and I need to get cheapest price for each provider. So lets says I have following:
Provide_ID Price
----------------------
1 30
2 40
1 15
2 20
3 5
3 10
How can I make a linq query (from item in offers group by item.provider_id into
max(item.price)) like this.
Because using group by I am not able to get all information of offer object. beside provider_ID and price I have more information. That's why I don't want to have (with {item.price, item.provider_ID}) etc. selecting each one by one.
And results of filtering should have only
provide_ID Price
----------------------
1 15
2 20
3 5
View 5 Replies
ADVERTISEMENT
May 17, 2010
I'm looking to release an application for free with (unubtrusive) ad support, and the option to upgrade to a registered version to remove the ads. Basically we want to give the product away for free, but need some income to support costs.
What would be the best way to achieve that? I essentially just want the user to be able to type in a serial number, which is sent to a server, checked and presumably moved to a list of used serials, and then the product is activated and the ads removed.
What is the best/cheapest service to do that?
View 4 Replies
Feb 24, 2010
how i can get a list of users who are members of a group in Active Directory. A vb.net example would be great. I can list all users in AD, but cannot get just the users in a group.
Also do anybody know of a really easy tutorial on LDAP queries with vb.net examples.
View 1 Replies
Nov 16, 2010
I am having trouble following some of the examples at MSDN for LINQ.Basically I have a List Of MyObject. MyObject has a property called Value which is an integer.I want to group all the MyObjects together that share the same Value and then return that Value where the count of the group is greater than 5.I have tried the following,
dim foak = From o as MyObject in MyObjectList _
Group o By o.Value into Count _
WHERE Count > 5 _
Select o.Value
View 2 Replies
Aug 3, 2011
i have 2 computers - a Server and a Client pc which is running on local area network with MICROSOFT SQL SERVER 2008 R2 Developer kit at the main pc and Client computer will need to connect to SQL SERVER at main pc using connection string.Let me named server computer as 'MAGNA-PC' and the client pc as 'LAC-PC' and database name is 'db_referafriend' so the code for MAGNA-PC(server) connection string is:[code] i GOOGLE and YOUTUBE for almost 2 weeks before i post . I know that i need to configure the sql configuration manager and enable tcp/ip also add a new port at firewall to allow remote connection also add the sqlserver.exe and sqlbrowser in firewall and I have also chosen "Using both TCP/IP and named pipes" under Remote Connections in the SQL Server 2005 Surface Area Configuration. and all of this doesnt work!
View 10 Replies
May 23, 2012
That was probably bad title, but I'll illustrate what I'm trying to do. I have a method in a class that I need to call several times. The method returns a List(Of String). I'm just grabbing some information from a database.
VB.NET
Public Function GetTestList() As List(Of String)
Dim int As Integer = 0
[code]....
View 4 Replies
Nov 23, 2011
Im trying to get a list of users in an AD group. My code is [code] I think the line causing the problem is the filter ("(&(objectClass=person)(memberOf=CN=MyGroup))").Could anyone confirm or advise how to get the list of members please?
View 5 Replies
Jan 20, 2009
I 'm trying to group a list of checkboxes.
1. Could I do it with a groupbox? How?
2. I have wrote this code
Public groupCB() As CheckBox = New CheckBox() {chboxAMIT, chboxOnoma, chboxEpon, chboxFather, chboxMother}
Private Sub CheckBox_CheckedChanged(ByVal sender As System.Object, ByVal e As
[Code].....
View 5 Replies
Mar 23, 2009
I am trying to develop a recipe manager that allows a user to create a shopping list. I've already determined that I want to use a list view for this job. I want to be able to group the items in the shopping list by the appropriate grocery aisle (i.e. Dairy, Bread, Canned Goods, etc.) I'm not sure how to assign the items to the appropriate group as the user selects each item.
I haven't started actually building the application yet as i'm still in the development stage, but i have been testing the list view out to figure out how it works. i've figured out how to add items. i just don't know how to specify the group that each item should belong to.
[code]...
View 2 Replies
Apr 19, 2011
I have a list of data as shown below
Original Data
Genre Name Year
Comedy Shrek Forever After 2010
Drama The Karate Kid 2010
Action Iron Man 2 2010
[Code]...
View 1 Replies
Feb 7, 2011
I am currently trying to create a program to list a large group of numbers for me. My final goal is to have every 2, 3, 4, ..., and 9 digit number containing only "1" "2" and "3". I thought I would go about this by using the following VB.NET program and then copying it into a text editor, and using find & replace to eliminate all other numbers.
Public Class Form1
Dim Start As Integer = 333333333
Dim Counter As Integer = 333333333
[Code].....
it fails due to the massive amount of processing that needs to take place. However, adding the intervals requires a great deal of time for each number to be displayed without any crashes.
Is there some way (in VB.NEt or another language) to get the number list I want in a short (an hour or less) amount of time?
View 7 Replies
Aug 2, 2011
Has anyone got some source code or advice on getting my app to be able to list all autorun items i.e. from HKLM/Software/Microsoft/CurrentVersion/Run (and other locations) and the start menu start up group - same sort of info as say msconfig or autoruns
View 8 Replies
Sep 3, 2009
After reading all the examples for list of T exists and Find and find first, none show how to handle multi-property objects. Below is bare bones example maybe someone could flesh out to show how this should be done.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim DatePriceList As New List(Of DateAndPrice)
DatePriceList.Add(New DateAndPrice(Date.Parse("1/1/2000"), 10.12))
DatePriceList.Add(New DateAndPrice(Date.Parse("1/2/2000"), 11.12))
[Code]...
View 3 Replies
Oct 26, 2011
I have these objects:[code]Using LINQ I need to take a List(Of MakeInfo) and a List(Of ModelInfo) and aggregate the StockInfo from ModelInfo into the List(Of MakeInfo).So for each MakeInfo I will have a total count of all stock where MakeInfo.Name = ModelInfo.Make, and also a minimum price.I think it's going to be something like this, but I'm having trouble accessing the nested object and not sure if it's going to be possible with a single query.[code]
View 2 Replies
Jun 22, 2010
I would like to have a function(of T) that returns a list(of T) that is assignable to a variable of list(of T).For Example:
the variable:
Private _StandardCodes As List(Of StandardCode)
the assignment:[code]....
I'm getting the error "Type paramater 'T' for ... cannot be inferred", as a result I have to use a comparable function to return a list(of Object) and then do:
_StandardCodes = (From x In AMExtensions.queryObject(GetType(StandardCode), "StandardCode") _
Select CType(x, StandardCode)).ToList
View 5 Replies
Feb 6, 2009
I am having a little trouble trying to use an array list. I am using a function that I want to return the array list. However, I am having a problem getting it to return the arraylist. when i do this:
[Code].....
View 5 Replies
Jul 29, 2011
I want the Function to accept List(Of String), Array & String and similarly return List(Of String), Array & String respectively. The Function simply adds a string (month) to the input collection. I just want to use it for string, array and list with needing to think of conversions.
[Code]...
View 2 Replies
Apr 23, 2012
I know I can do this with a for loop cause that's how i'm doing it now. I was hoping for a more efficient way to accomplish the task.
I have a dictionary(Of Integer, Boolean) or Of String, Boolean. i want to get a list(of integer) or Of String from the dictionary where all the values are true(or false depending on what i need at the time)
and to generalize it or "black box" it, it could be any dictionary(of whatever, whatever) and return a list(of whatever) where the value = whatever i'm looking for at the time.
string, string where value = "Closed"
in short: i want all list of all the keys who's value = some criteria
my current code:
Public Function FindInDict(Of tx, ty)(thedict As Dictionary(Of tx, ty), criteria As ty) As List(Of tx)
Dim tmpList As New List(Of tx)
[Code].....
View 2 Replies
May 8, 2009
I was speeding up my app by using compiled queries for queries which were getting hit over and over.I tried to implement it like this:
Function Select(ByVal fk_id As Integer) As List(SomeEntity)
Using db As New DataContext()
db.ObjectTrackingEnabled = False
[code].....
View 1 Replies
Oct 27, 2009
Given the following vb.net class:
Friend Class PairCollection(Of TKey, TValue)
Inherits List(Of KeyValuePair(Of TKey, TValue))
Public Overloads Sub Add(ByVal key As TKey, ByVal value As TValue)
Me.Add(New KeyValuePair(Of TKey, TValue)(key, value))
End Sub
[Code]...
View 1 Replies
Jan 5, 2012
I have a list going into a repeater, sorting with jquery sortable(), and then need to put the sorted list into a session variable. I cannot seem to figure out how to get the sorted values back into a list.[code]...
View 1 Replies
Aug 8, 2010
I wish to get the Text of item where I know its index! most of the codes I have founds Return the index number not the text it self!
View 5 Replies
Oct 5, 2011
Update: I didn't make it clear but I meant this to be a question about where/how I would use a function to return a list of strings when I'm trying to just work with classes.I have a class called Account.
I have data access class called AccountDAO.I have various functions that return lists of objects like GetAllAccounts, GetAccountByID etc.I want to populate a drop down list with just the account names and nothing else. It's proving rather slow when using lists of objects and databinding them to the dropdownlist.
I feel like I should be using a simple "Select Account_Name From blah" type statement and returning a list of strings but I don't know how to work this into my class and data access class.
View 4 Replies
Mar 9, 2010
I was speeding up my app by using compiled queries for queries which were getting hit over and over.
I tried to implement it like this:
Function Select(ByVal fk_id As Integer) As List(SomeEntity)
Using db As New DataContext()
db.ObjectTrackingEnabled = False
[Code].....
View 1 Replies
Feb 17, 2010
Sub pageload() Handles Me.Load
Dim bom As New List(Of Car)
Dim car1 As New Car With {.Name = "Pea", .Year = 2}[cod
WHY??? I mean the object has the exactly same data, so why does itee]..... say it is not contained?
View 3 Replies
Aug 27, 2009
I have written a function before to delete and update records, but never anything to return values back to my call of the function. Here is my code, and I will try to explain what I'm trying to acheive.
If Not Att1 = "" Then
Attribute1.Text = Att1
Attribute1.Visible = True
ComboBox1.Visible = True
[code]....
That codes goes on up to att20. It works just fine, but it is forever long, and I would like to clean it up.I want to do something like:
Or, should I pass the combobox number also, so that the code can fill the appropriate combobox? Like.comboboxfill(Att1,Combobox1) how to write the function and how to pass back the information or just how to make it work in general?
View 6 Replies
Jun 20, 2011
I have two xml files. I have to read them and return as a List( Of object). Here is my function.
Public Function GetData(ByVal name As String, ByVal city As String) As List(Of Object)
'Return Nothing
End Function
View 1 Replies
Mar 23, 2011
How can i select using linq from a datatable where the the only results I want back (ID's) are contained in a list of integers?
View 7 Replies
Jul 8, 2010
I'm trying to create a simple script that will return a list of folders in the current directory and their respective sizes:
Set objShell = CreateObject("WScript.Shell")
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set strCurrentDirectory = objFSO.GetParentFolderName(Wscript.ScriptFullName)
Set objFolder = objFSO.GetFolder("strCurrentDirectory")
[Code]...
Yet it doesn't like the fact that I am trying to pass the current directory into a variable and errors out with:D:dirsize.vbs(3, 1) Erreur d'exécution Microsoft VBScript: Objet requis: '[string: "D:"]'.
View 6 Replies
Dec 2, 2010
How to return Ilist of strin that object a has username i want return that name
View 1 Replies