C# Discussion Boards - CodeProject

Dave Kreskowiak2-Oct-09 9:16

2-Oct-09 9:16

LimitedAtonement wrote:
Does this seem crazy to anyone else?

Crazy, no. Vaguely disappointing, yes. 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.

LimitedAtonement wrote:
I'm in Microsoft land where they take care of everything you want FOR you ... and so much more,"

Which bloody idiot told you that?

A guide to posting questions on CodeProject[^]

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

DaveyM692-Oct-09 10:38

DaveyM69

2-Oct-09 10:38

Dave Kreskowiak wrote:
Which bloody idiot told you that?

Dave

Generic BackgroundWorker - My latest article!
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Why are you using VB6? Do you hate yourself? (Christian Graus)

LimitedAtonement5-Oct-09 5:56

LimitedAtonement

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.

Dave Kreskowiak5-Oct-09 12:55

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...

Reroute an Application's Network Traffic

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

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

Re: Reroute an Application's Network Traffic

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#[^]

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

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

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.

Saksida Bojan2-Oct-09 5:30

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

2-Oct-09 5:30

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

WebMaster2-Oct-09 5:45

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

2-Oct-09 5:45

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

Saksida Bojan2-Oct-09 6:28

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

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

WebMaster2-Oct-09 6:46

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

2-Oct-09 6:46

> PInvoke to constantly monitor changes when it apears or dissapears

Please elabroate on that one. Smile | :)

Saksida Bojan2-Oct-09 7:06

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

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[^]

WebMaster2-Oct-09 20:59

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

2-Oct-09 20:59

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

Saksida Bojan2-Oct-09 22:19

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

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.

WebMaster3-Oct-09 1:01

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

3-Oct-09 1:01

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

Saksida Bojan3-Oct-09 1:49

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

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

WebMaster3-Oct-09 4:34

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

3-Oct-09 4:34

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

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

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

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...

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