Hi all visitors
i have 1 table(salesdetail) in sql server 2008
in this table, i have 3 fields(code,itemcode,qty)
in vb.net, i create one form and drop DataGridView on that form
i also set 5 columns on DataGridView(Itemcode,IteamName,Qty,price,Total)
i user sql statement like this ("select itemcode,itemanem,price from item where itemcode=' & txtitemcode.text & "'"")
i use this query to display the item information to my gridview.
when i input 3 items on gridview, i want to save all item in gridView to my table(salesorder)
Note
i want to save only code,itemcode,qty to my salesdetail, for itemname,price,total use for display only.
Please help me how i can save data from gridView to my table?
Best Regards,
TONY