Actually my table is

[activityid] [int] IDENTITY(1,1) NOT NULL,

[salespersonid] [int] NULL,

[activitydate] [datetime] NULL

I am trying to make a calender using a gridview in...

Thanks for the code but I didnt understand the code ... and also there is also a condition - select only salespersonId =1 (salespersonId is another field which i didnt...

yes there will be only one entry for a date