data not binding to grid without refreshing the page

Hi,

Bind grid on pageload using the below code.You can use Updatepanel to avoid page reload.

Code :

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());

protected void Page_Load(object sender, EventArgs e)

{

BindData();

}

public void BindData()

{

try

{

SqlDataAdapter adp = new SqlDataAdapter("Select * from STATE_DETAIL order by ID Desc", con);

con.Open();

DataTable dt = new DataTable();

adp.Fill(dt);

grdstate.DataSource = dt;

grdstate.DataBind();

}

catch (Exception ex)

{

}

protected void Timer1_Tick(object sender, EventArgs e)

{

grdstate.DataBind();

}

Reference :

http://www.articlemirror.in/2013/09/auto-refresh-data-in-gridview-without.html

http://stackoverflow.com/questions/12212980/update-gridview-without-refreshing-the-page

2 Replies

Know the answer? Post it — somebody with the same question will find it here.