Click here to Skip to main content
15,563,228 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionInstall a VB Net application to install a sql database on other computers Pin
Member 147798703-Apr-20 13:41
Member 147798703-Apr-20 13:41 
AnswerRe: Install a VB Net application to install a sql database on other computers Pin
Dave Kreskowiak3-Apr-20 15:12
mveDave Kreskowiak3-Apr-20 15:12 
AnswerRe: Install a VB Net application to install a sql database on other computers Pin
evry1falls6-May-20 10:22
evry1falls6-May-20 10:22 
QuestionLinq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx3-Apr-20 8:48
professionaljkirkerx3-Apr-20 8:48 
AnswerRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx3-Apr-20 9:51
professionaljkirkerx3-Apr-20 9:51 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming6-Apr-20 2:19
mveRichard Deeming6-Apr-20 2:19 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx6-Apr-20 8:28
professionaljkirkerx6-Apr-20 8:28 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming6-Apr-20 9:01
mveRichard Deeming6-Apr-20 9:01 
No, in the outer query:
VB.NET
Dim gInvoicesAll As List(Of MarginCustomerInvoicesR1) = cTpAll.OrderBy(Function(ob) ob.FINVNO).GroupBy(Function(inv) inv.FINVNO).Select(Function(cl) New MarginCustomerInvoicesR1() With {
    .FCustNo = cl.First().FCUSTNO,
    .FInvNo = cl.First().FINVNO,
    .FShipDate = cl.First().FSHIPDATE,
    .FDescript = cl.First().FDESCRIPT,
    .FAmount = cl.Sum(Function(item) item.FAMOUNT),
    .FExtCost = cl.Sum(Function(item) item.FCOST * item.FSHIPQTY),
    .FExtPrice = cl.Sum(Function(item) item.FPRICE * item.FSHIPQTY),
    .FExtMargin = cl.Sum(Function(item) (item.FPRICE - item.FCOST) * item.FSHIPQTY),
    .FPercent = 0
}).ToList()




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx6-Apr-20 10:20
professionaljkirkerx6-Apr-20 10:20 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming7-Apr-20 1:30
mveRichard Deeming7-Apr-20 1:30 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx7-Apr-20 8:05
professionaljkirkerx7-Apr-20 8:05 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx8-Apr-20 10:24
professionaljkirkerx8-Apr-20 10:24 
QuestionHow to update sql server data from excel data using VBA code by all User Pin
Member 1478441627-Mar-20 1:25
Member 1478441627-Mar-20 1:25 
AnswerRe: How to update sql server data from excel data using VBA code by all User Pin
ZurdoDev27-Mar-20 2:19
professionalZurdoDev27-Mar-20 2:19 
GeneralRe: How to update sql server data from excel data using VBA code by all User Pin
Member 1478441627-Mar-20 3:17
Member 1478441627-Mar-20 3:17 
Questionevent handler Pin
Member 1356965022-Mar-20 0:16
Member 1356965022-Mar-20 0:16 
AnswerRe: event handler Pin
Richard MacCutchan22-Mar-20 0:31
mveRichard MacCutchan22-Mar-20 0:31 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 1:24
Member 1356965022-Mar-20 1:24 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 1:33
mveRichard MacCutchan22-Mar-20 1:33 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 2:04
Member 1356965022-Mar-20 2:04 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 5:03
mveRichard MacCutchan22-Mar-20 5:03 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 5:18
Member 1356965022-Mar-20 5:18 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 5:47
mveRichard MacCutchan22-Mar-20 5:47 
GeneralRe: event handler Pin
Member 1356965022-Mar-20 6:01
Member 1356965022-Mar-20 6:01 
GeneralRe: event handler Pin
Richard MacCutchan22-Mar-20 6:12
mveRichard MacCutchan22-Mar-20 6:12 

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.