how can i make an appointment schedulling in c#
-
we'll be making an appointment schedulling for doctors.. it should display a table: columns - doctor's name rows - time slots everytime we'll enter a new appointment, it will be displayed in the table.. can somebody help us?? :confused::confused::confused::confused:
-
we'll be making an appointment schedulling for doctors.. it should display a table: columns - doctor's name rows - time slots everytime we'll enter a new appointment, it will be displayed in the table.. can somebody help us?? :confused::confused::confused::confused:
-
sorry, whats the exact problem?
Tiefe Brunnen muss man graben wenn man klares Wasser will, tiefe Wasser sind nicht still.
-
hi mjee, I think you want to store doctor Name and Appointment time in each row.If am i right,then make a table(in databsse) which contains the column DoctorName(Text Type) and AppointmentTime(Date time Type) hope this helps
Rupesh Kumar Swami Software Engineer, Integrated Solution, Bikaner (India) My Company
-
do you want to show it like a matrix?
| Dr. 1 | Dr. 2 | Dr. 3 |...
09:00 | Mr. 1 | ---- | ----- |
09:30 | ----- | Mr. 2 | ----- |
...Der Staat mit der niedrigsten Geburtenrate ist nicht die Bundesrepublik, sondern der Vatikan.
You can make a class the inherits from DataTable: and make an initializing method where you put som ething like TableName = , add columns and dump to xml. you can load it next time, and put it as GridView datasource.
-
we'll be making an appointment schedulling for doctors.. it should display a table: columns - doctor's name rows - time slots everytime we'll enter a new appointment, it will be displayed in the table.. can somebody help us?? :confused::confused::confused::confused:
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.