I have an application wherein i am creating data entry forms dynamically and then insert the data back to the table.
The problem is that when i do an insert, i have to create an insert query at runtime.
Can u give me suggestions about what feature in ado.net allows me to build an INSERT query without knowing the names of the columns or the number of the columns beforehand.

Do you know the names of the tables? Usually when you deal with a dataset, you get the names of the columns in a collection. You should be able to build queries with that. However, I imagine you will have to do a lot of checking to determine if certain fields can be populated (i.e. Identity columns can't be populated.)

Peter

im not sure about ur question but i guess u r insering diffrent fields in diffrent times! I mean insert do not insert fix number or type of fields! In that case use SP & send parameters to that, & then manage it in ur SP.

Always:),
Hovik Melkomian.

You can use the CommandBuilder object provided by any of the Managed Provider( SQL, OLEDB or ODBC).Just set the CommandBuilder object to track the DataAdapter object.Then update your DataSet through DataAdapter.SQL commands will be automatically generated by the CommandBuilder.

Read more in MSDN by searching "Automatically Generated Commands"

Hope it helps you !!!