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:
| Id | Name | Mobile | Email | 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.