我该怎么办请帮帮我 [英] How I Do Please Help Me Out

问题描述

大家好，我使用过c＃，我有软件显示股票市场数据，当公司股票更新时，表格会进入excel表格，然后流媒体excel表格也将立即获得更新我现在正在创建一个显示的软件相同的数据，但不同种类现在当公司股票升级，我的表也应该更新它正在更新，但我必须一直运行...现在我想当excel表并排更新我的表也应该自动更新任何解决方案

解决方案

您应该在C＃中实现一个Excel加载项，用于管理Excel中的事件并自动更新数据库的表格。



MSDN演练 ^ ]

Hello



你可以写一个程序o监视文件的最后修改。

System.IO.FileSystemWatcher可以是理想的工作类。



例如

 string filePath = @[excel文件的目录]; 
 FileSystemWatcher watcher = new FileSystemWatcher（）; 
 
 watcher.Path = filePath; 
 watcher.NotifyFilter = NotifyFilters.LastWrite; 
 
 watcher.Filter =[excel文件的名称，例如myexcel.xls]; 
 watcher.Changed + = new FileSystemEventHandler（OnChanged）; 
 watcher.EnableRaisingEvents = true; 
 

希望这会对你有帮助。

< blockquote>嘿vick，我在南非创建或多或少相同的项目，m公司使用excel和sql数据库看到它是一个客户端应用程序，故事的重点是，你有你需要的所有数据吗？



您针对哪个市场？ forex，jse local？



所以要记住的事情是，如果你想要一个更新项目的生命饲料，它有版税，我也必须要求回答你更新问题，因为TanvirRaihan基本上回答了你的问题，只记得实现正确的引用。



你必须记住，如果这是一个每秒的市场数据应用程序，下载和更新流将是一个流程的地狱，所以你可能想要将它们作为后台处理类运行，两者都是分开的，这样你的连接就不会发生冲突，如果这是15分钟的延迟，它会让它更容易，但它仍然会最好在后台处理中这样做（打赌你现在缺少德尔福;））



请返回所有细节，我可以为你做一个演示

hello everyone i used c# and i have software that shows share market data that tables are snaps into excel sheet when company shares are update then also that streaming excel sheet will be also get update immiedietly now i am creating a software that is shows same data but different kind now when company shares get upadate that my table should also update its is updating but i have to run all the time ...now i want when that excel sheet is update side by side my tables should also update automatically any solution

解决方案

You should implement in C# an Excel Add-In that manage the events from Excel and automatically update your database's tables.

MSDN Walkthrough^]

Hello

You can write a program to monitor the file's last modification.
System.IO.FileSystemWatcher can be the ideal class to work with.

For example

string filePath = @"[directory of your excel file]";
           FileSystemWatcher watcher = new FileSystemWatcher();

           watcher.Path = filePath;
           watcher.NotifyFilter = NotifyFilters.LastWrite;

           watcher.Filter = "[name of your excel file ex. myexcel.xls]";
           watcher.Changed += new FileSystemEventHandler(OnChanged);
           watcher.EnableRaisingEvents = true;

Hope this will help you.

Hey vick, im in south africa creating more or less the same project, m company uses excel and sql database seeing that it is a client application, point of the story is,Do you have all the data you need?

which market are you targeting? forex, jse local?

so things to remember is that if you want a life feed updating a project there is royalties bound to it, also i must ask to answer your update question because TanvirRaihan basically answered your question , just remember to implement the correct references.

you must keep in mind that if this is a per second market data application that the downloading and updating stream will be a hell of a a process, so you might want to run them as background processing classes, both separate so that your connection does not clash, if this is like 15 min delay, it makes it easier but it would still be better to do this in background processing(bet you you are missing delphi now ;))

please return with all the details and i can work on a demo for you.

这篇关于我该怎么办请帮帮我的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！