ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Static Sql connection data source (C#)
<%@ Page Language="C#" %>

    protected void dataSelect(object sender, SqlDataSourceSelectingEventArgs e)
    {
        lblMessage.Text = "Retrieving data from database";
    }



    Cache SqlDataSource


    
    

    
            id="lblMessage"
        EnableViewState="false"
        Runat="server" />
    
    
            id="grdEmployee"
        DataSourceID="srcEmployee"
        Runat="server" />
        
            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=rntsoftuser;Password='password';"
        Runat="server" 
        OnSelecting="dataSelect" />
    
    

     


<%-- server=localhost;Initial Catalog=TT;User Id=sa;Password=yourpassword; --%>