Set <SelectParameters> To Constant Values

[MikeB]

Hello All, how can I set my selectparameter to a constant value within my
constants class or to a value in my web.config file?

[=?Utf-8?B?TWlsb3N6IFNrYWxlY2tpIFtNQ0FEXQ==?=]

Howdy,

I guess meant data source controls (sqldatasource, objectdatasource etc)

1. First way in Web config:

<configuration>
<appSettings>
<add key="Parameter1DefaultValue" value="5"/>
</appSettings>
<system.web>
... everything else...
</system.web>
<configuration>

aspx page:
<asp:ObjectDataSource runat="server" ID="ds" SelectMethod="MethodName"
TypeName="ClassName" >
<SelectParameters>
<asp:Parameter Name="parameter1" Type="Int32" DefaultValue="<%$
AppSettings:Parameter1DefaultValue %>" />
</SelectParameters>
</asp:ObjectDataSource>
2. second apprach, contants class (set value programatically)

<asp:ObjectDataSource runat="server" ID="ds" SelectMethod="MethodName"
TypeName="ClassName" OnSelecting="ds_Selecting" >
<SelectParameters>
<asp:Parameter Name="parameter1" Type="Int32"/>
</SelectParameters>
</asp:ObjectDataSource>

protected void ds_Selecting(object sender,
ObjectDataSourceSelectingEventArgs e)
{
e.InputParameters["parameter1"] = 5; // use your contants here
}
Hope this helps
--
Milosz
"MikeB" wrote:

Hello All, how can I set my selectparameter to a constant value within my
constants class or to a value in my web.config file?

[MikeB]

Yes, you are correct, that is what I meant, sorry for not being clear.
Also, that is exactly what I was looking for. Thank you very much.
"Milosz Skalecki [MCAD]" <mi*****@DONTLIKESPAMwp.plwrote in message
news:08**********************************@microsof t.com...

Howdy,

I guess meant data source controls (sqldatasource, objectdatasource etc)

1. First way in Web config:

<configuration>
<appSettings>
<add key="Parameter1DefaultValue" value="5"/>
</appSettings>
<system.web>
... everything else...
</system.web>
<configuration>

aspx page:
<asp:ObjectDataSource runat="server" ID="ds" SelectMethod="MethodName"
TypeName="ClassName" >
<SelectParameters>
<asp:Parameter Name="parameter1" Type="Int32" DefaultValue="<%$
AppSettings:Parameter1DefaultValue %>" />
</SelectParameters>
</asp:ObjectDataSource>
2. second apprach, contants class (set value programatically)

<asp:ObjectDataSource runat="server" ID="ds" SelectMethod="MethodName"
TypeName="ClassName" OnSelecting="ds_Selecting" >
<SelectParameters>
<asp:Parameter Name="parameter1" Type="Int32"/>
</SelectParameters>
</asp:ObjectDataSource>

protected void ds_Selecting(object sender,
ObjectDataSourceSelectingEventArgs e)
{
e.InputParameters["parameter1"] = 5; // use your contants here
}
Hope this helps
--
Milosz
"MikeB" wrote:

>Hello All, how can I set my selectparameter to a constant value within my
constants class or to a value in my web.config file?