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]]

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


fd> I need to change the CommandText query on the fly and then rebind to
fd> the control in question.
fd>
fd> Any help is appreciated.
fd>
fd> Thanks...
fd>

 

[forest demon]

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

fd> I need to change the CommandText query on the fly and then rebind to
fd> the control in question.
fd>
fd> Any help is appreciated.
fd>
fd> Thanks...
fd>

i apologize, i should have posted more info. in the designer, i create
a datasource and dataset/datatable, i attach
to a control and all works as expected. so far, all of this has been
done w/o any code behind. then, during runtime,
i need to change the query and rebind, but i can't find out how to
access the commandtext property.

thanks Michael...