Click here to Skip to main content
15,899,825 members
Home / Discussions / C#
   

C#

 
QuestionUK buddy's needed with C# skill for mega big project Pin
stopthespying15-Feb-18 5:49
stopthespying15-Feb-18 5:49 
AnswerRe: UK buddy's needed with C# skill for mega big project Pin
OriginalGriff15-Feb-18 5:51
mveOriginalGriff15-Feb-18 5:51 
GeneralRe: UK buddy's needed with C# skill for mega big project Pin
stopthespying15-Feb-18 6:43
stopthespying15-Feb-18 6:43 
QuestionRe: UK buddy's needed with C# skill for mega big project Pin
Eddy Vluggen15-Feb-18 6:22
professionalEddy Vluggen15-Feb-18 6:22 
AnswerRe: UK buddy's needed with C# skill for mega big project Pin
stopthespying15-Feb-18 7:40
stopthespying15-Feb-18 7:40 
GeneralRe: UK buddy's needed with C# skill for mega big project Pin
Eddy Vluggen15-Feb-18 12:40
professionalEddy Vluggen15-Feb-18 12:40 
QuestionC# 2008 express building a query Pin
Member 330187815-Feb-18 4:01
Member 330187815-Feb-18 4:01 
AnswerRe: C# 2008 express building a query Pin
OriginalGriff15-Feb-18 5:01
mveOriginalGriff15-Feb-18 5:01 
Yes, assuming you have two tables which share a common value.
For example, an Invoice would be two tables:
Invoices
ID         INT, IDENTITY
Issued     DATE
Company    NVARCHAR(256)

InvoiceLines
ID         INT, IDENTITY
InvoiceID  INT, FOREIGN KEY to Invoices.ID
Product    NVARCHAR(256)
Value      MONEY
Then you might retrieve data like this:
SQL
SELECT i.ID, i.Date, i.Company, il.Product, il.Value 
FROM Invoices i
JOIN InvoiceLines il ON il.InvoiceID = i. ID
And you would get the appropriate rows in the DGV
Or
SQL
SELECT i.ID, i.Date, i.Company, il.Total 
FROM Invoices i
JOIN (SELECT InvoiceID, SUM(Value) AS Total 
      FROM InvoiceLines 
      GROUP BY InvoiceID) il
ON il.InvoiceID = i. ID
And you would get invoice detail and total value
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

AnswerRe: C# 2008 express building a query Pin
stopthespying15-Feb-18 6:48
stopthespying15-Feb-18 6:48 
QuestionImplementing a moving average Pin
auting8214-Feb-18 10:12
auting8214-Feb-18 10:12 
AnswerRe: Implementing a moving average Pin
OriginalGriff14-Feb-18 20:41
mveOriginalGriff14-Feb-18 20:41 
GeneralRe: Implementing a moving average Pin
auting8214-Feb-18 23:54
auting8214-Feb-18 23:54 
AnswerRe: Implementing a moving average Pin
Ralf Meier15-Feb-18 0:25
mveRalf Meier15-Feb-18 0:25 
GeneralRe: Implementing a moving average Pin
Rob Philpott15-Feb-18 0:24
Rob Philpott15-Feb-18 0:24 
GeneralRe: Implementing a moving average Pin
OriginalGriff15-Feb-18 0:34
mveOriginalGriff15-Feb-18 0:34 
GeneralRe: Implementing a moving average Pin
auting8215-Feb-18 1:38
auting8215-Feb-18 1:38 
GeneralRe: Implementing a moving average Pin
OriginalGriff15-Feb-18 1:53
mveOriginalGriff15-Feb-18 1:53 
GeneralRe: Implementing a moving average Pin
auting8215-Feb-18 4:35
auting8215-Feb-18 4:35 
GeneralRe: Implementing a moving average Pin
OriginalGriff15-Feb-18 4:53
mveOriginalGriff15-Feb-18 4:53 
AnswerRe: Implementing a moving average Pin
Ralf Meier15-Feb-18 21:27
mveRalf Meier15-Feb-18 21:27 
GeneralRe: Implementing a moving average Pin
auting8216-Feb-18 1:25
auting8216-Feb-18 1:25 
GeneralRe: Implementing a moving average Pin
Pete O'Hanlon16-Feb-18 7:53
mvePete O'Hanlon16-Feb-18 7:53 
GeneralRe: Implementing a moving average Pin
Ralf Meier16-Feb-18 9:49
mveRalf Meier16-Feb-18 9:49 
GeneralRe: Implementing a moving average Pin
auting8216-Feb-18 11:40
auting8216-Feb-18 11:40 
GeneralRe: Implementing a moving average Pin
Ralf Meier16-Feb-18 12:42
mveRalf Meier16-Feb-18 12:42 

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.