C# Discussion Boards - CodeProject

Re: TreeView Multiple Column Microsoft Control

LimitedAtonement5-Oct-09 5:56

5-Oct-09 5:56

Dear Mr. Kreskowaik,

I think the control that I described shouldn't be one that would be much different from implementation to implementation. To me, it would be like saying, ``the ListView is useless: it only approximates my needs,'' or something like that, when really it's plenty generic enough to meet my needs just fine in every circumstance (if I have to finagle my classes to fit into it sometimes). That to say, I would much rather Microsoft give me an in-box multicolumn treeview control which would be MUCH easier to do the finagling rather than creating a whole new one! Oh well, I'll keep working on the one from the website.

In Christ,
Aaron Laws

Dave Kreskowiak wrote:
But, all for the better if I can find a contorl that exactly matches my needs instead of one that only approximates what I need.

Re: TreeView Multiple Column Microsoft Control

Dave Kreskowiak5-Oct-09 12:55

Dave Kreskowiak

5-Oct-09 12:55

LimitedAtonement wrote:
the ListView is useless: it only approximates my needs,''

I didn't say that. I said that I would rather find a 3rd party control that comes as close as possible to my needs and not rely on Microsofts implementation which only generally does what I need. You use the correct tool in the draw for the job at hand. If you want to go through all the pain of hanging additional functionality on a general MS control, more power to you. But, I'll use the one that is already pretty close if not dead on to what I need without spending the extra money on developing my own. Trust me, I do that enough already. When it costs me, say, $395 to get a control that does what I need, why should I spend 100 hours at, say, $40 an hour ($4,000) developing a control to do the same thing?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: TreeView Multiple Column Microsoft Control

Mycroft Holmes2-Oct-09 15:23

Mycroft Holmes

2-Oct-09 15:23

LimitedAtonement wrote:
I'm in Microsoft land

You're giving them (MS) delusions of competence, you are going to have to buy or roll your own. Infragistics do a nice one but their object model is a little overwhelming.

Never underestimate the power of human stupidity
RAH

Reroute an Application's Network Traffic

Zaegra2-Oct-09 6:04

Zaegra

2-Oct-09 6:04

Hello,

I'd like to know if it's possible to "wrap" a running process, and get all it's Outgoing network traffic? E.g when I'm playing a game, trap its network traffic and send it to a different server? Blush | :O

PS: This is not used for any form of hacking.

Thanks in advance,
Zaegra

Motivation is the key to software development.

Re: Reroute an Application's Network Traffic

Saksida Bojan2-Oct-09 6:38

Saksida Bojan

2-Oct-09 6:38

for redirecting it is possible if it doesn't use direct IP accsess
C:\WINDOWS\system32\drivers\etc

inside there is a file named host (Without extension).
You can redirect a specific DNS name to specific IP
If you type www.google.com it will automatlcly go to 209.85.129.147, because it is on DNS server.
If you put in host file
127.0.0.1 www.google.com
and then you save that file.
After that all links that try to use www.google.com will look only on your machine. (127.0.0.1 is localhost)

For monitoring look at Packet Monitor C#[^]

Re: Reroute an Application's Network Traffic

Zaegra2-Oct-09 7:01

Zaegra

2-Oct-09 7:01

Thanks! I will try this Big Grin | :-D

Motivation is the key to software development.

Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

WebMaster2-Oct-09 4:58

WebMaster

2-Oct-09 4:58

How can I do it? I have a custom borderless form that I want to not overlap the taskbar when maximized, and I was told that it is possibly to prevent that through the use of WM_GETMINMAXINFO + WndProc. Is it really possible, and if so, how?

Thanks.

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

Saksida Bojan2-Oct-09 5:30

Saksida Bojan

2-Oct-09 5:30

Are you coding in C#?
As i see your question, it shoud belong into c/c++/mfc board

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

WebMaster2-Oct-09 5:45

WebMaster

2-Oct-09 5:45

Yes, I'm very much coding in C#.

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

Saksida Bojan2-Oct-09 6:28

Saksida Bojan

2-Oct-09 6:28

I would do this whay:

this.FormBorderStyle = FormBorderStyle.Sizable; // Set the borders
this.WindowState = FormWindowState.Maximized; // Maximize so that it occupies worker area
this.MaximumSize = this.Size; // Set maximum size of Form while it has borders
this.FormBorderStyle = FormBorderStyle.None; // Removes borders and the MaximumSize prevents covering taskbar

This whay it can be seen with a border with less than a second. If you want to avoid and get the screen size, you need to use PInvoke of SystemParametersInfo with Constant SPI_GETWORKERAREA
and you could get the size of worker area. Also there can be problems when you have AutoHide enabled for taskbar. If you have then i suggest using PInvoke to constantly monitor changes when it apears or dissapears

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

WebMaster2-Oct-09 6:46

WebMaster

2-Oct-09 6:46

> PInvoke to constantly monitor changes when it apears or dissapears

Please elabroate on that one. Smile | :)

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

Saksida Bojan2-Oct-09 7:06

Saksida Bojan

2-Oct-09 7:06

http://www.codenewsgroups.net/group/microsoft.public.vb.general.discussion/topic17919.aspx[^]

This link shows how to get Worker Area through API (VB.NET)
You coud put that checking into a thread, so that if worker area is changed then you coud force to redraw with larger working area

Here is another link[^]

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

WebMaster2-Oct-09 20:59

WebMaster

2-Oct-09 20:59

Sorry, but those didn't really help me.
Any ideas on WM_GETMINMAXINFO?

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

Saksida Bojan2-Oct-09 22:19

Saksida Bojan

2-Oct-09 22:19

protected override void WndProc(ref Message m)<br />
{<br />
if (m.Msg == 36) // This code is for WM_GETMINMAXINFO<br />
{<br />
// Do Something<br />
}<br />
base.WndProc(ref m);<br />
}

this is from sdk:
The WM_GETMINMAXINFO message is sent to a window when the size or position of the window is about to change. An application can use this message to override the window's default maximized size and position, or its default minimum or maximum tracking size.

A window receives this message through its WindowProc function.

You can also look into events as ResizeBegin and Move. Althou when i have overriden WndProc, my Form didn't open

Why it didn't help. I have tested and my taskbar wasn't hidden.

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

WebMaster3-Oct-09 1:01

WebMaster

3-Oct-09 1:01

Hmm, I probably did it wrong then. Can you show me your code?

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

Saksida Bojan3-Oct-09 1:49

Saksida Bojan

3-Oct-09 1:49

this.FormBorderStyle = FormBorderStyle.Sizable; // Set the borders
this.WindowState = FormWindowState.Maximized; // Maximize so that it occupies worker area
this.MaximumSize = this.Size; // Set maximum size of Form while it has borders
this.FormBorderStyle = FormBorderStyle.None; // Removes borders and the MaximumSize prevents covering taskbar

I used this code in on load event. When i set the form Maximum size, even if you maximize it won't go beyond MaximumSize property

Re: Handling WM_GETMINMAXINFO to prevent borderless forms overlapping taskbar when maximized

WebMaster3-Oct-09 4:34

WebMaster

3-Oct-09 4:34

Thanks, that worked. Love you Laugh | :laugh:

not able to read data from excel sheet using Microsoft.Office.Interop.Excel

PrasannaKulkarni2-Oct-09 4:34

PrasannaKulkarni

2-Oct-09 4:34

I do have code which is reading the data from an excel sheet properly. but have a weird issue.

If the excel sheet has a column containing long numbers data eg. 89.00000001 and if that column is not resized to its max, that cell is displaying "#####" if you open the excel sheet. So my application code is also reading it as "#####" instead of the correct data. If i resize that column to display the data properly and save, then my application code is reading the data correctly.

I can have my users to have the input excel sheet have all the columns maximized, but was wondering if there any way to have it done programmatically.

Do let me know.

My code snippet is :
// get data in cell
for (int i = 2; i <= iValue; i++)
{
dr = ds.Tables["dtExcel"].NewRow();
for (int j = 1; j <= jValue; j++)
{
oRng = (Microsoft.Office.Interop.Excel.Range)oSheet.Cells[i, j];
string strValue = oRng.Text.ToString();
dr[j-1] = strValue;
}
ds.Tables["dtExcel"].Rows.Add(dr);
}
return ds;

Thanks
Prasanna

Re: not able to read data from excel sheet using Microsoft.Office.Interop.Excel

Dave Kreskowiak2-Oct-09 5:28

Dave Kreskowiak

2-Oct-09 5:28

PrasannaKulkarni wrote:
89.00000001 and if that column is not resized to its max, that cell is displaying "#####" if you open the excel sheet. So my application code is also reading it as "#####" instead of the correct data.

This isn't really possible unless you've doing something very wrong. If you get the Value of the cell, you get the value. The "######" you see is strictly limited to the display of the value, not the value itself.

As I look at your code, I see you're getting the Text property of the cell, not it's Value.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: not able to read data from excel sheet using Microsoft.Office.Interop.Excel

PrasannaKulkarni2-Oct-09 6:19

PrasannaKulkarni

2-Oct-09 6:19

appreciate your so quick response.
Me excel document has everything from text values to numeric values. Whats the right way to read the data?

Prasanna

Re: not able to read data from excel sheet using Microsoft.Office.Interop.Excel

Dave Kreskowiak2-Oct-09 7:05

Dave Kreskowiak

2-Oct-09 7:05

Read both and analyze what you've got. You should already expect certain types over values in certain ranges of cells. If you expect a certain cell to have a numeric value, you should only be looking at the Value property of that cell. You still need to validate what you get from it though.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Cannot convert from system...IList<class> to class[]</class>

Sevententh2-Oct-09 4:09

Sevententh

2-Oct-09 4:09

Please could somebody help... My brains gone dead D'Oh! | :doh:

I'm trying to pass the following to a wcf service

public IList<tbItem> GetItemsWhereIn (IList<tbClass> iclass)
{
iServiceClient svc = new iServiceClient();
IList<tbItem> list = svc.FindItems(iclass);

return list;
}

The problem is passing parameter iclass to svc.FindItems
error Cannot convert from system...IList<tbClass> to tbClass[]

The wcf service is setup as

public interface iService{
[OperationContract]
List<tbItem> FindItems(IList<tbClass> iclass);}

And the linq query as

public List<tbItem> FindItems(IList<tbClass> iclass)
{
...linq code working correctly
}

If you could point the way I would be very greatful Big Grin | :-D

Re: Cannot convert from system...IList to class[]

Keith Barrow2-Oct-09 4:19

Keith Barrow

2-Oct-09 4:19

I think you need to tell the Client Service Reference to generate the Client proxy using genertic Lists rather than arrays (Lists<T>, IList<T> and other collection types are normally sent up and down the wire as T[] unless you tell the service reference to generate the proxy with something else:

Right click your service reference
Select Configure Service Reference
In the Collection Type drop down select System.Collections.Generic.List

Note that you can't set the Value to IList<T> as Services don't play well with Interfaces / OO in general.

CCC solved so far: 2 (including a Hard One!)

Re: Cannot convert from system...IList to class[]

Sevententh5-Oct-09 23:27

Sevententh

5-Oct-09 23:27

Thanks for answer, this did the trick

I just needed to then change this line

IList<tbItem> list = svc.FindItems(iclass.ToList());

Odd behaviour when selecting item in a Combobox [Fixed it, my fault]

Anthony Mushrow2-Oct-09 4:07

Anthony Mushrow

2-Oct-09 4:07

I have a List<MyClass> I use this list to populate a combo box so that the user can select an item from the list, and I can easily grab which one they selected:

onSelectedIndexChanged(...)
{
  this.currentItem = this.comboBox.SelectedItem as MyClass;
}

The strange thing is, when you first select an item from the list, the box doesn't display any text. If you select the same item again, it does.
The box will only display the correct text if you select the same item twice in a row, and everything works as normal when I don't set this.currentItem

Upon further testing it seems to happen when I access properties on the instance of MyClass right after selecting it. If I comment out a bunch of code the combo box works fine, although it's only reading a few values nothing is actually being changed, not that I see how it could make any difference.

Does anybody have any idea what's going on?

EDIT: I know what it was, purely my fault. When an item was selected a numeric up down control was set with a value from that item, this triggered the ValueChanged event, which reset the value back to the item, and triggered Sort on my list, which clears out and refills the combo box with the items in the new order. Bit of a pain in the arse really, I must pay more attention in future D'Oh! | :doh:

My current favourite word is: Delicious!

-SK Genius

Game Programming articles start -here[^]-

modified on Friday, October 2, 2009 10:15 AM

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