Updating a dataset filled by a join query 1

[hitechboy78737]

I have a dataset that was filled from a join query that contains several tables.

I read somewhere that you cant use the .update command to update the underlying data if it consists of this type of query...

of course, I can't find where I THOUGHT I read this, so maybe I was hallucinating...

thanks!
Kevin Howell
Briefcase of Talent
Austin, Texas

 

[ashishraj14]

I am looking for it too. Having trouble updating dataset filled by a join query.

 

[PankajBanga]

You'll have to supply your own updating logic. Neither the CommandBuilder nor the Data Adapter configuration wizard will be of much help with the actual join query.

Or try using multiple DataTable objects and a DataRelation to stimulate the results of a join query. This way CommandBuilder and DataAdapter configuration wizard can generate an appropriate updating logic for you, as data in each DataTable will correspond to a single table in your database.

 

[Bruce1965]

I tend to agree with PankajBanja.

I don't know if this is true, but I understand that you can not update a single table when a join query is used. Therefore an alternative method must be used.