[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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