Update or Sync Datagridview when SQL table changes

147 views Asked by At

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

0

There are 0 answers