Selecting Event in ASP.NET 2.0 fires too late to set parameters.

[PugOne]

It appears that in Beta 2 of ASP.NET 2.0 the Selecting event is too late to
set parameters on the datasource. Apparently the command has already been
created. This is not consistent with the documentation. Is this a bug that
will be fixed or are the documents wrong?

Jim

 

[Brock Allen]

Seems to work for me:

protected void _authorDS_Selecting(object sender, SqlDataSourceSelectingEventArgs
e)
{
System.Data.Common.DbParameter p = e.Command.CreateParameter();
p.ParameterName = "foo";
p.Value = "bar";
e.Command.Parameters.Add(p);
}

 

[PugOne]

Ahh. Just enough clues in your snipit for me to find my mental laps. I was
manipulating the datasources parameter collection. Did not realize that the
command was in the event args. (can't wait for more complete documentation!)
Manipulating parameters on that command object works fine as you stated.
That's good news because it really is the logical place to manipulate
parameters. I like to fine logical events that occur as late as possible to
avoid unwanted side effects.

Thanks for your help!

Jim