C# Discussion Boards - CodeProject

Vitesh Aggarwal31-Jan-03 3:45

31-Jan-03 3:45

Hi All,

I am working on a C# based Windows application.Using the following code
to
create an Excel object.

Excel.Application ExcelObj = new Excel.Application();

Its workin fine for me, the problem is that i want to destroy this
object
when i exit form my method.
I am not able to delete this object.

Calling GC.Collect() Or MArshal.ReleaseComObject() waz not of any help.

Pls help.

Regards
Vitesh

Re: Destroying Excel object

Ed K31-Jan-03 4:16

Ed K

31-Jan-03 4:16

Here is a code snippet from a class I'm using to export some data from an excel sheet. I think it answers your question.

///////// these are declared as member variables...copied here for clarity
        private Excel.ApplicationClass m_objExcel =  null;
        private Excel.Workbooks m_objBooks = null;
        private Excel._Workbook m_objBook = null;
        //private Excel.Sheets m_objSheets = null;
        private Excel._Worksheet m_objSheet = null;
        private Excel.Range m_objRange =  null;	
        private object oMissing = System.Reflection.Missing.Value;
///////////////////////////////////////////////////////////////

	try
	{
		FileInfo inf = new FileInfo(excelFileName);
		
		m_objExcel = new Excel.ApplicationClass();
		m_objExcel.Visible = false;
		m_objBooks = m_objExcel.Workbooks;
		m_objBook = m_objBooks.Open(inf.FullName, oMissing, oMissing,
			oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, 
			oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);

		m_objSheet = (Excel._Worksheet)m_objBook.Sheets[2];

		string transformFileName = string.Format(@"{0}\{1}.cvt",inf.DirectoryName,inf.Name);

		m_objSheet.SaveAs(transformFileName,Excel.XlFileFormat.xlTextWindows,oMissing,oMissing,oMissing,false,false,oMissing,oMissing,oMissing);

		activeFile = new FileInfo(transformFileName);

	}
	catch(Exception ex)
	{
		throw ex;
	}
	finally
	{
		if( m_objBook != null)
		{
			m_objBook.Close(false, oMissing, oMissing);
			System.Runtime.InteropServices.Marshal.ReleaseComObject (m_objBook);
			m_objBook = null;
			System.Runtime.InteropServices.Marshal.ReleaseComObject (m_objBooks);
			m_objBooks = null;
			m_objExcel.Quit();
			System.Runtime.InteropServices.Marshal.ReleaseComObject (m_objExcel);
			m_objExcel = null;	
		}
	}

ed

Regulation is the substitution of error for chance.

Tooltip like window?

Roger Alsing31-Jan-03 3:22

Roger Alsing

31-Jan-03 3:22

Hi , ive asked this before , but does ANYONE know how to make a borderless window behave like a tooltip?
meaning , it should not steal focus from the app that shows it (grayout the apps caption)

i need to be able to place controls on the 'tooltip' but they dont need to be able to hold focus , just as long as i can click them and the click events work...

currently im doing some nasty wndproc hack , scanning for the wm_ncactivate message , and setting focus back to the parent window... but this causes the parents caption to redraw , so there is some minor flicker (but still annoying)

any idea?

//Roger

Re: Tooltip like window?

Richard Deeming31-Jan-03 3:46

Richard Deeming

31-Jan-03 3:46

If you're using Windows 2000 or higher, you can override the CreateParams property, and add WS_EX_NOACTIVATE to the ExStyle property:

class TooltipForm : Form
{
    ...
    protected const int WS_EX_NOACTIVATE = 0x08000000;
    
    protected override CreateParams CreateParams
    {
        get
        {
            CreateParams cp = base.CreateParams;
            cp.ExStyle |= WS_EX_NOACTIVATE;
            return cp;
        }
    }
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Re: Tooltip like window?

Roger Alsing31-Jan-03 3:50

Roger Alsing

31-Jan-03 3:50

hmmm.. it dont seem to work ...
using win2k and c# , setting the window to "Topmost=true"

it still steal focus..

//Roger

I would like to create a button that allow to open html page.

zoltix31-Jan-03 2:56

zoltix

31-Jan-03 2:56

Excuse-me for my stupid question, In WebForm, I would like to create a button that allow to open html page.(link with parameter ex: qsdf.asp?Text=tete) in the same browser (and other browser). How can I do that? Confused | :confused:

-=zoltx=-

Re: I would like to create a button that allow to open html page.

TigerNinja_31-Jan-03 5:09

TigerNinja_

31-Jan-03 5:09

In your event handler for your Button you can Response.Write your javascript code to load a new window and change the location of your current browser. This gives you a dynamic effect.

js references
window.open, href.location

example:

public void OnClickButton1(object sender, EventArgs e){<br />
  Response.Write("<javascript>window.open("www.codeproject.com");</javascript> );<br />
<br />
}

Note: code was written from memory, it is meant only for a guide

R.Bischoff | C++

.NET, Kommst du mit?

Re: I would like to create a button that allow to open html page.

zoltix31-Jan-03 5:30

zoltix

31-Jan-03 5:30

Sorry I tested and you code don't work, I modify your in this manner Response.Write("<javascript>window.open(\"www.codeproject.com\"); ")");

but it is not enough..

-=zoltx=-

Re: I would like to create a button that allow to open html page.

Anonymous31-Jan-03 19:52

Anonymous

31-Jan-03 19:52

how to do the same with C# as scripting language Confused | :confused:

is machine.config cached ???

Dato31-Jan-03 2:48

Dato

31-Jan-03 2:48

I"m curious..
I'm changing settings in my machine.config so my web service runs properly. Problem is .. I can't tell which configuration change is making it work properly. It seems to me like the machine.config file is being cached.
Is it? if so is there a way to prevent it from being cached ?

thks

Reusing closed/disposed forms

31-Jan-03 0:58

Hey there,

When using Form.Close and you try to show the form again, it shows without a Titlebar Confused | :confused:

How do you close a form knowing that you will want to load the form again at a later stage?

Re: Reusing closed/disposed forms

leppie31-Jan-03 4:18

leppie

31-Jan-03 4:18

form.Hide() / form.Show()
or
after Close/Dispose, use new Form().

Smile | :)

Who is this miscrosoft, and what devilish plans have they for us?

Excel automation

Mauricio Ritter30-Jan-03 23:49

Mauricio Ritter

30-Jan-03 23:49

I´m creating an application that does some automation with excel. The problem is that Excel sometimes is busy doing some tasks and can´t respond to my method calls. To solve this I´m using something similar to this;

while(true)
{
  try
  {
      oWorkbook.Range(...);
  }
  catch(System.RunTime.Interop.COMException)
  {
    // wait a littel bit
    System.Threading.Thread.Sleep(100)
  }
  catch(Exception exp)
  {
      throw(exp);
      break;
  }
}

The problem is that I have TONS of this oWorkbook.Range(...); lines... and I don´t want to write this bunch of code to all of them. Does anyone know some alternative way to do this (some kinda template maybe) ? I know I can write a wrapper to do this... but it´ll give me a lot of work... and I´m trying to find a better solution.

Mauricio Ritter - Brazil
Sonorking now: 100.13560 MRitter

Life is a mixture of painful separations from your loved ones and joyful reunions, without those two we'd just be animals I guess. The more painful the separation, that much more wonderful will be the reunion - Nish

"Th@ langwagje is screwed! It has if's but no end if's!! Stupid php cant even do butuns on forms! VISHAUL BASICS ARE THE FUTSHURE!" - Simon Walton

Can't get MAC address using ManagementClass

EnkelIk30-Jan-03 21:15

EnkelIk

30-Jan-03 21:15

I've written a small app that retrieves the MAC-address from computors, using ManagementClass, ManagementObjectCollection and so on, eventually ManagementBaseObject.get_Item("MacAddress"); which turns out to work fine for most computors. Lately however I have discovered that for some computors a different series of numbers is retrieved. Looking into it a bit deeper I found that on all computors not one, but serveral items could be found calling get_item("MacAddress"). So my program did work for computors where the real MACaddress was the first to be returned (and apparently this included most computers).

Have I missed something? How can I tell which one is the real MAC address, and what are the other numbers?

Kind regards
/EnkelIk

Below a snippet of my code:
ManagementClass mc;
ManagementObjectCollection moc;
ManagementBaseObject mbo;
ManagementObjectCollection.ManagementObjectEnumerator moe;
string strMAC="",strTmp;

mc = new ManagementClass("Win32_NetworkAdapterConfiguration");
moc = mc.GetInstances(); // Get network adapter instance

moe=moc.GetEnumerator();

//Loop till MAC address found
while(moe.MoveNext())
{
mbo=moe.Current;

if(mbo["IPEnabled"]!=null)
{
Object pObj;

//Get MAC address
pObj=mbo["MacAddress"];
if(pObj!=null)
{
strTmp=pObj.ToString();
strMAC=string.Concat(strMAC,strTmp);

//Remove colon
strMAC=strMAC.Replace(":","");
break;
}
}
}

Re: Can't get MAC address using ManagementClass

EnkelIk4-Feb-03 23:11

EnkelIk

4-Feb-03 23:11

The answer is often simple when you know it... Debugging more carefully I found that mbo["IPEnabled"] is a System.Boolean -it is either true or false, but never null. Smile | :)

/EnkelIk

SystemMenu

ShulapovMax30-Jan-03 20:50

ShulapovMax

30-Jan-03 20:50

How to get Sysmenu in Winforms?

Re: SystemMenu

Roger Alsing31-Jan-03 1:03

Roger Alsing

31-Jan-03 1:03

use pinvoke and call the getsysmenu api

/Roger

Cursor Change while UserControl Drag And Drop ?

Paresh Gheewala30-Jan-03 15:43

Paresh Gheewala

30-Jan-03 15:43

Hi,
I am developing usercontrol drag and drop.
DragSource: UserControl
DragDest: DataGrid

My Quesiton here is can I change Cursor (mouse icon) while draging? It gives Drag Effects for the Cursor like Move,Copy, None etc. I want to change the Cursor type say for example IBeam or Hand type Cursor instead of Move Effect. (Letting the Move effect remain same with having Cursor Image changed) is it possible ?
Could someone lead me to some direction or give me some link ?

kindda stuck Unsure | :~

Thanx,
Paresh

Re: Cursor Change while UserControl Drag And Drop ?

Paresh Gheewala31-Jan-03 10:56

Paresh Gheewala

31-Jan-03 10:56

anyone knows let me know ASAP... Confused | :confused:

How do I get a file's REAL last modified date?

lnong30-Jan-03 13:34

lnong

30-Jan-03 13:34

I'm allowing the client user to upload his file onto my server. Now how do I find out the file's ORIGINAL last modified date and time?

If I use any of these File methods:

File.GetCreationTime()
File.GetLastAccessTime()
File.GetLastWriteTime()

I get the same date and time, namely, the time corresponding to the instant the file was uploaded. But that's not the file's original modified date. How do I get the original modified date of the (as seen by the client)?

Re: How do I get a file's REAL last modified date?

Todd Smith30-Jan-03 14:17

Todd Smith

30-Jan-03 14:17

It's probably part of the HTTP response header (Last-Modified).

Todd Smith

Panel Repaint

sv787430-Jan-03 12:25

sv7874

30-Jan-03 12:25

I have Panel control on Form. But, when I change context in it, I want to repaint it.

How to force Panel, to be repainted ?

10x

best regards, sebastijan

Re: Panel Repaint

Nick Parker30-Jan-03 16:02

Nick Parker

30-Jan-03 16:02

sv7874 wrote:
How to force Panel, to be repainted ?

You could call Invalidate().

Nick Parker

The only man who never makes a mistake is the man who never does anything. - Theodore Roosevelt

Ownerdraw context menu in traybar?

anewmachine30-Jan-03 12:23

anewmachine

30-Jan-03 12:23

Hi all,
I have a c# class derived from MenuItem that I am using for ownerdraw menu items. I set the OwnerDraw property to true, added the DrawItem & MeasureItem methods. I tested my class with a form, attaching the context menu to the form, and it worked great, the DrawItem & MeasureItem methods get called. However, if I try to use the context menu with a traybar application, the methods don't get called. Is this a known issue or what am I doing wrong or is there a workaround?

thanks
warbler

entryPoint of a PE file

blacksun_damn30-Jan-03 11:52

blacksun_damn

30-Jan-03 11:52

Salamo 3alekom
I tried to open a PE file with a program called PEExplorer .. Opend the header & discoverd that all the items in the header is correct..
but i found something strange i igot "the address of entry point" field from the header but when i checked that address i found it's so different from the contents that the PEExplorer program shows...
i found that the "image base" field is added some times 2 the address of the entry point field...
for example the address of entry point is: 0000E67Ch
& the image base is: 01000000h
but when i run the disassembler view of the PEExplorer i find that the address of the entry point is 0100E67Ch & this address can't be located coz the file size is smaller than it & the contents that the disassembler show in this location 0100E67Ch i can find it in another different place in my file
plz does any one knows how is this operation handled & how can i reach 2 the real entry point of an exe file...
my email is
blacksun_damn@yahoo.com,
ashshab_beh@yahoo.com

blacksun

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.