Tuesday, March 3, 2009

AJAX Timer asp.net Datagrid

ajax.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
GridData.DataSource = getData();
GridData.DataBind();
Page.DataBind();
}


protected void Timer1_Tick(object sender, EventArgs e)
{
//Label1.Text = "Total Messages of " + DateTime.Now.ToLongTimeString();


}

public static DataTable getData()
{
DataSet ds = new DataSet();
try
{
OdbcConnection conn = new OdbcConnection(ConfigurationManager.ConnectionStrings["connection_string"].ConnectionString);
string query = String.Format("Stored Procedure");
OdbcDataAdapter adap = new OdbcDataAdapter(query, conn);

adap.Fill(ds);

}
catch (Exception ex)
{

}
return ds.Tables[0];
}
}

ajax.aspx

No comments: