Improving Performance with Connection Pooling : SqlConnection « Database « ASP.NET Tutorial

File: ShowUserConnections.aspx

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web.Configuration" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
<script runat="server">    void Page_Load()
        string connectionString = @"Min Pool Size=10;Data Source=.\SQLExpress;Integrated Security=True;AttachDbFileName=|DataDirectory|MyDatabase.mdf;User Instance=True";
        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand("SELECT * FROM master..sysprocesses WHERE hostname<>''", con);
        using (con)
            grdStats.DataSource = cmd.ExecuteReader();
<html xmlns="" >
<head id="Head1" runat="server">
    <title>Show User Connections</title>
    <form id="form1" runat="server">

    <h1>User Connections</h1>

        Runat="server" />


18.2.1.Retrieving Provider Statistics about the database commands executed with the connection
18.2.2.Displaying all provider statistics.
18.2.3.Improving Performance with Connection Pooling
18.2.4.Define data layer in a separate class
18.2.5.Hard code connection string in DropDownList