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

사용한 쿼리문

INSERT INTO t_Board

(Writer, Title, Content , ReadCount , RegDate)

VALUES

('테스트', '타이틀', '컨텐츠' , 0 , GetDate())

SELECT BoardId ,Title, Writer ,ReadCount, RegDate

FROM t_Board

-- WHERE Title LIKE '%이틀%'

WHERE Writer LIKE '%테스트%'

ORDER BY BoardId DESC

INSERT INTO t_Board

(Writer, Title, Content , ReadCount , RegDate)

VALUES

(@Writer, @Title, @Content , 0 ,GetDate())

  protected void ibOK_Click(object sender, ImageClickEventArgs e)

{

SqlConnection conn =

new SqlConnection(ConfigurationManager.ConnectionStrings["DBconStr"].ConnectionString);

string strInsQry = "INSERT INTO t_Board " +

"(Writer, Title, Content , ReadCount , RegDate) " +

"VALUES " +

"(@Writer, @Title, @Content , 0 ,GetDate()) ";

SqlCommand cmd = new SqlCommand(strInsQry , conn);

cmd.Parameters.Add("@Writer" , SqlDbType.NVarChar , 50).Value = txtWriter.Text.Trim();

cmd.Parameters.Add("@Title", SqlDbType.NVarChar, 200).Value = txtTitle.Text.Trim();

cmd.Parameters.Add("@Content", SqlDbType.NText).Value = txtContent.Text.Trim();

conn.Open();

cmd .ExecuteNonQuery();

conn.Close();

Response.Redirect("Board_List.aspx");

}

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_View : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

if (!IsPostBack) // 처음 불려졌다면

{

UpdateReadCount(); // 조회수 증가 메서드

FillContents(); // 상세내용 채우는 메서드

}

    }

private void FillContents()

{

SqlConnection conn =

new SqlConnection(ConfigurationManager.ConnectionStrings["DBconStr"].ConnectionString);

string strSqlQry = "SELECT " + 

   "writer, Title, content, Readcount, regdate " +

   "FROM t_Board " +

   "WHERE boardid = @boardid ";

SqlCommand cmd = new SqlCommand(strSqlQry, conn);

cmd.Parameters.Add("@boardid" , SqlDbType.Int).Value = Request.QueryString["boardid"];

conn.Open();

SqlDataReader read = cmd.ExecuteReader();

if (read.Read())

{

lblTitle.Text = read["title"].ToString();

lblWriter.Text = read["writer"].ToString();

lblRegDate.Text = read["regdate"].ToString();

lblReadCount.Text = read["readCount"].ToString();

lblContent.Text = read["content"].ToString().Replace("\r\n","<br/>");

}

read.Close();

conn.Close();

}

private void UpdateReadCount()

{

SqlConnection conn =

new SqlConnection(ConfigurationManager.ConnectionStrings["DBconStr"].ConnectionString);

string strUpQry =  "UPDATE t_Board SET " +

   "ReadCount = ReadCount + 1 " +

   "WHERE BoardId = @BoardId ";

SqlCommand cmd = new SqlCommand(strUpQry, conn);

cmd.Parameters.Add("@BoardId", SqlDbType.Int).Value = Request.QueryString["BoardId"];

//Response.Write("<script>javascript:alert('"+"/"+"') </script>");

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

}

protected void ibEdit_Click(object sender, ImageClickEventArgs e)

{

string boardID = Request.QueryString["boardId"];

Response.Redirect("~/Board_Edit.aspx?BoardID=" + boardId);

}

protected void ibDelete_Click(object sender, ImageClickEventArgs e)

{

string boardId = Request.QueryString["boardid"];

DeleteContent(boardId);

                Response.Redirect("~/board_List.aspx");

}

private void DeleteContent(string boardId)

{

SqlConnection conn = 

new SqlConnection(ConfigurationManager.ConnectionStrings[""].ConnectionString);

string strDelQry = "";

SqlCommand cmd = new SqlCommand(strDelQry, conn);

cmd.Parameters.Add(" ", SqlDbType.Int).Value = boardId;

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

}

}