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!

 

[Guest]

You could do it all programatically, set the SQLDataSource.SelectCommand
property and use the SQLDataSource.SelectParameter.Add() method to add the
parameter. Alternativley you could use the SQLDataSource.FilterExpression
and the SQLDataSource.FilterParameters properties to filter the data after
the fact.

 

[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(object sender, EventArgs e)
{
// do page load stuff
SetQueryDefaults();
}

private void SetQueryDefaults()
{
MySqlDataSource.SelectParameters["ParameterName"].DefaultValue =
MyValue.ToString()
}

 

[Kees de Winter]

That was it! Thanks!!

--
Kees de Winter

You could do it all programatically, set the SQLDataSource.SelectCommand
property and use the SQLDataSource.SelectParameter.Add() method to add the
parameter. Alternativley you could use the SQLDataSource.FilterExpression
and the SQLDataSource.FilterParameters properties to filter the data after
the fact.