Editing parameters in sqldatasource

Question

I want to create a dynamic select command in an SQLDataSource. It should read a value from the URL sent using get, grab it and stick it into the select command.

My sqldatadource is in my aspx page and looks like this

<asp:SqlDataSource ID="DS" Runat="server"

    SelectCommand="SELECT * FROM [dbo].[DS] WHERE [Install Process] = 'OCC' 
    AND [The Date] = @theDate"

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

</asp:SqlDataSource>

I want to update theDate parameter. I'm guessing you cant update it in Page_Load because the page hasn't loaded yet but I'm honestly not sure. can i call a codebehind function from within the sqldatasource or something...

This is my codebehind. It's currently in the page_load method, but i'm guessing that I need to move it? any help would be great. Thanks

protected void Page_Load(object sender, EventArgs e)
{
    string theDate = Request.QueryString["TheDate"];

    DS.SelectParameters.Add("@theDate", theDate);
    DS.SelectParameters["theDate"].DefaultValue = theDate.ToString();
}

score 0 · Answer 1 · answered Jun 14 '12 at 13:10

0

Can you not use the QueryStringParmater of the SelectParameters collection in the aspx declaration of the SqlDataSource as documented here?

answered Jun 14 '12 at 13:10

mreyeros

4,359
20
24

score 0 · Answer 2 · answered Jun 14 '12 at 13:19

This is one of the best samples I have used, check Assigning Parameter Values Programmatically in the page.

http://www.asp.net/web-forms/tutorials/data-access/accessing-the-database-directly-from-an-aspnet-page/using-parameterized-queries-with-the-sqldatasource-cs

Editing parameters in sqldatasource

2 Answers2