R Random Dec 30, 2004 #1 Can a DataSet be used to update a database if the query that originally populated it had table and field alias names in it?
Can a DataSet be used to update a database if the query that originally populated it had table and field alias names in it?
W W.G. Ryan eMVP Dec 30, 2004 #2 Yes, the update command will need to match the alias - in general you can get around aliasing though by using COlumnMappings - which map the db column names to the names you're using in your dataset.
Yes, the update command will need to match the alias - in general you can get around aliasing though by using COlumnMappings - which map the db column names to the names you're using in your dataset.