English 中文(简体)
如何更新数据库更新数据集
原标题:How to update dataset on updating database

我有一个中央数据库,2个(或2个以上)用户能够同时工作。 当数据库所有数据中的美国ER1记录输入数据集时,用户使用数据集获取数据。 现在,地点表有5个条目/地点名称。 同时,美国ER2为数据库增加了一个地点(Chicago)。 现在,我想进入美国ER1系统的新地点(芝加哥)。

我是否需要为此利用触发因素? 或者,我是否尝试过read子?

让我知道,这是否不可行。 欢迎获得任何额外和相对的资料。

我没有足够知识来理解所有这一切,我刚刚进入所有这些技术、技术和概念的学习阶段。 如果是个 question子问题,则会问。

最佳回答

Define database based dependency between clients, clients can subscribe to database so when data changes all its dependents are notified. It is called sqldependency notification, it uses service broker. Check the link.

问题回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签