How to access parameters of SqlDataSource

[Kees de Winter]

Hi,

I am trying to set a parameter in the SELECT statement of a SqlDataSource,
in the Page_Load event where the intended value for the parameter is
calculated. But how can I set the parameter to a certain value? If the value
comes from a control, form, querystring etc. then it's easily done
declaratively. But how to do it in code.

Have tried for hours. I will be grateful for all help!
--
Kees de Winter

[clickon]

You could do it all programatically , set the SQLDataSource.S electCommand
property and use the SQLDataSource.S electParameter. Add() method to add the
parameter. Alternativley you could use the SQLDataSource.F ilterExpression
and the SQLDataSource.F ilterParameters properties to filter the data after
the fact.

"Kees de Winter" wrote:

Hi,

I am trying to set a parameter in the SELECT statement of a SqlDataSource,
in the Page_Load event where the intended value for the parameter is
calculated. But how can I set the parameter to a certain value? If the value
comes from a control, form, querystring etc. then it's easily done
declaratively. But how to do it in code.

Have tried for hours. I will be grateful for all help!
--
Kees de Winter

[Flinky Wisty Pomm]

If you want to provide a default value for your parameter, and the
param is defined in the aspx file, just do.

protected void Page_Load(objec t sender, EventArgs e)
{
// do page load stuff
SetQueryDefault s();
}

private void SetQueryDefault s()
{
MySqlDataSource .SelectParamete rs["ParameterN ame"].DefaultValue =
MyValue.ToStrin g()
}

[Kees de Winter]

That was it! Thanks!!

--
Kees de Winter
"clickon" <cl*****@discus sions.microsoft .com> wrote in message
news:C7******** *************** ***********@mic rosoft.com...

You could do it all programatically , set the SQLDataSource.S electCommand
property and use the SQLDataSource.S electParameter. Add() method to add the
parameter. Alternativley you could use the SQLDataSource.F ilterExpression and the SQLDataSource.F ilterParameters properties to filter the data after
the fact.

"Kees de Winter" wrote:

Hi,

I am trying to set a parameter in the SELECT statement of a SqlDataSource, in the Page_Load event where the intended value for the parameter is
calculated. But how can I set the parameter to a certain value? If the value comes from a control, form, querystring etc. then it's easily done
declaratively. But how to do it in code.

Have tried for hours. I will be grateful for all help!
--
Kees de Winter