asked on

VB.Net -- After converting a project from VB6 to VB.Net and then to C# I've lost the DDE functionality of the project. Looking for alternative

Hi everyone,

After converting a project from VB6 to VB.Net and then to C# I've lost the DDE functionality of the project. Looking for alternative or a fix to get this functionality back so that the data is shared on my network/machine and dynamically can update excel and use old DDE references.

Can someone help me?

Let me express my thanks in advance for your gracious help.

Best regards,
Dynotoe

ASKER CERTIFIED SOLUTION

Bob Learned

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bob Learned

What are you using DDE to communicate with Excel for?

Bob

Dynotoe

ASKER

Hi Bob,

Well it supports Excel but also some software that can take in the DDE links. Ideally because there is software already to take in the DDE I would like to support it from the project. However I certainly would appreciate either something that uses a different mechanism to share the data, or one in which is a different mechanism but which appears as if it's the old DDE so that the software supporting it see A "DDE" altbhough in my project it is something else.

It's a finacial quote data project which I want on the client side to retrieve quotes etc.

Thanks for your advice any deatil is greatly appreciated.

Best,

Dynotoe

Dynotoe

ASKER

additionally I understand DDE is vastly inferior but in addition to a great replacement would also like to support it etc.

D

Bob Learned

It is difficult to identify a replacement to the DDE functions without understanding your environment and requirements.

1) .NET version?
2) Are you supporting multiple clients, or a single client?
3) Is this NET DDE or local DDE access?
4) Excel version?
5) Operating system?

Bob

Dynotoe

ASKER

Basically it is a client side gui app which resides on the persons machine. It retrieves quotes from the internet Real-Time and should then make the data availible to be accessed Real-Time on the clients machine. So although the data is obtained over the internet the data then itself is shared locally on the machine, or maybe small network. But they can do the network thing themselves once they have access to the data coming in.

More clear hopefully?

Dynotoe

Dynotoe

ASKER

Also..

I have VS2003.net, XP pro, excel 2003.net.

The project supports multiple connections to the data source, however I would like to eventually re-distribute the data i.e., having the customers get the data from me instead of the original internet source. The firm allows you to redistribute the data but don't want all my cusomers connecting to thier servers but rather want me to get the data then send it on and have others access it through me etc. But that's down the road a bit.

Would I use a NET DDE to broadcast data to users in a redistributive way?

Dynotoe

Dynotoe

ASKER

Does that VB.Net DDE control do C# also cause that is really what the app is in currently

Bob Learned

Where does DDE come into play here?

Bob

Dynotoe

ASKER

Well my project gets the data from the internet and then provides the data via ( or did before I converted it to VB.net and C# ) to the users local machine so that any apps the individual has that support getting DDE data (like Excel) sould reference the RT data etc. What I eventually want to be able to do is take this data and provide it to lets say you RT or very close over the internet etc. You would be able to hook into the data being updated every sec or so etc.

Dynotoe

Bob Learned

Some thoughts:

1) Web service
2) Remoting
3) Sockets--TcpClient or UdpClient

Bob