載入Loading Bar

 
因為在不同台主機資料庫讀取時，如果資料量大或主機繁忙時無法快速回傳資料 ，畫面空白。
所以在網路讀取資料庫資料時，增加出現一條loading bar，待資料取回顯示時，loading bar就自動消失。
  

 

 

<%@ Page Language="C#" Debug="true"%>

<%@ Import Namespace="System" %>

<%@ Import Namespace="System.Web" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.Sql" %>

<%@ Import Namespace="System.Data.SqlClient" %>

 

<script runat="server">

 

    protected void Page_Load(object sender, EventArgs e)

    {

 

    }

 

    protected void Button99_Click(object sender, EventArgs e)

    {

SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ProductionConnectionString"].ConnectionString);

string queryString = "select TOP 2000 * from Sales.Customer";

SqlCommand objCmd = new SqlCommand(queryString, objConn);

objConn.Open();

SqlDataReader objRdr = objCmd.ExecuteReader();

string r_CustomerID, r_TerritoryID, r_AccountNumber, r_CustomerType, r_rowguid;

while (objRdr.Read())

{

                           r_CustomerID = objRdr["CustomerID"].ToString();

r_TerritoryID = objRdr["TerritoryID"].ToString();

r_AccountNumber = objRdr["AccountNumber"].ToString();

r_CustomerType = objRdr["CustomerType"].ToString();

r_rowguid = objRdr["rowguid"].ToString();

Label99.Text += r_CustomerID + " " + r_TerritoryID + " " + r_AccountNumber + " " + r_CustomerType + " " + r_rowguid + "<br>";

}

objConn.Close();

}

 

</script>

 

<html>

<head runat="server">

<script type="text/javascript">

function ShowWaitDisplay()

{

document.getElementById('form1').style.display='none';

document.getElementById('loading').style.display='inline';

setTimeout('document.images["WaitImage"].src = "images/pleasewait.gif"', 900);  //設定setTimeout是因為IE上的動畫gif無法動

return true;

}

</script>

<style type="text/css">

#loading {  

    width:100%;  

    top:0px;  

    text-align:center;  

    padding:7px 0 0 0;  

    font:bold 11px Arial, Helvetica, sans-serif;  

} 

</style>

</head>

<body>

 

<div id="loading" style="display:none">

<center>

Loading Data, please wait...<br>  

<img id="WaitImage" src="images/pleasewait.gif" alt="loading..." />

</center>

</div> 

 

 

<form id="form1" runat="server">

 

<asp:Button ID="Button99" runat="server" OnClick="Button99_Click" OnClientClick="ShowWaitDisplay();" Text="取值" /><BR>

<asp:Label ID="Label99" runat="server" Text="" />

 

</form>

</body>

</html>

arrow
arrow
    全站熱搜

    adamschen9921 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄