How can I change the CommandText in a DataSet/TableAdapter atruntime.

[forest demon]

I need to change the CommandText query on the fly and then rebind to
the control in question.

Any help is appreciated.

Thanks...

[Michael Nemtsev [MVP]]

Re: How can I change the CommandText in a DataSet/TableAdapter at runtime.

Hello forest,

so, what are the problems?
CommandText has the setter and nothing stops your to change this property,
as I understand

---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo


fdI need to change the CommandText query on the fly and then rebind to
fdthe control in question.
fd>
fdAny help is appreciated.
fd>
fdThanks...
fd>