I think the other part to mention is that there are two things to keep in mind.
1. The input from the Calendar Control which become the WHERE in my SQL Statement
1. Running my SQL statement
2. And outputing the date on the page (through RadGrid control)
I need to keep straight all of the inputs and outputs and make sure the formats are what i expect.
So, when i click a date on the calendar control. Which is @ArticleDateTime in the WHERE clause. This needs to be sent in the Date format (no time).
| <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LionsConnectionString %>"
| SelectCommand="SELECT ArticleID, ArticleTitle, ArticleSubject, ArticleContent, ArticleDateTime, ArticleExp, ArticleExpChkBox, UserID, UserName FROM tblLionsArticles WHERE ((ArticleDateTime) = @ArticleDateTime)">
| <asp:ControlParameter ControlID="RadDatePicker1" DefaultValue="1/1/2008" Name="ArticleDateTime"
| PropertyName="SelectedDate" />
I need to somehow accept only the Date from the calendar parameter, as well as the database understand only the date even though the SQL database has DateTime.
I having a hard time understanding how to accept only Date and SQL do a SELECT only for Date and then return only the Date value.
I hope this helps a little more.