How do I pass a System Date Parameter to a SQLDatasource?

PianoMan64

Hey Guys and Gals,

I'm a little stumped on this one. I'm trying to find out how to pass the System Date from the server to a SQLDatasource control.

I need to know the syntax for passing that either in the aspx page, or the code behind file (aspx.vb)

What I have so far is:

Expand|Select|Wrap|Line Numbers

  
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 

            ConnectionString="<%$ ConnectionStrings:DailyRazorDatabase %>" 

            SelectCommand="SELECT [EventDate], [EventTitle], [EventStartTime], [EventEndTime], [Description] FROM [EventCalendar] WHERE ([EventDate] BETWEEN @EventDate AND @EventDate+30)">

            <SelectParameters>

                <asp:ControlParameter ControlID="Calendar1" DbType="DateTime" Name="EventDate" DefaultValue=<Need Syntax Here  />

            </SelectParameters>

        </asp:SqlDataSource>

Thanks for all your help in advance.

Joe P.

PianoMan64

Hey Guys and Gals,

I was able to figure it out with some more research.

What you have to do is create a control on a form. Make it invisiable, and set the value of the control to the current date/time.

Then you can use that control to pass the value in as a parameter.

Thanks again for all your help.

Joe P.

How do I pass a System Date Parameter to a SQLDatasource?

re: How do I pass a System Date Parameter to a SQLDatasource?

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about