Alter SQLDataSource programatically RRS feed

  • Question

  • User539757411 posted


    I have a Listview for ads with a SQLDataSource on the MasterPage, the MasterSQLDataSource.

    On the Default page there is a list of the states in linkbuttons.
    When the user clicks on a state it passes a parameter as : http://www.mysite.com/state=CA 

    So the other SQLDataSource, the StateSQLDataSource, has a Querystring parameter requesting the STATE to show the ads from that STATE.
    The difference between the 2 SQLDataSources is that the StatesSQLDataSource has a state_id column.

    How could i change the SQLDataSource programatically and if posible, add the row State_Id on a listview in case its a StateSQLDataSource ? 

    Friday, July 8, 2011 11:08 AM