ARTICLE

Working with AJAX Update progress control

Posted by Srinivas Kotra in Articles | AJAX in C# on November 11, 2009

Tags: AJAX, AJAX Update Progress, Update Progress, Working with Update progress

This article shows how to display AJAX Update Progress on center position of gridview.

Tweet
7615
3

Reader Level: Intermediate

Download Files:

UpdateProgress.zip

In this article I am explaining about how to show Ajax Update progress at center of grid view.

Aspx code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="System.Web.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

Namespace="System.Web.UI.WebControls" TagPrefix="asp" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Update Progress Sample</title>

function onUpdating() {

var updateProgressDiv = document.getElementById('upCustomer');

var gridView = document.getElementById('gvUpdateProgress');

var gridViewBounds = Sys.UI.DomElement.getBounds(gridView);

var updateProgressDivBounds = Sys.UI.DomElement.getBounds(updateProgressDiv);

var x = gridViewBounds.x + Math.round(gridViewBounds.width / 2) - Math.round(updateProgressDivBounds.width / 2);

var y = gridViewBounds.y + Math.round(gridViewBounds.height / 2) - Math.round(updateProgressDivBounds.height / 2);

Sys.UI.DomElement.setLocation(updateProgressDiv, x, y);

}

</script>

</head>

<body>

<div>

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<tbody>

<tr>

<td align="center" style="font-family: Calibri; background-color: #3366CC; color: #FFFFFF;

visibility: hidden; width: 100%">

UpdateProgress Sample

</td>

</tr>

<tr>

<td style="border: medium dotted Navy; font-family: Calibri; color: Purple; width: 100%;

border-color: Red; border-top-width: thick;">

<asp:UpdateProgress ID="upCustomer" AssociatedUpdatePanelID="upnlCustomer" runat="server">

<div id="imgdivLoading" align="center" valign="middle" runat="server" style="border-style: dotted;

padding: inherit; margin: auto; position: absolute; visibility: visible; vertical-align: middle;

border-color: #000066 black black black; border-width: medium">

<asp:Image ID="imgLoading" runat="server" ImageUrl="Images/loading.gif" Width="34px" />Loading...

</div>

</ProgressTemplate>

</asp:UpdateProgress>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

<tr>

<asp:UpdatePanel ID="upnlCustomer" runat="server">

<asp:GridView ID="gvUpdateProgress" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID"

AllowPaging="True" CellPadding="4" ForeColor="#333333" GridLines="None" Font-Names="Calibri"

OnPageIndexChanging="gvUpdateProgress_PageIndexChanging" Width="100%" Caption="UpdateProgress Sample">

<asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />

<asp:BoundField DataField="CompanyName" HeaderText="CompanyName" SortExpression="CompanyName" />

<asp:BoundField DataField="ContactName" HeaderText="ContactName" SortExpression="ContactName" />

<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />

<asp:BoundField DataField="PostalCode" HeaderText="PostalCode" SortExpression="PostalCode" />

<asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" />

<asp:BoundField DataField="Phone" HeaderText="Phone" SortExpression="Phone" />

</Columns>

<PagerStyle BackColor="#2461BF" BorderStyle="None" ForeColor="White" HorizontalAlign="Right"

Height="15px" />

</asp:GridView>

</ContentTemplate>

</asp:UpdatePanel>

</td>

</tr>

</tbody>

</table>

</div>

</form>

</body>

</html>

C# code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Data;

using System.Data.SqlClient;

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)

{

gvUpdateProgress.Attributes.Add("onclick", " onUpdating();"); // ading java script to grid view.

bindGrid();

}

/// <summary>
/// Getting Customer table data from North wind database to bind gridview
/// </summary>
private void bindGrid()
{
SqlConnection conn = new SqlConnection("Trusted_Connection=yes;Addr=Localhost;Initial Catalog=Northwind");
SqlCommand cmdCustomer = new SqlCommand("SELECT [CustomerID],[CompanyName],[ContactName],[City],[PostalCode],[Country],[Phone] FROM Customers", conn);
SqlDataAdapter adptCustomer = new SqlDataAdapter(cmdCustomer);
DataSet dsCustomer = new DataSet();
adptCustomer.Fill(dsCustomer,"Customer");
gvUpdateProgress.DataSource = dsCustomer.Tables["Customer"].DefaultView;
gvUpdateProgress.DataBind();
}

/// <summary>

///

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void gvUpdateProgress_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

System.Threading.Thread.Sleep(3000); // Loading image waiting period

gvUpdateProgress.PageIndex = e.NewPageIndex;

gvUpdateProgress.DataBind();

}

}

Note: I have used northwind database for this application. We can download northwind database from here :

http://code.msdn.microsoft.com/northwind/Release/ProjectReleases.aspx?ReleaseId=1401

This article is for single gridview controls. If we have more than one gridviews in your page we have to change javascript. If you have any concerns and comments please write to me.

Hope this example helps you. Happy coding.

post comment

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- insert_demo_sp_Expriment '','A',10.10,'Country','' -- select * from tblLists ALTER Procedure [dbo].[insert_demo_sp_Expriment] ( @AutoID bigint, @RecordStatus varchar(max), @UpdateID decimal(9,2), @Code CHAR(20), @Order int ) AS BEGIN DECLARE @MyOutput decimal(9,2) DECLARE @MyLastOutput decimal(9,2) DECLARE @OrderNo INT Set @MyOutput = 0 set @MyLastOutput = 0 set @OrderNo = 0 select @MyOutput = MAX(UpdateID) from dbo.tblLists where Code = ''+ @Code +'' select @OrderNo = Max([Order]) from dbo.tblLists where Code = ''+ @Code +'' select @MyLastOutput = ROUND(MAX(UpdateID),1,1) from dbo.tblLists if(@MyOutput != 0) BEGIN INSERT INTO dbo.tblLists ( UpdateID, RecordStatus, Code, [Order] ) Values ( @MyOutput + 00.01, 'A', @Code, @OrderNo + 1 ) END else BEGIN INSERT INTO dbo.tblLists ( UpdateID, RecordStatus, Code, [Order] ) Values ( @MyLastOutput + 1, 'A', @Code, 1 ) END END

Posted by Ketan Patel on Jun 09, 2011

i download and tried this sample in IE browser its working fine but in firebox its not working

Posted by cuteboy thiru on Dec 13, 2010

Keep the good work up.. very nice article.

Posted by Ravi Kiran on Nov 11, 2009

TOP LEADERS