[C#/ASP.NET] SqlDataSource 클래스 사용하기


<?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>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

<?xml version="1.0" encoding="utf-8"?>

<system.web>

<compilation

targetFramework="4.6"

debug="true" />

</system.web>

</connectionStrings>

</configuration>


<%@ 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>SqlDataSource 클래스 사용하기</title>
    </head>
    <body>
        <form id="form" runat="server">
            <div>
                <asp:DropDownList ID="dropDownList" runat="server"
                    DataSourceID="sqlDataSource"
                    DataTextField="NAME"
                    DataValueField="ID" />
                <asp:SqlDataSource ID="sqlDataSource" runat="server"
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                    SelectCommand="SELECT ID, NAME FROM dbo.Code ORDER BY NAME ASC" />
            </div>
        </form>
    </body>
</html>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="MainPage.aspx.cs" Inherits="TestProject.MainPage" %>

<!DOCTYPE html>

<title>SqlDataSource 클래스 사용하기</title>

</head>

<body>

<div>

<asp:DropDownList ID="dropDownList" runat="server"

DataSourceID="sqlDataSource"

DataTextField="NAME"

DataValueField="ID" />

<asp:SqlDataSource ID="sqlDataSource" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT ID, NAME FROM dbo.Code ORDER BY NAME ASC" />

</div>

</form>

</body>

</html>


using System;
using System.Web.UI;

namespace TestProject
{
    /// <summary>
    /// 메인 페이지
    /// </summary>
    public partial class MainPage : Page
    {
        //////////////////////////////////////////////////////////////////////////////////////////////////// Method
        ////////////////////////////////////////////////////////////////////////////////////////// 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
    }
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

using System;

using System.Web.UI;

namespace TestProject

{

/// <summary>

/// 메인 페이지

/// </summary>

public partial class MainPage : Page

{

//////////////////////////////////////////////////////////////////////////////////////////////////// Method

////////////////////////////////////////////////////////////////////////////////////////// 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

}