CSharp Cache Sql Data Source (C#) – ADO.Net Database

<%@ Page Language="C#" %><script runat="server">    protected void dataSelect(object sender, SqlDataSourceSelectingEventArgs e)
    {
        lblMessage.Text = "Retrieving data from database";
    }
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Cache SqlDataSource</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
 
    <asp:Label
        id="lblMessage"
        EnableViewState="false"
        Runat="server" />
    <br /><br />
 
    <asp:GridView
        id="grdEmployee"
        DataSourceID="srcEmployee"
        Runat="server" />
 
    <asp:SqlDataSource
        id="srcEmployee"
        EnableCaching="True"
        CacheDuration="3600"
        SelectCommand="SELECT * FROM Employee"
        ConnectionString="Data Source=whsql-v08.prod.mesa1.secureserver.net;Initial Catalog=DB_49907;User ID=w3mentoruser;Password='password';"
        Runat="server"
        OnSelecting="dataSelect" />
 
    </div>
    </form>
</body>
</html>
<%-- server=localhost;Initial Catalog=TT;User Id=sa;Password=yourpassword; --%>

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.