update a progressbar on update a mssql table

[Robert Bravery]

Hi all,

I have a typed dataset. I update, and insert well over a hundred rows at a
time.
How can I indicate to the user, via progreesbar, of some sort of progress
of the update, as each row is updated to the server

Thanks
Robert

[sloan]

You need a progress bar for 100 rows?

Hmm.

Check out (if you using sql server at the back end db)

http://support.microsoft.com/kb/315968

especially if you have a strong dataset, (and .GetXml() at your disposal.

see
http://groups.google.com/group/micro...0893522ad8c365

if you're using 2005 , i'd switch OPENXML for

http://www.sommarskog.se/arrays-in-sql-2005.html
(find these lines)
Inserting Many Rows
I said that where XML is really good is when you need to insert many rows.
So how would you do that? In fact you have already seen the basics. You use
nodes and value. Here is an example where I unpack a document with orders
and order details:


"Robert Bravery" <[e-mail] in message
news:OS****************@TK2MSFTNGP04.phx.gbl...

Hi all,

I have a typed dataset. I update, and insert well over a hundred rows at a
time.
How can I indicate to the user, via progreesbar, of some sort of progress
of the update, as each row is updated to the server

Thanks
Robert

[Robert Bravery]

HI,

THanks
Well its testing phase first, But I suspect that this routine will
eventually, I know its not that big, be translating 5000-10000 rows at a
time.
Robert

BTW, in order to speed test this little app. On a 2.4 core 2 duo, 2 gig ram.
What kind of throuput should I be looking at.
I have no idea as to what is fast or what is slow, when it comes to dataset
updates etc
"sloan" <sl***@ipass.netwrote in message
news:uq****************@TK2MSFTNGP05.phx.gbl...

>
You need a progress bar for 100 rows?

Hmm.

Check out (if you using sql server at the back end db)

http://support.microsoft.com/kb/315968

especially if you have a strong dataset, (and .GetXml() at your disposal.

see
http://groups.google.com/group/micro...0893522ad8c365

if you're using 2005 , i'd switch OPENXML for

http://www.sommarskog.se/arrays-in-sql-2005.html
(find these lines)
Inserting Many Rows
I said that where XML is really good is when you need to insert many rows.
So how would you do that? In fact you have already seen the basics. You
use
nodes and value. Here is an example where I unpack a document with orders
and order details:


"Robert Bravery" <[e-mail] in message
news:OS****************@TK2MSFTNGP04.phx.gbl...

>Hi all,

I have a typed dataset. I update, and insert well over a hundred rows at
a
time.
How can I indicate to the user, via progreesbar, of some sort of
progress
of the update, as each row is updated to the server

Thanks
Robert