62,046
社区成员
发帖
与我相关
我的任务
分享
<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>
<%@ 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;
}
}
}