Click here to Skip to main content
15,901,373 members
Home / Discussions / C#
   

C#

 
QuestionHow to globally suppress mouse click Pin
GeeBru10-Jul-09 12:14
GeeBru10-Jul-09 12:14 
AnswerRe: How to globally suppress mouse click Pin
Not Active10-Jul-09 13:08
mentorNot Active10-Jul-09 13:08 
GeneralRe: How to globally suppress mouse click Pin
GeeBru10-Jul-09 13:13
GeeBru10-Jul-09 13:13 
GeneralRe: How to globally suppress mouse click Pin
Not Active10-Jul-09 13:20
mentorNot Active10-Jul-09 13:20 
GeneralRe: How to globally suppress mouse click Pin
GeeBru10-Jul-09 13:23
GeeBru10-Jul-09 13:23 
Questionworking with dates and database Pin
elidotnet10-Jul-09 12:00
elidotnet10-Jul-09 12:00 
AnswerRe: working with dates and database Pin
Not Active10-Jul-09 13:18
mentorNot Active10-Jul-09 13:18 
AnswerRe: working with dates and database Pin
Henry Minute10-Jul-09 13:23
Henry Minute10-Jul-09 13:23 
In general terms what you need to do is the following.

Get the signNumber, Start Date, End Date and Company Name (needed for insert later) from the user.
Pass the signNumber, Start Date and End Date as parameters to an SQL select statement which does the following:

<big>Select</big> whichever fields you want from the orders table <big>where</big> orders.signNumber == the one passed as a parameter
  and ((the Start Date passed as a parameter is <big>between</big> orders.fromDate and orders.toDate)
    or (the End Date passed as a parameter is <big>between</big> orders.fromDate and orders.toDate))


If the Select statement returns any rows the sign is already booked for at least part of the required period.
If, on the other hand no rows are returned, then the board is free to be used.

The highlighting provides some clues to things that you will need to research in order to do this.

Good Luck! Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

QuestionDifferentiate Restart vs Shut Down, StandBy vs Hibernate Pin
olograph10-Jul-09 11:57
olograph10-Jul-09 11:57 
AnswerRe: Differentiate Restart vs Shut Down, StandBy vs Hibernate Pin
OriginalGriff10-Jul-09 21:57
mveOriginalGriff10-Jul-09 21:57 
QuestionNeed suggestions on datagrid/dataview Pin
babbelfisken10-Jul-09 11:26
babbelfisken10-Jul-09 11:26 
AnswerRe: Need suggestions on datagrid/dataview Pin
DaveyM6910-Jul-09 11:33
professionalDaveyM6910-Jul-09 11:33 
QuestionActive Directory... C#... How do I get the users windows login? Help please. [modified] Pin
JollyMansArt10-Jul-09 10:12
JollyMansArt10-Jul-09 10:12 
QuestionRe: Active Directory... C#... How do I get the users windows login? Help please. Pin
JollyMansArt10-Jul-09 12:13
JollyMansArt10-Jul-09 12:13 
AnswerFigured it out... Pin
JollyMansArt10-Jul-09 12:18
JollyMansArt10-Jul-09 12:18 
Questiontabbed forms with identical content. Pin
avDallas10-Jul-09 9:18
avDallas10-Jul-09 9:18 
AnswerRe: tabbed forms with identical content. Pin
DaveyM6910-Jul-09 11:18
professionalDaveyM6910-Jul-09 11:18 
GeneralRe: tabbed forms with identical content. Pin
avDallas10-Jul-09 18:05
avDallas10-Jul-09 18:05 
AnswerRe: tabbed forms with identical content. Pin
Henry Minute10-Jul-09 11:24
Henry Minute10-Jul-09 11:24 
QuestionDifference between Methods and Functions? Pin
Rajdeep.NET10-Jul-09 8:46
Rajdeep.NET10-Jul-09 8:46 
AnswerRe: Difference between Methods and Functions? Pin
Blue_Boy10-Jul-09 8:50
Blue_Boy10-Jul-09 8:50 
AnswerRe: Difference between Methods and Functions? Pin
0x3c010-Jul-09 9:03
0x3c010-Jul-09 9:03 
GeneralRe: Difference between Methods and Functions? Pin
Rajdeep.NET10-Jul-09 9:19
Rajdeep.NET10-Jul-09 9:19 
GeneralRe: Difference between Methods and Functions? Pin
0x3c010-Jul-09 9:43
0x3c010-Jul-09 9:43 
GeneralRe: Difference between Methods and Functions? Pin
PIEBALDconsult10-Jul-09 13:44
mvePIEBALDconsult10-Jul-09 13:44 

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.