GridView SelectParameter s

[Mike P]

I am using a GridView with 3 SelectParameter s 2 of which are
ControlParamete rs, but the third of my SelectParameter values is derived
through my code rather than a QueryString, Control etc, so I need to add
my select parameters programmaticall y.

Here are my 2 ControlParamete rs are they were originally :

<SelectParamete rs>
<asp:ControlPar ameter Name="Month"
ControlID="ddlM onth" PropertyName="S electedValue" />
<asp:ControlPar ameter Name="Year" ControlID="ddlY ear"
PropertyName="S electedValue" />
</SelectParameter s>

And here are all 3 of my parameters declared within my Page_Load instead
:

SqlDataSource1. SelectParameter s.Add("UserKey" , TypeCode.Int32,
UserKey.ToStrin g());
SqlDataSource1. SelectParameter s.Add("Month", TypeCode.String ,
ddlMonth.Select edValue);
SqlDataSource1. SelectParameter s.Add("Year", TypeCode.String ,
ddlYear.Selecte dValue);
Is this the right way to do this programmaticall y?


*** Sent via Developersdex http://www.developersdex.com ***

[Brock Allen]

You don't need to manually add the ones that you've already done declaratively
(that's the point of the declarative model). For the 3rd parameter that you
must add dynamically, you can do it either in Page_Load or you can do it
in one of the Data Source Control's pre-processing events, like Selecting,
Updating, Inserting or Deleting.

-Brock
http://staff.develop.com/ballen

I am using a GridView with 3 SelectParameter s 2 of which are
ControlParamete rs, but the third of my SelectParameter values is
derived through my code rather than a QueryString, Control etc, so I
need to add my select parameters programmaticall y.

Here are my 2 ControlParamete rs are they were originally :

<SelectParamete rs>
<asp:ControlPar ameter Name="Month"
ControlID="ddlM onth" PropertyName="S electedValue" />
<asp:ControlPar ameter Name="Year"
ControlID="ddlY ear"
PropertyName="S electedValue" />
</SelectParameter s>
And here are all 3 of my parameters declared within my Page_Load
instead :

SqlDataSource1. SelectParameter s.Add("UserKey" , TypeCode.Int32,
UserKey.ToStrin g());
SqlDataSource1. SelectParameter s.Add("Month", TypeCode.String ,
ddlMonth.Select edValue);
SqlDataSource1. SelectParameter s.Add("Year", TypeCode.String ,
ddlYear.Selecte dValue);
Is this the right way to do this programmaticall y?

*** Sent via Developersdex http://www.developersdex.com ***