2014년 2월 5일 수요일

ASP.NET으로 작성한 게시판-안정환, 오라클자바커뮤니티운영,오엔제이프로그래밍실무교육센터,C#,ASP.NET강좌교육,구로디지털오엔제이프로그래밍실무교육센터

ASP.NET으로 작성한 게시판-안정환, 오라클자바커뮤니티운영,오엔제이프로그래밍실무교육센터,C#,ASP.NET강좌교육,구로디지털오엔제이프로그래밍실무교육센터














메인으로 list 페이지를 사용하였고 검색페이지는 list 페이지와 기능이 완벽하게 동일함으로 스킵하였습니다.

페이지코딩 순서는 list => write => view => update => delete 입니다.

[list.aspx]


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
using System.Data.OleDb;

namespace Board
{
    public partial class list : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            boardGrid_Bind();
        }

        protected void WriteButton_Click(object sender, EventArgs e)
        {
            Response.Redirect("write.aspx");
        }

        protected void boardGrid_Bind()
        {
            OleDbDataAdapter adapter = null;
            OleDbConnection conn;
            string conStr = "Provider=MSDAORA;data source=ONJ;User ID=scott;Password=tiger";
            conn = new OleDbConnection(conStr);
            conn.Open();
            string sqlString = "select * from board ORDER BY wNo DESC";

            adapter = new OleDbDataAdapter(sqlString, conn);
            DataSet ds = new DataSet();

            adapter.Fill(ds);

            ListGrid.DataSource = ds;
            ListGrid.DataBind();
            conn.Close();
        }

     

        protected void btnSearch_Click(object sender, EventArgs e)
        {
            OleDbDataAdapter adapter = null;
            OleDbConnection conn;
            string conStr = "Provider=MSDAORA;data source=ONJ;User ID=scott;Password=tiger";
            conn = new OleDbConnection(conStr);
            conn.Open();

            //값이 있을 때만 검색
            if (txtSearchString.Text.Trim() != "")
            {
                string where = "";

                if (listSearch.SelectedItem.Value != "wName")
                {
                    where = string.Format(
                    " where {0} like '%{1}%'",
                    listSearch.SelectedItem.Value,
                    txtSearchString.Text
                    );
                }
                else
                {
                    where = string.Format(
                    " where wName like '%{0}%' or wContent like '%{0}%' or wTitle like '%{0}%'",
                    txtSearchString.Text
                    );
                }

                string sqlString = "select wNo, wTitle, wContent, wName, wDate, wEmail from board "+where+" ORDER BY wNo DESC";
                adapter = new OleDbDataAdapter(sqlString, conn);
                DataSet ds = new DataSet();

                adapter.Fill(ds);

                ListGrid.DataSource = ds;
                ListGrid.DataBind();
                conn.Close();

            }
        }     
    }
}


[write]

namespace Board
{
    public partial class wrtie : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        //글목록 페이지ㅣ 이동 
        protected void btnList_Click(object sender, EventArgs e)
        {
            Response.Redirect("list.aspx");
        }

        //저장 글저장 
        protected void btnSave_Click(object sender, EventArgs e)
        {

            OleDbConnection conn;

            string conStr = "Provider=MSDAORA;data source=ONJ;User ID=scott;Password=tiger";
            conn = new OleDbConnection(conStr);

            conn.Open();
            OleDbCommand cmd = new OleDbCommand("insert into board(wNo, wName,wEmail,wTitle,wContent,wPwd, wDate ) values(boa_seq.nextval,'" + this.txtName.Text +
                "','" + this.txtEmail.Text + "','" + this.txtTitle.Text + "','" + this.txtContent.Text + "','" + this.txtPwd.Text + "',sysdate)");
            cmd.Connection = conn;

            cmd.ExecuteNonQuery();
            conn.Close();                

            Response.Redirect("list.aspx");

        }
    }
}

[view]

namespace Board
{
    public partial class view : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                try
                {
                    OleDbConnection conn;
                    string conStr = "Provider=MSDAORA;data source=ONJ;User ID=scott;Password=tiger";
                    conn = new OleDbConnection(conStr);
                    conn.Open();

                    OleDbCommand command = conn.CreateCommand();
                    command.CommandText = "select wNo, wTitle, wContent, wName, wDate, wEmail, wPwd from board  where wNo = " + Request["wNo"];

                    OleDbDataReader orareader = command.ExecuteReader();//SELECT 쿼리실행

                    if (orareader.HasRows)
                    {
                        if (orareader.Read())
                        {
                            this.lblCount.Text = orareader["wDate"].ToString();
                            this.lblPasswod.Text = "*****";                           
                            this.linkName.Text = orareader["wName"].ToString();
                            this.lblTitle.Text = orareader["wTitle"].ToString();
                            this.lblContent.Text = orareader["wContent"].ToString();
                            
                        }
                    }
                    conn.Close();
                }
                catch (Exception ex)
                {
                    Response.Write(ex.ToString());
                }
            }
        }

        // 글목록으로 이동
        protected void btnList_Click(object sender, EventArgs e)
        {
            Response.Redirect("list.aspx");
        }
        protected void btnDelete_Click(object sender, EventArgs e)
        {
            //Response.Redirect("delete.aspx");
             Response.Redirect(string.Format("delete.aspx?wNo={0}", Request.QueryString["wNo"]));
        }
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            //Response.Redirect("update.aspx");
             Response.Redirect(string.Format("update.aspx?wNo={0}", Request.QueryString["wNo"]));
        }
    }
}


[update]

namespace Board
{
    public partial class update : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                try
                {
                    OleDbConnection conn;
                    string conStr = "Provider=MSDAORA;data source=ONJ;User ID=scott;Password=tiger";
                    conn = new OleDbConnection(conStr);
                    conn.Open();

                    OleDbCommand command = conn.CreateCommand();
                    command.CommandText = "select wNo, wTitle, wContent, wName, wDate, wEmail, wPwd from board  where wNo = " + Request["wNo"];

                    OleDbDataReader orareader = command.ExecuteReader();//SELECT 쿼리실행

                    if (orareader.HasRows)
                    {
                        if (orareader.Read())
                        {
                            this.txtEmail.Text = orareader["wEmail"].ToString();
                            this.txtName.Text = orareader["wName"].ToString();
                            this.txtTitle.Text = orareader["wTitle"].ToString();
                            this.txtContent.Text = orareader["wContent"].ToString();

                        }
                    }
                    conn.Close();
                }
                catch (Exception ex)
                {
                    Response.Write(ex.ToString());
                }
            }

        }

        // 글목록으로 이동
        protected void btnList_Click(object sender, EventArgs e)
        {
            Response.Redirect("list.aspx");
        }

        // 취소
        protected void btnCancel_Click(object sender, EventArgs e)
        {

        }

        // 수정
        protected void btnSave_Click(object sender, EventArgs e)
        {
            OleDbConnection conn;
            string conStr = "Provider=MSDAORA;data source=ONJ;User ID=scott;Password=tiger";
            conn = new OleDbConnection(conStr);
            conn.Open();

            OleDbCommand command = conn.CreateCommand();
            command.CommandText = "select wPwd from board  where wNo = " + Request["wNo"];

            string wPwd = command.ExecuteScalar().ToString();//wpwd 컬럼의 선택된 값을 string 형태로 불러온다.

            //불러온 비밀번호가 맞는지 확인후 삭제 쿼리 실행
            if (this.txtPwd.Text == wPwd)
            {
                command.CommandText = "update board set wName ='" + txtPwd.Text + "' , wEmail='" + txtEmail.Text + "', wTitle='" + txtTitle.Text + "', wContent='" + txtContent.Text + "' , wDate = sysdate where wNo= " + Request["wNo"];
                command.ExecuteNonQuery();
                Clientscript.RegisterStartupscript(typeof(Page), "alert", "<script language=Javascript>alert('수정이 완료되었습니다!!!');</script>");
                Response.Redirect("list.aspx");
            }
            else Clientscript.RegisterStartupscript(typeof(Page), "alert", "<script language=Javascript>alert('비밀번호도 모릅니까? 다시해!');</script>");

            conn.Close();
        }
    }
}


[delete]

namespace Board
{
    public partial class delete : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }        

        // 글목록
        protected void btnList_Click(object sender, EventArgs e)
        {
            Response.Redirect("list.aspx");
        }

        // 취소
        protected void btnCancel_Click(object sender, EventArgs e)
        {

        }

        // 삭제처리
        protected void btnDelete_Click(object sender, EventArgs e)
        {            
            OleDbConnection conn;
            string conStr = "Provider=MSDAORA;data source=ONJ;User ID=scott;Password=tiger";
            conn = new OleDbConnection(conStr);
            conn.Open();

            OleDbCommand command = conn.CreateCommand();
            command.CommandText = "select wPwd from board  where wNo = " + Request["wNo"];     

           string wPwd = command.ExecuteScalar().ToString();//wpwd 컬럼의 선택된 값을 string 형태로 불러온다.
          
            //불러온 비밀번호가 맞는지 확인후 삭제 쿼리 실행
            if (this.txtPwd.Text == wPwd)
            {
                command.CommandText = "delete from board  where wNo=" + Request["wNo"];
                command.ExecuteNonQuery();               
                Clientscript.RegisterStartupscript(typeof(Page), "alert","<script language=Javascript>alert('삭제되었다!!! 영원히!!');</script>");
                Response.Redirect("list.aspx");
            }
            else Clientscript.RegisterStartupscript(typeof(Page), "alert", "<script language=Javascript>alert('비밀번호도 모릅니까? 다시해!');</script>");

            conn.Close();          
        }

    }
}

C#4.0, ADO.NET, Network 프로그래밍 5일 35시간   02-24
C#,ASP.NET마스터 18일 54시간   02-18
C#,ASP.NET마스터 8일 56시간   02-09
닷넷실무자를위한WPF개발자과정 8일 56시간   02-22

댓글 없음:

댓글 쓰기