06.ASP.NET - 기본형 게시판(7) : 검색(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