ASP.NET

28-Jul-08 19:54

How to load an assembly using wrapper class and unload it?

Paul Conrad28-Jul-08 19:58

28-Jul-08 19:58

What have you tried doing?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

amit.jha28-Jul-08 20:08

28-Jul-08 20:08

I am creating a dll at run time. When i need to refer that dll i have to laod the assembly and get the reference. Till here its working fine but now if i recompile this assembly to modify it message comes that this assembly can't be loaded as it is in progress.So before recompiling i have to unload that assembly.

Christian Flutcher28-Jul-08 20:25

Christian Flutcher

28-Jul-08 20:25

You can't unload assemblies. You can unload application domain which hosts these assemblies. So all the assemblies will get unloaded. BTW, what this has to do with ASP.NET ?

amit.jha28-Jul-08 20:50

28-Jul-08 20:50

I have to dynamically load and unload assemblies in .net website so that the assembly can be modified at runtime and recompiled.Assemblies can not be unloaded but how using appdomain i can unload an assembly.I am compiling my assembly at one page and using it by loading the assemble in different page.

satyaanand.andra@gmail.com

satyaanand.andra@gmail.com28-Jul-08 20:35

28-Jul-08 20:35

in the Page_Unload Event,
make the object to null

it will be nullified and no problem will be in future compiling

amit.jha28-Jul-08 20:53

28-Jul-08 20:53

This is the object of the class i am making.This object is used to get the methods of the assembly using reflection.Can u pls tell me which object i will make null?

Dim asm As [Assembly] = [Assembly].LoadFile(System.Web.HttpRuntime.AppDomainAppPath & "Bin\Mytext.dll")
Dim objAssembly As System.Reflection.Assembly = asm
Dim objTheClass As Object = objAssembly.CreateInstance("DynamicClass")

satyaanand.andra@gmail.com

satyaanand.andra@gmail.com28-Jul-08 23:18

28-Jul-08 23:18

objAssembly

Make it null in the page unload event

ERROR : Exception from HRESULT: 0x800A03EC

varshavmane28-Jul-08 19:53

28-Jul-08 19:53

Hello All,

I am using ASP.NET 2005(C#). I want to show and save the excel file on server. For this I opened excel file in iframe and kept a save button outside the iframe. On Page Load I have the following code:

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            try
            {
                string fileName = AppDomain.CurrentDomain.BaseDirectory + "SaveExcelFile\\Excel1.xls";
                Microsoft.Office.Interop.Excel.Application ObjExcel = new Microsoft.Office.Interop.Excel.Application();
                Microsoft.Office.Interop.Excel.Workbook ObjWB;
                Microsoft.Office.Interop.Excel.Worksheet ObjWS;
                Object missing = System.Reflection.Missing.Value;
                if (ObjExcel == null)
                {
                    //'throw an exception
                    throw (new Exception("Unable to Start Microsoft Excel"));
                }
                else
                {
                    ObjExcel.Visible = true;
                    ObjExcel.DisplayAlerts = false;
                    ObjWB = ObjExcel.Workbooks._Open(fileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
                    ObjWS = (Microsoft.Office.Interop.Excel.Worksheet)ObjWB.ActiveSheet;
                    Session["ExcelObject"] = ObjExcel;
                    Session["WorkBook"] = ObjWB;
                    Session["WorkSheet"] = ObjWS;
                    htxtFileName.Value = "SaveExcelFile/Excel1.xls";
                }
            }
            catch (Exception ex)
            {
                Response.Write("Page Load Error : " + ex.Message);
            }
        }
    }

and On Save Button Click event I have the following code:

protected void btnSaveFileToServer_Click(object sender, EventArgs e)
    {
        try
        {
            if (Session["ExcelObject"] != null && Session["WorkBook"] != null && Session["WorkSheet"] != null)
            {
                Microsoft.Office.Interop.Excel.Application ObjExcel = (Microsoft.Office.Interop.Excel.Application)Session["ExcelObject"];
                Microsoft.Office.Interop.Excel.Workbook ObjWB = (Microsoft.Office.Interop.Excel.Workbook)Session["WorkBook"];
                Microsoft.Office.Interop.Excel.Worksheet ObjWS = (Microsoft.Office.Interop.Excel.Worksheet)Session["WorkSheet"];
                ObjExcel.ThisWorkbook.Save();
            }
        }
        catch (Exception ex)
        {
            Response.Write("ERROR : " + ex.Message);
        }
    }

The above code works fine on my machine but when I deploy it on server it gives error "ERROR : Exception from HRESULT: 0x800A03EC" while saving the file back to server.

Please help me.

Thanks in advance.

Paul Conrad28-Jul-08 19:58

28-Jul-08 19:58

Have you tried googling with the error message as the search string. You might find what it means.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

varshavmane28-Jul-08 20:08

28-Jul-08 20:08

Thanks Paul for replying. Yes I have tried but didnt get much help Frown | :(

I am not able to figure out what is the exact problem in the code.

Please help me...

Paul Conrad28-Jul-08 20:15

28-Jul-08 20:15

I've seen this kind of thing happen when there is an instance of Excel, ( or Word, doesn't really matter when using Office Interop ) that is not closed, and a New is invoked the second time through. I'd put a check in your code to make sure you are creating a single instance of Excel, and closing that instance when done with it.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Paul Conrad28-Jul-08 20:17

28-Jul-08 20:17

In btnSaveFileToServer_Click....

ASP.NET 2.0 wrote:
Microsoft.Office.Interop.Excel.Worksheet ObjWS = (Microsoft.Office.Interop.Excel.Worksheet)Session["WorkSheet"];
ObjExcel.ThisWorkbook.Save();

Add something like ObjExcel.Quit, so you can dispose of the Excel app when done with it.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

varshavmane28-Jul-08 20:23

28-Jul-08 20:23

thanks for the reply Paul, but its not working. now the error is coming on page load it self and excel file is not getting saved Frown | :(

Please help me...

Thanks again.

Paul Conrad28-Jul-08 20:25

28-Jul-08 20:25

Well, it's late here. I'm curious as to why this is a problem. I'll write my own little mock up of your code you are trying to do and see what is up. Stay tuned Smile | :)

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

varshavmane28-Jul-08 20:29

28-Jul-08 20:29

hey thanks Paul. I am trying this from yesterday but Frown | :(

First I was getting Error "Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005."

I solved that but now getting this error.

Thanks again.

OleHansen21-Jul-09 21:44

OleHansen

21-Jul-09 21:44

Hi, found a possible solution here: http://www.made4dotnet.com/Default.aspx?tabid=141&aid=15

priya_velan19-Oct-10 15:30

priya_velan

19-Oct-10 15:30

Hi,

I tried your code, I get the error even in my local dev machine.
The error when executing the line "ObjExcel.ThisWorkbook.Save();" is : "Exception from HRESULT: 0x800A03EC".
If you find the solution for the above, pls help me out to solve.

Thanks
Priya

vs2003 setup

Kissy1628-Jul-08 19:40

Kissy16

28-Jul-08 19:40

How to create a setup file for a webbased project which is developed in vs2003/msaccess.
I have created and installed.but it is unable to open.
How to give url??and step step by process i need.please give the steps to create.
i found something on the net but it is now so useful.let me know if anybody is free.

kissy

Re: vs2003 setup

Paul Conrad28-Jul-08 19:59

28-Jul-08 19:59

Kissy16 wrote:
but it is unable to open.

What is unable to open?

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: vs2003 setup

Kissy1628-Jul-08 20:20

Kissy16

28-Jul-08 20:20

the generated setup file,i have installed in a PC but it is not opening.

kissy

Re: vs2003 setup

Paul Conrad28-Jul-08 20:24