2
Answers

Export Excel Sheet Problem

Sameer Khan

Sameer Khan

7y
263
1
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
<pre>maxRequestLength="10240" requestLengthDiskThreshold="10240"
Answers (2)
2
Midhun T P

Midhun T P

NA 19.7k 281.1k 8y
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
Accepted
1
Kishore Chowdary

Kishore Chowdary

NA 12.7k 254.9k 8y
use the string conversion code. the code is as follows
consider it as follows.
int a;
a=Console.ReadLine(int.Parse());
1
Raja

Raja

NA 1.7k 45.2k 8y
1
Pradeep Shet

Pradeep Shet

NA 6.3k 2.1m 8y
hi raja,
This is what you were looknig for?
foreach(DataRow dr in dt.Rows)
{
if(Convert.ToInt32(dr["colname"])>0)
{
//do something
}
}
1
Delpin Susai Raj

Delpin Susai Raj

NA 32k 1m 8y
http://stackoverflow.com/questions/1019793/how-can-i-convert-string-to-int
1
Krishna Rajput Singh

Krishna Rajput Singh

NA 5.5k 2m 8y
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