14장 ADO.NET 메모리상의 데이터 베이스(Parameters)

using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class FrmSqlParamter : System.Web.UI.Page {     protected void Page_Load(object sender, EventArgs e)     {         DisplayData();     }     private void DisplayData()     {         SqlConnection con = new SqlConnection                (ConfigurationManager.ConnectionStrings                  ["ConnectionString"].ConnectionString);         con.Open();         SqlCommand cmd = new SqlCommand                      ("Select *From Categories", con);         SqlDataAdapter da = new SqlDataAdapter(cmd);         DataSet ds = new DataSet();         da.Fill(ds, "Categories");         this.ctlCategoryList.DataSource = ds.Tables[0];         this.ctlCategoryList.DataBind();         con.Close();             }     //추가     protected void btnAddConnection_Click(object sender, EventArgs e)     {         SqlConnection con = new SqlConnection();         con.ConnectionString = ConfigurationManager.ConnectionStrings                      ["ConnectionString"].ConnectionString;         con.Open();         SqlCommand cmd = new SqlCommand();         cmd.Connection = con;         cmd.CommandText =       "Insert Into Categories(CategoryName) Values(@CategoryName)";         cmd.CommandType = CommandType.Text;                       //[1] 파라미터 추가하는 첫번째 방법         //cmd.Parameters.AddWithValue                ("@CategoryName", txtCategoryName.Text);         //[2] 파라미터 추가하는 두번째 방법         cmd.Parameters.Add("@CategoryName", SqlDbType.VarChar, 50);         cmd.Parameters["@CategoryName"].Value = txtCategoryName.Text;         //[3] SqlParamter 클래스 사용 :          //Sp의 Output 매개변수 처리시 무조건 사용 하여야 한다.         //SqlParameter ParamterCategoryName =         //new SqlParameter("@CategoryName", SqlDbType.VarChar, 50);         //ParamterCategoryName.Direction = ParameterDirection.Input;          //ParamterCategoryName.Value = txtCategoryName.Text;         //cmd.Parameters.Add(ParamterCategoryName);                 cmd.ExecuteNonQuery(); //실행                 con.Close();         DisplayData();     } }

---

AspNet0929.zip