Re: Sorting? algorithm - C# Discussion Boards

2-Feb-06 7:33

Assuming your table contains an Identity column ..

create procedure EmployeeCreate (@name varchar(20), @dept varchar(20), @employeeid numeric out)<br />
as<br />
begin<br />
insert into Emplyee (Name, Department) values (@name, @dept)<br />
select @employeeid = @@identity<br />
end

So when you execute your SQL command from .net and pass parameters, pass a parameter for "@employeeid". You wont need to set a value for this SqlParameter, but you'll have to set the correct Direction.

- Malhar

System Bitmaps

deepscyberpulse2-Feb-06 6:26

deepscyberpulse

2-Feb-06 6:26

Hey guys, could anyone please tell me from where i can get the windows default bitmaps for standard toolbar buttons like 'cut', 'copy', 'print', 'save',etc..... in my C# forms

Re: System Bitmaps

malharone2-Feb-06 6:31

Problems with VB 6.0 App loading .net assembly with own mdi window (message loop)...

2-Feb-06 6:31

c:\program files\vs.net\common7\graphics\...

Re: System Bitmaps

James Gupta2-Feb-06 8:30

James Gupta

2-Feb-06 8:30

If you make a toolstrip and in its options choose to embedd standard items, then the cut copy save etc appear with icons

You could search for the strings they use to get the icons in the designer file

Chris Richner2-Feb-06 6:26

Chris Richner

2-Feb-06 6:26

Our main application is written in vb 6.0. The latest module for this product is written in .net. To accomplish this our .net module expose a COM interface to start and stop the .net module from the vb 6.0 code base.

Furthermore the module needs to receive data from the vb application during the session. Otherwise the connection between both is useless. At the moment the .net module is a Inproc COM thing which runs in the same process as the vb app does.

At first glance the problem seemed just to be that the Tab key behaved strange. A few tests later we saw that the .net module opens a MDI Form but didn't create a message loop (Application.Run). A few coffees later we fixed that part and the .net module main window was finally running inside a Application.Run(new MdiMainForm()) call. Guess what, the tab problem was fixed...

I assume that the vb application message loop wasn't suitable for the .net part of the process Wink | ;)

I guess it's very strange to have such a constelation inside one process, right?

After seeking codeproject I know that the best solution would be to let the module run as an exe in his very own process, OutOfProcess as a COM Server or use one of the IPC solutions (Named Pipe, Remoting WM Messages etc..)

This seems all to be very compilcated, all I want is to start/control/stop our .net module by the vb application, any ideas?

myMsg.BehindDaKeys = "Jerry Maguire";

Sorting? algorithm

criz84262-Feb-06 6:17

2-Feb-06 6:17

This doesn't apply specifically to C#, but it is the language I am using and I did not see a better place to post this. If there is a better place, please let me know.

I have a finite, positive number of integers (in most cases between 3 and 20)
I want to split the integers into two groups such that their sums are as equal as possible (easy)

now the part that I'm having trouble with:

I want to find the top X combinations of groupings with the closest total sums (not just the top 1)

Obviously, I need calculate the sums for every possible combination, but I'm having trouble figuring out how to do this. Any ideas from veteran developers on a strategy to approach this or a recommended data structure?

EDIT:

I should add one more stipulation, the two groupings must both have the same number of elements (or one off if an odd number of total elements).

-- modified at 13:02 Thursday 2nd February, 2006

Paddy Boyd2-Feb-06 6:26

Paddy Boyd

2-Feb-06 6:26

Just to clarify - combinations of groupings (of any amount of the numbers) that have the closest possible sums with any of the other groupings (of any amount of the numbers).

This is going to work out to being a very large number of calculations/combinations... Sniff | :^)

Depending on the number of numbers of course...

-- modified at 12:27 Thursday 2nd February, 2006

criz84262-Feb-06 6:35

2-Feb-06 6:35

I should add one more stipulation, the two groupings must both have the same number of elements (or one off if an odd number of total elements).

for example, if I had elements with values: 1, 5, 19, 10
and I wanted the best 2 groupings, I would get:
{ 19, 1 }, { 10, 5 }
{ 19, 5 }, { 10, 1 }

I hope that clarifies things. It will be a fair amount of calculations, but it shouldn't be too bad because the maximum number of elements (in this case) is 20. That and I can't think of a better way :/

Guffa2-Feb-06 6:44

Guffa

2-Feb-06 6:44

Are there any limitations on the number of items in each group, or can one group have many more items as long as the totals are close?

An easy way to find all combinations is too look at each item belonging to either group as a bit value. If you have 8 items you need 8 bits to represent which group they belong to, so there are 256 (2^8) ways of dividing the items into two groups if there is no limitations on the number of items in each group.

If you place the (rather obvious) limitation that each group has to contain at least one item, you have (2^n)-2 combinations, where n is the number of items.

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

-- modified at 12:44 Thursday 2nd February, 2006

criz84262-Feb-06 7:15

2-Feb-06 7:15

I editted my main post to include the limitation that both groups must have an as-close-to-equal-as-possible number of elements.

Guffa2-Feb-06 10:46

Guffa

2-Feb-06 10:46

Which is more important then, the difference in total sum, or the difference in number of elements?

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

criz84262-Feb-06 12:26

2-Feb-06 12:26

the [lack of] diffrence in number of elements is more important

How did the user close the form?

Guffa2-Feb-06 21:43

Guffa

2-Feb-06 21:43

Then you only have to do the actual calculation for those combinations where the difference is low enough. Loop through the combinations and count the bits, and if the difference between zeroes and ones are low enough, calculate the sums. You can keep a sorted list with the best results so that you easily can add results that are better than the previous.

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

Chals2-Feb-06 4:45

2-Feb-06 4:45

Hi,

I'm doing a windows app and I need to know if the user pushed the red X button in the top right of my form.

I know the Form_closing has an enum telling the reason of the form close, but it doesnt specify if it was my own cancel button or the X button, and I need to know it.

Any ideas?

Thanks in advance

malharone2-Feb-06 5:42

2-Feb-06 5:42

public class MyForm:Form<br />
{<br />
  private bool _cancelButtonClicked = false;<br />
  private void cancelbutton_clicked(..)<br />
  {<br />
    _cancelButtonClicked = true;<br />
  }<br />
  private void form_closing(..)<br />
  {<br />
     if (_cancelButtonClicked)<br />
     {<br />
        //User clicked the button with the dialog result == cancel<br />
     }<br />
     else<br />
     {<br />
        //User clicked X button to close the form<br />
     }<br />
  }<br />
}

- Malhar

Chals2-Feb-06 5:45

2-Feb-06 5:45

Yeah, well...thanks for the reply, but I was looking for a non-flag solution, thats the easy way Smile | :)

Dave Kreskowiak2-Feb-06 5:48

Dave Kreskowiak

2-Feb-06 5:48

That's also the only way you can tell the difference.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Chals2-Feb-06 6:23

2-Feb-06 6:23

Damn...thats bad. Thanks for your help guys

microsoc2-Feb-06 22:16

microsoc

2-Feb-06 22:16

hi chals!

try this:

private const int WM_SYSCOMMAND = 0x112; 
private const int SC_CLOSE = 0xF060;

protected override void WndProc(ref Message m)
{
     if (m.Msg == WM_SYSCOMMAND && m.WParam.ToInt32() == SC_CLOSE)
     {
          //do something here
     }
}

messages under WM_SYSCOMMAND includes:
- Restore, Move, Size, Minimize, Maximize & Close (x button in the forms) or the commands in the context menu when you right click the title bar of a window.

the SC_CLOSE WParam is for the close command.

you can look for other commands in the WinUser.h file of Visual Studios. most of the time it is in "C:\Program Files\Microsoft Visual Studio .NET\Vc7\PlatformSDK\Include\" folder. It has the list of constants for API commands.

hope that helps! Smile | :)

microsoc

Chals6-Feb-06 6:37

6-Feb-06 6:37

Thanks!!! That worked like a charm

Updating MenuItems (vs2005)

microsoc6-Feb-06 14:19

microsoc

6-Feb-06 14:19

nice to know that! Smile | :)

happy coding! Smile | :)

microsoc

Mark062-Feb-06 4:41

Mark06

2-Feb-06 4:41

Hi,
just across a silly problem whilst coding.
Have a menustrip, in the following layout:

menustrip1
---------File
-------------Connect to DB
-------------Disconnect from DB

Obviously the two menuitems need to be enabled and disabled at various stages of the application.

But the problem is, I cant access them!

ok, menustrip1.Items[0] will return me the "File" menu object.
But I cant find the collection within that object to reference the menuitems.
There is no Items object and there is no dropdownitems object.

I expected to be able to do something like:
menustrip1.Items[0].items[0].enabled = true;
or even
menustrip1.items["File"].Items["Connect to DB"].Enabled = true;
but this context doesnt exist

So Anyone know?

Re: Updating MenuItems (vs2005)

Mark062-Feb-06 4:50

Mark06

2-Feb-06 4:50

Found the solution.

If anyone is interested...

<br />
            System.Windows.Forms.ToolStripMenuItem mi = (ToolStripMenuItem)menuStrip1.Items[0];<br />
            mi.DropDownItems[0].Enabled = false;

First time will return the File menu as an object, the second will drill down to the sub menuitems!! Big Grin | :-D

Re: Updating MenuItems (vs2005)

malharone2-Feb-06 5:43