06.ASP.NET - 기본형 게시판(7) : 검색(Search) 페이지

Search(검색) : 검색 페이지

---

Search.aspx

<div> <h3>검색 리스트</h3> <asp:GridView ID="ctlSearchList" runat="server"     AutoGenerateColumns="false">       <Columns>       <asp:BoundField HeaderText="번호" DataField="Num" />             <asp:HyperLinkField HeaderText="제목"           DataNavigateUrlFields="Num"           DataNavigateUrlFormatString="View.aspx?Num={0}"           DataTextField="Title" ItemStyle-Width="350px" />       <asp:BoundField HeaderText="작성자" DataField="Name" />             <asp:BoundField HeaderText="작성일" DataField="PostDate"           DataFormatString="{0:yyyy-mm-dd}" />                 <asp:BoundField HeaderText="조회수" DataField="ReadCount" />   </Columns>   </asp:GridView> <asp:Button ID="btnList" runat="server" Text="검색 종료"     onclick="btnList_Click" /> </div>

---

Search.aspx.cs

protected void Page_Load(object sender, EventArgs e) {     if (!Page.IsPostBack)     {         DisplayData(); // 그리드뷰 컨트롤에 데이터 출력     }    }   private void DisplayData() {     SqlConnection con = new SqlConnection(         ConfigurationManager.ConnectionStrings         ["ConnectionString"].ConnectionString);       SqlCommand cmd = new SqlCommand("SearchBasic", con);     cmd.CommandType = CommandType.StoredProcedure;       cmd.Parameters.AddWithValue("@SearchField"         , Request["SearchField"]); //Name, title     cmd.Parameters.AddWithValue("@SearchQuery"         , Request["SearchQuery"]); //홍길동, 안녕       SqlDataAdapter da = new SqlDataAdapter(cmd);       DataSet ds = new DataSet();       da.Fill(ds, "Basic");       this.ctlSearchList.DataSource = ds.Tables[0];     this.ctlSearchList.DataBind(); }   protected void btnList_Click(object sender, EventArgs e) {     Response.Redirect("List.aspx"); }

---

결과화면

[그림6-1]

Search.aspx

Search.aspx.cs