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

Magic_kit 2009. 9. 29. 15:12

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