%@ Page Language="C#"%> <%@ Import Namespace ="System" %> <%@ Import Namespace="System.Data" %> <%@ Import NameSpace = "System.Data.SqlClient" %> <%@ Import NameSpace = "System.Web.Configuration" %> <% SqlConnection Conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["topicReader_ConnectionString"].ConnectionString); SqlCommand Cmd; String SelectComm; String CitySelect = ""; SelectComm = "select * from TwCityAddress"; Cmd = new SqlCommand(SelectComm, Conn); Conn.Open(); SqlDataReader dr = Cmd.ExecuteReader(); while (dr.Read()) { CitySelect = CitySelect + ""; } Cmd.Cancel(); dr.Close(); if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } %>