how to update database directly with datagridview
I am having with datagridview. Actually i would like to explain in detail
In Form1 i am having Datagridview with columns Bill_No, Product_Description, Quantity, Rate, Amount(5 Columns) I am not binding with database to populate the datagridview.
My problem is that when the user insert into datagridview and When the form is closed before that my database should be updated with the each every cell so entered in their respective column in database.
Secondly ,I am having three textbox costtxt, profittxt, sptxt
For example when in costtxt the value is 2000 and in profittxt its 20% then in textbox sptxt it must display the value of 2400 i.e [2000+400(20% of 2000)]
Can anybody solve my problem?