Click here to Skip to main content
15,906,463 members
Home / Discussions / C#
   

C#

 
QuestionFramework 1.1 and 2 Pin
Niklas Ulvinge16-Sep-05 5:35
Niklas Ulvinge16-Sep-05 5:35 
AnswerRe: Framework 1.1 and 2 Pin
Dave Kreskowiak16-Sep-05 6:19
mveDave Kreskowiak16-Sep-05 6:19 
GeneralRe: Framework 1.1 and 2 Pin
Judah Gabriel Himango16-Sep-05 8:16
sponsorJudah Gabriel Himango16-Sep-05 8:16 
QuestionDataRow array Pin
zaboboa16-Sep-05 5:28
zaboboa16-Sep-05 5:28 
AnswerRe: DataRow array Pin
miah alom16-Sep-05 6:02
miah alom16-Sep-05 6:02 
AnswerRe: DataRow array Pin
Jon Sagara16-Sep-05 6:18
Jon Sagara16-Sep-05 6:18 
QuestionSmart document security Pin
WillemM16-Sep-05 3:47
WillemM16-Sep-05 3:47 
QuestionCalculating dates from tables and displaying results Pin
AdamskiR16-Sep-05 3:02
AdamskiR16-Sep-05 3:02 
Hi
I want to create a page where someone can view if someone has been seen within a week or not with 2 buttons on the page, 1 to click which will display records of people who were which will show results in a datagrid and another button to show which was not and to show in a datagrid.

The way the system works now is someone fills out an initial form which populates the data in a table below and the date of submission is recorded:

Initial Referral table
RefID int 4 0
Base varchar 150 0
CustNumber int 4
ReasonForAppointment varchar 50
TimeSpent varchar 50
Contact varchar 50 0
CustomerType varchar 50
Comments varchar 2000
DateSubmitted datetime 8

Then someone else will need to follow up the referral from another form and the following is added and date of submission recorded:

Follow up table
FollowUpID int 4
RefID int 4 0
AdditionalInfo varchar 2000
Point1 bit 1
Point2 varchar 2000
DateToBeCompleted datetime 8
ClientSeen bit 1
DateSubmitted datetime 8

I have the form pages all done, it is just this page i am having a problem with so it can calculate if the dates are longer or shorter than the 2 dates from the two tables and fill the datagrid with the right results.

Any hints or points in the right direction will be appreciated.

CheersSmile | :)
QuestionObjects to bytes... Pin
Niklas Ulvinge16-Sep-05 2:47
Niklas Ulvinge16-Sep-05 2:47 
AnswerRe: Objects to bytes... Pin
turbochimp16-Sep-05 17:03
turbochimp16-Sep-05 17:03 
GeneralRe: Objects to bytes... Pin
Niklas Ulvinge16-Sep-05 21:07
Niklas Ulvinge16-Sep-05 21:07 
GeneralRe: Objects to bytes... Pin
Niklas Ulvinge16-Sep-05 21:25
Niklas Ulvinge16-Sep-05 21:25 
GeneralRe: Objects to bytes... Pin
turbochimp17-Sep-05 6:25
turbochimp17-Sep-05 6:25 
GeneralRe: Objects to bytes... Pin
Niklas Ulvinge17-Sep-05 6:32
Niklas Ulvinge17-Sep-05 6:32 
GeneralRe: Objects to bytes... Pin
turbochimp17-Sep-05 6:42
turbochimp17-Sep-05 6:42 
GeneralRe: Objects to bytes... Pin
Niklas Ulvinge17-Sep-05 7:00
Niklas Ulvinge17-Sep-05 7:00 
GeneralRe: Objects to bytes... Pin
turbochimp17-Sep-05 6:23
turbochimp17-Sep-05 6:23 
QuestionHow to call ITAddressTranslation method Pin
Fredy16-Sep-05 1:08
Fredy16-Sep-05 1:08 
QuestionC# and voice chat Pin
pakFari16-Sep-05 1:07
pakFari16-Sep-05 1:07 
QuestionDateTime search with Data Tables "Select" Method Pin
16-Sep-05 0:50
suss16-Sep-05 0:50 
Questionimage on toolbarbutton Pin
g00fyman16-Sep-05 0:46
g00fyman16-Sep-05 0:46 
AnswerRe: image on toolbarbutton Pin
Subrahmanyam K16-Sep-05 1:01
Subrahmanyam K16-Sep-05 1:01 
GeneralRe: image on toolbarbutton Pin
g00fyman16-Sep-05 1:07
g00fyman16-Sep-05 1:07 
AnswerRe: image on toolbarbutton Pin
mav.northwind16-Sep-05 5:05
mav.northwind16-Sep-05 5:05 
QuestionThread and timer problem Pin
NicklasRing15-Sep-05 23:41
NicklasRing15-Sep-05 23:41 

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.