Click here to Skip to main content
14,303,639 members

Visual Basic

 
AnswerRe: i want to erase two datatables with a single button please help Pin
Richard Deeming10-Sep-19 1:33
mveRichard Deeming10-Sep-19 1:33 
QuestionHow to perform non-case search in DataGridViewComboBoxColumn Pin
speedbump993-Sep-19 8:09
memberspeedbump993-Sep-19 8:09 
SuggestionRe: How to perform non-case search in DataGridViewComboBoxColumn Pin
CHill603-Sep-19 23:38
protectorCHill603-Sep-19 23:38 
GeneralRe: How to perform non-case search in DataGridViewComboBoxColumn Pin
speedbump994-Sep-19 4:58
memberspeedbump994-Sep-19 4:58 
GeneralRe: How to perform non-case search in DataGridViewComboBoxColumn Pin
CHill605-Sep-19 0:02
protectorCHill605-Sep-19 0:02 
GeneralRe: How to perform non-case search in DataGridViewComboBoxColumn Pin
speedbump995-Sep-19 5:42
memberspeedbump995-Sep-19 5:42 
QuestionLinq, GroupBy, Select, First() or Last() Pin
jkirkerx28-Aug-19 12:38
professionaljkirkerx28-Aug-19 12:38 
AnswerRe: Linq, GroupBy, Select, First() or Last() Pin
Maciej Los28-Aug-19 21:24
protectorMaciej Los28-Aug-19 21:24 
It seems to be quite easy:
Dim gCustomerItemsAll As List(Of MarginItemCustomerProfit) = sTpAll _
   .Where(Function(w) w.FCustomerNo.Equals(cI.FCustomerNumber) AndAlso w.Price>0) _
   .GroupBy(Function(item) item.FItemNo) _
   .Select(Function(cl) New MarginItemCustomerProfit() With _
   { _
      .FCustomerNumber = cl.First().FCustomerNo,
      .FItemNumber = cl.First().FItemNo,
      .FShipQty = cl.Sum(Function(qty) qty.FShipQty),
      .FCost = cl.Last().FCost,
      .FPrice = cl.Last().FPrice,
      .FAmount = cl.Sum(Function(amount) amount.FAmount)
   }) _
   .ToList()

OrderBy() method call is redundant due to later usage of GroupBy() method.
GeneralRe: Linq, GroupBy, Select, First() or Last() Pin
jkirkerx29-Aug-19 6:59
professionaljkirkerx29-Aug-19 6:59 
AnswerRe: Linq, GroupBy, Select, First() or Last() Pin
Richard Deeming29-Aug-19 7:14
mveRichard Deeming29-Aug-19 7:14 
GeneralRe: Linq, GroupBy, Select, First() or Last() Pin
jkirkerx29-Aug-19 8:32
professionaljkirkerx29-Aug-19 8:32 
QuestionTrying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Augusto10026-Aug-19 6:51
memberAugusto10026-Aug-19 6:51 
AnswerRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
ZurdoDev26-Aug-19 7:38
professionalZurdoDev26-Aug-19 7:38 
AnswerRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Richard Deeming27-Aug-19 2:55
mveRichard Deeming27-Aug-19 2:55 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Augusto10027-Aug-19 5:36
memberAugusto10027-Aug-19 5:36 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Richard Deeming27-Aug-19 5:40
mveRichard Deeming27-Aug-19 5:40 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Augusto10027-Aug-19 6:23
memberAugusto10027-Aug-19 6:23 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Richard Deeming27-Aug-19 6:30
mveRichard Deeming27-Aug-19 6:30 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Augusto10027-Aug-19 6:36
memberAugusto10027-Aug-19 6:36 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Richard Deeming27-Aug-19 7:07
mveRichard Deeming27-Aug-19 7:07 
GeneralRe: Trying to make a fixed asset program using visual studio and sql server I got a conversion error varchar to numeric Pin
Mycroft Holmes27-Aug-19 15:14
memberMycroft Holmes27-Aug-19 15:14 
QuestionCount the number of database hit were made Pin
desanti24-Aug-19 12:37
memberdesanti24-Aug-19 12:37 
AnswerRe: Count the number of database hit were made Pin
Gerry Schmitz25-Aug-19 2:30
mveGerry Schmitz25-Aug-19 2:30 
GeneralRe: Count the number of database hit were made Pin
desanti25-Aug-19 3:49
memberdesanti25-Aug-19 3:49 
GeneralRe: Count the number of database hit were made Pin
Gerry Schmitz25-Aug-19 11:38
mveGerry Schmitz25-Aug-19 11:38 

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.