467,211 Members | 1,233 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,211 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.
CLOSED THE ODBC CONNECTION.
Validated the datatable entries.
And then with an SQL connection, i have inserted it into SQL server
2000.
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
format.
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
application.

Looking forward to some help on this issue.

regards,
vivek
Nov 19 '05 #1
  • viewed: 1999
Share:
1 Reply
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).

vivek.

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
By using this site, you agree to our Privacy Policy and Terms of Use.