DateTime.Min/MaxValue as SQL data source default parameter value?

  • Thread starter Homer J. Simpson
  • Start date
H

Homer J. Simpson

When I try to use the following:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:csToolbar %>"
SelectCommand="spGetValuesForDateRange" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:parameter DefaultValue="<%= DateTime.MinValue %>"
Name="FIRSTDAY" Type="DateTime" />
<asp:parameter DefaultValue="<%= DateTime.MaxValue %>"
Name="LASTDAY" Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>

....I get an error implying that DateTime.M[in]|[ax]Value is invalid--ASP.NET
seems to think I'm trying to use strings. I can't figure out the proper
syntax.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,995
Messages
2,570,225
Members
46,815
Latest member
treekmostly22

Latest Threads

Top