DTS package - C# Discussion Boards

RobertVG1-Jul-04 5:18

1-Jul-04 5:18

I would like to allow my users the opportunity to update changes on a control in a particular tab when they try to leave. To do this I use the user control thats loaded into the tab's Validating event (Catching the event in the tabbedcontrol itself will not find the changes). The event is caught and a dialog box is fired off to ask whether or not theyd like to leave.

Problem 1: the Validating event is fired twice when a user tries to leave the tab.

Problem 2: the call to e.cancel = true gets enforced not on the two times when its leaving, but rather when the tab is getting the focus once again, ie the cancel call doesnt do anything until you leave the tab and then try and come back.

Any suggetions?

Thank You
Robert

TabbedControl Validation

RobertVG1-Jul-04 11:32

RobertVG

1-Jul-04 11:32

yeah so this absolutely does not work

// In C#
private void tabPage1_Validating(object sender, System.ComponentModel.CancelEventArgs e)
{
e.Cancel = true;
}

And it will get called twice before the focus actually leaves the tab, which its allowed to do. Then attempting to return to that tab, it will cancel.

Any ideas?

Windows Forms and Role Based Security

OMalleyW1-Jul-04 5:14

OMalleyW

1-Jul-04 5:14

I thought I would post this just in case anyone was wondering how to go about doing Role based security with windows forms

Now most of the applications that I have written have been on the web so Role based security was ease
if (User.IsInRole("Power Users"))
{
.. code here
}

Now I am doing a windows application that requires Role based security..
So here is what I did..

public System.Security.Principal.WindowsPrincipal User;
this.User = new System.Security.Principal.WindowsPrincipal(System.Security.Principal.WindowsIdentity.GetCurrent() );

if (User.IsInRole("Power Users"))
{
.. code here
}
thats it!! easy stuff..

well like I said, I just wanted to post this for anyone who may need it.

Will

Word 2003

Giles1-Jul-04 4:34

Giles

1-Jul-04 4:34

Anyone tried launching a copy of Word 2003 using Process.Start. You may be interested to find that Word for some reason, spaws a seperate copy of itself in another process, and the handle that you have in the code immediately exits. Hmmm. Not the case for Excel. Just wondering what MS's logic was with that one.

"Je pense, donc je mange." - Rene Descartes 1689 - Just before his mother put his tea on the table.

Shameless Plug - Distributed Database Transactions in .NET using COM+

How to find out printable area?

Pain_Elemental1-Jul-04 4:19

Pain_Elemental

1-Jul-04 4:19

I'm trying to find out the printable area of my printer.

The first try was this:

void OnPrintPageBoard(object obj, PrintPageEventArgs ppea)
{
    Graphics   grfx  = ppea.Graphics;
    grfx.PageUnit = GraphicsUnit.Millimeter;

    RectangleF rectf = new RectangleF(
        ppea.MarginBounds.Left -
        (ppea.PageBounds.Width - grfx.VisibleClipBounds.Width) / 2,
        ppea.MarginBounds.Top -
        (ppea.PageBounds.Height - grfx.VisibleClipBounds.Height) / 2,
        ppea.MarginBounds.Width,
        ppea.MarginBounds.Height);

    Pen myPen = new Pen(Color.Black,1);
    grfx.DrawRectangle(myPen,rectf.X, rectf.Y,rectf.Width,rectf.Height);
}

But this didn't work at all.
Second try was this:

void OnPrintPageBoard(object obj, PrintPageEventArgs ppea)
{
    Graphics   grfx  = ppea.Graphics;

    RectangleF rectf = new RectangleF(
        ppea.MarginBounds.Left -
        (ppea.PageBounds.Width - grfx.VisibleClipBounds.Width) / 2,
        ppea.MarginBounds.Top -
        (ppea.PageBounds.Height - grfx.VisibleClipBounds.Height) / 2,
        ppea.MarginBounds.Width,
        ppea.MarginBounds.Height);

    //get printable area in millimeters
    double dPrintableAreaX  = PrinterUnitConvert.Convert(rectf.X, PrinterUnit.Display, PrinterUnit.TenthsOfAMillimeter)/10;
    double dPrintableAreaY  = PrinterUnitConvert.Convert(rectf.Y, PrinterUnit.Display, PrinterUnit.TenthsOfAMillimeter)/10;
    double dPrintableAreaWidth  = PrinterUnitConvert.Convert(rectf.Width, PrinterUnit.Display, PrinterUnit.TenthsOfAMillimeter)/10;
    double dPrintableAreaHeight  = PrinterUnitConvert.Convert(rectf.Height, PrinterUnit.Display, PrinterUnit.TenthsOfAMillimeter)/10;

    //switch output to millimeters
    grfx.PageUnit = GraphicsUnit.Millimeter;

    Pen myPen = new Pen(Color.Black,1);
    grfx.DrawRectangle(myPen, (float)dPrintableAreaX, (float)dPrintableAreaY, (float)dPrintableAreaWidth, (float)dPrintableAreaHeight);
}

This worked, but the rectangle is way smaller than I expected! If I draw for example like grfx.DrawRectangle(myPen, 0, 0, 100, 100), the rectangle is more at the border of the page.

I also don't understand, why the values of the rectf of my first example don't have the same value as dPrintableAreaX,dPrintableAreaY,dPrintableAreaWidth,dPrintableAreaHeight of my second example. Should be millimeters either way, shouldn't it?

Best Regards
Bernd R.

The light at the end of the tunnel has been switched off temporarily due to budget problems...

Re: How to find out printable area?

Pain_Elemental1-Jul-04 4:37

Pain_Elemental

1-Jul-04 4:37

Now I got it:

void OnPrintPageBoard(object obj, PrintPageEventArgs ppea)
{
    Graphics   grfx  = ppea.Graphics;

    //get printable area in millimeters
    double dPrintableWidth = PrinterUnitConvert.Convert(grfx.VisibleClipBounds.Width, PrinterUnit.Display, PrinterUnit.TenthsOfAMillimeter)/10;
    double dPrintableHeight = PrinterUnitConvert.Convert(grfx.VisibleClipBounds.Height, PrinterUnit.Display, PrinterUnit.TenthsOfAMillimeter)/10;

    //switch output to millimeters
    grfx.PageUnit = GraphicsUnit.Millimeter;

    Pen myPen = new Pen(Color.Black,1);
    grfx.DrawRectangle(myPen, 0, 0, (float)dPrintableWidth, (float)dPrintableHeight);
}

Printing is hard! Big Grin | :-D

----------------------------
The light at the end of the tunnel has been switched off temporarily due to budget problems...

Re: How to find out printable area?

misterbear1-Jul-04 23:05

misterbear

1-Jul-04 23:05

you also might wanna check this out:

http://www.codeproject.com/csharp/DotNetprinterbounds.asp

it's about finding the true printer margins of a printer, since these vary from printer to printer and (from what I know of)
can't be found through the .NET framework.

DTS package

Member 11509011-Jul-04 2:47

Member 1150901

1-Jul-04 2:47

I have to transfer a data base from old to new one in batch.
I am working with the Data transformation services at the sql server.
How can i run/excute a dts package from a stored procedure or from the query analyzer? .
Is it possible?, I know i can do it from the command prompt but it does't help me
Thanks in advance

Be Good...
Dudi

Re: DTS package

Nick Parker1-Jul-04 4:07

Nick Parker

1-Jul-04 4:07

Dudi ben shimon wrote:
How can i run/excute a dts package from a stored procedure or from the query analyzer? .

This may have been better suited for the SQL / ADO / ADO.NET[^] forum, but read the following article to explain how to do this:

Execute DTS packages from within T-SQL[^]

- Nick Parker
My Blog | My Articles

Pocket PC\Telnet

Schkin30-Jun-04 23:43

Schkin

30-Jun-04 23:43

I've recently started a new job, where they have purchased pocket pc devices with the intent of communicating with their unixware server over GPRS. This is fine and lends itself well to their intended application. The problem is they want to do this via Telnet! To me this sounds crazy but they insist on doing it this way. How is it possible using C# on Pocket PC for me to communicate via Telnet in a controlled fashion so that I may handle dropped GPRS to their server!
I'd really love to hear ideas on the subject ans possible sugestions!

Schkin

Re: Pocket PC\Telnet

Mike Dimmick1-Jul-04 0:04

Mike Dimmick

1-Jul-04 0:04

Telnet is Evil. Your major problem is that there's no way to pick up a dropped session - the session is tied intimately to the state of the TCP connection: lose the connection, lose the session.

This probably isn't the answer you want to hear, but I recommend implementing the Telnet client as a server process on a server somewhere, then implementing some reconnectable protocol, that allows you to specify a session to reconnect to, between the handheld and the front-end server.

I assume that the point of connecting to the Unixware server over Telnet is to scrape data from the screen? Implementing the screen-scraping in the server would be more sensible, IMO; you could implement the handheld-to-server interface using a Web service. You could probably convince your admins that exposing a web service over HTTP/HTTPS is more secure than exposing direct access to Telnet over the internet (even if you're going to use a VPN).

Stability. What an interesting concept. -- Chris Maunder

The FlexGrid component

saud_a_k30-Jun-04 23:34

saud_a_k

30-Jun-04 23:34

Hello big guys,
I remember using a FlexGrid in VB6, I want to use a component like that in C#.
I know there is that component for sale... I can't buy that in my MP.
All I need to do is to have rows to enter text.. like in Exel.
I cannot use a multiline textbox.
HELP!

_____________________________________________________
Believe! Every thing has a purpose

Re: The FlexGrid component

Nick Parker1-Jul-04 4:18

Nick Parker

1-Jul-04 4:18

Check out the DataGrid Class[^] on MSDN.

- Nick Parker
My Blog | My Articles

Re: The FlexGrid component

saud_a_k1-Jul-04 18:19

saud_a_k

1-Jul-04 18:19

yes I went through that last night, but I can find only the database connectivity & property modification. All I want is a row-ised text box.!

_____________________________________________________
Believe! Every thing has a purpose

Re: The FlexGrid component

saud_a_k1-Jul-04 23:44

saud_a_k

1-Jul-04 23:44

Ok thanx..
I found an article on the net to make a datagrid to a flexigrid.. (like I wanted)
but I have to add data to it, & this can be done only through an ArrayList. http://www.c-sharpcorner.com/Code/2004/June/ObjectDataGridBinding.asp[^], gives a way to do it.. but I cannot get an Idea of wats happening..
the code is

//.. form load class & fun
ArrayList list = new ArrayList();
list.Add(new BindingObject(1, "One", null)); //..constructer alright
list.Add(new BindingObject(2, "Two", null));
list.Add(new BindingObject(3, "Three", "NULL"));
dataGrid1.DataSource = list;
//......

public class BindingObject
		{
			private int intMember;
			private string stringMember;
			private string nullMember;

			public BindingObject(int i, string str1, string str2)
			{
				intMember = i;
				stringMember = str1;
				nullMember = str2;
			}

			public int IntMember
			{
				get { return intMember; }
			}
			public string StringMember
			{
				get { return stringMember; }
			}
			public string NullMember
			{
				get { return nullMember; }
			}
		}

What's happening here!!
Help!!

_____________________________________________________
Believe! Every thing has a purpose

Before Resize

bouli30-Jun-04 22:55

bouli

30-Jun-04 22:55

Hi gurus,

I would like to know if there is an event BEFORE the Resize event?

I would like to get the window location (this.Location) just before the window state (this.WindowState) changes from FormWindowState.Normal to FormWindowState.Maximized or FormWindowState.Minimized.

When the Resize event is raised, the this.Location has already changed to the new one. I would like to get this value (this.Location) before it is changed.

Thanks.

Best regards.

There is no spoon.

Re: Before Resize

Heath Stewart1-Jul-04 4:56

Heath Stewart

1-Jul-04 4:56

You have to override WndProc, handle the WM_SIZING (0x0214) notification message, and set Message.Result to new IntPtr(1) (TRUE) in order to cancel it.

If all you want to do is prevent resizing, set the FormBorderStyle to FormBorderStyle.FixedDialog and set the MaximizeBox and MinimizeBox properties to false. These are all properties on the Form.

Microsoft MVP, Visual C#
My Articles

Re: Before Resize

bouli1-Jul-04 5:00

bouli

1-Jul-04 5:00

Hi Heath,

I don't want to cancel the Resize event, I want to save the Location of the window before the Resize event is raised.

I'm going to try to handle the WndProc method as you said.

Thanks.

There is no spoon.

Re: Before Resize

Dave Kreskowiak1-Jul-04 5:24

Dave Kreskowiak

1-Jul-04 5:24

WEll, the problem with using the WM_SIZING message is that it is fired continuously as the window is being resized. So now you have to set a flag when the first WM_SIZING message hits you so you don't coninuously save the Location of the window as it's being resized. I can't remember off the top of my head, but I think after the user let's go of the mouse, you'll get a WM_SIZE (not WM_SIZING) message with the final dimensions of the client area of the window. You might be able to use that message to reset the flag you set under WM_SIZING... Unsure | :~

I THINK!

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

Re: Before Resize

bouli1-Jul-04 5:35

bouli

1-Jul-04 5:35

I have to handle the WndProc and the WM_SYSCOMMAND message.
how can I define constants in C# like

#define SC_MINIMIZE     0xF020
#define SC_MAXIMIZE     0xF030

thanks.

There is no spoon.

Re: Before Resize

Dave Kreskowiak1-Jul-04 5:49

Dave Kreskowiak

1-Jul-04 5:49

Just delcare them as constants:

private const int SC_MINIMIZE = 0xF020;
private const int SC_MAXIMAIZE = 0xF030;

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

Re: Before Resize

bouli1-Jul-04 5:44

bouli

1-Jul-04 5:44

ok, it works now Smile | :)

thanks!

There is no spoon.

Re: Before Resize

Anonymous1-Jul-04 8:18

Anonymous

1-Jul-04 8:18

Just an idea. Wouldnt it have worked if you saved the window location when the program starts. Then in the resize event you save the new resized location. So everytime the resize event happens you can access the data from the previous resize.

Re: Before Resize

bouli1-Jul-04 9:33

bouli

1-Jul-04 9:33

Hi,

I would not do that. One possible way I have done is the following:
- 1) when loading
* a) initialize the default value of the state, size, location of the window
* b) try to read values from the saving location (ini file, xml file, registry...)
* c) if succeed to read the values, assign these values to the current window
- 2) when closing
* a) save the state of the window to the saving location
* b) if the window is not minimized or not maximized (set to normal),
save the current size and location to the saving location
else
save the size and location that was read just before maximize or minimize.

to save the size and location of the window just before being maximize, as Heath suggested, I override the WinProc method and processed the WM_SYSCOMMAND message if the WParam of the WM_SYSCOMMAND is SC_MAXIMIZE or SC_MINIMIZE then we save the size and location of the window before calling the base.WinProc method.
And it works just fine.
This is the usual way in C++, so it's the same logic in C#.

Best regards.

There is no spoon.

WMI problem on Windows 98

sachinkalse30-Jun-04 22:12

sachinkalse

30-Jun-04 22:12

Why the following code throws System.Management exception on windows 98?
------------------------------------------------------------------------------------
ManagementObjectSearcher searcher = new ManagementObjectSearcher("SELECT * FROM Win32_Printer");
------------------------------------------------------------------------------------

though i have added the following namespaces at the befining of the form

using System.Management;
using System.Management.Instrumentation;

please guide

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