Communication With Projects

Question

Hi,

I have two different projects. But now I want to provide the communication between the projects. Their main tables has 3 same fields. I want to read first project's main table and write another project's main table. How can I do that fast? Because first project's data is grown very fast(e.g 100 datas in a second). What is the best way?

Mahesh Chand · Answer

From your question, it is not clear if you want to share the files/data in between two applications or two databases? When you say project, that means Visual Studio project and its impossible to share data between two projects unless you have some kind of remoting going on. If you want to share data from two databases in two different applications. There are several ways to do it. 1. You can have two database connections opened direct with two databases 2. You can have two Web Services exposing data from these two databases and let applications consume these Web services. 3. Data between application to application can be shared using .NET Reporting or DCOM

Gurkan · Answer

I decide to try remoting/dcom. Thank you all.

Piotr Justyna · Answer

Oh, you have 2 separate databases, that complicates your problem a bit :) Is there a possibility in your case to write a windows service on your database server which will synchronize both databases?

Gurkan · Answer

Thanks for your reply. But they are two different projects and two different databases. My first solution is to use Web Handler. But First project's datas have to be automatically written to another's database. Automatically operation, not manual. So it is useless. So, how can I apply your solution? I can't find the way to provide the communication of these distinct projects.

Piotr Justyna · Answer

Hi! Just bind the second table to first table's datasource and refresh it with desired time interval. If you like my answer please mark it as helpful. Cheers!