About IIS6.0 Restart issue

I have a problem to restart a server whenever I am uploading Excel sheet.

Actually in my project I am uploading an excel sheet whose data is going to store in a sql table.

and this record going to update in another table on the basis of some fields.

field in Excelsheet are:

Name

Mobile

City

State

DataId

Amount

Date

Source

uploadedexceldata Table having column

Id,Name,Mobile,Email,City,State,DataId,Amount,Date, UploadedDate, Source

another Tble Leadtable Having column Mobile,DataId,Source

whenever I upload excelsheet the data of Excelsheet inserted into uploadedexceldata

and the Leadtable is updated on the matched column mobile of uploadedexceldata

the field which are going to update is DataId,Source .

all is running on iis6.0.

whenever I upload the file is not uploading is only loading and when I Restart server the file easily being uploaded.

I dont want to restart my server again and again how to resolve this problem.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
Just make sure you are properly disposing all the resources consumed by you. Especially like Excel instances, sql server connections, files opened, etc. These resources are outside the area of garbage collection so it doesn't touch them.
So you should take care to dispose them manually.
If possible try to use using(....) clause as much as you can.
0