Hi I have a gridview showing me a data from two tables using an inner join.
Problem is how do I update and insert into both
There are 3 tables
Products (ProductID, Desc)
ProductImageMap (MapID, ProductID, ImageID, DisplayOrder)
ProductImages (ImageID, Image)
When you open a product it then opens a inner join of the ProductImageMap and ProductImages by the productID
I want to be able to add insert delete and delete from the datatable but cannot work out how to do this using a tableadapter or any other way for that matter.
I know I need to save the ProductImage table first to get the ImageID and then use the ImageID to insert the productimagemap but where do I start and is there an easy way of doing this?