Trying to upload excel file size 2 MB, when rows are more than 10000 then reading only 6000 rows and remaining rows are not added.

Question

I am using Asp.net, using FileUpload control trying to read excel file and converting them into StringWriter.

IF StringWriter data is processed directly in SQL query I can see all the rows are available but when I run through interface then I can see only limited rows are considered in the dataset.

Looks strange to me. Any idea.

Answer 1

asp.net design
   <asp:Label ID="Label9" runat="server" Text="File Name"></asp:Label>
                        <asp:FileUpload ID="xlsUpload" runat="server" Width="300px" />
                        <asp:Button ID="btnUpload" runat="server" class="btn btn-success" Width="80px" Text="Upload"/>

CODE

 	    dt = xlsInsert(uploadedFile, "Sheet1")
                        dt.TableName = "BULKUPLOAD"

                        Dim sw As New StringWriter()
                        dt.WriteXml(sw, XmlWriteMode.IgnoreSchema)

                        ViewState("XMLDATA") = ""
                        ViewState("XMLDATA") = sw.ToString()

 dbConn.sqlCmd.Parameters.AddWithValue("@P_XmlData", ViewState("XMLDATA"))
  ds = dbConn.XcuteResult(str, CommandType.StoredProcedure, "SP_Name")