|
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
} | 
