How do I refresh the datagrid in x seconds?

See more:

Gridview

Hello everyone,

I have a project. Simply;

- There is a table in database named 'books'. Books are served on a web application. No problem till here.
- I created a desktop application which should warn the user; "a new book has been added." and then list all the books inside the desktop application. So I used datagridview and a timer. When a new book has been added into the database, gridview shows the whole records.

- Problem starts here. When the user changes the name of a book, or publishing year, this isn't being showed on the grid view till the user restart the desktop app.

private void frmAnaGovde_Load(object sender, EventArgs e)
       {
           LoadBooks();
       }

       public void LoadBooks()
       {
           dataGridView1.DataSource = _books.SelectAll();
           ChangeCellContent();
       }

       public void ChangeCellContent()
       {
           dataGridView1.Columns[3].Visible = false;
           dataGridView1.Columns[4].Visible = false;
           dataGridView1.Columns[7].Visible = false;
           dataGridView1.Columns[8].Visible = false;
           dataGridView1.Columns[9].Visible = false;
           dataGridView1.Columns[11].Visible = false;
           dataGridView1.Columns[12].Visible = false;
           for (int i = 0; i < dataGridView1.Rows.Count; i++)
           {
               dataGridView1.Rows[i].Cells[0].Value = UlusoyKebapApp.n2.Sabitlerim.SIPARISDURUMU(Convert.ToInt32(dataGridView1.Rows[i].Cells[4].Value));
               dataGridView1.Rows[i].Cells[1].Value = UlusoyKebapApp.n2.Sabitlerim.ODEMESEKLI(Convert.ToInt32(dataGridView1.Rows[i].Cells[7].Value));
               dataGridView1.Rows[i].Cells[2].Value = UlusoyKebapApp.n2.Sabitlerim.PAKETSEKLI(Convert.ToInt32(dataGridView1.Rows[i].Cells[8].Value));
           }
       }

       public void InitTimer()
       {
           Zamanlayici = new Timer();
           Zamanlayici.Tick += new EventHandler(Zamanlayici_Tick);
           Zamanlayici.Interval = 2000;//
           Zamanlayici.Start();
       }
       private void Zamanlayici_Tick(object sender, EventArgs e)
       {
           LoadBooks();
       }

Do you have any solutions?