using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; namespace label_cs { /// <summary> /// label_xml_reader에 대한 요약 설명입니다. /// </summary> public class label_xml_reader : System.Web.UI.Page { protected System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1; protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1; protected System.Data.OleDb.OleDbConnection oleDbConnection1; private void Page_Load(object sender, System.EventArgs e) { // 여기에 사용자 코드를 배치하여 페이지를 초기화합니다. Response.ContentEncoding = System.Text.Encoding.Default; this.oleDbConnection1.Open (); System.Data.OleDb.OleDbDataReader myReader; myReader = this.oleDbSelectCommand1.ExecuteReader(); Response.Write("<?xml version='1.0' encoding='euc-kr'?>"); Response.Write("<root>" + "\n"); while(myReader.Read()) { Response.Write(" <받는사람>\n" ); Response.Write(" <우편번호>" + myReader["PostalCode"].ToString() + "</우편번호>"); Response.Write(" <주소>" + myReader["City"].ToString() + " " + myReader["Address"].ToString() + "</주소>"); Response.Write(" <회사명>" + myReader["CompanyName"].ToString() + "</회사명>"); Response.Write(" <담당자명>" + myReader["ContactName"].ToString() + "</담당자명>"); Response.Write(" <담당자직책명>" + myReader["ContactTitle"].ToString() + "</담당자직책명>"); Response.Write(" </받는사람>\n" ); } Response.Write("</root>" + "\n"); // 데이터 베이스 닫기 myReader.Close() ; this.oleDbConnection1.Close() ; } #region Web Form 디자이너에서 생성한 코드 override protected void OnInit(EventArgs e) { // // CODEGEN: 이 호출은 ASP.NET Web Form 디자이너에 필요합니다. // InitializeComponent(); base.OnInit(e); } /// <summary> /// 디자이너 지원에 필요한 메서드입니다. /// 이 메서드의 내용을 코드 편집기로 수정하지 마십시오. /// </summary> private void InitializeComponent() { this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(); this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand(); this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection(); // // oleDbDataAdapter1 // this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1; this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "Customers", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("CustomerID", "CustomerID"), new System.Data.Common.DataColumnMapping("CompanyName", "CompanyName"), new System.Data.Common.DataColumnMapping("ContactName", "ContactName"), new System.Data.Common.DataColumnMapping("ContactTitle", "ContactTitle"), new System.Data.Common.DataColumnMapping("Address", "Address"), new System.Data.Common.DataColumnMapping("City", "City"), new System.Data.Common.DataColumnMapping("Region", "Region"), new System.Data.Common.DataColumnMapping("PostalCode", "PostalCode"), new System.Data.Common.DataColumnMapping("Country", "Country"), new System.Data.Common.DataColumnMapping("Phone", "Phone"), new System.Data.Common.DataColumnMapping("Fax", "Fax")})}); // // oleDbSelectCommand1 // this.oleDbSelectCommand1.CommandText = "SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region," + " PostalCode, Country, Phone, Fax FROM Customers Where City like '%" + Request.QueryString["City"].ToString() + "%'"; this.oleDbSelectCommand1.Connection = this.oleDbConnection1; // // oleDbConnection1 // this.oleDbConnection1.ConnectionString = @"User ID=sa;Tag with column collation when possible=False;Data Source=hwabong;Password=cab123;Initial Catalog=NWind;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=True;Provider=""SQLOLEDB.1"";Workstation ID=HWABONG;Use Encryption for Data=False;Packet Size=4096"; this.Load += new System.EventHandler(this.Page_Load); } #endregion } }