Click here to Skip to main content
12,403,130 members (70,749 online)
   

ASP.NET

 
GeneralRe: related to itext sharp Pin
Member 97985416-Feb-13 18:08
memberMember 97985416-Feb-13 18:08 
Answerrelated to itext sharp-iText use for commercial purpose Pin
Abhishek Pant6-Feb-13 19:07
memberAbhishek Pant6-Feb-13 19:07 
AnswerRe: related to itext sharp Pin
Sandeep Mewara2-Feb-13 0:24
mvpSandeep Mewara2-Feb-13 0:24 
QuestionDisplay image using handler.ashx what wrong my code Pin
Michael511931-Jan-13 20:43
memberMichael511931-Jan-13 20:43 
AnswerRe: Display image using handler.ashx what wrong my code Pin
Richard Deeming1-Feb-13 2:17
memberRichard Deeming1-Feb-13 2:17 
GeneralRe: Display image using handler.ashx what wrong my code Pin
Michael51191-Feb-13 4:16
memberMichael51191-Feb-13 4:16 
GeneralRe: Display image using handler.ashx what wrong my code Pin
Richard Deeming1-Feb-13 5:36
memberRichard Deeming1-Feb-13 5:36 
GeneralRe: Display image using handler.ashx what wrong my code Pin
Michael51191-Feb-13 5:58
memberMichael51191-Feb-13 5:58 
GeneralRe: Display image using handler.ashx what wrong my code Pin
Michael51191-Feb-13 7:03
memberMichael51191-Feb-13 7:03 
GeneralRe: Display image using handler.ashx what wrong my code Pin
Richard Deeming1-Feb-13 8:12
memberRichard Deeming1-Feb-13 8:12 
GeneralRe: Display image using handler.ashx what wrong my code Pin
Michael51198-Feb-13 20:10
memberMichael51198-Feb-13 20:10 
GeneralRe: Display image using handler.ashx what wrong my code Pin
Richard Deeming11-Feb-13 1:29
memberRichard Deeming11-Feb-13 1:29 
QuestionImagesIn Gridview Pin
Member 941611331-Jan-13 20:13
memberMember 941611331-Jan-13 20:13 
QuestionImporting Excel into Gridview, doesn't import all rows Pin
Craist31-Jan-13 8:29
memberCraist31-Jan-13 8:29 
I am attempting to import an Excel Spreadsheet (2010, XLSX) to Gridview, then upload to MS SQL 2012 database. There are 30,000 rows in spread sheet approximately. When I run it locally it works just fine. When I put it live on the server it doesn't work properly.
 
When it is importing into the Gridview it stops at a particular row every time. The row is around 21,000. If I delete the top 10,000 rows from spreadsheet it still stops at that same row. So in other words it doesn't matter if I try 21,000 rows or 11,000 rows it stops at that same one. That tells me it isn't a size or time limit. If I delete the top 16,000 rows and the bottom 5,000 rows. It does go past that record. This tells me the next record doesn't have bad data.
 
So we know it isn't a size / time issue. We know it isn't corrupt data in the next row. We know the code runs fine locally, but not on server.
 
I have tried this using datasets and datatables and the results are the same.
 
Connection String:
 
string myPath1 = @""+Server.MapPath(".") + @"\"+TextBox3.Text;
string strConn = @"provider=microsoft.ace.oledb.12.0;extended properties=""excel    12.0;HDR=YES"";data source="+myPath1+"";
 

In web.config I have:
 
<httpRuntime maxRequestLength="72604736"/>
and
 
<requestLimits maxAllowedContentLength="72604736" />
 

GridView code:
 
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="True" >
</asp:GridView>
Code behind to fill GridView (DataTable)
 
    OleDbConnection myExcelConn = new OleDbConnection(strConn);
    OleDbCommand myExcellComm = new OleDbCommand();
    OleDbDataAdapter oda = new OleDbDataAdapter();
    DataTable myDT = new DataTable();
    myExcellComm.Connection = myExcelConn;
    myExcelConn.Open();
    myExcellComm.CommandText = query;
    oda.SelectCommand = myExcellComm;
    oda.Fill(myDT);
    myExcelConn.Close();
    GridView1.DataSource = myDT;
    GridView1.DataBind();
Code behind to fill GridView (DataSet) DataSet excelDataSet = new DataSet(); OleDbDataAdapter da = new OleDbDataAdapter(query, strConn);
 
    da.Fill(excelDataSet);
 
    GridView1.DataSource = excelDataSet;
    GridView1.DataBind();
Again doesn't matter if I use DataTable or DataSet it produces the same thing.
 
I have verified the spreadsheet that gets uploaded does contain all the data. I have tried using FTP instead of file upload and same results. I have downloaded the uploaded excel file and ran it locally and again it works just fine.
 
Using Visual Web Developer Express 2010 with all Service Packs and Updates in C# local machine - Vista Ultimate with all updates Web server - VPS Windows Server 2012 with all updates and MS SQL 2012 with all updates.
 
Does anyone have any idea and where I should look next to solve the problem?

AnswerRe: Importing Excel into Gridview, doesn't import all rows Pin
Craist31-Jan-13 9:22
memberCraist31-Jan-13 9:22 
QuestionWeb Pages Authentication Pin
Jassim Rahma30-Jan-13 21:22
memberJassim Rahma30-Jan-13 21:22 
AnswerRe: Web Pages Authentication Pin
Rahul Rajat Singh30-Jan-13 22:14
mvpRahul Rajat Singh30-Jan-13 22:14 
QuestionAuthentication with database MVC4 Pin
AghaKhan30-Jan-13 20:44
memberAghaKhan30-Jan-13 20:44 
QuestionAutocomplete List hides behind Grid's horizontal scrollbar Pin
Ponka_developer30-Jan-13 12:01
memberPonka_developer30-Jan-13 12:01 
AnswerRe: Autocomplete List hides behind Grid's horizontal scrollbar Pin
jkirkerx30-Jan-13 12:50
memberjkirkerx30-Jan-13 12:50 
QuestionMVC 4 & jquery Pin
Collin Jasnoch29-Jan-13 4:39
memberCollin Jasnoch29-Jan-13 4:39 
QuestionHow to create and get the user input in alert message in asp.net webservice Pin
Rocky2327-Jan-13 22:22
memberRocky2327-Jan-13 22:22 
AnswerRe: How to create and get the user input in alert message in asp.net webservice Pin
Sandeep Mewara27-Jan-13 23:28
mvpSandeep Mewara27-Jan-13 23:28 
AnswerRe: How to create and get the user input in alert message in asp.net webservice Pin
Ali Al Omairi(Abu AlHassan)28-Jan-13 3:41
memberAli Al Omairi(Abu AlHassan)28-Jan-13 3:41 
GeneralRe: How to create and get the user input in alert message in asp.net webservice Pin
Rocky2328-Jan-13 22:13
memberRocky2328-Jan-13 22:13 
GeneralRe: How to create and get the user input in alert message in asp.net webservice Pin
Ali Al Omairi(Abu AlHassan)28-Jan-13 22:54
memberAli Al Omairi(Abu AlHassan)28-Jan-13 22:54 
AnswerRe: How to create and get the user input in alert message in asp.net webservice Pin
jkirkerx30-Jan-13 12:52
memberjkirkerx30-Jan-13 12:52 
QuestionChange CSS dynamically using javaScript Pin
sonusharma6527-Jan-13 21:36
membersonusharma6527-Jan-13 21:36 
AnswerRe: Change CSS dynamically using javaScript Pin
Sandeep Mewara27-Jan-13 23:24
mvpSandeep Mewara27-Jan-13 23:24 
Questioncapture the signature from signature pad in Web App. Pin
premaa_36@yahoo.co.in27-Jan-13 20:40
memberpremaa_36@yahoo.co.in27-Jan-13 20:40 
AnswerRe: capture the signature from signature pad in Web App. Pin
Sandeep Mewara27-Jan-13 21:08
mvpSandeep Mewara27-Jan-13 21:08 
GeneralRe: capture the signature from signature pad in Web App. Pin
Abhishek Pant27-Jan-13 21:53
memberAbhishek Pant27-Jan-13 21:53 
Questionlogin object in asp.net Pin
Luqman Inam25-Jan-13 0:52
memberLuqman Inam25-Jan-13 0:52 
AnswerRe: login object in asp.net Pin
Sandeep Mewara25-Jan-13 5:03
mvpSandeep Mewara25-Jan-13 5:03 
AnswerRe: login object in asp.net Pin
Rahul Rajat Singh25-Jan-13 19:17
mvpRahul Rajat Singh25-Jan-13 19:17 
QuestionExperience with BootMetro? Pin
Marco Alessandro Bertschi24-Jan-13 23:06
memberMarco Alessandro Bertschi24-Jan-13 23:06 
AnswerRe: Experience with BootMetro? Pin
Abhishek Pant25-Jan-13 10:28
memberAbhishek Pant25-Jan-13 10:28 
Questionsignature capture from signature pad Pin
premaa_36@yahoo.co.in24-Jan-13 17:36
memberpremaa_36@yahoo.co.in24-Jan-13 17:36 
AnswerRe: signature capture from signature pad Pin
Sandeep Mewara25-Jan-13 5:03
mvpSandeep Mewara25-Jan-13 5:03 
AnswerRe: signature capture from signature pad Pin
Abhishek Pant25-Jan-13 9:51
memberAbhishek Pant25-Jan-13 9:51 
QuestionObtaining the SelectedValue of a dropdownlist Pin
Collin Jasnoch24-Jan-13 2:50
memberCollin Jasnoch24-Jan-13 2:50 
QuestionHow to get the value of a dynamically created textBox in asp.net C#? Pin
susanna.floora24-Jan-13 2:46
membersusanna.floora24-Jan-13 2:46 
AnswerRe: How to get the value of a dynamically created textBox in asp.net C#? Pin
chester_it2124-Jan-13 14:50
groupchester_it2124-Jan-13 14:50 
GeneralRe: How to get the value of a dynamically created textBox in asp.net C#? Pin
susanna.floora24-Jan-13 17:54
membersusanna.floora24-Jan-13 17:54 
GeneralRe: How to get the value of a dynamically created textBox in asp.net C#? Pin
chester_it2129-Jan-13 4:47
groupchester_it2129-Jan-13 4:47 
GeneralRe: How to get the value of a dynamically created textBox in asp.net C#? Pin
susanna.floora3-Feb-13 20:30
membersusanna.floora3-Feb-13 20:30 
GeneralRe: How to get the value of a dynamically created textBox in asp.net C#? Pin
chester_it216-Feb-13 6:22
groupchester_it216-Feb-13 6:22 
QuestionURL Rewriting Pin
MaheshPandian24-Jan-13 0:37
memberMaheshPandian24-Jan-13 0:37 
AnswerRe: URL Rewriting Pin
Shameel24-Jan-13 1:00
memberShameel24-Jan-13 1:00 
GeneralRe: URL Rewriting Pin
MaheshPandian24-Jan-13 2:28
memberMaheshPandian24-Jan-13 2:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 28 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid