Click here to Skip to main content
15,922,584 members
Home / Discussions / C#
   

C#

 
AnswerRe: FileStream object and performance concern Pin
rcollina16-May-08 21:37
rcollina16-May-08 21:37 
Questionhow can i make an appointment schedulling in c# Pin
mjee15-May-08 20:53
mjee15-May-08 20:53 
QuestionRe: how can i make an appointment schedulling in c# Pin
sunspeed15-May-08 20:55
sunspeed15-May-08 20:55 
AnswerRe: how can i make an appointment schedulling in c# Pin
mjee15-May-08 21:26
mjee15-May-08 21:26 
GeneralRe: how can i make an appointment schedulling in c# Pin
Rupesh Kumar Swami15-May-08 21:45
Rupesh Kumar Swami15-May-08 21:45 
GeneralRe: how can i make an appointment schedulling in c# Pin
sunspeed15-May-08 21:47
sunspeed15-May-08 21:47 
GeneralRe: how can i make an appointment schedulling in c# Pin
Shani Natav15-May-08 22:03
Shani Natav15-May-08 22:03 
AnswerRe: how can i make an appointment schedulling in c# Pin
J4amieC15-May-08 22:24
J4amieC15-May-08 22:24 
Can I suggest you start out by having a good think about your database. It is the core of any application like this and unless you get this bit right early on you will struggle to enhance the system.

To get you started I would initially approach this with 3 tables.

Doctor
======
DoctorId - INT - NOT NULL - IDENTITY - PRIMARY KEY
DoctorName - NVARCHAR(200) - NOT NULL
(You can add other columns here later as needed)

Surgery
=======
SurgeryId - INT - NOT NULL - IDENTITY - PRIMARY KEY
SurgeryName - NVARCHAR(200) - NOT NULL
(Other columns here too eg/ opening times)

Appointment
===========
AppointmentId - INT - NOT NULL - IDENTITY - PRIMARY KEY
DoctorId - INT - FOREIGN KEY (Doctor)
SurgeryId - INT - FOREIGN KEY (Surgery)
AppointmentDateTime - DATETIME
(Other columns here if necessary)

That should get you started on the Db structure, and easily allows you to pull out all records for a particular doctor, or surgery, to display in a grid.
QuestionMultithreading in streaming media Pin
B!Z15-May-08 20:31
B!Z15-May-08 20:31 
AnswerRe: Multithreading in streaming media Pin
Ray Parker16-May-08 4:31
Ray Parker16-May-08 4:31 
QuestionHelp me with Tree View and TextBox [modified] Pin
kissmevn15-May-08 19:53
kissmevn15-May-08 19:53 
AnswerRe: Help me with Tree View and TextBox Pin
sunspeed15-May-08 20:31
sunspeed15-May-08 20:31 
GeneralRe: Help me with Tree View and TextBox Pin
kissmevn15-May-08 21:24
kissmevn15-May-08 21:24 
GeneralRe: Help me with Tree View and TextBox Pin
sunspeed15-May-08 21:42
sunspeed15-May-08 21:42 
GeneralRe: Help me with Tree View and TextBox Pin
kissmevn15-May-08 21:51
kissmevn15-May-08 21:51 
QuestionLong and INT64 not big enough Pin
MumbleB15-May-08 19:23
MumbleB15-May-08 19:23 
AnswerRe: Long and INT64 not big enough Pin
Christian Graus15-May-08 19:31
protectorChristian Graus15-May-08 19:31 
GeneralRe: Long and INT64 not big enough Pin
MumbleB15-May-08 19:40
MumbleB15-May-08 19:40 
GeneralRe: Long and INT64 not big enough Pin
Christian Graus15-May-08 19:49
protectorChristian Graus15-May-08 19:49 
GeneralRe: Long and INT64 not big enough Pin
Vikram A Punathambekar15-May-08 20:21
Vikram A Punathambekar15-May-08 20:21 
GeneralRe: Long and INT64 not big enough Pin
MumbleB15-May-08 20:24
MumbleB15-May-08 20:24 
AnswerRe: Long and INT64 not big enough [modified] Pin
Guffa15-May-08 20:11
Guffa15-May-08 20:11 
AnswerRe: Long and INT64 not big enough Pin
Luc Pattyn15-May-08 21:44
sitebuilderLuc Pattyn15-May-08 21:44 
GeneralRe: Long and INT64 not big enough Pin
MumbleB15-May-08 22:50
MumbleB15-May-08 22:50 
AnswerRe: Long and INT64 not big enough Pin
MumbleB15-May-08 22:55
MumbleB15-May-08 22:55 

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.