How to update grid data without page refresh in c#
Show Data in Grid without page refresh using Timer in c#
In c# are you using Timer control and set interval as you want and use update panel for do not refresh page
please see under below design code
<asp:ScriptManager ID="ScriptManager1" runat="server" /> <div> <asp:Timer ID="Timer1" runat="server" Interval="10000"> </asp:Timer> </div> <asp:UpdatePanel ID="UpdatePanel1" UpdateMode="Conditional" runat="server"> <Triggers>
<asp:AsyncPostBackTrigger ControlID="Timer1" EventName="Tick" /> </Triggers> <ContentTemplate> <asp:DataGrid ID="grvDemo" runat="server" Width="100%" GridLines="Both" HeaderStyle-BackColor="AntiqueWhite" AutoGenerateColumns="true"> </asp:DataGrid> </ContentTemplate> </asp:UpdatePanel>
|
And Code Side :
using System.Data; using System.Data.SqlClient; protected void Page_Load(object sender, EventArgs e) { BindGrid(); } public void BindGrid() {
//SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString); SqlConnection con = new SqlConnection("Data Source=BITPLUS5\\SqlExpress;Initial Catalog=temp;User ID=sa;pwd=bit123;"); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select * from chat order by 1";
cmd.Connection = con;
con.Open(); SqlDataReader dr = cmd.ExecuteReader();
grvDemo.DataSource = dr;
grvDemo.DataBind(); }
|