Click here to Skip to main content
15,915,656 members
Home / Discussions / C#
   

C#

 
AnswerRe: Log when windows starts and shuts downs Pin
Mc_Topaz4-May-09 2:12
Mc_Topaz4-May-09 2:12 
GeneralRe: Log when windows starts and shuts downs Pin
Luc Pattyn4-May-09 5:45
sitebuilderLuc Pattyn4-May-09 5:45 
QuestionLog when windows starta and shuts down Pin
Mc_Topaz4-May-09 2:09
Mc_Topaz4-May-09 2:09 
AnswerRe: Log when windows starta and shuts down Pin
Mc_Topaz4-May-09 2:12
Mc_Topaz4-May-09 2:12 
QuestionDetect mouse click event Pin
Member Ártemis4-May-09 1:34
Member Ártemis4-May-09 1:34 
AnswerRe: Detect mouse click event Pin
Reyals4-May-09 1:48
Reyals4-May-09 1:48 
GeneralRe: Detect mouse click event Pin
Member Ártemis4-May-09 2:32
Member Ártemis4-May-09 2:32 
Questionhow to pass Comparison Operators as parameter to query in C#? Pin
obarahmeh4-May-09 0:20
obarahmeh4-May-09 0:20 
Dear All,

I have a query that has some parameters:
(
SELECT DISTINCT
T.TICKET_NUMBER AS TicketNum, A.DESCRIPTION AS Action, O.SYMBOL_CODE AS Symbol, T.TRADE_PRICE AS Price, T.VOLUME_TRADED AS FillVol,
T.EXTENDED_PRICE AS TotalValue, T.SUBMITTED_TIME AS ActTime, T.SUBMITTED_DATE AS TransDate
FROM TSDETL AS T INNER JOIN
TSORDR AS O ON O.SUBMITTED_DATE = T.SUBMITTED_DATE AND O.TICKET_NUMBER = T.TICKET_NUMBER INNER JOIN
TSORDA AS A ON O.ORDER_ACTION = A.ACTION_CODE
WHERE (T.SUBMITTED_DATE = @SUBMIT_DATE) AND (T.VOLUME_TRADED >= @Volume) AND (T.TICKET_NUMBER IS NOT NULL) AND (O.SYMBOL_CODE= @Symbol)
ORDER BY ActTime DESC
)
I passed the three parameters (@SUBMIT_DATE, @Volume, @Symbol) successfully, but I want to read the operator (>= or <=) as a parameter...I have a combo box with >= and <=, and I want to pass the value of this combo into the query.
How can I do this???
this is because the operator may be >= or <=, and I don't want to write two queries.

Kind Regards
OBarahmeh

AnswerRe: how to pass Comparison Operators as parameter to query in C#? Pin
Eddy Vluggen4-May-09 0:31
professionalEddy Vluggen4-May-09 0:31 
GeneralRe: how to pass Comparison Operators as parameter to query in C#? Pin
obarahmeh4-May-09 1:26
obarahmeh4-May-09 1:26 
GeneralRe: how to pass Comparison Operators as parameter to query in C#? Pin
Eddy Vluggen4-May-09 7:09
professionalEddy Vluggen4-May-09 7:09 
GeneralRe: how to pass Comparison Operators as parameter to query in C#? Pin
obarahmeh4-May-09 22:31
obarahmeh4-May-09 22:31 
QuestionA simple question... please help Pin
Reyals4-May-09 0:08
Reyals4-May-09 0:08 
AnswerRe: A simple question... please help Pin
SeMartens4-May-09 0:16
SeMartens4-May-09 0:16 
AnswerRe: A simple question... please help Pin
OriginalGriff4-May-09 0:18
mveOriginalGriff4-May-09 0:18 
AnswerRe: A simple question... please help Pin
Reyals4-May-09 0:42
Reyals4-May-09 0:42 
AnswerRe: A simple question... please help Pin
OriginalGriff4-May-09 1:02
mveOriginalGriff4-May-09 1:02 
GeneralRe: A simple question... please help Pin
Reyals4-May-09 1:37
Reyals4-May-09 1:37 
JokeRe: A simple question... please help Pin
OriginalGriff4-May-09 1:52
mveOriginalGriff4-May-09 1:52 
QuestionFire enter key Pin
rmedo3-May-09 23:55
rmedo3-May-09 23:55 
AnswerRe: Fire enter key Pin
stancrm4-May-09 0:37
stancrm4-May-09 0:37 
AnswerRe: Fire enter key Pin
Member 44703544-May-09 0:50
Member 44703544-May-09 0:50 
GeneralRe: Fire enter key Pin
rmedo4-May-09 2:46
rmedo4-May-09 2:46 
QuestionSQL SCRIPT Pin
kibromg3-May-09 23:20
kibromg3-May-09 23:20 
AnswerRe: SQL SCRIPT - cross post Pin
Mycroft Holmes3-May-09 23:25
professionalMycroft Holmes3-May-09 23:25 

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.