Re: Add Project References at runtime - C# Discussion Boards

Re: The process cannot access the file because it is being used by another process

3-Oct-08 7:13

Maybe you have some problem with Vs and/or Windows or even vise versa!

While (true) { Human.isLearnable = true; }

Pedram Behroozi3-Oct-08 7:22

Re: The process cannot access the file because it is being used by another process

3-Oct-08 7:22

Hey, you didn't close your file!

<blockquote class="FQ"><div class="FQA">Alan Balkany wrote:</div>public void monitorFile()
{
   while (!Form1.done)
   {
      fi = new FileInfo(fname);
      DateTime dt = fi.LastWriteTime;

      if (lastWrite < dt)
      {
         lastWrite = dt;
         parent.showBitmap (new Bitmap(fname));
      }
      fi = null;
      Thread.Sleep(3000);
   }   
}</blockquote>

Add fi.Close(); before fi = null;

While (true) { Human.isLearnable = true; }

Mark Salsbery3-Oct-08 7:36

Mark Salsbery

3-Oct-08 7:36

Your Bitmap object keeps the file open.

Try disposing the Bitmap object after you're done working with it.

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: The process cannot access the file because it is being used by another process

Alan Balkany3-Oct-08 7:52

Alan Balkany

3-Oct-08 7:52

Yes! You solved it! I just copied the bitmap to a new one and disposed the old one, and it worked! Thanks Mark!

Re: The process cannot access the file because it is being used by another process

Pedram Behroozi3-Oct-08 9:27

Add Project References at runtime

3-Oct-08 9:27

Oh, you're right. My mistake! Thanks Mark Smile | :)

While (true) { Human.isLearnable = true; }

AngusOAP3-Oct-08 5:16

AngusOAP

3-Oct-08 5:16

I have a C# application which creates Excel Workbooks. To date I have added reference to the Excel version installed on my machine. I now need to do something which will read the Excel version installed on a user's machine and call the appropriate library.

Does anybody know how to do this? Many thanks

Angus

dan!sh 3-Oct-08 5:26

dan!sh

3-Oct-08 5:26

Use Type.GetTypeFromProgID and Activator.CreateInstance to instantiate the object. Then you can use Reflection for further operations.

"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry

led mike3-Oct-08 5:46

led mike

3-Oct-08 5:46

AngusOAP wrote:
I now need to do something which will read the Excel version installed on a user's machine and call the appropriate library.

Loading an assembly at runtime is not the same thing as adding a reference to a project.

If you are using the Primary Interop Assembly there is no guarantee that the users machine has it installed. You might be needing to study the Microsoft information[^] about using the Primary Interop Assemblies.

led mike

AngusOAP4-Oct-08 2:13

AngusOAP

4-Oct-08 2:13

Thanks, but having read the Microsoft information I fear I may be debarred - it says that I have to have Microsoft Visual Studio .NET for developers, whereas all I have is the miserablt C# Express Edition (2005 version plus Service Pack 1, at that). Do you know if it is it worth trying with that?

Thanks again.

Angus

led mike6-Oct-08 4:48

led mike

6-Oct-08 4:48

AngusOAP wrote:
Do you know if it is it worth trying with that?

I've never used Express Edition. However the PIA's are just assemblies so I would guess there should be no problem.

led mike

Communicating with user controls

Paul Conrad3-Oct-08 6:35

Paul Conrad

3-Oct-08 6:35

Like led mike said, read up from Microsoft on how to work with the PIA.

"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

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

KabirPatel3-Oct-08 4:38

KabirPatel

3-Oct-08 4:38

Hi,

I have a windows form that contains 2 buttons - a "Next" button and a "Prev" button.

When the form loads, a user control is loaded into the form. After the user presses the "Next" button, the user control is replaced by another user control. If the user presses the "Prev" button they move back to the prevous control. The process continues like this until 5 different user controls are loaded. i.e. I have implemented Wizard like functionaility.

This all works fine.

My problem is that the "Next" and "Prev" buttons are always enabled. I would only like the "Next" button to be enabled if the user has completed working on the User Control that they are currently on.

In other words, once a user has completed the minimum requirements of the control they are in, the "Next" button should become enabled.

An example of this would be a user control with a first name field. When the user fills in this field the "Next" button should be enabled.

Is it possible for the user control to bubble up this information back to its parent form, so that the button is enabled at the proper time?

Thanks,
Kabir

Re: Communicating with user controls

Pedram Behroozi3-Oct-08 5:00

Re: Communicating with user controls

3-Oct-08 5:00

Hi Kabir
You can use a public bool variable (true/false) in your UC. When user fills a valid text, your flag goes true, else false. And your form can use your flag to complete your task.

While (true) { Human.isLearnable = true; }

nelsonpaixao3-Oct-08 13:13

nelsonpaixao

3-Oct-08 13:13

if you are using delegates i don´t see how you didn´t achieve that after what you already coded?! D'Oh! | :doh:

parent form? you meen main_form and only form right? because you load usercontrols in main_form? i don´t see where is the change Dead | X|

nelsonpaixao@yahoo.com.br

trying to help & get help

excel cell alignment

michael_jhons3-Oct-08 4:04

michael_jhons

3-Oct-08 4:04

hello everybody
can somebody help me in formating excel cells inside a worksheet:
i tried

worksheet.get_Range(worksheet.Cells[2, 1], worksheet.Cells[2, 3]).HorizontalAlignment = HorizontalAlignment.Left;

but gave me an error i made a research i found that i have to use

... HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter

the problem is that i couldn't find XlHAlign property i tried many reference but without any solution.

thank you in advance and kind regards

Re: excel cell alignment

Pedram Behroozi3-Oct-08 4:50

3-Oct-08 4:50

michael_jhons wrote:
but gave me an error i made a research i found that i have to use

... HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter

But it worked for me! Confused | :confused:

It's my code:

using System;
using System.Text;
using Microsoft.Office.Interop.Excel;

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            WorksheetClass ws = new WorksheetClass();
            ws.get_Range(ws.Cells[2, 1], ws.Cells[2, 3]).HorizontalAlignment = XlHAlign.xlHAlignCenter;
        }
    }
}

While (true) { Human.isLearnable = true; }

Re: excel cell alignment

michael_jhons5-Oct-08 21:31

michael_jhons

5-Oct-08 21:31

thank you pedram, it was the

using Microsoft.Office.Interop.Excel;

i added as a reference but when i added from using XLHalign apears, thank you fro your help

Re: excel cell alignment

minhlao21-Mar-09 17:14

minhlao

21-Mar-09 17:14

Range rng = objSheet.getRange(col1, row1,col2 ,row2);
rng.HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;

Wink | ;)

enjoy it

soicodon : mihazu_undead@yahoo.com

ref and out [modified]

DaveyM693-Oct-08 1:29

DaveyM69

3-Oct-08 1:29

Am I correct in thinking that the only difference is:

ref has to be preassigned but does not have to be used in the method
out must be assigned before returning but can be unassigned before calling the method
?

Are there any notable benifits of using either one?

[edit] Just discovered that if using out, the parameter is treated as if it is unassigned (even if it's already been assigned) as soon as you call the method. So it appears that ref is kind of an input and output parameter whereas out is just output.[/edit]

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

modified on Friday, October 3, 2008 7:37 AM

Brij3-Oct-08 1:54

Brij

3-Oct-08 1:54

for 'out' you are correct and for 'ref' it doesn't need to assigned by callee.
For more check the below link
http://msdn.microsoft.com/en-us/vcsharp/aa336814.aspx[^]

Cheers!!
Brij

Guffa3-Oct-08 5:46

Guffa

3-Oct-08 5:46

Brij wrote:
for 'ref' it doesn't need to assigned by callee

Yes it does.

Read the page that you linked to.

Despite everything, the person most likely to be fooling you next is yourself.

Ennis Ray Lynch, Jr.3-Oct-08 4:17

Ennis Ray Lynch, Jr.

3-Oct-08 4:17

ref is input output on value types. For object types while it is technically the same you can accidentally change the pointer reference if you are not careful as objects are naturally passed by referenced. This was discussed on this very forum a few weeks ago.

Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Most of this sig is for Google, not ego.

led mike3-Oct-08 4:32

led mike

3-Oct-08 4:32

Ennis Ray Lynch, Jr. wrote:
This was discussed on this very forum a few weeks ago.

Yes, and in many other places in times far far away. What was that old quip about monkeys, keyboards and the internet? Laugh | :laugh:

led mike