ASP.NET

using System;<br />
using System.Data;<br />
using System.Configuration;<br />
using System.Collections;<br />
using System.Web;<br />
using System.Web.Security;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.WebControls.WebParts;<br />
using System.Web.UI.HtmlControls;<br />
using System.Data.SqlClient;<br />
<br />
<br />
    /// <summary><br />
    /// Demonstrates how to work with SqlConnection objects<br />
    /// </summary><br />
    class SqlConnectionDemo<br />
    {<br />
    static void Main()<br />
    {<br />
        // 1. Instantiate the connection<br />
        SqlConnection conn = new SqlConnection("Data Source=;Initial Catalog=SupportIIS;User ID=sa ;Password=password");<br />
<br />
        SqlDataReader SupportIIS_rdr = null; <br />
<br />
        try<br />
        {<br />
            // 2. Open the connection<br />
            conn.Open();<br />
<br />
            // 3. Pass the connection to a command object<br />
            SqlCommand cmd = new SqlCommand("select * from ", conn);<br />
<br />
//TEST<br />
            // 1. Instantiate a new command with a query and connection<br />
            SqlCommand cmd = new SqlCommand("select CategoryName from SupportIIS", conn);<br />
<br />
            // 2. Call Execute reader to get query results<br />
            SqlDataReader SupportIIS_rdr = cmd.ExecuteReader();<br />
<br />
<br />
//TEST END<br />
            // get query results<br />
            SupportIIS_rdr = cmd.ExecuteReader();<br />
<br />
            // print the CustomerID of each record<br />
           while (SupportIIS_rdr.Read())<br />
				{<br />
					// get the results of each column<br />
					string categories1 = (string)SupportIIS_rdr["Categories"];<br />
					string MonthYear1 = (string)SupportIIS_rdr["MonthYear"];<br />
					string repeatCall1 = (string)SupportIIS_rdr["repeatCall"];<br />
<br />
					// print out the results<br />
					Console.Write("{0,-25}", categories1);<br />
					Console.Write("{0,-20}", MonthYear1);<br />
					Console.Write("{0,-25}", repeatCall1);<br />
					Console.WriteLine();<br />
                }}<br />
            finally<br />
        {<br />
            // close the reader to pervent buildup of readers?<br />
            if (SupportIIS_rdr != null)<br />
            {<br />
                SupportIIS_rdr.Close();<br />
            }<br />
<br />
            // 5. Close the connection<br />
            if (conn != null)<br />
            {<br />
                conn.Close();<br />
            }<br />
        }}<br />
    }<br />
  }<br />
}<br />

Error	1	Type or namespace definition, or end-of-file expected	c:\inetpub\wwwroot\SQLConnectionTest\SQLConnection.aspx.cs	75	3	http://localhost/SQLConnectionTest/<br />