Too many Updates to do

Hello. I'd want to know how does a .net application work when we have to do too many updates, I want to say for example 1000 updates on a file at the same time.

For only one update, if I'm rigth, we send to a procedure:

the connection and the sql statement I want.

The procedure, open the connection, execute the sql statement and close the connection.

But, If I have 1000 updates to do at the same time ? I can't open and close the connection for each update ? It's not logic, I guess...

Could anyone tell me how can I do that ?

Thanks....
[661 byte] By [NetPochi] at [2007-12-26]
# 1

SQL batch updates, stored procedures or calling a single sql string at a time:

Connextion.Open

For each s in MySqlStrings

MyCommand.text = s

MyCommand.executeNonQuery

Next

Connection.close

DMan1 at 2007-9-4 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...
# 2

Thanks.

Another question, please:

If I have 10000 updates to do. Must I set something special ? I say that because la connection is opened much time.

thanks...

NetPochi at 2007-9-4 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...
# 3
What database are you using?
DMan1 at 2007-9-4 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...
# 4

Pervasive....

thanks...

NetPochi at 2007-9-4 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

.NET Development

Site Classified