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; using System.Data.SqlClient; namespace SampleCS.Upload { /// /// List¿¡ ´ëÇÑ ¿ä¾à ¼³¸íÀÔ´Ï´Ù. /// public class List : System.Web.UI.Page { protected System.Web.UI.WebControls.DataGrid DataGrid1; protected System.Web.UI.WebControls.Button btnWrite; protected System.Web.UI.WebControls.TextBox SearchQuery; protected System.Web.UI.WebControls.DropDownList SearchField; protected System.Web.UI.WebControls.Button btnSearch; protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1; protected System.Web.UI.WebControls.ValidationSummary ValidationSummary1; private void Page_Load(object sender, System.EventArgs e) { if(!Page.IsPostBack) { ReadData(); } } private void ReadData()//µ¥ÀÌÅÍ Àо µ¥ÀÌÅͱ׸®µå¿¡ Ãâ·ÂÇÏ´Â ÇÔ¼ö(¸Þ¼­µå) { SqlConnection objCon = new SqlConnection(); objCon.ConnectionString = Application["CONNECTION_STRING"].ToString(); objCon.Open(); SqlCommand objCmd = new SqlCommand(); objCmd.Connection = objCon; objCmd.CommandText = "procListUpload"; objCmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter objDa = new SqlDataAdapter(); objDa.SelectCommand = objCmd; DataSet objDs = new DataSet(); objDa.Fill(objDs, "Upload"); DataGrid1.DataSource = objDs.Tables["Upload"].DefaultView; DataGrid1.DataBind(); } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: ÀÌ È£ÃâÀº ASP.NET Web Form µðÀÚÀ̳ʿ¡ ÇÊ¿äÇÕ´Ï´Ù. // InitializeComponent(); base.OnInit(e); } /// /// µðÀÚÀÌ³Ê Áö¿ø¿¡ ÇÊ¿äÇÑ ¸Þ¼­µåÀÔ´Ï´Ù. /// ÀÌ ¸Þ¼­µåÀÇ ³»¿ëÀ» ÄÚµå ÆíÁý±â·Î ¼öÁ¤ÇÏÁö ¸¶½Ê½Ã¿À. /// private void InitializeComponent() { this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged); this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click); this.btnWrite.Click += new System.EventHandler(this.btnWrite_Click); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void btnWrite_Click(object sender, System.EventArgs e) { Response.Redirect("./Write.aspx"); } private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e) { DataGrid1.CurrentPageIndex = e.NewPageIndex; ReadData(); } private void btnSearch_Click(object sender, System.EventArgs e) { string strQuery = "./Search.aspx?SearchField=" + SearchField.SelectedItem.Value + "&SearchQuery=" + SearchQuery.Text; Response.Redirect(strQuery); } } }