Click here to Skip to main content
14,327,583 members
   

C#

 
AnswerRe: c# Pin
OriginalGriff18-Mar-19 21:07
protectorOriginalGriff18-Mar-19 21:07 
AnswerRe: c# Pin
Gerry Schmitz19-Mar-19 5:44
mveGerry Schmitz19-Mar-19 5:44 
Question(SOLVED) - How do I execute stored proc with pivot query? Pin
samflex18-Mar-19 4:39
membersamflex18-Mar-19 4:39 
AnswerRe: How do I execute stored proc with pivot query? Pin
Gerry Schmitz18-Mar-19 6:01
mveGerry Schmitz18-Mar-19 6:01 
GeneralRe: How do I execute stored proc with pivot query? Pin
samflex18-Mar-19 7:02
membersamflex18-Mar-19 7:02 
GeneralRe: How do I execute stored proc with pivot query? Pin
Gerry Schmitz18-Mar-19 9:56
mveGerry Schmitz18-Mar-19 9:56 
AnswerRe: How do I execute stored proc with pivot query? Pin
Richard Deeming18-Mar-19 9:23
mveRichard Deeming18-Mar-19 9:23 
GeneralRe: How do I execute stored proc with pivot query? Pin
samflex18-Mar-19 10:05
membersamflex18-Mar-19 10:05 
Greetings Richard,

Thank you so much. Man you make coding look so simple!

As for updating them, all updates are done via my C# and they can only update Members and Transactions tables. Any new records added or updated are stored on those tables

Once the updates are made, they will be picked up by the PIVOT query.

That's the thinking at least.

I am having just one error right now:

Error	CS0103	The name 'commandText' does not exist in the current context


which is on this line:

using (SqlCommand command = new SqlCommand(commandText, connection))


At least you clearly understand what I am doing to do

UPDATE: I replaced commandText with selectCommand and it started working.

You are simply awesome!!

Exactly the solution I was looking for.

Thank you very much.

modified 18-Mar-19 17:40pm.

QuestionChecking internet connection at startup Pin
RedPandinus17-Mar-19 11:54
memberRedPandinus17-Mar-19 11:54 
AnswerRe: Checking internet connection at startup Pin
Luc Pattyn17-Mar-19 15:00
professionalLuc Pattyn17-Mar-19 15:00 
QuestionA Question on a C# command Pin
Brian_TheLion16-Mar-19 13:40
memberBrian_TheLion16-Mar-19 13:40 
AnswerRe: A Question on a C# command Pin
Dave Kreskowiak16-Mar-19 14:15
mveDave Kreskowiak16-Mar-19 14:15 
GeneralRe: A Question on a C# command Pin
Brian_TheLion16-Mar-19 15:45
memberBrian_TheLion16-Mar-19 15:45 
GeneralRe: A Question on a C# command Pin
Brian_TheLion17-Mar-19 12:21
memberBrian_TheLion17-Mar-19 12:21 
GeneralRe: A Question on a C# command Pin
Dave Kreskowiak17-Mar-19 14:25
mveDave Kreskowiak17-Mar-19 14:25 
GeneralRe: A Question on a C# command Pin
Brian_TheLion17-Mar-19 18:00
memberBrian_TheLion17-Mar-19 18:00 
QuestionAsking about collecting inputs Pin
Member 1235678215-Mar-19 7:45
memberMember 1235678215-Mar-19 7:45 
AnswerRe: Asking about collecting inputs Pin
Richard MacCutchan15-Mar-19 7:49
protectorRichard MacCutchan15-Mar-19 7:49 
GeneralRe: Asking about collecting inputs Pin
Member 1235678215-Mar-19 8:21
memberMember 1235678215-Mar-19 8:21 
GeneralRe: Asking about collecting inputs Pin
Richard MacCutchan15-Mar-19 9:12
protectorRichard MacCutchan15-Mar-19 9:12 
GeneralRe: Asking about collecting inputs Pin
Member 1235678215-Mar-19 22:11
memberMember 1235678215-Mar-19 22:11 
GeneralRe: Asking about collecting inputs Pin
Richard MacCutchan15-Mar-19 23:12
protectorRichard MacCutchan15-Mar-19 23:12 
GeneralRe: Asking about collecting inputs Pin
OriginalGriff15-Mar-19 9:13
protectorOriginalGriff15-Mar-19 9:13 
GeneralRe: Asking about collecting inputs Pin
Mycroft Holmes15-Mar-19 13:16
memberMycroft Holmes15-Mar-19 13:16 
GeneralRe: Asking about collecting inputs Pin
OriginalGriff15-Mar-19 20:38
protectorOriginalGriff15-Mar-19 20: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.