How to fetch data from Sql Server table for Comparison and how to do the table binding?

microsoft.public.dotnet.framework.adonet

31 Jul 2006 5:31 PM

ajmera.puneet

If I have Calendar Control on Asp.net page and I have a table for
Fiscal years on sql server
then, How can I check the dates from table to Calendar Control,so that
I can format the Calendar control cells according to my need.
I want to change the color of Dates according to fiscal month. i.e. As
Calendar control has dates for Current + next + Previous months, I need

to change the color of dates of month which is comes under Fiscal
month.
I have table for fiscal years, which has following :

CREATE TABLE [AccountingCalendar] (
        [AccountingCalendarID] [int] IDENTITY (1, 1) NOT NULL ,
        [FiscalYear] [smallint] NOT NULL ,
        [FiscalQuarter] [tinyint] NOT NULL ,
        [FiscalMonth] [tinyint] NOT NULL ,
        [MonthName] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT
NULL ,
        [MonthStart] [smalldatetime] NOT NULL ,
        [MonthEnd] [smalldatetime] NOT NULL ,
        [CalendarYear] [smallint] NOT NULL ,
        [CalendarQuarter] [tinyint] NOT NULL ,
        [CalendarMonth] [tinyint] NOT NULL ,
        [NoOfWeeks] [tinyint] NOT NULL ,
        CONSTRAINT [pkAccountingCalendar] PRIMARY KEY CLUSTERED
        (
                [AccountingCalendarID]
        ) WITH FILLFACTOR = 90 ON [PRIMARY]
) ON [PRIMARY]
GO

And data according to it.
Now How can I check the dates from these table with Calendar Date and
change the backgrond color for the month Started from MonthStart to
MonthEnd field of table.

Any suggestion or help will be appriciated.
TIA