<%@ 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(); } %> 「全民潮台灣」短片徵件競賽 用你的鏡頭說一段最潮的台灣故事 - 首獎20萬元 - 外交部 x Cheers x 第一電商
<%--