更新或同步datagridView当SQL表更改时
我已经使用SQL 2019&构建了Databse Windows表单应用程序。 C#在Visual Studio 2022中。在该Windows表单应用中,我的DataGridView在该表单的底部&另外,我在DataGridView上方有一些文本字段。当我填写该文本并将该值保存到数据库表中时,这些值会自动显示在Lower DataGridView中。我的应用程序是由8至12个用户同时使用的多用户。他们在单独的系统上一起进行数据输入。作为管理员,我将我的表单保持可见,其中我的文本和datagridview可以观看到目前为止所输入的内容。我保持自己的表格&直到我关闭该表格并重新打开该表格之前,我看不到将新值输入到DataGridView中。我如何在datagrodview中的数据库表中看到的每个新值或每个更新,而无需关闭和重新打开它。 在此处输入图像描述
I have built Databse Windows Form App using SQL 2019 & C# in Visual Studio 2022. In that Windows Form App, I have a DataGridView in bottom side of that form & also I have some text fields on above the DataGridView. When I fill that text fileds and save that values into the Databse table then these values are automatically shown in lower DataGridView. My App is being used by multi users like 8 to 12 users at same time. They do data entry together on their separate systems. I as an Administartor keep my that Form visible in which I have text fileds and DataGridView to watch what is being entered so far. I keep open my Form & I can't see new values entered into the DataGridView until I close that Form and reopen it. How I can see every new values or every update that is being made in Databse Table in DataGrodView without closing and reopening it.
enter image description here
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论