• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

Batch update in c#

Hi

I am working in ASP.net 3.5 using C#

How do we do batch update in ASP.net

I have sql strored, where I need to pass parameters and then sql stored proc do it job fine

Please guide me how do I do batch update in C#

Thanks
0
tia_kamakshi
Asked:
tia_kamakshi
  • 2
1 Solution
 
lenordisteCommented:
if you're using ADO.NET 2.0 you can set the UpdateBatchSize of your SqlAdapter to set the number of items to update at the same time. Here is the msdn ressource about this with a simple example:
http://msdn.microsoft.com/en-us/library/kbbwt18a(VS.80).aspx
0
 
gemailjCommented:
Batch Updates in ADO.NET 2.0 for Improved Performance
http://davidhayden.com/blog/dave/archive/2006/01/05/2665.aspx
0
 
lenordisteCommented:
above post is refering to the exact same material, only a different example of the same thing.
0
 
tia_kamakshiAuthor Commented:
Many Thanks for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now