Setting Parameter fields dynamically for a SqlDataSource

Question

I need to fill in the "SelectParameters" dynamically , but all I found on Google , was using fixed parameters.

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="XX"
                            OnSelecting="SqlDataSource2_Selecting" SelectCommand="">
                            <SelectParameters>
                            </SelectParameters>
                        </asp:SqlDataSource>

Is there any solutions ?

I also tried to use the "OnSelecting" event , but I can't assign value to parameters that are not present.

 protected void SqlDataSource2_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        string[] queryFields = new string[] { ... }; // some dynamic field depends on different table

        foreach (string s in queryFields)
        {
            e.Command.Parameters["@" + s].Value = "filter";
        }

    }

Do you want to set the values of the parameters dynamic or the variables and value? — Arion
– Arion, Commented Apr 16, 2012 at 10:28
@Arion only the parameter fields , I know how to set values but failed when the parameter was not present (I just updated my question) — daisy
– daisy, Commented Apr 16, 2012 at 10:29

Arion · Accepted Answer · 2012-04-16 10:33:34Z

2

You can in code behind set the variables like this:

SqlDataSource1.SelectParameters.Add("parameterName", "parameterValue");

But be aware that you need the clear the parameters before adding them. Because otherwise you will end up with duplicates of parameters.

answered Apr 16, 2012 at 10:33

Arion

31.3k10 gold badges74 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex · Accepted Answer · 2014-09-07 12:45:49Z

-1

If you're ok with setting the connection string when initializing the control you can do so on the control's init event like this:

protected void SqlDataSource1_Init(object sender, EventArgs e)
{
     SqlDataSource1.ConnectionString = <whatever code you want here>;
     SqlDataSource1.ProviderName = <whatever code you want here>;
}

This is still dynamic in the sense that you determine the connection properties at runtime, not design time. This helped me avoid having to resort to web.xml transformations and switch between QA and PROD connection strings based on an environment variable specifying QA/PROD environment.

answered Sep 7, 2014 at 12:45

Alex

9,44912 gold badges75 silver badges84 bronze badges

Collectives™ on Stack Overflow

Setting Parameter fields dynamically for a SqlDataSource

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related