.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: October 11, 2010    Points: 0   Category :ASP.Net

hey again

Im trying to create appointment for patients that not allowed double booking but allowed long booking 

I have table callled Appointment ( appointmentID, DrID, PatientsID, Date, Time) how can I do that ?


Note I have patients and Doctor tables 

View Complete Post

More Related Resource Links

Collaboration Data Objects: Send Microsoft Exchange Appointment Reminders to Your Pager Using CDO


Besides your typical e-mail services, Microsoft Exchange also provides the service infrastructure you need to build extensible knowledge and workflow management systems. Understanding Collaboration Data Objects (CDO) is the key to accessing these Exchange services for your own programs. With CDO you can automate tedious tasks and integrate information such as e-mail, calendars, and contacts with almost any application. This article explains how CDO enables you to access Exchange services, then walks you through a sample application that reads calendar events from an Exchange server and sends pager reminders to your users.

Sean McCormick

MSDN Magazine June 2000

Problem with appointment function

I am beginner of asp.net and c#Currently i am learning on create a website with appointment feature. The website i am doing basically a dental appointment web, which show the free slot of dentist on the website and enable patient to book appointment by schedule an appointment based on time and date given. I have done others thing such as register, login, report those however i have no idea on doing the appointment module. I am trying to learn easy way to create booking feature for dental website. Is that a tutorial on learning to do this or others way which i can easily learn it. Thank you.

Appointment Calendar

I want to create a web app that will allow authenticated users to login and set an appointment by viewing a calendar and if available, clicking a day on that calendar and request an appointment to web owner. I am thinking of a Doctor's office, offering their patients the ability to pick a their own appointment, if available, and selecting that day. Later, a nurse can view the request and either accept and confirm the appointment or deny and suggest another. I tried looking for examples, but could not find any. Any suggestions???   Thank You.. Edski 

Appointment validation checking and data inserting

I am beginner of asp.net and c#Currently i doing appointment website and need suggestions/ ideas. I have create a simple web form  with Calender Control as picture below enable users to select date and time. At the calender control, i have set that users can only select tuesday and thursday every month using DayRender. After that i put a DropDownList to display the time. Next step, i want to store the data into database, for example UserA make appointment on Date 21 September 2010, Time 1100 and make it unavailable for other bookings. When UserB makes appointment on same Date and Time, it will display information that the slot is booked/unavailable. To implement this, what approach should i take? When i insert the data into database should i convert the value of DropDownList to time format or just insert DropDownList.Text? If i just insert according to DropDownList.Text will it having problem in check the slot is booked or not? <asp:DropDownList ID="DropDownList1" runat="server"> <asp:ListItem>0900</asp:ListItem> <asp:ListItem>1000</asp:ListItem> <asp:ListItem>1100</asp:ListItem> <asp:ListItem>1200</asp:ListItem> <asp:ListItem>1400</asp:ListItem> <asp:ListItem>1500</asp:ListItem> <asp:ListItem>1600</asp:L

Appointment Checking


Currently i am using asp.net and visual c# to do appointment checking.

I having problem in doing validation which is if the database got same date and time record, it will display a message tell user the slot is booked and user have to reselect.

Web Form- Calander control, Listbox, Button

Database got a table call AppBooking 

Stored Procedure

Create Procedure bookingcheck ( @App_Date Date, @App_Time nVarchar(50) ) 
IF EXISTs (SELECT * FROM AppBooking Where App_Date = @App_Date AND App_Time = @App_Time) RETURN 1 ELSE RETURN 0; 

I have created the stored procedure however i don't how to implement it in the submit button and  associate with insert value into database table. Kindly if you could help me in solving the problem. Thank you.

NULL for user who don't have appointment - UNION error ... LEFT JOIN doesn't work



It's so silly what i'm trying to do.. I just need to catch the entire list of user and null for users who don't have appointment ....

I tried union but I've got an error, please help


Msg 205, Level 16, State 1, Line 2
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

declare @SQL Varchar(4000)

declare @CRM_FilteredAppointment nvarchar(2000)
declare @CRM_FilteredSystemUser nvarchar(2000)

set @CRM_FilteredSystemUser = 'SELECT systemuserid, eu_reporthubname, fullname, businessunitidname 
 FROM FilteredSystemUser 
 WHERE businessunitidname = ''Spain''
--exec (@CRM_FilteredSystemUser)

set @CRM_FilteredAppointment = 'SELECT activityid, ownerid, regardingobjectid, subject, scheduledend 
 FROM FilteredAppointment 

set @SQL = ' 
 SELECT SU.systemuserid, SU.fullname, count(partyid)
 FROM (' + @CRM_FilteredSystemUser + ') AS SU
    (' + @CRM_FilteredAppointment + ') as Apt ON 
    SU.systemuserid = Apt.ownerid 
    FilteredActivityParty AS AP ON Apt.activityid = AP.activityid 
   AND (AP.participationtypemask = 8 OR AP.participationtypemask = 5) 
 WHERE Partyidname is not null 
group by SU.systemuserid, SU.fullname

Appointment alerts - server or pc


I have an appointment software using C# WinForm and I want to send alerts (SMS & Emails) through SMS gateways and email to the customers..

I want to know what's best...

1. Send the alert directly from the PC? this will require an internet connection on the PC.


2. Send the alerts to the database on the server and make it in queue? this will not require internet connection to be enabled on every PC.

what do you think?

Jassim Rahma
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend