.Net Project & 재태크 재무 관리

using System.Configuration;
using System.Data;
using System.Data.SqlClient;

public partial class Category_FrmDataView : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DisplayData();
        }
    }
    private void DisplayData()
    {
       //커넥션
        SqlConnection con = new SqlConnection
                   (ConfigurationManager.ConnectionStrings
                    ["ConnectionString"].ConnectionString);

        con.Open();
       
        //커맨드
        SqlCommand cmd = new SqlCommand
                     ("Select *From Products", con);
        //어댑터
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd;

        DataSet ds = new DataSet();
        da.Fill (ds,"Products");

        //출력
        this.ctlProductList1.DataSource = ds; //[1]데이터셋
        this.ctlProductList1.DataBind();

        DataTable dt = ds.Tables["Products"]; //[2]데이터테이블
        this.ctlProductList2.DataSource = dt;
        this.ctlProductList2.DataBind();

        DataView dv = ds.Tables[0].DefaultView; //[3]데이터뷰
        this.ctlProductList3.DataSource = dv;
        this.ctlProductList3.DataBind();
    }
}

using System.Configuration;
using System.Data;
using System.Data.SqlClient;

public partial class Category_FrmDataTable : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DisplayData();            
        }
    }

    private void DisplayData()
    {
        //[1] 커넥션
        SqlConnection con = new SqlConnection
                (ConfigurationManager.ConnectionStrings
                 ["ConnectionString"].ConnectionString);
       
        con.Open();
                    
        //[2] 커멘드
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Select *From Categories ;
               Select ProductID, ModelName From Products;";

        //[3] 데이터 어댑터
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = cmd ; //명령어를 담고 있는 커맨드 개체 지정
       
        //[4] 데이터셋
        DataSet ds = new DataSet(); //한개 이상의 테이블을 담을 수 있는 그릇
       
        //[5] Fill()
        da.Fill(ds, "Market");

        //[6] [데이터테이블]
        DataTable dt1 = ds.Tables[0] ; //Categories
        DataTable dt2 = ds.Tables[1] ; //Products

        //[7] GridView 에 바인딩
        this.ctlCategoryList.DataSource = dt1; ctlCategoryList.DataBind();
        this.ctlProductList.DataSource = dt2; ctlProductList.DataBind();

        //마무리
        con.Close();
     }
}

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Category_FrmDataset : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack) //처음 로드시에만 데이터 읽어서 바인딩
        {
            DisplayData();
        }
    }

    private void DisplayData()
    {
        using (SqlConnection con = new SqlConnection
                  (ConfigurationManager.ConnectionStrings
                   ["ConnectionString"].ConnectionString))
        {
            con.Open();

            SqlCommand cmd = new SqlCommand
                                ("Select *From Categories", con);
           
            //[!]SqlDataAdapter 클래스 인스턴스 생성
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;

            //[2]Dataset 클래스의 인스턴스
            DataSet ds = new DataSet();
           
            //[3]da.fill()메서드로 데이터 셋 채우기
            da.Fill(ds, "Categories");

            //[4]GridVies에 바인딩
            ctlCategoryList.DataSource = ds;
            ctlCategoryList.DataBind();
        }
    }
}

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;
using System.Transactions; (참조추가 통해서 추가)

public partial class Category_FrmTransaction : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnUpdateDelete_Click(object sender, EventArgs e)
    {
       //수정과 삭제를 동시에 하기 위해서  
        string UpdateQuery =
            "Update Categories Set CategoryName =
                                      '컴퓨터' Where CategoryID = 10";
        string DeleteQuery =
            "Delete Categories Where CategoryID >= 16";

        using (SqlConnection con = new SqlConnection
                                 (ConfigurationManager.ConnectionStrings
                                 ["ConnectionString"].ConnectionString))
        {
            con.Open();

            //[1] sqlTransaction클래스의 인스턴스 생성
            SqlTransaction tran = con.BeginTransaction(""); //트랜잭션 초기화

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;

            //[2] 현재 명령어에서 사용한 트랜잭션 지정
            cmd.Transaction = tran;
            try
            {
                cmd.CommandText = UpdateQuery;
                cmd.ExecuteNonQuery(); //수정

                cmd.CommandText = DeleteQuery;
                cmd.ExecuteNonQuery(); //삭제
                tran.Commit(); //에러가 발생하지 않으면 실행
                lblError.Text = "정상처리";
            }
            catch (Exception ex)
            {
                lblError.Text = ex.Message; //에러가 메시지 출력 
                //에러가 발생하면 롤백
                tran.Rollback();
            }            
        }
    }
    //삭제 + 삭제
    protected void btnCommand_Click(object sender, EventArgs e)
    {
       
        string UpdateQuery =
            "Delete Categories Where CategoryID = 8";
        string DeleteQuery =
            "Delete Categories Where CategoryID2 = 9";

        //참조추가 -> .NET - > System.Transactions 추가
        using (TransactionScope scope = new TransactionScope())
        {
            using (SqlConnection con = new SqlConnection
                     (ConfigurationManager.ConnectionStrings 
                     ["ConnectionString"].ConnectionString))
            {
                con.Open();
               
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = con;
                              
                try{
                    cmd.CommandText = UpdateQuery;
                    cmd.ExecuteNonQuery(); //수정

                    cmd.CommandText = DeleteQuery;
                    cmd.ExecuteNonQuery(); //삭제

                    lblError.Text = "정상처리";
                }
                catch (Exception ex) {
                    lblError.Text = ex.Message; //에러가 메시지 출력 
                }
                //scope.Complete(); //완료
            }            
        }
    }
}