.net 怎么用ajax读取sql server数据库里的数据，然后再传回前台页面显示

[码农_Aaron]

本人菜鸟，刚刚接触ajax，今天老大让实现用ajax从sqlserver 数据库中读取数据，然后把数据显示在前台页面上，请问该怎么写啊！

[md5e]

ajax以get或post提交给一个aspx页面处理，aspx通过Request[]来获取参数进行处理，然后通过Response.write(指定格式的字符串)向客户端输出，ajax的返回方法，通过返回的字符串进行处理加工，然后按照格式显示

[laowang134]

//aspx

    <script type="text/javascript" language="javascript">
        function GetCategoryData(type) {
            $.ajax({
                type: "GET",
                url: "AjaxService/Handler.ashx",
                dataType: "text",
                data: "type=" + type + "&id=" + $("#txt1").val() + "&val=" + $("#txt2").val(),
                success: function (msg) {
                    for (var i in msg) {
                        $("#tb1").append(msg[i]);
                    }
                },
                error: function (data) {
                    alert(data);
                }
            })
        }
    </script>
    <div>
        <input type="text" id="txt1" />
        <input type="text" id="txt2" />
        <input type="button" id="btn" value="输出html" onclick="GetCategoryData(this.value);" />
        <table id="tb1">
        </table>
    </div>

//ashx

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Text;
using System.Data;
using System.Data.SqlClient;

public class Handler : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {
        StringBuilder strBul = new StringBuilder();
        int i = 1;
        string id = context.Request.QueryString["id"];
        string val = context.Request.QueryString["val"];
        SqlConnection con = new SqlConnection("数据库连接");
        con.Open();
        SqlCommand cmd = new SqlCommand("select left(infotitle,10) infotitle,left(infodesc,20) infodesc,substring(infocontent,1,30) infocontent,releasedate from info where len(infotitle)>0 and len(infodesc)>0", con);
        cmd.CommandType = CommandType.Text;
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            strBul.Append("<tr>");
            strBul.Append("<td>" + i++.ToString() + "</td>");
            strBul.Append("<td>" + dr["infotitle"].ToString()+"……</td>");
            strBul.Append("<td>" +dr["infodesc"].ToString() + "……</td>");
            strBul.Append("<td>" +dr["infocontent"].ToString()+ "……</td>");
            strBul.Append("<td>" + Convert.ToDateTime((dr["releasedate"])).ToString("yyyy-MM-dd") + "</td>");
            strBul.Append("</tr>");
        }
        dr.Close();
        con.Close();
        context.Response.ContentType = "text/html";
        context.Response.Write(strBul.ToString());
    }

    public string OutPutStr(string str)
    {
        return str.Replace("<", "<").Replace(">", ">").Replace("&","&").Replace(""",@"""");
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}

[tyang258]

楼上正解

[dylan_ovo]

顶 +1

[cqfeng]

js -> aspx/ashx/或者你自己定义的接口 -> database

[dkl1427]

如果我想查一个表的所有内容没有条件 dataType: "text", data: "type=" + type + "&id=" + $("#txt1").val() + "&val=" + $("#txt2").val(), 这两该怎么改！