73-6장 닷넷노트_검색 (DotNetNote

73-6장 닷넷노트_검색 (DotNetNote_Search)

Magic_kit 2009. 11. 2. 14:29

Search.aspx

<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="BoardSearch.aspx.cs"
Inherits="DotNetNote_BoardSearch" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>검색 결과</title>
<link href="../DotNetNote/DotNetNote.css"
    rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
    <div>
      <h3>완성형 게시판</h3>
      <font style="font-size: 9pt; color: #ff0000">
        글 검색 - 검색 조건에 맞는 항목을 나열합니다.</font>
      <hr width="100%" size="1" />
      <div align="center">
        <table border="0" cellpadding="0"
          cellspacing="0">
          <tr>
            <td>
              <asp:GridView ID="ctlBoardList"
                runat="server" AutoGenerateColumns="False"
                CellPadding="4" ForeColor="Black"
                GridLines="None" AllowPaging="True"
                DataKeyNames="Num"
                OnPageIndexChanging="ctlBoardList_PageIndexChanging"
                PageSize="10">
                <FooterStyle BackColor="#5D7B9D"
                  Font-Bold="True" ForeColor="White" />
                <Columns>
                  <asp:TemplateField HeaderText="번호">
                    <ItemTemplate>
                      <%# Eval("Num") %>
                    </ItemTemplate>
                    <HeaderStyle HorizontalAlign="Center"
                      Width="30px" />
                  </asp:TemplateField>
                  <asp:TemplateField HeaderText="제 목">
                    <ItemTemplate>
                      <a href='BoardView.aspx?Num=<%# Eval(
                        "Num") %>&SearchField=<%=Request[
                          "SearchField"]%>&SearchQuery=<%=Request[
                            "SearchQuery"]%>'>
                        <%# Eval("Title") %>
                      </a>
                    </ItemTemplate>
                    <HeaderStyle Width="350px" />
                  </asp:TemplateField>
                  <asp:BoundField DataField="Name"
                    HeaderText="작성자">
                    <HeaderStyle HorizontalAlign="Center"
                      Width="60px" />
                  </asp:BoundField>
                  <asp:BoundField DataField="PostDate"
                    HeaderText="작성일" DataFormatString="{0:yyyy-MM-dd}"
                    HtmlEncode="False">
                    <HeaderStyle HorizontalAlign="Center"
                      Width="70px" />
                  </asp:BoundField>
                  <asp:BoundField DataField="ReadCount"
                    HeaderText="조회수">
                    <ItemStyle HorizontalAlign="Right" />
                    <HeaderStyle HorizontalAlign="Center"
                      Width="50px" />
                  </asp:BoundField>
                </Columns>
                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                <EditRowStyle BackColor="#999999" />
                <SelectedRowStyle BackColor="#E2DED6"
                  Font-Bold="True" ForeColor="#333333" />
                <PagerStyle BackColor="#C0C0FF"
                  ForeColor="Black" HorizontalAlign="Center" />
                <HeaderStyle BackColor="#5D7B9D"
                  Font-Bold="True" ForeColor="White" />
                <AlternatingRowStyle BackColor="White"
                  ForeColor="#284775" />
                <PagerSettings Mode="NumericFirstLast" />
              </asp:GridView>
            </td>
          </tr>
          <tr>
            <td>
              <table border="0" width="100%"
                cellpadding="3" cellspacing="0">
                <tr>
                  <td width="25%">
                     </td>
                  <td width="50%" align="center">
                    <font face="굴림"></font>
                  </td>
                  <td width="25%" align="right">
                    <asp:Button ID="btnWrite" runat="server"
                      BorderColor="#404040" BorderStyle="Groove"
                      BorderWidth="1px" Text="검색종료"
                      OnClick="btnWrite_Click"></asp:Button> 
                  </td>
                </tr>
              </table>
            </td>
          </tr>
        </table>
      </div>
    </div>
</form>
</body>
</html>

Search.aspx.Cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 System.Data.SqlClient;
using System.IO;

/// <summary>
/// BoardSearch : 완성형(DotNetNote) 게시판의 검색 페이지
/// </summary>
public partial class DotNetNote_BoardSearch : System.Web.UI.Page
{
#region Event Handlers
// 검색 결과 출력
protected void Page_Load(object sender, System.EventArgs e)
{
    if (!Page.IsPostBack)
    {
      ReadData();
    }
}

// 글쓰기 페이지로 이동
protected void btnWrite_Click(object sender, System.EventArgs e)
{
Response.Redirect("./BoardList.aspx");
}

// 페이지 링크 이동 구현
protected void ctlBoardList_PageIndexChanging(
    object sender, GridViewPageEventArgs e)
{
    this.ctlBoardList.PageIndex = e.NewPageIndex;
    ReadData();
}
#endregion

#region Private Methods
//데이터 읽어서 그리드뷰에 출력하는 함수(메서드)
private void ReadData()
{
    SqlConnection objCon = new SqlConnection(
      ConfigurationManager.ConnectionStrings[
        "ConnectionString"].ConnectionString);
    objCon.Open();

SqlCommand objCmd = new SqlCommand("SearchDotNetNote", objCon);
objCmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter objDa = new SqlDataAdapter();
objDa.SelectCommand = objCmd;

    objCmd.Parameters.Add(
      "@SearchField", SqlDbType.VarChar, 25).Value =
        Request["SearchField"];
    objCmd.Parameters.AddWithValue(
      "@searchQuery", Request["SearchQuery"]);

DataSet objDs = new DataSet();
objDa.Fill(objDs, "DotNetNote");

ctlBoardList.DataSource = objDs;
ctlBoardList.DataBind();
}
#endregion
}