Hi all visitors
i have created 2 tables (SaleHeader,SaleDetail) in sql server 2005.
SaleHeader is the master and SaleDetail is the Detail(show data in datagrid).
in SaleHeader(Shcode,custcode,empcode,discount,amount),SaleDetail(code,Shcode,Itemcode
,qty,discount,Amount)
i created datasource that connect to these tables. then i drop SaleHeaderDatasource to my form as Detail(and it will show all texbox that link to each field in table SaleHeader) and SaleDetail on the form as DataGridView( and it will show all fields that link to each field in table SaleDetail).but in the DataGridView(get from Table SaleDetail), i just want to show ItemCode,ItemName,Qty,Discount,Amount and for code field will automatic created.
How can i show Itemcode,ItemName,Qty,Discount,Amount in DataGridView and can save to Table SaleDetail?
Best Regards,