ASP.NET 연결기반 업데이트 예제

==>   오토포스트백 선택

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;

using System.Data.SqlClient; // ADO.NET

public partial class ConnectedUpdate : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack) // 처음로드되면

{

BindDropDownList(); // 드랍다운리스트 채우기 메서드

SetInfo(); // 텍스트박스채우기메서드

}

//Response.Write("<script>javascript:alert('" + "" + "') </script>");

//Response.Write("하하하");

}

private void SetInfo()

{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ASPConnectionString"].ConnectionString);

string strQry = "SELECT user_id, password, name, phone, age FROM member WHERE user_id = @user_id";

SqlCommand cmd = new SqlCommand(strQry, conn);

cmd.Parameters.Add("@user_id", SqlDbType.NVarChar, 12).Value = DropDownList1.SelectedValue;

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

if (reader.Read())

{

Label2.Text = reader["user_id"].ToString();

TextBox2.Text = reader["password"].ToString();

TextBox3.Text = reader["name"].ToString();

TextBox4.Text = reader["phone"].ToString();

TextBox5.Text = reader["age"].ToString();

}

reader.Close();

conn.Close();

}

private void BindDropDownList()

{

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ASPConnectionString"].ConnectionString);

string strQry = "SELECT user_id FROM member";

SqlCommand cmd = new SqlCommand(strQry, conn);

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

DropDownList1.Items.Add(reader["user_id"].ToString());

// Response.Write("<script>javascript:alert('" + reader["user_id"].ToString() + "') </script>");

}

reader.Close();

conn.Close();

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Write("<script>javascript:alert('" +"메세지" + "') </script>");

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ASPConnectionString"].ConnectionString);

string strQry = "UPDATE member SET password=@password, name=@name, phone=@phone, age=@age  WHERE user_id=@user_id";

conn.Open();

SqlCommand cmd = new SqlCommand(strQry, conn);

cmd.Parameters.Add("@user_id", SqlDbType.NVarChar, 12).Value = Label2.Text;

cmd.Parameters.Add("@password", SqlDbType.NVarChar, 20).Value = (TextBox2.Text.Trim());

cmd.Parameters.Add("@name", SqlDbType.NVarChar, 20).Value = (TextBox3.Text.Trim());

cmd.Parameters.Add("@phone", SqlDbType.NVarChar, 20).Value = (TextBox4.Text.Trim());

cmd.Parameters.Add("@age", SqlDbType.Int).Value = Convert.ToInt32(TextBox5.Text.Trim());

cmd.ExecuteNonQuery();

conn.Close();

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

SetInfo(); // 텍스트박스채우기메서드

}

}