By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,034 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,034 IT Pros & Developers. It's quick & easy.

How to display a "loading page, please wait" box...

P: n/a
I cannot figure this out and would appreciate any help.....
I have a datagrid view that displays the results from a Stored Procedure.
it can take awhile to load.....
the stored procedure fires when a Calendar is clicked. ( a date is part of
the stored procedure ) How can i just show a new page or a pop-up that says
"please wait" until the stored procedure has run and gotten all the data and
the page is completely loaded? In all the examples i have studied, there is
always a button click event or are written in C#....
I was hoping to just use the Visible = True on a new page until the stored
procedure page is completely loaded.
<%@ Page Language="VB" AutoEventWireup="false"
CodeFile="WorstPerfroming.aspx.vb" Inherits="WorstPerfroming" %>

<!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>Worst Performing Statements</title>
</head>
<body>
<form id="form1" runat="server">
<div>
Worst Performing Statements
<asp:LinkButton ID="LinkButton1" runat="server"
PostBackUrl="~/Default.aspx">Home</asp:LinkButton><br />
<br />
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1"
DataTextField="SQLServerInstanceName"
DataValueField="SQLServerInstanceName">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1"
runat="server" ConnectionString="<%$
ConnectionStrings:SQLDiagM46ConnectionString8 %>"
SelectCommand="select distinct SQLServerInstanceName from
MonitoredSQLServers
">
</asp:SqlDataSource>
<br />
<asp:Calendar ID="Calendar1" runat="server" BackColor="White"
BorderColor="#999999"
CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana"
Font-Size="8pt"
ForeColor="Black" Height="180px" Width="200px">
<SelectedDayStyle BackColor="#666666" Font-Bold="True"
ForeColor="White" />
<TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
<SelectorStyle BackColor="#CCCCCC" />
<WeekendDayStyle BackColor="LightCyan" />
<OtherMonthDayStyle ForeColor="Gray" />
<NextPrevStyle VerticalAlign="Bottom" />
<DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True"
Font-Size="7pt" />
<TitleStyle BackColor="#999999" BorderColor="Black"
Font-Bold="True" />
</asp:Calendar>

</div>
<br />
<asp:GridView ID="GridView1" runat="server"
DataSourceID="SqlDataSource2">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:SQLDiagM46ConnectionString9 %>"
SelectCommand="usp_IderaWorstPerforming"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1"
Name="sqlname" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="Calendar1" Name="thedate"
PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
Jun 25 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Jun 25, 11:10 pm, geoffa <geo...@discussions.microsoft.comwrote:
I cannot figure this out and would appreciate any help.....
I have a datagrid view that displays the results from a Stored Procedure.
it can take awhile to load.....
the stored procedure fires when a Calendar is clicked. ( a date is part of
the stored procedure ) How can i just show a new page or a pop-up that says
"please wait" until the stored procedure has run and gotten all the data and
the page is completely loaded? In all the examples i have studied, there is
always a button click event or are written in C#....
I was hoping to just use the Visible = True on a new page until the stored
procedure page is completely loaded.

<%@ Page Language="VB" AutoEventWireup="false"
CodeFile="WorstPerfroming.aspx.vb" Inherits="WorstPerfroming" %>

<!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>Worst Performing Statements</title>
</head>
<body>
<form id="form1" runat="server">
<div>
Worst Performing Statements
<asp:LinkButton ID="LinkButton1" runat="server"
PostBackUrl="~/Default.aspx">Home</asp:LinkButton><br />
<br />
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1"
DataTextField="SQLServerInstanceName"
DataValueField="SQLServerInstanceName">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1"
runat="server" ConnectionString="<%$
ConnectionStrings:SQLDiagM46ConnectionString8 %>"
SelectCommand="select distinct SQLServerInstanceName from
MonitoredSQLServers
">
</asp:SqlDataSource>
<br />
<asp:Calendar ID="Calendar1" runat="server" BackColor="White"
BorderColor="#999999"
CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana"
Font-Size="8pt"
ForeColor="Black" Height="180px" Width="200px">
<SelectedDayStyle BackColor="#666666" Font-Bold="True"
ForeColor="White" />
<TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
<SelectorStyle BackColor="#CCCCCC" />
<WeekendDayStyle BackColor="LightCyan" />
<OtherMonthDayStyle ForeColor="Gray" />
<NextPrevStyle VerticalAlign="Bottom" />
<DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True"
Font-Size="7pt" />
<TitleStyle BackColor="#999999" BorderColor="Black"
Font-Bold="True" />
</asp:Calendar>

</div>
<br />
<asp:GridView ID="GridView1" runat="server"
DataSourceID="SqlDataSource2">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:SQLDiagM46ConnectionString9 %>"
SelectCommand="usp_IderaWorstPerforming"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1"
Name="sqlname" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="Calendar1" Name="thedate"
PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
Hi...

Use javascript to do that...
on form submit show a div with absolute positioning ...

Thanks
Masudur
http://munnacs.110mb.com

Jun 25 '07 #2

P: n/a
Re:
!How to display a "loading page, please wait" box...

See the samples in chapter 3 :

http://www.daveandal.net/books/6744/samples.aspx

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
======================================
"geoffa" <ge****@discussions.microsoft.comwrote in message
news:41**********************************@microsof t.com...
>I cannot figure this out and would appreciate any help.....
I have a datagrid view that displays the results from a Stored Procedure.
it can take awhile to load.....
the stored procedure fires when a Calendar is clicked. ( a date is part of
the stored procedure ) How can i just show a new page or a pop-up that says
"please wait" until the stored procedure has run and gotten all the data and
the page is completely loaded? In all the examples i have studied, there is
always a button click event or are written in C#....
I was hoping to just use the Visible = True on a new page until the stored
procedure page is completely loaded.
<%@ Page Language="VB" AutoEventWireup="false"
CodeFile="WorstPerfroming.aspx.vb" Inherits="WorstPerfroming" %>

<!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>Worst Performing Statements</title>
</head>
<body>
<form id="form1" runat="server">
<div>
Worst Performing Statements
<asp:LinkButton ID="LinkButton1" runat="server"
PostBackUrl="~/Default.aspx">Home</asp:LinkButton><br />
<br />
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1"
DataTextField="SQLServerInstanceName"
DataValueField="SQLServerInstanceName">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1"
runat="server" ConnectionString="<%$
ConnectionStrings:SQLDiagM46ConnectionString8 %>"
SelectCommand="select distinct SQLServerInstanceName from
MonitoredSQLServers
">
</asp:SqlDataSource>
<br />
<asp:Calendar ID="Calendar1" runat="server" BackColor="White"
BorderColor="#999999"
CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana"
Font-Size="8pt"
ForeColor="Black" Height="180px" Width="200px">
<SelectedDayStyle BackColor="#666666" Font-Bold="True"
ForeColor="White" />
<TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
<SelectorStyle BackColor="#CCCCCC" />
<WeekendDayStyle BackColor="LightCyan" />
<OtherMonthDayStyle ForeColor="Gray" />
<NextPrevStyle VerticalAlign="Bottom" />
<DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True"
Font-Size="7pt" />
<TitleStyle BackColor="#999999" BorderColor="Black"
Font-Bold="True" />
</asp:Calendar>

</div>
<br />
<asp:GridView ID="GridView1" runat="server"
DataSourceID="SqlDataSource2">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:SQLDiagM46ConnectionString9 %>"
SelectCommand="usp_IderaWorstPerforming"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1"
Name="sqlname" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="Calendar1" Name="thedate"
PropertyName="SelectedDate"
Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
</form>
</body>
</html>


Jun 25 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.