ADD two List view ex; listvew1, listview2 to SQL two tables

Question

Hello Friends,

 

I need solution for inserting records in two tables from two listview by single click, but from same form which already having many controls of C#:

 

In these tables I want to add all items from List views by checking empty listview.

 

for example I have one form called "frmInvoice" in this I have  two ListView- Listview1, listview2. and also form having control like BillNo, customerName etc.

 

Now when I click save button, I want to insert all information from "frminvoice" and "listviews" into two tables like table1, table2.

 

if listview1 havinh 5 items, and listview2 having 10 items, then "for each item of list-views" should inserted  BillNo and CustomerName also into tables separately for later joining of tables.

 

table1=listview1, table2=listview2.

 

Regards