update page every x seconds from fetching values from DB

Vishwas Kadamannaya

13y1.8k.NET

Hi ,

I need to create an asp.net web application just like cricinfo,(with no page flickering) which will update the scores every 'X' seconds which will fetch from database based on some condition. If you guys have sample application so that i can look into and startup with, it will be really useful. Iam using oracle DB.

Thanks in Advance

Vishwas

3 Replies

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

Hari Krishna13y ago
Hi Vishwas,
Try this code for no page flickering use OracleConnection instead of Sqlconnection.

.aspx code
--------------

Every 5 sec.s the Grid will refreshes automatically without postback

BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px"
CellPadding="4" GridLines="Horizontal">

<%--

--%>

OnTick="Timer1_Tick">

.cs Code
--------------
public partial class AutoRefreshGrid : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("user id=sa;password=urpassword;initial catalog=databasename;server=urservername");
SqlDataAdapter da;
DataSet ds;

protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
Bind();
}

public void Bind()
{
da = new SqlDataAdapter("select * from EmpDetails", con);
ds = new DataSet();
da.Fill(ds);
Gridview1.DataSource = ds;
Gridview1.DataBind();
}

protected void Timer1_Tick(object sender, EventArgs e)
{
Bind();
lblMsg.Text ="Refresh at :" +DateTime.Now.ToLongTimeString();
}
}
Vishwas Kadamannaya13y ago
Hello Pankaj,

Thanks for the reply, if you could share some code that does this , that would be really greateful..

Thanks
Vishwas
Pankaj Pandey13y ago
You can try AJAx tool timer and put timer and ur part which need to update within updatepanel
And just write other code in simple way.

Timer will call ur function after a interval and ur page or part will update.