Export Excel Sheet Problem

Question

When i export Excel Sheet using file uploader i am getting correct count of dataset when running from local machine. But when i upload the code on server i am not getting proper count in dataset.

Example : When Uploading from code = 6000 which is perfect according in excel sheet
but when upload on server the count which i getting is 4000

What I have tried:

In Web Config File

Hide Copy Code

<pre>maxRequestLength="10240" requestLengthDiskThreshold="10240"

Answer 1

Hi,<br><br> Do you need to validate a row or column?<br> You can convert to int as below-<br> Convert.ToInt32(dt.Rows[0]["colname"].ToString())>0

Answer 2

use the string conversion code. the code is as follows

consider it as follows.

int a;

a=Console.ReadLine(int.Parse());

Answer 3

Thank You! to all

Midhun T P

Delpin Susai Raj

Pradeep Shet

Krishna Rajput Singh

Answer 4

hi raja,

This is what you were looknig for?

foreach(DataRow dr in dt.Rows)

{

if(Convert.ToInt32(dr["colname"])>0)

{

//do something

}

}

Answer 5

http://stackoverflow.com/questions/1019793/how-can-i-convert-string-to-int

Answer 6

Hello Raja thank you for writing below links helpful for your question...........:)

and please clear your question first.....if you not looking that

https://msdn.microsoft.com/en-IN/library/bb397679.aspx

http://stackoverflow.com/questions/1019793/how-can-i-convert-string-to-int

http://sqlserverplanet.com/tsql/convert-text-string-to-numbers-int