Save DataGridView changes in 3 layer application design

See more:

DataTable

hello everybody

at first let me to excuse for my bad english.

i try to convey my problem clearly.

my application suppose to connect to a MS Access database.

First layer: consist of property related to my table fields

Second layer: a function return requested rows as DataTable of same table

Third layer: after getting DataTable from second layer, return that as DataTable of same table.

Finally in Presentation layer I put DataTable in a BindingSource and assign it to DataGridView.DataSource.

Ok, I can see the requested rows correctly so far but, how can I save all changes which has made by user in DataGridView?

***************************

1: Is it correct to create a loop to Update each row separetly?

2: Or I must send all changes as DataTable to database?

Main problem:

for the first solution I know that how should I do it but for second I can't find any way to do it because I don't know how I can send DataTable to database through 3 layer.

if my question is vague, please tell me