Adding multiple update params sqldatasource

Question

This code is part of a SqlDataSource:

<UpdateParameters>
            <asp:Parameter Name="username" Type="String" />
            <asp:Parameter Name="first_name" Type="String" />
            <asp:Parameter Name="surname" Type="String" />     
   </UpdateParameters>

How can i code this so i can add multiple parameters, since i can only seem to add one at a time. I do not wish to place these update params in my .aspx file since i wish to seperate my database related items.

SqlDataSourceUsers.UpdateParameters.Add(parameter);

Thanks.

Hm nothing i suppose, i just dont like to see 8 times the same line. But it seems i have little choice on this mather. — Dajing
– Dajing, Commented May 5, 2011 at 13:29

Michael Arnell · Accepted Answer · 2011-05-05 13:49:25Z

1

You could place your params in a Dictionary (or list if using parameter objects) and then use a loop to add them...

var params = new Dictionary<string, string>
{
    {"param1", "value1"},
    {"param2", "value2"},
};

foreach(var param in params)
{
    SqlDataSourceUsers.UpdateParameters.Add(
        new SqlParameter(param.Key, param.Value)
    );
}

answered May 5, 2011 at 13:49

Michael Arnell

1,0381 gold badge9 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Adding multiple update params sqldatasource

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related