Sorry if this has been discussed, I am not really sure what search terms would target the topic.
I need to create update commands for arbitrary (and unknown at design time) tables. I am creating a SQLDataAdapter for the job, and I just create parameter names for the insert command by using the column names. The problem is that I need to provide a column data type. I looked at using the column data type of the dataset, but that is a System.type and I need the actual SQLDataType. I could write a select statement to map the types, but I feel like I am missing something obvious. I have not been working with DataSets for a long time and I suspect that I am making this more difficult than it should be. Can someone please point in the right direction? Either a quick example, or even just a reference to an article or posting would do the trick. As I said, I feel am just forgetting something basic. Thanks!
