|
In this tutorial i will let you know how to auto refresh or update GridView using AJAX Timer and UpdatePanel in asp.net. In this it is described that how a GridView is update after a specific time set in timer control.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:Timer ID="Timer1" Interval="10000" runat="server" ontick="Timer1_Tick">
</asp:Timer>
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
<asp:Label ID="update" runat="server" Text="Label"></asp:Label>
</ContentTemplate>
</asp:UpdatePanel>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Timer1_Tick(object sender, EventArgs e)
{
databind();
update.Text = " Gridview Was Last Updated at " + DateTime.Now;
}
public void databind()
{
string strcon = ConfigurationManager.ConnectionStrings["con"].ConnectionString;
SqlConnection conn = new SqlConnection(strcon);
conn.Open();
string str = "select * from dept";
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
|
|
|
|
|
protected void Page_Load(object sender, EventArgs e)
{
string sss = "xxx";
Response.AppendHeader("Refresh", "2");
if (!IsPostBack)
{
}
}
|
|
|
|
|
How to support the e-signature pad with crystal report and get the sign in asp.net?
|
|
|
|
|
Hi,
I am trying validating emailID against database without refreshing the page and without using the update panel.
I want to do it by client side script.
Is it possible?
Thank You.
|
|
|
|
|
|
|
Hi,
I am getting the below error in my ASP.NET 4.0 web application:
Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
I started getting this error when I added the below tag in web.config to encrypt the viewstate:
<pages enableEventValidation="true" controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID" enableViewStateMac="true" viewStateEncryptionMode="Always"/>
<machineKey validationKey="9EFA2D2E71A1BC8ECAF76E2377F29E61AB0214D893EBDBBD49C594A94FB0A2336BA3023F1578BFFE7ACD09C56872885537D07F5FA8FFF0FE4CD8B0E955A02845" decryptionKey="3EBF84F260F8883A69379502DF6DC999ADCAAA90885EAB1BD0423CEED13526A4" validation="SHA1" decryption="AES"/>
I looked for lot of solutions on aspnet forums and Internet but nothing worked. If I change the viewStateEncryptionMode to "Auto" or "Never", then the page loads fine. But that would make my application insecure and security is my prime objective.
FYI:My application is deployed on a Windows 2008 R2 server and not on a webfarm.
Any solution to solve this issue?
|
|
|
|
|
First, just to check the simplest solution, you aren't posting back "old" pages are you? By this I mean getting the page when the viewstateEncryptionMode is off/auto, switching the mode to on then posting back. This wide cause the error, but is unlikely Tokyo are doing this.
This problem is ringing a bell, but I can't place my finger on it. You might be suffering from this http://blogs.msdn.com/b/tom/archive/2008/03/14/validation-of-viewstate-mac-failed-error.aspx (On my mobile so can't make clickety),though this was fixed IIRC.
|
|
|
|
|
Are you using Shared Hosting Environment?
|
|
|
|
|
Hi Karthick,
Are you asking whether our web server hosts other applications also apart from the application I am talking about here. If you agree to this, then my answer is yes.
|
|
|
|
|
no i am asking about the type of hosting..Where its leased or own.
|
|
|
|
|
|
k.. any particular page is displaying this error or whole application
|
|
|
|
|
I am seeing this issue only on particular pages and not all. Is there something I should specifically check on those pages?
|
|
|
|
|
yes..If ur using data reader ..make sure that connection is closed..
|
|
|
|
|
Hi
I am trying to create a column that will always have remaining width. However I want it consist of 3 divs as the middle div will always fill the width available where as the left and right divs will be a fixed width. The problem I have is that the middle div which has remaining width knocks the other divs onto a new line. How can I prevent this?
Appear on Left, this would be fixed width
Always be remainging width
Appear Right, this would be fixed width
note :
something the left div will have no controls in it.
many thanks in adavance
|
|
|
|
|
I'm working on my mobile, so apologies in advance for the lack of formatting / example code.
In principle it's pretty simple, once you know how:
1. Create a div as a container.
2. Into the above place three divs left,right and middle in that order
3. Using CSS float the left div left and the right div. ALSO set the widths
4. Using CSS set the left margin and right margin of the middle div so
it doesn't run round the divs on the edge.
You might also need to Google cleafix if you want to support other browsers.
A round up of the above can be seen here:
http://css.maxdesign.com.au/floatutorial/tutorial0915.htm
|
|
|
|
|
Thanks for solution.
But no use.
Cause when i dont have anything in left div the content div's width should increase ( i mean it should take the left div with too).
Please Help !
|
|
|
|
|
CSS sibling selectors will help. You might even be able to use the general sibling combinator[^]:
<div class="wrapper">
<div class="left-column">
Left column content.
</div>
<div class="right-column">
Right column content.
</div>
<div class="main-column">
Main column content.
</div>
</div>
.left-column
{
float: left;
width: 120px;
}
.left-column ~ .main-column
{
margin-left: 120px;
}
.right-column
{
float: right;
width: 120px;
}
.right-column ~ .main-column
{
margin-right: 120px;
}
.wrapper:after
{
content: "";
display: table;
clear: both;
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thanks All!
But i wanna somthing like this :
<div style="width: 100%;">
<div style="width:15%;float:right"><asp:TextBox runat="server" Width="120px"></asp:TextBox></div>
<div style="float:right;width:100%"><asp:TextBox ID="TextBox2" runat="server" Width="100%"></asp:TextBox></div>
<div style="width:15%;float:left"><asp:TextBox ID="TextBox1" runat="server" Width="117px"></asp:TextBox></div>
</div>
and user can remove center texbox in settings and it will be like this :
<div style="width: 100%;">
<div style="width:15%;float:left"><asp:TextBox runat="server" Width="120px"></asp:TextBox></div>
<div style="float:left;"><asp:TextBox ID="TextBox2" runat="server" Width="100%"></asp:TextBox></div>
<div style="width:15%;float:left"></div>
</div>
Now Center div should take the left div width too.
Example 2 :
first i have :
<div class="wrapper">
<div class="left-column">
<asp:TextBox ID="TextBox1" runat="server" Width="100%">Left</asp:TextBox>
</div>
<div class="right-column">
<asp:TextBox ID="TextBox2" runat="server" Width="100%">Rigth</asp:TextBox>
</div>
<div class="main-column">
<asp:TextBox ID="TextBox3" runat="server" >content</asp:TextBox>
</div>
</div>
and the user can change remove the left textbox in left div :
<div class="wrapper">
<div class="left-column">
</div>
<div class="right-column">
<asp:TextBox ID="TextBox2" runat="server" Width="100%">Rigth</asp:TextBox>
</div>
<div class="main-column">
<asp:TextBox ID="TextBox3" runat="server" >content</asp:TextBox>
</div>
</div>
Now the center div should "Stretch".
|
|
|
|
|
hi , im sorry for the subject name i didnt found sth else to write it to .
i have two forms , master page/form and default page/form .
when i run the website some of the element in the default page are not correct . i mean is like i didnt defined any css property for it .
but i figure out sth , when im using the id for a particular element and the element is type of asp not html i mean start with <asp:element name="" runat:server="" id="button">
if i set a css for it with an id
like
#button {sth,sth,sth}
is not work pretty fine in the default page .
but if i used the class and internal css for that element . is work pretty fine.
look at this
<asp:element name="" runat:server="" class="button" id="button">
.button{sth,sth,sth}-------------->> it works pretty fine in the default
and this one too
<asp:element name="" runat:server="" style="sth,sth,sth" id="button">
but is not working fine with the id . i dont know why.
i dont know if this place is the right place for asking this type of qustion or not.
but i'll appreciate if you suggest me any thing that help me out.
and i'm sorry for my poor english.
|
|
|
|
|
You are correct the style sheets for element id seems to not work. This is because asp controls are by default renderend with name and id attributes set to unique values.
As a result you don't have to worry about having <asp:button id="Button"> on master page, content page and 3 copies of the same user control - they all will get different id, avoiding problems with html validation and event handling.
If you absolutely have to use css with id and you know 100% there will be no other control with the same ID, you can set ClientIDMode="static", however I would encourage using css class instead (set with "CssClass" attribute for asp controls, not "class" as in your example".
On final note, you can check exact id and other properties of rendered page using F12 tool in most browsers.
--
"My software never has bugs. It just develops random features."
|
|
|
|
|
I have design on crystal report e.g. myreport.rpt.
and i am passing parameter at runtime from aspx page to this report but it is not showing message;
"The report you requested requires further information."
Server name:
Database name:
User name:
Password:
Use Integrated Security
but I have added this information when reportDocument is generated.
i.e.
ReportDocument objRpt = new ReportDocument();
objRpt.FileName = Server.MapPath("~/Report/myreport.rpt");
objRpt.SetDatabaseLogon("root", "", "localhost", "test");
objRpt.SetDataSource(Ds);
objRpt.Load(objRpt.FileName);
plz help me
|
|
|
|
|
Page which trying to access requires security permission....it May be Folder Rights or Permission issues
|
|
|
|
|
how to convert Div.innerHtml to image format in VB.Net.It contains image,textbox and checkbox also.....
thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
