使用DDE将VB6小程序升级到VS2010 [英] upgrading VB6 applets with DDE to VS2010

问题描述

十年前，我有三个用VB6设计的小程序.它们与某些仪器接口(一个通过串行端口；两个通过ADC卡)，并在屏幕上显示一个仪器的读数以及其他信息.小程序通过DDE链接使数据可用，并且我们提供了一个示例Excel文件来显示如何访问数据并将其(通过函数或查找表)转换为客户所需的值.客户提供转换功能. (仪器是用于测量吸光度的光度计；转换是吸光度的倒数= f(x)，其中x是自变量.)

现在是时候更新这些了，我在看C#(每个程序小于1000 LOC；转换应该不难).我知道DDE已过时；我一直在研究替代方案，但我不清楚对于我们的客户而言，最容易实施的方案仍然是灵活的.例如，当我们提供示例Excel [电子表格]时，客户可能想要[使用]不同的电子表格程序或数据库；因此，创建Excel加载项可能不是解决之道.

有关如何进行的任何建议?赞赏资源的链接.如果我决定将这些小程序扩展为读数的数据库，可以使用哪些控件[或库包/框架]允许用户输入自己的公式?

为了清晰起见，在[]中进行编辑

I have three applets designed in VB6 a decade ago. They interface with some instruments (one via serial port; two via ADC card) and provide an on-screen display of an instrument''s reading along with other information. The applets make the data available through DDE links and we supply a sample Excel file to show how to access the data and convert that (through a function or look up table) into the value the customer needs. The customer provides the conversion function. (The instruments are photometers, measuring absorbance; the conversion is the inverse of absorbance = f(x) where x is the independent variable.)

It''s time to update these and I am looking at C# (each program is less than 1000 LOC; conversion should not be difficult). I know DDE is deprecated; I''ve been researching the alternatives but I''m not clear what will be easiest for our customers to implement and still be flexible. For example, while we supply a sample Excel [spreadsheet] a customer might want to [use] a different spreadsheet program or a database; hence, creating an Excel add-in may not be the way to go.

Any recommendations on how to proceed? Links to resources are appreciated. If I decide to expand these applets to be a database of the readings what controls [or library package/framework] are available to allow the user to enter their own formula?

Edits in [] for clarity

推荐答案

首先将Visual Studio投入使用，以转换和升级您的项目，并查看需要做多少工作.

其次，如果您的代码库只有1000行，那么重写比遍历错误可能更简单.

第三，用于数据的简单Web服务界面可以帮助您解决将来遇到的集成问题(当今大多数Excel类型的应用程序都可以从Web服务读取XML).

First put Visual Studio at work to convert and upgrade your projects, and see how much work you need to do.

Second if your code base is just 1000 lines then rewriting could be simpler than wading through the errors.

Third a simple web service interface for your data could help your out and be future resistant for your integration problem (most Excel type applications can read XML from a web service nowadays).

这篇关于使用DDE将VB6小程序升级到VS2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！