Create Scheduler in Asp.net.C# or Databound Schedule controls

Databound Schedule controls

In order to display a schedular in asp.net, there is a third party tool avaliable.

Please go through this article to get details:

http://www.codeproject.com/KB/custom-controls/schedule.aspx


And Inorder to schedule an email through .net follow:

http://www.codeproject.com/KB/aspnet/Schedule_Task.aspx


sp for the scheduler

ALTER PROCEDURE [dbo].[sessions_NonTicketedScheduleDAY]
-- Add the parameters for the stored procedure here
@confGuid varchar(500),
@sDay varchar(500)
AS
BEGIN

DECLARE @SQL varchar(1000)


-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;


--SET @SQL = 'SELECT sID, sName, sDate, sEndDate,sTime,sEndTime FROM sessions_NonTicketed WHERE confguid='+@confGuid+' and sdate between ('+@startDate+') and ('+@endDate+') '
SET @SQL = 'SELECT sID, sName, sDate, sEndDate,sTime,sEndTime,Category FROM sessions_NonTicketed WHERE confguid='+@confGuid+' and
Day(sdate)='+@sDay+''

--'SELECT sID, sName, sDate, sEndDate,sTime,sEndTime FROM sessions_NonTicketed WHERE confguid='+@confGuid+' and sdate >="'+convert(varchar(23),@startDate)+'"AND shippeddate <="'+convert(varchar(23),@endDate)+'"'
--'select * from orders where requireddate >="'+convert(varchar(23),@reqdate)+'" AND shippeddate >="'+convert(varchar(23),@shipdate)+'"'

EXEC(@SQL)
END

Also In case you wanna color codeing as per type its possible within this scheduler