Hello Rajesh,

Thank you for your patience.

The issue is caused because of the serialization and de-serialization of returned objects. Serialization converts .net objects to XML format and when the data length exceed the limit of serialization, error is thrown. Basically our WebDataGrid has a limitation and he could not handle more than 1000 rows and 12 columns. I have used the configuration below in order to achieve this result.

Web.config:

....

<httpRuntime maxRequestLength="2147483647" />
  <system.webServer>
    <security>
      <requestFiltering>
        <requestLimits maxAllowedContentLength="4294967295"></requestLimits>
      </requestFiltering>
    </security>
  </system.webServer>
  <system.web.extensions>
    <scripting>
      <webServices>
        <jsonSerialization maxJsonLength="2147483647"></jsonSerialization>
      </webServices>
    </scripting>
  </system.web.extensions>
</configuration>

My suggestions are to follow different approaches when it comes to commit this amount of data at once:

- reduce the portions of data not to be saved at once.

- performed the data operations on the server directly (have a look at the attached sample from my previous reply).

- use our Ignite UI igGrid widget, which is client based component. Have a look at the articles below for more information: