♣♣♣Carpe Diem

Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <a href="Default2.aspx?tbl=tblBoard">게시판 1번으로</a><br />
    <a href="Default2.aspx?tbl=tblPds">게시판 2번으로(자료실)</a><br />
    <a href="Default2.aspx?tbl=tblAlbum">게시판 3번으로(앨범)</a><br />
    <a href="Default2.aspx?tbl=tblQnA">게시판 4번으로(QnA)</a><br />
    <br />
    <br />
    <asp:LinkButton ID="LinkButton1" runat="server" onclick="btn_Click">게시판 1번으로</asp:LinkButton><br />
    <asp:LinkButton ID="LinkButton2" runat="server" onclick="btn_Click">게시판 2번으로(자료실)</asp:LinkButton><br />
    <asp:LinkButton ID="LinkButton3" runat="server" onclick="btn_Click">게시판 3번으로(앨범)</asp:LinkButton><br />
    <asp:LinkButton ID="LinkButton4" runat="server" onclick="btn_Click">게시판 4번으로(QnA)</asp:LinkButton><br />
    </div>
    </form>
</body>
</html>

Default.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

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

}

    protected void btn_Click(object sender, EventArgs e)
    {
       string tbl = null;
      LinkButton lnk = sender as LinkButton;
        switch(lnk.ID)
        {
            case "LinkButton1": tbl="tblBoard";break;
            case "LinkButton2": tbl="tblPds";break;
            case "LinkButton3": tbl="tblAlbum";break;
            case "LinkButton4": tbl="tblQnA";break;
            case "LinkButton5": tbl = "테이블";
                Session["tbl"] = tbl;
                Response.Redirect("Default3.aspx");
                break;
         }

        Session["tbl"] = tbl;
        Response.Redirect("Default2.aspx");
    }
}

Default2.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

Default2.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string tbl = null;
        if(Session["tbl"] == null)
         tbl = Request["tbl"];
        if(Request["tbl"] == null)
         tbl = Session["tbl"].ToString();
        string msg = null;
        string sql = "select * from ";
        switch (tbl)
        {
            case "tblBoard": msg = "게시판"; break;
            case "tblPds": msg = "자료실"; break;
            case "tblAlbum": msg = "앨범 게시판"; break;
            case "tblQnA": msg = "Q & A 게시판"; break;
            case null: msg = "게시판이 선택되지 않앗습니다."; break;
        }
        //GetData(tbl);
        sql += tbl;
        Response.Write(msg + "<br>" + sql);
       // Session["tbl"] = null;
    }
}

Default3.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:Label ID="txt" runat="server" Text=""></asp:Label>
    </div>
    </form>
</body>
</html>

Default3.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        txt.Text = Session["tbl"].ToString();
    }
}

AddPhoto.aspx.cs

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;

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

    }
    protected void btnUpload_Click(object sender, EventArgs e)
    {
        if (Request.Files.Count > 0)
        {
            HttpPostedFile file = Request.Files[0];

if (file.ContentLength < 10240000)
{

DBConn conn = new DBConn();

                conn.Open();
                int imgid = conn.AddPhoto(Title.Text, Comment.Text);
                conn.Close();

string fname = String.Format("{0}.jpg", imgid);

                if (fname != null)
                {
                    fname = Server.MapPath(@"photos\" + fname);
                    file.SaveAs(fname);
                }

                Response.Redirect("Show.aspx?imgid=" + imgid);
            }
            else
            {
                Response.Redirect("list.apsx");

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

web.config

</configSections>
<location path ="write.aspx">
    <system.web>
      <httpRuntime maxRequestLength ="102400"/>
    </system.web>
</location>
<appSettings/>
<connectionStrings/>