A
Asaf
Hi,
I have let's say, about 10,000 rows in a DataTable.
I am looping with foreach on each row and need to update each and every row
with new data.
After updating, for each row I am calling MySQLDataAdapter.Update(MyTable)
for the row to be updated to my DB.
* I know I can call one Update after updating all of the rows but I need to
update the DB for each row.
My question is, the way that I am calling Update for each row, is this right
way? or should I create a Connection object, open a connection to the DB,
update each row by SQLCommand and finally close the connection?
When using Update method, does for each call, SQLDataAdapter will open a new
connection to the server?
Thanks in advanced for any advice,
Asaf
I have let's say, about 10,000 rows in a DataTable.
I am looping with foreach on each row and need to update each and every row
with new data.
After updating, for each row I am calling MySQLDataAdapter.Update(MyTable)
for the row to be updated to my DB.
* I know I can call one Update after updating all of the rows but I need to
update the DB for each row.
My question is, the way that I am calling Update for each row, is this right
way? or should I create a Connection object, open a connection to the DB,
update each row by SQLCommand and finally close the connection?
When using Update method, does for each call, SQLDataAdapter will open a new
connection to the server?
Thanks in advanced for any advice,
Asaf