Setting ObjectDataSourc e Parameter Programmaticall y

[JJ]

How can I set an ObjectDataSourc e's Parameter programmaticall y?

The slight complication here is that I want to set this NOT in the
'Selecting' method of the ObjectDataSourc e, but elsewhere.

I was hoping I could do something like:

ObjectDataSourc e.SelectParamet ers("MyParam") = thisValue.

But clearly not. I've managed to add a parameter with a value, but I cannot
reset it (it just adds another one and adds a number to its name to make it
unique):

ObjectDataSourc e.SelectParamet ers.Add("MyPara m", thisValue) - works for one
itertion, but I need to set it to a new value each time.

I guess I could remove this each time and add the parameter again, but I
would have though there was a way I could change the value?

Thanks in advance,

JJ

[Lloyd Sheen]

"JJ" <ab*@xyz.comwro te in message
news:Ou******** ******@TK2MSFTN GP04.phx.gbl...

How can I set an ObjectDataSourc e's Parameter programmaticall y?

The slight complication here is that I want to set this NOT in the
'Selecting' method of the ObjectDataSourc e, but elsewhere.

I was hoping I could do something like:

ObjectDataSourc e.SelectParamet ers("MyParam") = thisValue.

But clearly not. I've managed to add a parameter with a value, but I
cannot reset it (it just adds another one and adds a number to its name to
make it unique):

ObjectDataSourc e.SelectParamet ers.Add("MyPara m", thisValue) - works for
one itertion, but I need to set it to a new value each time.

I guess I could remove this each time and add the parameter again, but I
would have though there was a way I could change the value?

Thanks in advance,

JJ

Instead of adding each time you can check the count of parameters. If it is
zero (not set) then add the parameter. Otherwise get the current parameter
from the SelectParameter s collection and reset the value of the "MyParam"
parameter.

Lloyd Sheen

[JJ]

Ah I see. Thanks,

JJ
"Lloyd Sheen" <[e-mail] in message
news:36******** *************** ***********@mic rosoft.com...

>
"JJ" <ab*@xyz.comwro te in message
news:Ou******** ******@TK2MSFTN GP04.phx.gbl...

>How can I set an ObjectDataSourc e's Parameter programmaticall y?

The slight complication here is that I want to set this NOT in the
'Selecting' method of the ObjectDataSourc e, but elsewhere.

I was hoping I could do something like:

ObjectDataSour ce.SelectParame ters("MyParam") = thisValue.

But clearly not. I've managed to add a parameter with a value, but I
cannot reset it (it just adds another one and adds a number to its name
to make it unique):

ObjectDataSour ce.SelectParame ters.Add("MyPar am", thisValue) - works for
one itertion, but I need to set it to a new value each time.

I guess I could remove this each time and add the parameter again, but I
would have though there was a way I could change the value?

Thanks in advance,

JJ

Instead of adding each time you can check the count of parameters. If it
is zero (not set) then add the parameter. Otherwise get the current
parameter from the SelectParameter s collection and reset the value of the
"MyParam" parameter.

Lloyd Sheen