iamgsi

use exam
go

-- 고객 테이블
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customers](
 [CustomerID] [int] IDENTITY(1,1) NOT NULL,
 [FullName] [nvarchar](50) NULL,
 [EmailAddress] [nvarchar](50) NULL,
 [Password] [nvarchar](50) NULL,
 CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED
(
 [CustomerID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

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

using System;
using System.Collections;
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 고객입력 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        // 변수
        string strFullName = this.txtFullName.Text;
        string strEmailAddress = this.txtEmailAddress.Text;
        string strPassword = this.txtPassword.Text;
        string strSql = "Insert Customers Values(@FullName, @EmailAddress, @Password)";

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

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

        // 파라미터 추가
        objCmd.Parameters.Add("@FullName", SqlDbType.NVarChar, 50);
        objCmd.Parameters["@FullName"].Value = strFullName;
        objCmd.Parameters.Add("@EmailAddress", SqlDbType.NVarChar, 50);
        objCmd.Parameters["@EmailAddress"].Value = strEmailAddress;
        objCmd.Parameters.Add("@Password", SqlDbType.NVarChar, 50);
        objCmd.Parameters["@Password"].Value = strPassword;

        // 실행
        objCmd.ExecuteNonQuery();

        // 닫기
        objCon.Close();

        // 저장 후 리스트 페이지로 이동
        //Response.Redirect("./고객리스트.aspx");
    }
}

using System;
using System.Collections;
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 고객리스트 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        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=store;Initial Catalog=Store;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.dgCustomersList.DataSource = objDr;
        this.dgCustomersList.DataBind();

        // DataGrid 사용할때는 Close 필요 없음
        objCon.Close();
    }
}