개발 참고자료

=============================================================== FrmWrite.aspx =============================================================== <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="FrmWrite.aspx.cs" Inherits="WebADONET.FrmWriteinlineSql" %>

데이터입력
이름:
이메일:
메모:

=============================================================== FrmWrite.aspx.cs =============================================================== using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace WebADONET { public partial class FrmWriteinlineSql : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btn_Write_Click(object sender, EventArgs e) { //변수선언 string ls_Name = txt_Name.Text; string ls_Email = txt_Email.Text; string ls_Title = txt_Title.Text; string ls_PostIP = Request.UserHostAddress; string ls_Con = "server=SUPERMAN\\MSQL;database=study;uid=study;pwd=XXX"; string ls_Sql = "WriteMemo"; //[1] sqlonnection 클래스의 인스턴스 생성 SqlConnection con = new SqlConnection(); con.ConnectionString = ls_Con; con.Open(); //[!] 입력예시문 실행 //sqlCommand의 인스턴스 생성 SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = con; sqlCmd.CommandText = ls_Sql; sqlCmd.CommandType = CommandType.StoredProcedure; //파라메타 sqlCmd.Parameters.AddWithValue("@Name", ls_Name); sqlCmd.Parameters.AddWithValue("@Email", ls_Email); sqlCmd.Parameters.AddWithValue("@Title", ls_Title); sqlCmd.Parameters.AddWithValue("@PostIP", ls_PostIP); //실행 sqlCmd.ExecuteNonQuery(); //마무리 con.Close(); lbl_Display.Text = "저장완료"; } } };