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; // 추가
public partial class Board_List : System.Web.UI.Page
{
#region ## 전역변수
public int CurrentNum = 1;
SqlConnection conn = null;
SqlDataAdapter Adapt = null;
DataSet ds = null;
SqlCommand cmd = null;
SqlDataReader read = null;
#endregion
/// <summary>
/// 생성자
/// </summary>
public Board_List()
{
conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBconStr"].ConnectionString);
cmd = new SqlCommand();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillGridView();
}
}
/// <summary>
/// 그리드뷰를 채우는 메서드
/// </summary>
private void FillGridView()
{
// 쿼리 문자열
string mainQry = String.Empty;
string opQry = String.Empty;
string orQry = String.Empty;
orQry = "ORDER BY BoardId DESC ";
mainQry = "SELECT BoardId ,Title, Writer ,ReadCount, RegDate " +
"FROM t_Board " + orQry;
cmd.Connection = conn;
cmd.CommandText = mainQry;
Adapt = new SqlDataAdapter(cmd);
ds = new DataSet();
Adapt.Fill(ds);
if (ds != null)
{
gvBoard.DataSource = ds.Tables[0];
gvBoard.DataBind();
}
}
/// <summary>
/// 그리드뷰 페이지를 변경할때 발생하는 이벤트
/// </summary>
/// <param name="sender"></param>
/// <param name="e">새 페이지 인덱스 사용 </param>
protected void gvBoard_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvBoard.PageIndex = e.NewPageIndex;
FillGridView();
}
}