If we move the DataAdapter.update...) how will that affect the performance

[Tony Johansson]

Hello!

We have an application where we pass all the SQLQuery to another class
module where it is executed.
When we have a DataGridView and some changes is done we want to save these
changes by using the DataAdapter.Update
functionallity.
We still want to keep all the data access in the separate class module.
If we now pass the DataAdapter and the DataSet to the class module
so in this class module we can do
passedDataAdapter.Update(passedDataSet.Tables[0])

When we pass the DataAdapter and the DataSet will this be a great overhead
on the performance.

//Tony

 

[Jesse Houwing]

Hello Tony,

Hello!

We have an application where we pass all the SQLQuery to another class
module where it is executed.
When we have a DataGridView and some changes is done we want to save
these
changes by using the DataAdapter.Update
functionallity.
We still want to keep all the data access in the separate class
module.
If we now pass the DataAdapter and the DataSet to the class module
so in this class module we can do
passedDataAdapter.Update(passedDataSet.Tables[0])
When we pass the DataAdapter and the DataSet will this be a great
overhead on the performance.

Why would you expect a great performance overhead? It should be fine.