 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / Windows Forms / WinForm General / February 2006reading components form in vb net
hello everyone, i have a simple form in which there are 1 sqlconnection, some sqldataadapter and 1 dataset. During runtime i want to read all sqldataadapter to change all SqlSelectCommand because my table defined at designtime is "TABLE", but in runtime is "TABLE1" or "TABLE2", depending of a variable. Is it possible to do this? Thanks, Roberto Roby, Unless you add all your dataadapters in a collection there us no way to iterate them (at least not one that I know). SqlDataAdapter is a componet. Some disposable components are implemented to go in the components collection when added in design time, but SqlDataAdapter is not one of them. The solution is really easy just keep a collection and when you create dataadapter (or in the form constructor if you add them in design time) add all the dataadapters to this collection. If you destroy some of them don't forget to remove it from there.  SignatureHTH Stoitcho Goutsev (100) > hello everyone, > i have a simple form in which there are 1 sqlconnection, some [quoted text clipped - 7 lines] > > Roberto thank you very much Stoicho, your answer was very complete. I will follow what you said, Bye! Roberto Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.