.Net Project & 재태크 재무 관리

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 FrmADONET : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DisplayDatees();
        }
    }

    //데이터 불러온다
   private void DisplayDatees()
    {
        SqlConnection conn = new SqlConnection("Data Source = .;Initial 
                              Catalog=Market;User ID=Market;Password=1234;");
        conn.Open();

        SqlCommand cmdd = new SqlCommand
                                     ("Select *From Categories", conn);
        cmdd.CommandType = CommandType.Text;

        //ExecuteReader()메서드의 결과값을 DataReader개체에 담기
        SqlDataReader dr = cmdd.ExecuteReader();

        //GridView바인딩
        this.ctrlGridView.DataSource = dr; //datareader, dataSet, List<T>
        this.ctrlGridView.DataBind(); //그렇지 않으면 알아서 모양 만들어 출력

        dr.Close(); //데이터리더도 반드시 Close()해야 함...

        conn.Close();
    }

    protected void btnCatory_Click(object sender, EventArgs e)
    {
        //[0]변수선언부
        string strCategoryName = txtInput.Text.Trim();
        //[1]커넥션
        SqlConnection con = new SqlConnection();
        con.ConnectionString = 
       "server=.;database=Market;uid=Market;pwd=1234;";
        //lblDisplay.Text = "연결되었습니다";
      
        con.Open();

        //[2]커맨드
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = String.Format
               ("Insert Categories(CategoryName)
                 Values('{0}')", strCategoryName);
        cmd.CommandType = CommandType.Text;

        //[3]실행 
        // 모든 명령어 실행 <-> Selecteh 가능 -> Reader사용 
        int rows = cmd.ExecuteNonQuery();    
        this.lblDisplay.Text = rows.ToString() + "개 입력되었습니다";

        con.Close();

    }

---

    //새로고침
    protected void BtnRefresh_Click(object sender, EventArgs e)
    {
        DisplayDatees();
        //ctrlGridView.DataBind();
    }

}

        //Connection
        SqlConnection con = new SqlConnection();
        con.ConnectionString =
                "server=.;database=Market;uid=Market;pwd=1234;";
             
        //Command
        SqlCommand cmd = new SqlCommand
                                    ("Select *From categories", con);
        cmd.CommandType = CommandType.Text;

        //Data Reader
        try
        {
            con.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            this.lblError.Text = "연결완료";
           
            con.Close();
        }
        catch (SqlException se)
        {

            SqlErrorCollection sec = se.Errors;

            //에러를 묶어서 출력 (예외 처리 의해 에러 발생)
            string msg = "";
            foreach (var item in sec) //[3] 에러 하나를 담는 클래스
            {
                msg += item.ToString() + "<br />"; //.Message : 에러 메시지
            }
            this.lblError.Text = msg;
        }
    }