using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Configuration;
using System.Web.Configuration;
using System.Collections.Generic;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Activation;
using System.ServiceModel.Web;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Json;
using Pesta.Utilities.Helpers;

//네임스페이스는 SandwichServices 입니다.
namespace SandwichServices
{

    [ServiceContract(Namespace = "SandwichServices")]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
    public class CostService : BaseCode
    {
        [OperationContract]
        public string CostOfSandwiches()
        {
            //BaseCode에서 연결 문자열을 가져옵니다.
            //코드 내용은아래에 있습니다.
            BaseCode bc = new BaseCode();
            string strConnection = bc.strConnection;

            //데이터베이스에 연결하고 오픈합니다.
            SqlConnection con = new SqlConnection();
            con.ConnectionString = strConnection;
            con.Open();

            //데이터를 가져오기 위한 쿼리 문자열을 생성합니다.
            //운영할 때 편이성을 위해 이렇게 코드에 쿼리를 넣는 것 보다는 SP로 하는게 더 낫습니다.
            string Query = string.Empty;
            Query = "select * from leeho_test";

            SqlCommand cmd = new SqlCommand(Query, con);
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds);

            //데이터 셋을 JSONHelper 객체로 보내 JSON 문자열을 생성합니다.
            Pesta.Utilities.Helpers.JSONHelper jh = new Pesta.Utilities.Helpers.JSONHelper();
            string ss = jh.ToJSON(ds);

            return ss;
           
        }
    }
}

//아래는 JSON 헬퍼 입니다.
//헬퍼 클래스는 2개의 메서드를 가지는데 하나는 데이터 셋을 인자로 받고, 다른 하나는 데이터 테이블을 직접 전달할 수
//있게 되어 있습니다.
namespace Pesta.Utilities.Helpers
{

    public class JSONHelper
    {
        #region Made from datatable of dataset to JSON string
        /// <summary>
        /// WriteDate : 2010-06-14
        /// Author : Jonghyun, Park
        /// Content: Made from DataTable of DataSet to JSON
        /// </summary>
        /// <param name="obj">DataSet</param>
        /// <returns>jsonBuilder</returns>
        public string ToJSON(DataTable dt)
        {
            return MakeData(dt);
        }
        #endregion

        #region Made from DataSet of dataset to JSON
        /// <summary>
        /// WriteDate : 2010-06-14
        /// Author : Jonghyun, Park
        /// Content: Made from DataSet of dataset to JSON
        /// </summary>
        /// <param name="obj">DataSet</param>
        /// <returns>jsonBuilder</returns>
        public string ToJSON(DataSet obj)
        {
            DataTable dt = obj.Tables[0];
            return MakeData(dt);
        }
        #endregion

        #region Make Data
        /// <summary>
        /// WriteDate : 2010-06-14
        /// Author : Jonghyun, Park
        /// Content: Make Data
        /// </summary>
        /// <param name="dt">DataTable</param>
        /// <returns></returns>
        private static string MakeData(DataTable dt)
        {
            StringBuilder jsonBuilder = new StringBuilder();
            jsonBuilder.Append("[");
           
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                jsonBuilder.Append("{");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    jsonBuilder.Append("\""+ dt.Columns[j].Caption +"\":\"");
                    jsonBuilder.Append(dt.Rows[i][j].ToString());
                    jsonBuilder.Append("\",");
                }
                jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
                jsonBuilder.Append("},");
            }
            jsonBuilder.Remove(jsonBuilder.Length - 1, 1);

            jsonBuilder.Append("]");
            return jsonBuilder.ToString();
        }
        #endregion
    }
}

 using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;

namespace SandwichServices
{
    public class BaseCode
    {
        public string DBKEY = string.Empty;
        public string GETKey = tring.Empty;
        private string dbkey {
            get {
                return DBKEY;
            }
            set {
                dbkey = DBKEY;
            }
        }
        public string strConnection = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString();
    }
}

 <%

    response.charset = "utf-8"
   
    dim cmd, db
   
    set db = server.createobject("adodb.connection")
    db.open "provider=sqloledb; data source = IP Address;uid=DBID;pwd=PASSWORD;database=DBNAME"
   
    set cmd = server.createobject("adodb.command")
    cmd.activeconnection = db
    cmd.commandtext = spNAME
    cmd.commandtype = 1
   
    set rs = cmd.execute
   
    if not rs.eof then
        OpenEventCommentList = rs.getrows()
    end if
    rs.close
  
    set rs = nothing

'   ============================================================
'   배열로 저장된 레코드 셋 출력하기.
'   ============================================================
    dim rowCnt, colCnt
    rowCnt = ubound(OpenEventCommentList, 2)    '행
    colCnt = ubound(OpenEventCommentList, 1)    '열
  
    dim json
    if IsArray(OpenEventCommentList) then
        json = json + "["
        for i=0 to rowCnt
            json = json + "{"
            for j=0 to colCnt
                if j=0 then json = json + """UserID"":""" end if
                if j=1 then json = json + """Content"":""" end if
                if j=2 then json = json + """RegDate"":""" end if
                json = json + OpenEventCommentList(j, i)
                json = json + ""","
            next
            json = Mid(json, 1, len(json) -1)
            json = json + "},"
        next
        json = Mid(json, 1, len(json) -1)
       
        json = json + "]"
    end if
   
    response.write json
%>

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

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>댓글 기능</title>
    <script language="javascript" type="text/javascript">
        var strTable = "";
        function createXMLHttpRequest() {
            if (window.ActiveXObject) {
                xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
            }
            else if (window.XMLHttpRequest) {
                xmlHttp = new XMLHttpRequest();
            }
        }

        function getCommentList() {
            createXMLHttpRequest();
            xmlHttp.onreadystatechange = getCommentList_Callback;
            xmlHttp.open("GET", "GetCmtList.asp", true);
            xmlHttp.send();
        }

        function getCommentList_Callback() {
            if (xmlHttp.readyState == 4) {
                if (xmlHttp.status == 200) {
                    var obj = eval('(' + xmlHttp.responseText + ')');

                    strTable += "<table border='1' cellpadding='0' cellspacing='0'><tr><td>Idx</td><td>keyword</td><td>writeday</td></tr>";
                    for (var i = 0; i < obj.length; i++) {
                        strTable += "<tr>";
                        strTable += "<td>" + obj[i]["UserID"] + "</td>";
                        strTable += "<td>" + obj[i]["Content"] + "</td>";
                        strTable += "<td>" + obj[i]["RegDate"] + "</td>";
                        strTable += "</tr>";
                    }
                    strTable += "</table>";
                    document.getElementById("CommentList").innerHTML = strTable;
                }
            }
        }
    </script>
</head>
<body>
    <div id="CommentList"></div>
    <form id="eventComment">
        <textarea name="content" id="cheerContent" cols="100" rows="3"></textarea>
        <input type="button" value="comment" />
    </form>
    <script type="text/javascript" language="javascript">
        getCommentList();
    </script>
</body>
</html>