ansaurus

Question

What is the recommended approach for Bulk Insert/Update in ASP.NET Gridview?

Answer 1

+1 A:

Have you considered not using the ASP.Net GridView in favor of a purely client side grid control (i.e. a JQuery plugin control)? What I would suggest you consider is to perhaps use client side JSON or an XML data island as the data source, to store all the changes the user is making and then once they hit the main submit button send this payload to the server and handle all the database updates in a single batch or round trip.

The downside to this is that it is going to probably be quite a bit more work that just a ASP.Net GridView. Also you'll have to build in/incorporate an optimistic concurrency data model. Once it's all done you'll have a really fast and slick interface since most of the actions will occur client side without all the post backs. I built something like this several years back and it turned out great.

Sorry I cannot provide more, but below is a very rough skeleton of how it would work. I hope this helps.

<html>
    <head>
     <SCRIPT LANGUAGE="javascript">
     var xmlDomItems;

     function initialize()
     {
         xmlDomItems = document.all("itemsXML").XMLDocument;
         docProds.async = false;
     }

     function ModifyXMLDOM()
     {
       // just work with the xmlDomItems variable just like you would with an .Net XMLDocument Object.
     }

     function SumbitChangePayload()
     {
       // submit xmlDomItems.OuterXML to some AJAX or web service endpoint in an async manner.
     }
     </SCRIPT>
    </head>
    <body onload="initialize()">

     <XML id="itemsXML">
      <Items>
      <%
      // Server side code to render XML inner contents here...

      %>
      </Items>
     </XML>
     <form>
      <!-- build your UI here -->

      <input type="button" onclick="SumbitChangePayload()" value="Submit" />
     </form>
    </body>
</html>

James 2009-02-27 16:49:20

Good alternative to try out. If you have any pointers to this please do post it.

rajesh pillai 2009-02-27 17:06:28

See my last edit.

James 2009-02-27 18:09:42

Answer 2

+3 A:

Take a look at this article on Code Project.

UPDATE:
I found a better implementation of the same kind of control here.

Enrico Campidoglio 2009-04-24 11:57:35

ansaurus

tags:

views:

answers:

What is the recommended approach for Bulk Insert/Update in ASP.NET Gridview?

related questions