Re: using aggregate functions - C# Discussion Boards

Re: redim preserve...in c#?

Tamimi - Code28-Aug-06 2:59

Tamimi - Code

28-Aug-06 2:59

hi C# can't dynamically resize an array.
try to use the array list

Tamimi - Code

Re: redim preserve...in c#?

Guffa28-Aug-06 3:17

Guffa

28-Aug-06 3:17

The "ReDim Preserve" functionality is intentionally left out in .NET, as there is no other way of resizing an array than to create a new array and copy the elements from the old array.

There are methods in the Array class to copy the elements, but there is no "Resize" method that would hide this resource consuming task from view. If you really want to do this, you can, but you can't do it "by mistake".

As Tamimi said, you should use an ArrayList instead, as it automatically grows as needed. Or better yet, if you are using .NET 2, use a generic list to make the code type safe.

---
b { font-weight: normal; }

Re: redim preserve...in c#?

Roger Alsing28-Aug-06 3:56

Roger Alsing

28-Aug-06 3:56

It should be noted that the arraylist uses arrays internally and it does the same as described above.
So creating new arrays and copy its content is not slower than using the arraylist.

but do use the lists since they are already created for this purpose, but dont expect them to be any faster..

//Roger

http://www.puzzleframework.com

Re: redim preserve...in c#?

Not Active28-Aug-06 4:04

Not Active

28-Aug-06 4:04

2.0 does have a Resize method

int[] arr = {1,2,3,4,5,6,7,8,9};
Array.Resize(ref arr, 3);
or
Array.Resize(ref arr, 20);

only two letters away from being an asset

Re: redim preserve...in c#?

Judah Gabriel Himango28-Aug-06 4:22

Judah Gabriel Himango

28-Aug-06 4:22

There is the static System.Array.Resize method, however, as others have stated, if you need to be resizing lists, your best bet is to use the System.Collections.Generic.List object.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Dumbest. Movie. Title. Evaaar.
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: redim preserve...in c#?

Dave Doknjas28-Aug-06 15:07

Dave Doknjas

28-Aug-06 15:07

Yes, you can resize arrays while preserving existing contents in C#:
http://www.tangiblesoftwaresolutions.com/Articles/CSharp%20Equivalent%20to%20VB%20ReDim%20Preserve.htm[^]

However, as others have mentioned you may want to use an ArrayList(2003) or a generic List (2005) instead.

David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
Instant C++: C# to C++ converter, VB to C++ converter
Clear VB: Cleans up VB.NET code
C# Code Metrics: Quick metrics for C#

using aggregate functions

haseeb_saeed28-Aug-06 1:59

haseeb_saeed

28-Aug-06 1:59

hello
i have started a small database application and i want to use the aggregate function (max) to find the maximum id in a table that is placed inthe dataset named ds.... i searched through alot of books but am unable to do so... though a result set execute scalar would help me to write the statement but i want it to be executed on a data set....
thankyou

haseeb

Re: using aggregate functions

Nader Elshehabi28-Aug-06 3:15

Nader Elshehabi

28-Aug-06 3:15

Hello

if you're dealing with a datatable in a dataset, why not trying something like this

int Max = 0;
foreach(DataRow MyRow in MyDataTable.Rows)
{
    if((int)MyRow.ItemArray[MyIndex].Value > Max)
        Max = (int)MyRow.ItemArray[MyIndex].Value;
}

I hope I got you right

Regards

TextBox filling in Crystal Reports VS2005

Glen Harvy28-Aug-06 1:44

Glen Harvy

28-Aug-06 1:44

Hi,

Slightly off topic - if you know of a good place elsewhere to ask then please let me know Smile | :)

I want to put a textbox or field into a crystal report and that textbox is filled by reading in a text file at run time. To clarify, a user types in their text which could be several pages using their favourite wordprocessor and then the contents are incorporated into the Crystal Report generated by the program in much the same way as database fields are.

Is this possible?

If not, are there any alternatives to achieving the same end result?

Glen Harvy

Re: TextBox filling in Crystal Reports VS2005

~~~Johnny~~~28-Aug-06 3:58

~~~Johnny~~~

28-Aug-06 3:58

In older versions of Crystal the answer was no although you could have tried working with OLE objetcs (not recommended, it was a nightmare!) but now with the latest versions you can write VB code that should permit you to do what you want. I think you need at least version 10, or maybe version 9 can't rmenber exactely when VB code was introduced.

Re: TextBox filling in Crystal Reports VS2005

Glen Harvy28-Aug-06 5:34

Glen Harvy

28-Aug-06 5:34

Thanks for the response.

~~~Johnny~~~ wrote:
with OLE objetcs (not recommended, it was a nightmare!)

I was looking at this and I think you're right Hmmm | :|

~~~Johnny~~~ wrote:
least version 10,

That's the version that ships with VS2005 - or at least a cut down version anyway.

Any idea where I may be able to find somewhere on the net that tells me how to do it?

Glen Harvy

Re: TextBox filling in Crystal Reports VS2005

~~~Johnny~~~28-Aug-06 6:23

~~~Johnny~~~

28-Aug-06 6:23

Personnaly I lloked at the version that ships with VS and ordered the full version right away. There is no way you will create reports with this version if you want to use the features of Crystal Reports. In the shipped version you have to prepare your data before hand and then create the report besed on that.
If you feel you need more help try the http://www.businessobjects.com but again, any help you get from there might not apply as you don't have the full version.

Word color problem [modified]

jithen_dt28-Aug-06 1:22

jithen_dt

28-Aug-06 1:22

-------------------------------------------------------------------
I am reading pixel by pixel from a image, creating a color object corresponding to that pixels color and witing a "." into a word file and coloring it with the same color as the pixel.

But Word.wdColor has only 60 colors I am not able to relate the color object with Word.wdColor enum.
-------------------------------------------------------------------

Every is Illusion

Re: Word color problem

Nader Elshehabi28-Aug-06 1:29

Nader Elshehabi

28-Aug-06 1:29

Hello

Try to transform it to the closest color using its RGB value.

Regards

Capturing TAB event of a button Button

Kais4U28-Aug-06 1:13

Kais4U

28-Aug-06 1:13

Hi All,

I have a button on my form. When the button is selected and TAB is hit, am not able to capture this event. How can I capture the tab event on a button?

Its urgent, anykind of help is highly appreciated .

Thanks in advance

Regards
Kais

Re: Capturing TAB event of a button Button

Navi1528-Aug-06 1:28

Navi15

28-Aug-06 1:28

Check out this link

http://www.wdvl.com/Authoring/Scripting/Tutorial/java_event_others.html

Hope it will help u

Navi

Re: Capturing TAB event of a button Button

Kais4U28-Aug-06 1:34

Kais4U

28-Aug-06 1:34

Thanks Navi,

The link you provided holds good for JAVA but not for C#.
Let me know if you can help me out in C#.

Regards
Kais

Re: Capturing TAB event of a button Button

Andrei Ungureanu28-Aug-06 1:33

Andrei Ungureanu

28-Aug-06 1:33

Hi,
The only way I could capture the TAB key was on the KeyUp event

Do your best to be the best

Re: Capturing TAB event of a button Button

Kais4U28-Aug-06 1:38

Kais4U

28-Aug-06 1:38

The keyup event does not get fired if you select the button and hit tab. The only event gets fired is the leave event.

Re: Capturing TAB event of a button Button

Nader Elshehabi28-Aug-06 1:52

Nader Elshehabi

28-Aug-06 1:52

Hello

The best thing to do, I believe, would be to handle the LostFocus event. It will be fired when the button loses focus whether by the tab key or the mouse.

Isn't this what you want? If not, please give more details.

Regards

Re: Capturing TAB event of a button Button

Kais4U28-Aug-06 2:00

Kais4U

28-Aug-06 2:00

Hi,

Thank you for your quick response.
As you mention, the lost focus (Leave event for the button) will get fired for both key board and mouse movements.

I explicitly need to capture Tab event generated on the button so that I can set the focus to some other control on the form. The reason is, Am using MDI form and displays two child windows side by side. On the first child window, when the focus is on the last control and the user clicks on TAB, the focus should go to the first control of second child window.

Hope things are clear and you might be in able to help me out.

Thanks

Regards
Kais

Re: Capturing TAB event of a button Button

Nader Elshehabi28-Aug-06 2:26

Nader Elshehabi

28-Aug-06 2:26

Hello

If you are using .Net 2.0 framework, handle the PreviewKeyDown event

private void MyButton_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e)
        {
            if (e.KeyData == Keys.Tab)
                MessageBox.Show("Tab");//Your code goes here!!
        }

I hope this helps Smile | :)

Regards

Re: Capturing TAB event of a button Button

Martin#28-Aug-06 2:34

Martin#

28-Aug-06 2:34

I think I have to change to .Net 2.0.

Thats a great Event.

Thanks for that post.

Martin

Re: Capturing TAB event of a button Button

Martin#28-Aug-06 2:01

Martin#

28-Aug-06 2:01

Hello,

Do you whant to navigate with the Tab Key?

Re: Capturing TAB event of a button Button

Kais4U28-Aug-06 2:06

Kais4U

28-Aug-06 2:06

Yes, I need to navigation on the screen thru TAB.

Actually, Its MDI form and has two child windows displays side by side. On the first child window, when the focus is on the last control and the user hits TAB, the focus should go to the first control of the second child form.

Thanks in advace for all your suggestion/help

Regards,
Kais

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