첨부 실행 코드는 나눔고딕코딩 폰트를 사용합니다.

728x90
반응형
728x170

TestProject.zip
다운로드

▶ TestDB.sql

CREATE TABLE dbo.Memo
(
    ID            INT           IDENTITY(1, 1) PRIMARY KEY, -- ID
    Title         NVARCHAR(100) NOT NULL,                   -- 제목
    MailAddress   NVARCHAR(100) NULL,                       -- 메일 주소
    [Description] NVARCHAR(500) NOT NULL,                   -- 설명
    WriteDate     DATETIME      DEFAULT(GETDATE()),         -- 작성일
    WriteIP       NVARCHAR(15)  NULL                        -- 작성 IP 주소
)
GO

INSERT INTO dbo.Memo
VALUES
(
    N'메모1',
    N'test@daum.com',
    N'테스트 문자열1',
    GetDate(),
    '127.0.0.1'
)
Go

INSERT INTO dbo.Memo
VALUES
(
    N'메모2',
    N'test@daum.com',
    N'테스트 문자열2',
    GetDate(),
    '127.0.0.1'
)
Go

CREATE PROCEDURE dbo.ListMemo
AS
    SELECT
        ID
       ,Title
       ,MailAddress
       ,[Description]
       ,WriteDate
       ,WriteIP
    FROM dbo.Memo
    ORDER BY ID DESC
GO

 

728x90

 

▶ Web.config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
    <system.web>
        <compilation
            targetFramework="4.6"
            debug="true" />
        <httpRuntime targetFramework="4.6" />
    </system.web>
    <connectionStrings>
        <add name="ConnectionString" connectionString="Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=TestDB;Integrated Security=True;" />
    </connectionStrings>
</configuration>

 

300x250

 

▶ MainPage.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MainPage.aspx.cs" Inherits="TestProject.MainPage" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>ObjectDataSource 클래스 사용하기</title>
    </head>
    <body>
        <form id="form" runat="server">
            <div>
                <asp:GridView ID="gridView" runat="server" 
                    DataSourceID="objectDataSource" />
                <asp:ObjectDataSource ID="objectDataSource" runat="server" 
                    SelectMethod="GetDataReader" 
                    TypeName="TestProject.MainPage" />
            </div>
        </form>
    </body>
</html>

 

▶ MainPage.aspx.cs

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI;

namespace TestProject
{
    /// <summary>
    /// 메인 페이지
    /// </summary>
    public partial class MainPage : Page
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// Public

        #region 데이터 리더 구하기 - GetDataReader()

        /// <summary>
        /// 데이터 리더 구하기
        /// </summary>
        /// <returns>데이터 리더</returns>
        public SqlDataReader GetDataReader()
        {
            SqlConnection connection = new SqlConnection();

            connection.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

            connection.Open();

            SqlCommand command = new SqlCommand();

            command.Connection  = connection;
            command.CommandText = "ListMemo";
            command.CommandType = CommandType.StoredProcedure;

            return command.ExecuteReader(CommandBehavior.CloseConnection);
        }

        #endregion

        ////////////////////////////////////////////////////////////////////////////////////////// Protected

        #region 페이지 로드시 처리하기 - Page_Load(sender, e)

        /// <summary>
        /// 페이지 로드시 처리하기
        /// </summary>
        /// <param name="sender">이벤트 발생자</param>
        /// <param name="e">이벤트 인자</param>
        protected void Page_Load(object sender, EventArgs e)
        {
        }

        #endregion
    }
}
728x90
반응형
그리드형(광고전용)
Posted by icodebroker

댓글을 달아 주세요