dataset schema and binding

[alanchinese]

i have made my user control containing textboxes and bind them into a dataset.

one suggests i should fill the dataset with query "select xx, yy, zz from 1 = 0"

to obtain the dataset schema dynamically.

however, the NewRow of the dataset table only provides me the column names, but all with type System.DBNull

is there an express method to initialize the new row other than putting default values of each control maually?

[PlausiblyDamp]

The DataAdapter class (and it's sub-classes) provide a FillSchema method, have you tried that? Edited November 8, 2005 by PlausiblyDamp