User-718146471 posted
Hi there, many thanks to MGEBHard for his help. The original thread is
found here. What I need to do now is get the data refresh to happen
but show the "Loading Data - Please Wait..." Say every two minutes or so. Here is my existing code:
aspx:
<%@ Page Title="Audited Apps No Comments" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Dashboard.aspx.cs"
Inherits="ASPNETApp.AppsByDevReport" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.js"></script>
<script type="text/javascript">
$(function () {
function DoPost() {
$('#loadingGraphic').show();
$('#<%=HiddenPostback.ClientID%>').click();
}
//Submit a post back if this page was requested for the first time
var shouldIPostBack = $('#<%=ShouldIPostback.ClientID%>').val();
if (shouldIPostBack == 'yes')
{
DoPost();
}
$('#ShowDashboard').click(function () {
$('#DashBoardData').hide();
DoPost();
return false;
});
});
</script>
<style type="text/css">
.modal
{
;
top: 0;
left: 0;
background-color: black;
z-index: 99;
opacity: 0.8;
filter: alpha(opacity=80);
-moz-opacity: 0.8;
min-height: 100%;
width: 100%;
}
.loading
{
font-family: Arial;
font-size: 10pt;
border: 5px solid #67CFF5;
width: 200px;
height: 100px;
display: none;
;
background-color: White;
z-index: 999;
}
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
<div style="display:none">
<asp:Button ID="HiddenPostback" runat="server" Text="HiddenPostback" />
<asp:HiddenField ID="ShouldIPostback" runat="server" />
</div>
<div id="DashBoardData">
<div style="text-align:center">
<asp:Label ID="lblTitle" runat="server" Text="Application Dashboard" Font-Bold="True" Font-Size="XX-Large" />
<br />
</div>
<div id="loadingGraphic" style="display:none">
<asp:Label ID="lblRefreshing" runat="server" Text="Refreshing Dashboard, please wait..."></asp:Label>
</div>
<br />
<div style="text-align: center">Applications with No Developer Comments<br />
</div>
<asp:GridView ID="gvAppListing" runat="server" CellPadding="4"
ForeColor="#333333" Width="100%" AutoGenerateColumns="False">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:TemplateField HeaderText="Application Version">
<ItemTemplate>
<asp:Label ID="lblProjName" runat="server" Text='<%# Bind("Project") %>'></asp:Label>
<asp:Label ID="lblProjVers" runat="server" Text='<%# Bind("Version") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Priority">
<ItemTemplate>
<asp:Label ID="lblPriority" runat="server" Text='<%# Bind("Priority") %> '></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Category">
<ItemTemplate>
<asp:Label ID="lblCategory" runat="server" Text='<%# Bind("Category") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" VerticalAlign="Top" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#E9E7E2" />
<SortedAscendingHeaderStyle BackColor="#506C8C" />
<SortedDescendingCellStyle BackColor="#FFFDF8" />
<SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>
</div>
<div>
<input id="ShowDashboard" type="button" runat="server" value="Refresh Dashboard" />
</div>
</asp:Content>
cs:
using System;
using System.Configuration;
using System.Data;
using Oracle.ManagedDataAccess.Client;
using System.Web.UI.WebControls;
using System.Collections.Generic;
using System.Threading;
namespace ASPNETApp
{
public partial class AppsByDevReport : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
//bind grid view
ShouldIPostback.Value = "no";
DataGrab();
}
else
{
//Tell the browser to post back
ShouldIPostback.Value = "yes";
}
}
protected void DataGrab()
{
List<MockData> data = GetMockData(5000);
gvAppListing.DataSource = data;
gvAppListing.DataBind();
DataTable dt = new DataTable();
string OraQuery = "********************************************************"; // Hidden
string OrConStr = ConfigurationManager.ConnectionStrings["OraConnStr"].ConnectionString;
OracleConnection conn = new OracleConnection(OrConStr);
OracleCommand cmd = new OracleCommand(OraQuery, conn);
try
{
conn.Open();
OracleDataReader rdr = cmd.ExecuteReader();
dt.Load(rdr);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
conn.Close();
}
gvAppListing.DataSource = dt;
gvAppListing.DataBind();
}
private List<MockData> GetMockData(int delay)
{
Thread.Sleep(delay);
return new List<MockData>()
{
new MockData() {
Project = "One",
Version = "Two",
Priority = "Three",
Category = "Four"
},
};
}
}
public class MockData
{
public string Project { get; set; }
public string Version { get; set; }
public string Priority { get; set; }
public string Category { get; set; }
}
}
