Changing Table Adapter select command.

If i create the dataset using data designer, the table adapters are also created. But , i am not able to change the sql command of that table adapter at design time in my code

A workaround that i have found out is that i create a new untyped table adapter and a new untyped sql command in my code with the new command text that i want and attach this command to this new table adapter.

Is this the only way? Does .NET not allow the changing of SQL data adapter commands programmatically? I have ensured that the modifier property of the table adapter is public.