---
title: "How to refresh gridview after every insert command automatically?"  
description: "How to refresh gridview after every insert command automatically?"  
author: "Anonymous User"  
published: 2014-08-28  
updated: 2014-08-28  
canonical: https://www.mindstick.com/forum/2187/how-to-refresh-gridview-after-every-insert-command-automatically  
category: "c#"  
tags: ["c#", "asp.net grid view", "refresh grid view", "refresh gridview after every insert command automatically"]  
reading_time: 1 minute  

---

# How to refresh gridview after every insert command automatically?

I am inserting [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) to [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) when i [click](https://www.mindstick.com/articles/12423/social-login-magento-2-one-click-to-register-social) [submit button](https://www.mindstick.com/forum/12834/make-text-appear-when-submit-button-clicked-and-checkbox-is-unchecked) data inserted into Database but no changes get reflected in [GridView](https://www.mindstick.com/articles/873/update-delete-edit-gridview-in-asp-dot-net) without refreshing the page.

## Replies

### Reply by Sumit Kesarwani

Hi Pravesh, \

```
public void GetData()            {        try        {           
SqlConnection connection = new SqlConnection();           
connection.ConnectionString = ConfigurationManager.ConnectionStrings["mysql"].ConnectionString;            String sql= "Your Query";            DataSet ds= new DataSet();           
SqlDataAdapter da = new SqlDataAdapter(sql, connection);           
da.Fill(ds);            DataTable dt = new DataTable();            dt =ds.Tables[0];           
GridView1.DataSource = dt;        }        catch (SqlException ex)        {        }        catch (Exception e)        {        }    }
```


---

Original Source: https://www.mindstick.com/forum/2187/how-to-refresh-gridview-after-every-insert-command-automatically

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.