title: Refresh the Grid Automatically when table changes in the DB
body: <p>I am having the Windows application accessing the internal server and creating the setup file based on the user request from the Front End application.</p>
  
  <p>1) When we request the server for creating the setup file from the Front End application we will add details into the table.(req id="101", Status="Started" and etc) 
  and showed those entries in the Grid .</p>
  
  <p>2) We process the request from the server based on the FIFO (Queue) and create the setup file. Once setup file is created we will update into the table status="Completed".</p>
  
  <p>Problem : Once we update status of the request into table (Done in the server) we need to refresh the Grid in the Front End application. </p>
  
  <p>I don't want to put the timer in the form to refresh the datasource. Is any other way to achieve this ?</p>
  
  <p>My data retrival statment in my c# program</p>
  
  <pre><code>public DataTable GetCustomPatchGridDatasource(string Requesteduser)
          {
              try
              {
                  dbConn = new DBConnection();
                  myconn = dbConn.CreateConnection();
                  myCommand = new SqlCommand();
                  myCommand.CommandText = "sp_Patch_GetPatchDetails";
                  myCommand.CommandType = CommandType.StoredProcedure;
                  myCommand.Parameters.Add(new SqlParameter("@RequestedUserEmail", Requesteduser));
                  myCommand.Connection = myconn;
                  myDatatadapter = new SqlDataAdapter(myCommand);
                  datatable = new DataTable();
                  myDatatadapter.Fill(datatable);
                  dbConn.CloseConnection();
                  return datatable;
              }
              catch (Exception ex)
              {
                  dbConn.CloseConnection();
                  MessageBox.Show(ex.Message, "Message");
                  return null;
              }
          }
  </code></pre>