forum

Home / DeveloperSection / Forums / How to refresh gridview after every insert command automatically?

Ask Question

How to refresh gridview after every insert command automatically?

Anonymous User 2028 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.

c#
Updated on 28-Aug-2014
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Sumit Kesarwani

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

Liked By