What is The Best Method To Use Update SQL Databaes

See more:

C#

I Have One Table call ,SALES_INVO_MAIN
I Have Another Table CAll , SALES_INVO_SUB

This Main Table Should contain Invo_No as primary key
And Another Details Like Invoice Total Invoice Discount etc.

SUB Table Should Contain like Item Code/ Quantity / Sale Price And Should Also Multiple Records (More Than One Items )

Both table Link With Inov_No

sub table data getting for a datagridview

what is the best method to update the database..?

Thank You