C# Discussion Boards - CodeProject

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

Pedram Behroozi3-Oct-08 9:27

Pedram Behroozi

3-Oct-08 9:27

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

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

Add Project References at runtime

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

Re: Add Project References at runtime

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

Re: Add Project References at runtime

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

Re: Add Project References at runtime

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

Re: Add Project References at runtime

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

Re: Add Project References at runtime

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

Communicating with user controls

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

Pedram Behroozi

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; }

Re: Communicating with user controls

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

Pedram Behroozi

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

Re: ref and out

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

Re: ref and out

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.

Re: ref and out

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.

Re: ref and out

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

Re: ref and out

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

Ennis Ray Lynch, Jr.

3-Oct-08 4:33

I don't know but if the punch line involve feces I don't want to hear it :p

Re: ref and out

DaveyM693-Oct-08 5:14

DaveyM69

3-Oct-08 5:14

led mike wrote:
and in many other places in times far far away

I looked and read what I found, but was just seeking clarification as I wasn't 100%

led mike wrote:
monkeys

What is it with the 'respected' members of this site and the desire to abuse anyone whenever they can? I won't take it personally, but it's not necessary or justified.

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)

Re: ref and out

led mike3-Oct-08 5:39

led mike

3-Oct-08 5:39

DaveyM69 wrote:
What is it with the 'respected' members of this site

Who says I am respected? Big Grin | :-D

DaveyM69 wrote:
to abuse anyone whenever they can?

I did not post my comment to you.

DaveyM69 wrote:
but it's not necessary or justified.

Perhaps not in this case. In many others it is and without doubt. We see a large number of users here that make no attempt to learn software development. They seem to believe internet forums are a replacement for learning. Given the nature of text messages it is not always apparent when someone is not in that category of users.

If you are not one of those people, then you should not be offended by my comment, correct? In fact it seems you would be inclined to agree with it. Wink | ;)

led mike

Re: ref and out

DaveyM693-Oct-08 6:50

DaveyM69

3-Oct-08 6:50

led mike wrote:
it seems you would be inclined to agree with it

Most definately Big Grin | :-D

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)

Re: ref and out

Mark Salsbery3-Oct-08 5:57

Mark Salsbery

3-Oct-08 5:57

It's refreshing to see an actual C# question here!

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

Re: ref and out

DaveyM693-Oct-08 5:01

DaveyM69

3-Oct-08 5:01

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

Sorry - I never saw it, I tend to be on here daily but somehow missed that one. Apologies.

Ennis Ray Lynch, Jr. wrote:
you can accidentally change the pointer reference

Thanks - I'll investigate further as what I did find by googling never suggested that.

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)

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