Hi all visitors
i have 2 tables in sql server 2005.they are SaleHeader and SaleDetail
SaleHeader(shcode,custcode,empcode,saledate,amount)
saledetail(sdcode,shcode,itemcode,qty,discount).
i created dataset (in vb.net) to that tables and for SaleHeader, i choose Detail(not Grid) to show on the form and i also define the custcode and empcode to table customer and employee.and it can save to the SaleHeader.
---The problem is in SaleDetail--------
For the SaleDetail, i choose Grid (in vb.net). but when i drop it to the form(the form above), it show all(sdcode,shcode,itemcode,qty,discount).I dont want to show (sdcode,shcode) in that grid.How can i do that?
and How can i save sdcode and shcode to table SaleDetail?
Best Regards,