SqlCeDataAdapte r Commands

[Ghost]

Hello.
I have such question:

I want to create SqlCeDataAdapte r object at runtime...

I'm writing:
SqlCeDataAdapte r dataAdapter = new SqlCeDataAdapte r();

then I specify Select Command:
dataAdapter.Sel ectCommand = new SqlCeCommand("S ELECT * FROM Supplier",
sqlCeConnection );

I want specify other commands too, such as Insert, Update and Delete
commands, but they are too large for inserting it into my code manualy, when
I'm working not in Compact Framework I can just drag the DataAdapter
component to my form and allow it while its configuration to generate these
commands automaticaly, so I can Update my datasets and not only view them.
Is there any method to generate SqlCeDataAdapte r commands automaticaly at
runtime and don't insert them to my code manualy?
If its poseble PLEASE show me some example or demo.