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(); // 텍스트박스채우기메서드
}
}