개발 참고자료

web.config ========================== LinkList.aspx ========================== <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="LinkList.aspx.cs" Inherits="MemoEngine.Modules.Link.LinkList" %> <%@ Register Src="~/Modules/Link/LInkListUserControl.ascx" TagPrefix="uc1" TagName="LInkListUserControl" %>

LInkListUserControl.ascx ========================== <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="LInkListUserControl.ascx.cs" Inherits="MemoEngine.Modules.Link.LInkListUserControl" %>

링크 리스트

LInkListUserControl.ascx.cs ========================== using Microsoft.Practices.EnterpriseLibrary.Data; using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.Configuration; using System.Web.UI; using System.Web.UI.WebControls; namespace MemoEngine.Modules.Link { public partial class LInkListUserControl : System.Web.UI.UserControl { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DisplaData(); } } private void DisplaData() { ////[1] sqlonnection 클래스의 인스턴스 생성 //SqlConnection con = new SqlConnection(); ////[2] ConnectionString 속성지정 //con.ConnectionString = "server=127.0.0.1;database=mnpDB;uid=mnpUSR;pwd=XXX"; ////[3] Open 메소드로 데이터베이스 연결 //con.Open(); ////[!] 입력예시문 실행 ////sqlCommand의 인스턴스 생성 //SqlCommand sqlCmd = new SqlCommand(); //sqlCmd.Connection = con; //// CommandText 속성에 모든 명령어 지정 //sqlCmd.CommandText = "Select * From Links Order By Id Asc"; ////CommandType 속서어 : Text, SP //sqlCmd.CommandType = CommandType.Text; ////데이터 어댑터 객체 //SqlDataAdapter sqlDA = new SqlDataAdapter(); //sqlDA.SelectCommand = sqlCmd; ////데이터셋 //DataSet ds_Data = new DataSet(); //sqlDA.Fill(ds_Data, "Links"); ////출력 //gv_LinkList.DataSource = ds_Data; //gv_LinkList.DataBind(); ////[4] Close 메소드로 데이터베이스 연결 종료 //con.Close(); this.gv_LinkList.DataSource = (new DatabaseProviderFactory()).Create("mnpbanana").ExecuteDataSet(CommandType.Text, "Select * From Links Order By Id Asc"); this.gv_LinkList.DataBind(); } } }