|
What data provider are you using for writing to the excel file? I have always used oledb to write to excel files, but I never found out a way to do the column headers. I always just had the first row as the column names, which worked out just fine. I don't think it can be done using jet, but I didn't really look into it all that much. If you are using the Office Interop, It probably can be done that way. I really have no idea though.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Hi there,
I´m starting to do some work in C#. I´m developing a dll library to communicate unmanaged code in C++ with managed code in C#, one of the problems I have is the use of a method that returns an array of integers in C++ (using vector<int>), can someone tell me what kind of structure of integers can I use in C# which is a equivalent to vector<int> for calling this function in the C# code?.
Thanks, regards.
|
|
|
|
|
Try looking at ArrayList. It is in System.Collections.Generic
Hogan
|
|
|
|
|
Yeah, I´ve already I tried and it doesn´t work...
|
|
|
|
|
Hi,
if possible I would create the array of the right size using managed code, use the
GCHandle class to pin it in memory and get its IntPtr, then pass that to the unmanaged code
which can read and/or write the array; afterwards apply GCHandle.Free().
That is much easier than trying to have unmanaged code create an object, and it avoids
copying all the data while marshaling.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
alispas wrote: a method that returns an array of integers in C++ (using vector)
if that means:
vector<int> mymethod();
then I don't believe there is a way to consume that using C#. Even if there is it would be ugly. I suggest you use C++/CLI to build a mixed mode assembly that will define a managed class API and marshal the native vector into it.
|
|
|
|
|
led mike wrote: I suggest you use C++/CLI to build a mixed mode assembly that will define a managed class API and marshal the native vector into it.
Yup - ugly... So much for easy interoperability...
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
John Simmons / outlaw programmer wrote: So much for easy interoperability...
Yes so much for the thing that is everything or the automated application generation tools that will eliminate the need for developers. They don't exist and maybe never will.
|
|
|
|
|
hi
I receive an exception at runtime when try to execute:
System.Diagnostics.Process[] Proc = System.Diagnostics.Process.GetProcesses();
exception type:
System.InvalidOperationException
exception message:
Process performance counter is disable, so the requested operation cannot be performed.
H.R
|
|
|
|
|
Take a look at this thread[^].
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi
Can anyone tel me if u can join them
so for every node ther will be a checkBox
THNKS
kobkob
|
|
|
|
|
Try setting this property[^].
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
THNKS
kobkob
|
|
|
|
|
In one of my projects, I have a form with a grid of controls on it. I create the controls on the fly, as there are a dynamic number of them. To keep track of the controls, I keep them in a ArrayList.
As I create each control, I bind a handler to it, to handle events.
So:
ArrayList aMembersComboBoxes = new ArrayList();<br />
ArrayList aRelationshipComboBoxes = new ArrayList();<br />
...<br />
aMembersComboBoxes.Insert(iPosition, new System.Windows.Forms.ComboBox());<br />
aRelationshipComboBoxes.Insert(iPosition, new System.Windows.Forms.ComboBox());<br />
...<br />
((ComboBox)aMembersComboBoxes[iPosition]).SelectedIndexChanged += new EventHandler(cmbMembers_SelectIndexChanged);<br />
((ComboBox)aRelationshipComboBoxes[iPosition]).SelectedIndexChanged += new EventHandler(cmbRelationship_SelectIndexChanged);<br />
In the handler for my first combobox (cmbMembers) I change the DataSource for my second combobox (cmbRelationship), based on the selection the user makes in the first combobox.
<br />
private void cmbRelationship_SelectIndexChanged(object sender, EventArgs e)<br />
{<br />
int i = aMembersComboBoxes.IndexOf((ComboBox)sender);<br />
<br />
if (((ComboBox)sender).SelectedItem.ToString().Contains("String"))<br />
{<br />
((ComboBox)aRelationshipComboBoxes[i]).DataSource = aRelationshipList_Strings;<br />
}<br />
}<br />
In this handler, the code works fine, because sender turns out to be the control I clicked on. But in the handler for the second combobox, the same code fails:
private void cmbRelationship_SelectIndexChanged(object sender, EventArgs e)<br />
{<br />
int i = aRelationshipComboBoxes.IndexOf((ComboBox)sender);<br />
}<br />
Because in this case, "sender" turns out to be the control that initiated the action (the code executing in cmbMember), not the control that received it.
How can I get the identity of the control that is RECEIVING the event, the one for whom the handler is firing?
Thanks in advance.
-- modified at 8:39 Wednesday 26th September, 2007
|
|
|
|
|
Not too sure what you mean but if
int i = aRelationshipComboBoxes.IndexOf((ComboBox)sender);
gives you the sender, wouldn't this (no pun intended)
int i = aRelationshipComboBoxes.IndexOf((ComboBox)this);
give you the receiver? Or am i totally missing the point?
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
no, "this" is the form. The code you described won't even compile... I need to know the index of the current control inside the ArrayList of controls aRelationshipComboBoxes[]...
|
|
|
|
|
I think there is probably something else wrong. If you use Reflector[^] you can see that the SelectedIndexChanged event is always fired by a ComboBox using "this" as the sender. Check out the OnSelectedIndexChanged(EventArgs) method.
I would recommend setting the Name property on the ComboBoxes that you are creating (assuming you are not already doing that).
Can you put together a small sample project and send it over?
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Ignore my code for a second, it's probably confusing the issue.
Generically, how do you get the identity of the control for whom a handler is executing? I believe I'm looking for the C# equivalent of the VB "Me" keyword, here.
|
|
|
|
|
The "sender" parameter is the control that fired the event. I'm assuming that is what you are asking. The C# equilvalent of the VB.Net "Me" is "this".
So if you have two combo boxes and you hook them both up to the same event handler like:
private ComboBox comboBox1 = new ComboBox();
private ComboBox comboBox2 = new ComboBox();
private void CreateComboBoxes() {
this.comboBox1 = new ComboBox();
this.comboBox2 = new ComboBox();
this.comboBox1.Location = new System.Drawing.Point(51, 157);
this.comboBox1.Name = "comboBox1";
this.comboBox1.Size = new System.Drawing.Size(121, 21);
this.comboBox1.TabIndex = 0;
this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox_SelectedIndexChanged);
this.comboBox2.Location = new System.Drawing.Point(51, 184);
this.comboBox2.Name = "comboBox2";
this.comboBox2.Size = new System.Drawing.Size(121, 21);
this.comboBox2.TabIndex = 1;
this.comboBox2.SelectedIndexChanged += new System.EventHandler(this.comboBox_SelectedIndexChanged);
this.Controls.Add(this.comboBox2);
this.Controls.Add(this.comboBox1);
}
private void comboBox_SelectedIndexChanged(Object sender, EventArgs e) {
if (sender == this.comboBox1) {
}
else if (sender == this.comboBox2) {
}
}
Then you can use the sender to distinguish the control that fired the event. The sender will be the ComboBox whose selected indexed changed regardless of how it changed (e.g. through code or through user interaction).
In the comboBox_SelectedIndexChanged() method, "this" refers to the Form because the method is defined in the Form class.
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
yeah, ignore my "Me" comment, too. I include too much.
Okay, write the second handler without typing "combobox1" or "combobox2". My controls are located in ListArrays. I can only refer to them by knowing what their index is.
So in comboBox_SelectedIndexChanged(Object sender, EventArgs e), I need to know which of my two comboboxes is executing. "sender" turns out to be the combobox you clicked on, UNLESS you actually clicked on ComboBox1 and the code therein caused the DataSource for ComboBox2 to change. At that point, ComboBox2 receives a "SelectedIndexChanged" message, whose "sender" is ComboBox1.
So - in comboBox_SelectedIndexChanged(Object sender, EventArgs e) - how can you figure out which control is having it's Selected Index changed, without referring to it by name?
|
|
|
|
|
I would need to see a sample of this happening. What I'm saying is that if the SelectedIndexChanged is being fired for the ComboBox2 (because of a DataSource change or any other reason) then the sender will always be ComboBox2. This is hard-coded into the .Net framework.
I think there is something else wrong in your code. The sender will always be the ComboBox that had it's selected index changed (regardless of whether the user clicked in the first ComboBox or not). So there must be a problem with how the events are hooked up or with something else being done before the event is fired.
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Sorry! My bug. I was binding the same handler to two different combo types. I gotta stop working all night.
So then - I can always use "sender" to know which control instance received the event? Yay! I can go to bed now!
|
|
|
|
|
Oh, and thanks. I'm tired, so I'm not being as clear as I should be.
BTW, if you know any better way to find out who "the current control" is in my case than what I am doing ("I don't have a reference for myself, so here, find Sender in this ArrayList and return me the Index"), I'd take it. That feels very obtuse to me...
Good night!
|
|
|
|
|
If it's always one main ComboBox to one secondary ComboBox, then I would use a Dictionary[^]. This way you can use the first ComboBox as the Key, then quickly obtain the secondary ComboBox (which would be the value).
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
I wish. It's an arbitrary number of "rows", each of which is composed of 10 controls.
I keep 10 ArrayLists(), one for each "column" in each row. Each ArrayList contains the control that goes in that "column" at that "row" (Index).
So at every point in my code where I need to refer to those controls, I use
. ((TypeOfControl)aNameOfArray[RowNum]).Property
Each column of controls shares an event handler. To find out which control is actually being fired upon, I have to use this:
. int i =aNameOfArray.IndexOf((TypeOfControl)sender);
Now that I have "i" (the index of this control in that specific ArrayList), I can use it to manage the other controls in that "row".
It doesn't seem so bad now, but while I was struggling with that bug I desparately wished for a shortcut like "thisControl" which I could refer to...
What would make life easier would be if ArrayList allowed multiple dimensions. However, it's really a Collection and apparently Collections don't allow that.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
