02.ASP.NET - 기본형 게시판(3) : Write(글쓰기) 페이지
| Write.aspx |
|
<div>
<h3>글 쓰기</h3>
이름 :
<asp:TextBox ID="txtName" runat="server" /><br />
이메일 :
<asp:TextBox ID="txtEmail" runat="server" /><br />
홈페이지 :
<asp:TextBox ID="txtHomepage" runat="server" /><br />
제목 :
<asp:TextBox ID="txtTitle" runat="server" /><br />
내용 :
<asp:TextBox ID="txtContent" runat="server"
TextMode="MultiLine" Columns="20" Rows="5">
</asp:TextBox><br />
인코딩 :
<asp:RadioButtonList ID="lstEncoding" runat="server"
RepeatDirection="Horizontal" RepeatLayout="Flow">
<asp:ListItem Selected="True">Text</asp:ListItem>
<asp:ListItem>HTML</asp:ListItem>
<asp:ListItem>Mixed</asp:ListItem>
</asp:RadioButtonList>
<br />
비밀번호 :
<asp:TextBox ID="txtPassword" runat="server"
TextMode="Password"></asp:TextBox>
<br />
<asp:Button ID="btnWrite" runat="server" Text="저장"
onclick="btnWrite_Click" />
<asp:Button ID="btnList" runat="server" Text="리스트"
onclick="btnList_Click" /> </div> |
| Write.aspx.cs |
|
protected void Page_Load(object
sender, EventArgs
e) {
// txtName 텍스트박스에 포커스
Page.SetFocus("txtName"); } protected void btnWrite_Click(object sender, EventArgs
e) {
// 커넥션
SqlConnection objcon = new SqlConnection(
ConfigurationManager.ConnectionStrings
["ConnectionString"].ConnectionString);
// 커멘드
SqlCommand objcmd = new SqlCommand("WriteBasic", objcon);
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.Parameters.AddWithValue("@Name",
txtName.Text);
objcmd.Parameters.AddWithValue("@Email",
txtEmail.Text);
objcmd.Parameters.AddWithValue("@Title",
txtTitle.Text);
objcmd.Parameters.AddWithValue("@PostIP",
Request.UserHostAddress); //IP주소
objcmd.Parameters.AddWithValue("@Content",
txtContent.Text);
objcmd.Parameters.AddWithValue("@Password",
txtPassword.Text);
objcmd.Parameters.AddWithValue("@Encoding",
lstEncoding.SelectedValue);
objcmd.Parameters.AddWithValue("@Homepage",
txtHomepage.Text);
objcon.Open();
objcmd.ExecuteNonQuery();
objcon.Close();
btnList_Click(null,
null); //리스트 페이지로 이동 } protected void btnList_Click(object sender, EventArgs
e) {
// 리스트 페이지로 이동
Response.Redirect("List.aspx"); } |
| 결과화면 |
[그림2-1] |
Write.aspx