WebService

    [WebMethod]

    public string GetCategory()

    {

        SqlConnection conn = new SqlConnection("server=.;database=Holpe_Info;uid=sa;pwd=123;");

        DataTable dt = new DataTable();

        dt.TableName = "t_Category";

        SqlDataAdapter sda = new SqlDataAdapter("SELECT Category_Name FROM Item_T_Info_Category WHERE Category_ParentID=1", conn);

        sda.Fill(dt);

        string str = DataTable2Json(dt);

        return str;

    }



    private string DataTable2Json(DataTable dt)

    {

        StringBuilder jsonBuilder = new StringBuilder();

        jsonBuilder.Append("{\"");

        jsonBuilder.Append(dt.TableName);

        jsonBuilder.Append("\":[");

        for (int i = 0; i < dt.Rows.Count; i++)

        {

            jsonBuilder.Append("{");

            for (int j = 0; j < dt.Columns.Count; j++)

            {

                jsonBuilder.Append("\"");

                jsonBuilder.Append(dt.Columns[j].ColumnName);

                jsonBuilder.Append("\":\"");

                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("]");

        jsonBuilder.Append("}");

        return jsonBuilder.ToString();

    }

HTML

<script type="text/javascript">

$(function(){

        $("#button1").click(function(){

            $.ajax({

                       type: "Post",

                       dataType: "json",

                       contentType:"application/json;utf-8",

                       url: "WS1.asmx/GetCategory",

                       data:"{}",

                       success: function(data){

                       

                       //json

  //var jsontext = '{"man":{"weight":"75kg","age":"24"},"ar":["1","2","3","4"]}';

  //解析json

  var aman = eval("("+data.d+")");

  //取出json中的信息

  for(var i=0;i<aman.t_Category.length;i++)

  {

    alert(aman.t_Category[i].Category_Name);

  }

                      }

            });

        })

})

</script>

发表于 @ 2008年06月24日 19:20:56|评论(loading...)|收藏