Click here to Skip to main content
15,905,607 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: MIDI and USB Keyboard! Pin
User 989707411-Dec-17 6:22
User 989707411-Dec-17 6:22 
GeneralRe: MIDI and USB Keyboard! Pin
User 989707411-Dec-17 8:33
User 989707411-Dec-17 8:33 
GeneralRe: MIDI and USB Keyboard! Pin
Sascha Lefèvre13-Dec-17 8:08
professionalSascha Lefèvre13-Dec-17 8:08 
GeneralRe: MIDI and USB Keyboard! Pin
User 989707413-Dec-17 8:42
User 989707413-Dec-17 8:42 
GeneralRe: MIDI and USB Keyboard! Pin
User 989707411-Dec-17 9:41
User 989707411-Dec-17 9:41 
GeneralRe: MIDI and USB Keyboard! Pin
User 989707412-Nov-17 8:30
User 989707412-Nov-17 8:30 
AnswerRe: MIDI and USB Keyboard! Pin
Jaroslav Mitrovic28-Dec-17 16:39
Jaroslav Mitrovic28-Dec-17 16:39 
QuestionLinq GroupBy Name using some sort of logic of names in common Pin
jkirkerx9-Nov-17 9:08
professionaljkirkerx9-Nov-17 9:08 
I have this XLS Sheet to create, or a report that groups sales by states and by customers.
Some of the customers have multiple locations in states, and have different customer names but it' the same customer.
EG.
ABC Company (Ontario)
ABC Company (Anaheim)
ABC Company *
(San Jose) ABC Company

I'm not even sure what to call this so I can search the internet.
Nor where to even start on this.
But this is my final GroupBy Call before I send it to the XLS creator.
Dim gCustomersItems_Final As List(Of model_itemDistribution_Items) = gCustomer_items.OrderBy(Function(ob) ob.FSSTATE).ThenBy(Function(tb) tb.FCOMPANY).GroupBy(Function(v) New With {Key v.FCOMPANY, Key v.FSSTATE}).Select(Function(cl) New model_itemDistribution_Items() With {
    .FSADDR1 = cl.First().FSADDR1,
    .FITEMNO = cl.First().FITEMNO,
    .FDESCRIPT = cl.First().FDESCRIPT,
    .FSHIPQTY = cl.Sum(Function(qty) qty.FSHIPQTY),
    .FCSAMT = cl.Sum(Function(amount) amount.FCSAMT),
    .FSCITY = cl.First().FSCITY,
    .FSSTATE = cl.First().FSSTATE,
    .FSZIPCODE = cl.First().FSZIPCODE,
    .FSCOUNTRY = cl.First().FSCOUNTRY,
    .FCUSTNO = cl.First().FCUSTNO,
    .FCOMPANY = cl.First().FCOMPANY,
    .FSALESPN = cl.First().FSALESPN,
    .FMAXDATE = cl.Max(Function(m) m.FSHIPDATE)
}).ToList()
If it ain't broke don't fix it

AnswerRe: Linq GroupBy Name using some sort of logic of names in common Pin
Mycroft Holmes9-Nov-17 13:16
professionalMycroft Holmes9-Nov-17 13:16 
GeneralRe: Linq GroupBy Name using some sort of logic of names in common Pin
jkirkerx10-Nov-17 6:22
professionaljkirkerx10-Nov-17 6:22 
GeneralRe: Linq GroupBy Name using some sort of logic of names in common Pin
Mycroft Holmes10-Nov-17 13:14
professionalMycroft Holmes10-Nov-17 13:14 
Questionerror 9 Pin
Member 135117618-Nov-17 22:04
Member 135117618-Nov-17 22:04 
AnswerRe: error 9 Pin
Member 135117618-Nov-17 22:05
Member 135117618-Nov-17 22:05 
GeneralRe: error 9 Pin
Member 135117618-Nov-17 22:05
Member 135117618-Nov-17 22:05 
SuggestionRe: error 9 Pin
Jochen Arndt8-Nov-17 23:41
professionalJochen Arndt8-Nov-17 23:41 
QuestionToo many arguments Pin
carlosdas17-Nov-17 14:09
carlosdas17-Nov-17 14:09 
AnswerRe: Too many arguments Pin
Kenneth Haugland7-Nov-17 14:15
mvaKenneth Haugland7-Nov-17 14:15 
QuestionVS2015 data source connection wizard error Pin
Member 1314374431-Oct-17 11:29
Member 1314374431-Oct-17 11:29 
AnswerRe: VS2015 data source connection wizard error Pin
Dave Kreskowiak3-Nov-17 12:36
mveDave Kreskowiak3-Nov-17 12:36 
QuestionEMAIL ARCHIVE Pin
Member 1277093031-Oct-17 4:58
Member 1277093031-Oct-17 4:58 
AnswerRe: EMAIL ARCHIVE Pin
OriginalGriff31-Oct-17 4:58
mveOriginalGriff31-Oct-17 4:58 
AnswerRe: EMAIL ARCHIVE Pin
Maciej Los31-Oct-17 10:24
mveMaciej Los31-Oct-17 10:24 
QuestionVb.net Pin
Member 1312553228-Oct-17 2:18
Member 1312553228-Oct-17 2:18 
AnswerRe: Vb.net Pin
Eddy Vluggen28-Oct-17 4:29
professionalEddy Vluggen28-Oct-17 4:29 
AnswerRe: Vb.net Pin
Dave Kreskowiak28-Oct-17 4:32
mveDave Kreskowiak28-Oct-17 4:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.