C# Discussion Boards - CodeProject

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

Richard Andrew x644-May-20 10:25

4-May-20 10:25

How about this link?

This seems to explain what you're asking:

The WindowsFormsHost control - The complete WPF tutorial[^]

The difficult we do right away...
...the impossible takes slightly longer.

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

arnold_w4-May-20 10:36

arnold_w

4-May-20 10:36

Do I have to go in and make changes in the code that looks like some kind of XML or is there a way to accomplish this in the .cs-file alone?

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

Richard Andrew x644-May-20 11:48

Richard Andrew x64

4-May-20 11:48

There is no way to run a Windows Forms form inside a WPF application.

That would be like the USS Enterprise from Star Trek suddenly appearing next to the Millennium Falcon from Star Wars. It would break the space-time continuum.

The difficult we do right away...
...the impossible takes slightly longer.

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

arnold_w4-May-20 21:12

arnold_w

4-May-20 21:12

Is it possible to make them "siblings" instead of parent-child? As long the WPS-application can call delegates inside the WinForm-application it should still be useful to me.

Or could I perhaps start a new WPF-windows ( System.Windows.Application.Run(System.Windows.Window) ) that in turn contains the WinForm form (basically, make a WPF window wrap around the WinForm form)?

modified 5-May-20 3:27am.

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

arnold_w4-May-20 22:30

arnold_w

4-May-20 22:30

I just tried the following, but I got a runtime exception (System.InvalidOperationException: 'Cannot create more than one System.Windows.Application instance in the same AppDomain.')

System.Threading.Thread myThread = new System.Threading.Thread(delegate ()
{
    System.Windows.Forms.Form childFormWithItsOwnMsgPump = new System.Windows.Forms.Form();
    childFormWithItsOwnMsgPump.TopLevel = false;
    System.Windows.Forms.Integration.WindowsFormsHost host =
        new System.Windows.Forms.Integration.WindowsFormsHost();
    host.Child = childFormWithItsOwnMsgPump;
    System.Windows.Window WPFwindow = new System.Windows.Window();
    System.Windows.Application app = new System.Windows.Application();
    app.Run(WPFwindow);
});
myThread.SetApartmentState(System.Threading.ApartmentState.STA);
myThread.Start();

Suggestions are still welcome and very much appreciated.

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

Richard MacCutchan4-May-20 22:59

Richard MacCutchan

4-May-20 22:59

The message is clearly telling you that what you are trying to do is not allowed. You should use a communications link between the two applications to pass the information between them: see WinForms communicate between forms (C#) - TechNet Articles - United States (English) - TechNet Wiki[^]

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

Richard Andrew x645-May-20 13:31

Richard Andrew x64

5-May-20 13:31

Afraid not. What you're trying to do is not possible.

WPF cannot host a WinForms window, nor vice versa.

The difficult we do right away...
...the impossible takes slightly longer.

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

Richard Andrew x644-May-20 10:35

Richard Andrew x64

4-May-20 10:35

I'm sorry but it looks like I misunderstood your question.

The link I gave shows how to host Windows Forms controls in a WPF form.

But you want to run a Windows Form inside a WPF application, correct?

Pretty sure there is no way to do that. They are distinct frameworks and you can't have an instance of one framework inside another.

The difficult we do right away...
...the impossible takes slightly longer.

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

Gerry Schmitz4-May-20 14:07

Gerry Schmitz

4-May-20 14:07

You can "load" / open a Windows Form / app "from" WPF, you just have to give up on the "in WPF". WPF does not support "child" / MDI windows, even natively. Easiest way is just to make calls into a "Forms" project from a "WPF" project, with compatible frameworks.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Re: How can I open a System.Windows.Forms.Form with its own message pump from a WPF application?

arnold_w8-May-20 4:56

arnold_w

8-May-20 4:56

The following works fine:

System.Threading.Thread myThread = new System.Threading.Thread(delegate ()
{
    System.Windows.Forms.Form childFormWithItsOwnMsgPump = new System.Windows.Forms.Form();
    System.Windows.Forms.Run(childFormWithItsOwnMsgPump);
});
myThread.SetApartmentState(System.Threading.ApartmentState.STA);
myThread.Start();

C# Service to gather information from SQL

Member 119552454-May-20 3:13

Member 11955245

4-May-20 3:13

Need some guidance here -

Requirement-

I have 1000 SQL servers and I have a scheduled task running on all of those which updates a table with just an integer, let's call it X (its a sum of some numbers). Now the ask is to create some sort of ticker which updates every few mins with the sum of the total of all the X's from all the 1000 servers and display it either on a webpage or a console. So I will need a service that runs centrally and gets this data from all those 1000 servers or service which runs on all the 1000 servers which pushes this info on the central server. Can you please help with do I achieve this.

And remember if this runs centrally then it should be a multithreaded service.

modified 4-May-20 9:59am.

Re: C# Service to gather information from SQL

CHill604-May-20 3:15

CHill60

4-May-20 3:15

1000 instances of SQL Server? Or 1000 SQL Server Databases (they are not the same)

Re: C# Service to gather information from SQL

BillWoodruff4-May-20 5:08

BillWoodruff

4-May-20 5:08

Repost of question on QA: [^]

«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali

Re: C# Service to gather information from SQL

Gerry Schmitz4-May-20 14:53

Gerry Schmitz

4-May-20 14:53

You make your "central server" a web server to which you post your numbers. So, the server doesn't "get"; instead, the clients post / push.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Enable Security to Excel generated with closexml

AmitChaurasiya4-May-20 0:05

AmitChaurasiya

4-May-20 0:05

Hi,
I am trying to add password protection to my excel file using c# which is generated and downloaded after closexml data loading
pls help in this problem as soon pls

Re: Enable Security to Excel generated with closexml

Gerry Schmitz4-May-20 14:58

Gerry Schmitz

4-May-20 14:58

Unless you have Excel installed, you can't "protect" it. Zip it and password protect that. You get what you pay for.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Re: Enable Security to Excel generated with closexml

Mycroft Holmes4-May-20 21:49

Mycroft Holmes

4-May-20 21:49

Can you add password protection via interop?

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

Re: Enable Security to Excel generated with closexml

AmitChaurasiya5-May-20 21:11

AmitChaurasiya

5-May-20 21:11

"you can't "protect" it. Zip it and password protect that." This is what help me
Thank you for response

Re: Enable Security to Excel generated with closexml

Richard Deeming5-May-20 1:27

Richard Deeming

5-May-20 1:27

XLWorkbook.Protect(string workbookPassword) + overloads: output file in not protected with password. · Issue #951 · ClosedXML/ClosedXML · GitHub[^]:
Password protection to enable/disable the opening of a file is not supported with OpenXML.

You can only lock the structure and windows of an OpenXML document and that is indeed what the wb.Protect() method does.

Sheet Protection · ClosedXML/ClosedXML Wiki · GitHub[^]

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Enable Security to Excel generated with closexml

AmitChaurasiya5-May-20 14:44

AmitChaurasiya

5-May-20 14:44

I Got my points,Thank you for your response.

How to capture (read) feedback data from games in C# or C++ ( like vibration, force feedback, gunshot, explosion)

Member 113408333-May-20 21:53

Member 11340833

3-May-20 21:53

Hello,
I am creating a immersive experience system for gaming and VR. Where the system controls LED light, seat vibration, gun recoil, depending on the feedback received from the game.
Sending data from the PC to the microcontroller over USB and control all these effects is done.

I am not able to get information on how to read these feedback data from game.

Thankyou
Harikrishna

Re: How to capture feedback data from games ( like vibration, force feedback, gunshot, explosion)

Pete O'Hanlon3-May-20 21:02

Pete O'Hanlon

3-May-20 21:02

Is this for a game you are developing? If so, you would send the appropriate "feedback" message yourself. If it's for other people's games, then you probably aren't going to be able to capture this.

Advanced TypeScript Programming Projects

Re: How to capture feedback data from games ( like vibration, force feedback, gunshot, explosion)

Member 113408333-May-20 21:53

Member 11340833

3-May-20 21:53

Thank you for the replay.
I am not developing game, I wan to capture(read) feedback messages from game using C# or C++. This is to control external hardware like seat vibrate, LED light, gun recoil etc.

Re: How to capture feedback data from games ( like vibration, force feedback, gunshot, explosion)

Richard MacCutchan3-May-20 23:21

Richard MacCutchan

3-May-20 23:21

You can only capture what the game sends to you.

Re: How to capture feedback data from games ( like vibration, force feedback, gunshot, explosion)

Richard MacCutchan3-May-20 21:05

Richard MacCutchan

3-May-20 21:05

Feedback will depend on the hardware and software in use. Check the documentation for the game.

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