Calender Control help (Possibly easy)

[Aspnoober]

Ok heres a problem thats been bugging me for sometime, but magaed to put it off as I had other stuff to program.

I'm using a Callender control in ASP.NET to display some data from a SQL table.

My current code is

Code: Select all

<asp:Calendar ID="Calendar1" runat="server"></asp:Calendar>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"></asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:default %>" SelectCommand="select message from myTable where day_date = @day_date">
<SelectParameters>
<asp:ControlParameter Name="day_date" Type="DateTime" ControlID="Calendar1" PropertyName="SelectedDate" />
</SelectParameters>
</asp:SqlDataSource>

Now this code works but I need it to work in weeks instead of days so to speak. So the data would show for 7 days instead of just that 1 day (for example Monday - Sunday). My only thoughts would be to make the database hold 7 rows of dates, however that may be impractical as other users may need to change the dates once in a while.
Can anyone think of an easy way to do this? Or am I going to need to use a hella of lot more code.

Any help would be appreciated.

[RSoftware]

Unfortuntely the caledar control doesn't support a week-view like in, say, outlook?
One way around this would be to use a repeater or datalist to show data for the days of the current week (as calculated on the calendar) then set the currently selected calendar day as the selected datalist control.

Other than that, i can't think of anything.
There are a few third party Outlook style calendar controls, but i don't think any of them are freeware.

All the best:
Rob - Riviera Software