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="Worst Perfroming.aspx .vb" Inherits="Worst Perfroming" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<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:LinkButt on ID="LinkButton1 " runat="server"
PostBackUrl="~/Default.aspx">H ome</asp:LinkButton> <br />
<br />
<asp:DropDownLi st ID="DropDownLis t1" runat="server"
DataSourceID="S qlDataSource1"
DataTextField=" SQLServerInstan ceName"
DataValueField= "SQLServerInsta nceName">
</asp:DropDownLis t><asp:SqlDataS ource ID="SqlDataSour ce1"
runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:SQLDiagM46Co nnectionString8 %>"
SelectCommand=" select distinct SQLServerInstan ceName from
MonitoredSQLSer vers
">
</asp:SqlDataSour ce>
<br />
<asp:Calendar ID="Calendar1" runat="server" BackColor="Whit e"
BorderColor="#9 99999"
CellPadding="4" DayNameFormat=" Shortest" Font-Names="Verdana"
Font-Size="8pt"
ForeColor="Blac k" Height="180px" Width="200px">
<SelectedDaySty le BackColor="#666 666" Font-Bold="True"
ForeColor="Whit e" />
<TodayDayStyl e BackColor="#CCC CCC" ForeColor="Blac k" />
<SelectorStyl e BackColor="#CCC CCC" />
<WeekendDayStyl e BackColor="Ligh tCyan" />
<OtherMonthDayS tyle ForeColor="Gray " />
<NextPrevStyl e VerticalAlign=" Bottom" />
<DayHeaderSty le BackColor="#CCC CCC" Font-Bold="True"
Font-Size="7pt" />
<TitleStyle BackColor="#999 999" BorderColor="Bl ack"
Font-Bold="True" />
</asp:Calendar>
</div>
<br />
<asp:GridView ID="GridView1" runat="server"
DataSourceID="S qlDataSource2">
</asp:GridView>
<asp:SqlDataSou rce ID="SqlDataSour ce2" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:SQLDiagM46Co nnectionString9 %>"
SelectCommand=" usp_IderaWorstP erforming"
SelectCommandTy pe="StoredProce dure">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Drop DownList1"
Name="sqlname" PropertyName="S electedValue"
Type="String" />
<asp:ControlPar ameter ControlID="Cale ndar1" Name="thedate"
PropertyName="S electedDate"
Type="DateTime" />
</SelectParameter s>
</asp:SqlDataSour ce>
</form>
</body>
</html>
