ASP.NET 게시판 만들기 따라와 # 4

 

SELECT BoardId ,Title, Writer ,ReadCount, RegDate

FROM t_Board

ORDER BY BoardId DESC

테이블의 TD 스타일을 지워준다 1열 3열 4열

////////////////////////////// 아래는 소스 ////////////////////////////////

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();

}

}

잘되지??  ~!! 신기하네???