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

많이 해봤잖아 그제???

SQL에서 쿼리 날려보고 복사 붙여넣기하면된단다

 

하나도 남김없이 복사해라

그림에서는 글쓰기하고 유효성 검사 선택못했는데 하면된다

///////////////////// board_edit.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_Edit : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

FillEditContent();

}

}

private void FillEditContent()

{

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

SqlConnection conn =

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

string strSelQry = "SELECT writer, title,content " +

  "FROM t_board " +

  "WHERE boardID = @boardID ";

SqlCommand cmd = new SqlCommand(strSelQry, conn);

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

conn.Open();

SqlDataReader read = cmd.ExecuteReader();

if (read.Read())

{

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

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

txtContent.Text = read["content"].ToString();

}

read.Close();

conn.Close();

}

protected void ibOK_Click(object sender, ImageClickEventArgs e)

{

UpdateContent();

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

}

private void UpdateContent()

{

SqlConnection conn =

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

string strUpQry = "UPDATE t_board SET " +

 "writer = @writer, " +

 "title = @title ," +

 "content = @content " +

 "WHERE BoardID = @BoardID ";

SqlCommand cmd = new SqlCommand(strUpQry, 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;

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

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

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

}

}

///////////////////// board_view.aspx ///  의 추가사항

/// <summary>

///  삭제 버튼

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void ibDelete_Click(object sender, ImageClickEventArgs e)

{

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

DeleteContent(boardId);

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

}

자~!!!!!!!!  마지막으로 올려보자~!

끝

집에가자~!