protected void BtnWrite_Click(object sender, EventArgs e)
{
Memos memos = new Memos();
memos.Name = TxtName.Text;
memos.Email = TxtEmail.Text;
memos.Title = TxtTitle.Text;
memos.PostDate = DateTime.Now;
memos.PostIP = Request.UserHostAddress;
var connString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
using (var conn = new SqlConnection(connString))
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
try
{
// 일반 쿼리 사용
/*var query = @"Insert Memos(Name, Email, Title, PostDate, PostIP)
* Values(@Name, @Email, @Title, @PostDate, @PostIP)";
* SqlCommand cmd = new SqlCommand(query, conn);
* cmd.CommandType = System.Data.CommandType.Text;*/
// 저장프로시저 사용
SqlCommand cmd = new SqlCommand("WriteMemo", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", memos.Name);
cmd.Parameters.AddWithValue("@Email", memos.Email);
cmd.Parameters.AddWithValue("@Title", memos.Title);
cmd.Parameters.AddWithValue("@PostDate", memos.PostDate);
cmd.Parameters.AddWithValue("@PostIP", memos.PostIP);
cmd.ExecuteNonQuery();
LblResult.Text = "저장되었습니다";
}
catch (Exception ex)
{
LblResult.Text = $"예외발생 : {ex}";
}
}
}
protected void BtnWrite_Click(object sender, EventArgs e)
{
Memos memos = new Memos();
memos.Name = TxtName.Text;
memos.Email = TxtEmail.Text;
memos.Title = TxtTitle.Text;
memos.PostDate = DateTime.Now;
memos.PostIP = Request.UserHostAddress;
var connstring = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;
using (var conn = new SqlConnection(connstring))
{
if (conn.State == System.Data.ConnectionState.Closed)
{
conn.Open();
}
try
{
SqlCommand cmd = new SqlCommand("WriteMemo", conn); // 저장프로시져
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", memos.Name);
cmd.Parameters.AddWithValue("@Email", memos.Email);
cmd.Parameters.AddWithValue("@Title", memos.Title);
cmd.Parameters.AddWithValue("@PostDate", memos.PostDate);
cmd.Parameters.AddWithValue("@PostIP", memos.PostIP);
cmd.ExecuteNonQuery();
lblDisplay.Text = "저장되었습니다!";
}
catch (Exception ex)
{
lblDisplay.Text = $"예외발생 {ex}";
}
}
}