1. 비주얼 스튜디오 2005를 열고 웹사이트 하나 만들고....
2. 참조 추가해야한다 ㅋㅋ
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.ObjectBuilder;
using System.Data.Common;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//Database northWind = null;
DataSet dsCustomers = null;
if (!IsPostBack)
{
// 디자인패턴 중한부분 DatabaseFactory
// 엔터프라이즈 라이브러리쓰면 이런식으로 연결해야한다~!!
// 커넥션 Open과 Close가없다 ,,
// 엔터프라이즈 라이브러리가알아서한다
//northWind = DatabaseFactory.CreateDatabase("NorthwindConnectionString");
//string strSelQry = "SELECT * FROM Customers ";
//IDataReader reader = northWind.ExecuteReader(CommandType.Text, strSelQry);
//if (reader.Read())
//{
// GridView1.DataSource = reader;
// GridView1.DataBind();
dsCustomers = GetCustomers("");
if (dsCustomers != null)
{
GridView1.DataSource = dsCustomers;
GridView1.DataBind();
}
}
}
private DataSet GetCustomers(string customerId)
{
// 엔트프로아즈 Database클래스안에 LoadDataSet메서드에 값이 쏙들어간다
Database northWind = DatabaseFactory.CreateDatabase("NorthwindConnectionString");
string strSelQry = "SELECT * FROM Customers "
+ "WHERE customerID LIKE '%' + @customerID + '%' ";
DbCommand cmd = northWind.GetSqlStringCommand(strSelQry);
northWind.AddInParameter(cmd, "@customerID",DbType.String ,customerId);
DataSet ds = new DataSet();
northWind.LoadDataSet(cmd, ds, "Custommers");
return ds;
}
}