개발 참고자료

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

============================================================== FrmList.aspx.cs ============================================================== using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace WebADONET { public partial class FrmList : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { //변수선언 string ls_Con = "server=SUPERMAN\\MSQL;database=study;uid=study;pwd=XX"; string ls_Sql = "ListMemo"; //커넥션 SqlConnection con = new SqlConnection(); con.ConnectionString = ls_Con; con.Open(); //커맨드 SqlCommand sqlCmd = new SqlCommand(); sqlCmd.Connection = con; sqlCmd.CommandText = ls_Sql; sqlCmd.CommandType = CommandType.StoredProcedure; //데이터어댑터 SqlDataAdapter sqlDA = new SqlDataAdapter(); sqlDA.SelectCommand = sqlCmd; //데이터셋 DataSet ds_Data = new DataSet(); sqlDA.Fill(ds_Data, "Memos"); //그리드뷰 컨트롤 gv_MemoList.DataSource = ds_Data; gv_MemoList.DataBind(); //마무리 con.Close(); lbl_Display.Text = "조회완료 :: " + DateTime.Today.ToShortDateString(); } } }