470,638 Members | 1,510 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

CPU usage 99% (aspnet_wp.exe) while importing excel sheet

Hi all,
I am trying to import data from an excel sheet to MSSQL server 2000
using a web application (C#).
Since I have to validate the data in the excel sheet, the approach i
have used is to get the data from the excel sheet in a datatable in my
excel sheet.
For this i have used an ODBC connection and selected the contents from
my excel sheet. Through the data adapter got it into a datatable.
Validated the datatable entries.
And then with an SQL connection, i have inserted it into SQL server
I have used the using block for entering data into my sheet. So that
the sql connection is closed as soon as the database is updated.
The excel sheet has some 500 odd entries. Most of them in string
Some fields are as long as 500 characters.

After running this application on my system, after some time the
application hangs. When I check the task manager, it shows that
aspnet_wp.exe is utilising 99% of the CPU.

Please note that I am not using string concatenation in my

Looking forward to some help on this issue.

Nov 19 '05 #1
1 2105
Hi all,
I have solved the issue.
It was a terrible little piece of code, an infinite while loop!
Its working great now.(so next time u face a problem like this, the
first thing u can do is go through the entire code).


Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Darren | last post: by
9 posts views Thread by jillandgordon | last post: by
7 posts views Thread by Clement | last post: by
4 posts views Thread by RC | last post: by
3 posts views Thread by Conrad F | last post: by
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.