How to refresh gridview after every insert command automatically?

Anonymous User 2372 28 Aug 2014

I am inserting data to database when i click submit button data inserted into Database but no changes get reflected in GridView without refreshing the page.

Ask by Anonymous User

Updated 28 Aug 2014

1 Answers

Sumit Kesarwani 28 Aug 2014

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)
        {
        }
    }

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

How to refresh gridview after every insert command automatically?

Can you answer this question?

1 Answers