I'm new and this is what make me come to this forum here. I try to update a dataset, which contains data from multiple tables join together. I read that I will not be able to update this unless I create different data adapters for different table. I also need to add all related table to the dataset.
Question: When I make a change to my gridview, how do I update that change to the right table in the dataset and from there update it to the database?
I'm using visual studio 8 and work with sql server.
Any help is appreciated.
strSql = "select qc.polinesID, products.product_id, polines.item, description, polines.quantity, customerrequest, qcNote, qc.droptest, dropship, "
strSql &= "cusresponse from qc inner join polines on qc.polinesId=polines.polinesID join po on "
strSql &= "polines.poid=po.id left outer join products on polines.item=products.item where po.id= " & posql.poID