iamgsi :: 기본 DB 연동 코드 (Sql 파일 + Insert, FillList)

use exam
go

-- 고객 테이블
Create Table dbo.Customers
(
CustomerID int Identity(1,1) Primary Key Not NULL, --일련번호
Name Varchar(25) Null, --이름
Email Varchar(100) Null, --이메일
RegistDate DateTime Default(GetDate()) --등록일
)
Go

--입력 예시
Insert Customers Values('홍길동', 'h@h.com', GetDate())
--출력 예시
Select * From Customers Order By CustomerID Desc
--세부출력 예시
Select * From Customers Where Name = '홍길동'
--수정 예시
Begin Tran
Update Customers
Set Name = '백두산', Email = 'b@b.com'
Where Name = '홍길동' And Email = 'h@h.com'
--RollBack Tran
Commit Tran
--삭제 예시
Delete Customers Where Name = '백두산'
--검색 예시
Select * From Customers
Where Name Like '%백%' Or Email Like '%b%'

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
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;

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

    private void ReadData()
    {
        string strSql = "Select * From Customers Order By CustomerID Desc";
        // 커넥션
        SqlConnection objCon = new SqlConnection();
        objCon.ConnectionString = "Password=gsi7091;Persist Security Info=True;User ID=exam;Initial Catalog=exam;Data Source=GSI\\SQLEXPRESS";
        objCon.Open();
        // 커멘드
        SqlCommand objCmd = new SqlCommand();
        objCmd.Connection = objCon;
        objCmd.CommandText = strSql;
        objCmd.CommandType = CommandType.Text;
        // 데이터 리더 또는 데이터어뎁트 + 데이터 셋
        SqlDataReader objDr = objCmd.ExecuteReader();
        // 출력
        this.dgList.DataSource = objDr;
        this.dgList.DataBind();
        // DataGrid 사용할때는 Close 필요 없음
        //objCon.Close();
    }

    protected void btnWrite_Click(object sender, EventArgs e)
    {
        // 변수
        string strName = this.txtName.Text;
        string strEmail = this.txtEmail.Text;
        string strSql = "Insert Customers Values(@Name, @Email, GetDate())";

        // 커넥션
        SqlConnection objCon = new SqlConnection();
        objCon.ConnectionString = "Password=gsi7091;Persist Security Info=True;User ID=exam;Initial Catalog=exam;Data Source=GSI\\SQLEXPRESS";
        objCon.Open();

        // 커멘드
        SqlCommand objCmd = new SqlCommand();
        objCmd.Connection = objCon;
        objCmd.CommandText = strSql;
        objCmd.CommandType = CommandType.Text;

        // 파라미터 추가
        objCmd.Parameters.Add("@Name", SqlDbType.VarChar, 25);
        objCmd.Parameters["@Name"].Value = strName;
        objCmd.Parameters.Add("@Email", SqlDbType.VarChar, 100);
        objCmd.Parameters["@Email"].Value = strEmail;

// 실행
objCmd.ExecuteNonQuery();

objCon.Close();

ReadData(); // 다시 출력
}
}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">