Hi
If your SqlDataAdapter select command is a mutiple table query (ie retrieving meaningful text for a ID field) is there anyway of still using the SqlCommandBuilder class to generate your DB update statements. I thought specifying the table filling the dataset would achieve this, ie
daSuppliers.Fill(dsSuppliers, "Supplier")
but it seems not. I still get the error 'Dynamic sql not supported against multiple base tables.
Cheers