I have been reading your book and it's great! I had a question to ask you regarding the command collection of the automatically produced tableAdapters. Is there a way to modify their SQL command at run time because I want to give my users the flexibility of writing their own commands and at the same time I want to use the DataBinding features that .NET have provided.

For now, I have made the _commandCollection[] public so that I can modify them any time that I want, but I don't think that that is a good idea.

thanks,
Payam.