ajax代码
private string NewId(HttpContext context) { Hashtable ht1 = new Hashtable();
List TreeList = new List(); Hashtable ht = new Hashtable(); TreeList.Add(ht);
ht1.Add("Result", TreeList); string ReturnValue = string.Empty; string _id = context.Request["NewId"] ?? "";
string sql = "select * from new where NewId='"+_id+"'"; //sql语句
// SqlDBHelper.ExecuteNonQuery(DBConfig.getSqlserverDBConnString(), CommandType.Text, strsql, null);
DataTable dt = SqlDBHelper.ExecuteTable(DBConfig.getSqlserverDBConnString(),CommandType.Text,sql,null); //数据库帮助类 返回databale类型
//ReturnValue = DataTableJson(dt);
ht.Add("NewId", dt.Rows[0]["NewId"].ToString());
ht.Add("NewTitle", dt.Rows[0]["NewTitle"].ToString());
ht.Add("NewContent", dt.Rows[0]["NewContent"].ToString());
ht.Add("NewAddTime", dt.Rows[0]["NewAddTime"].ToString());
ht.Add("NewAddAuthor", dt.Rows[0]["NewAddAuthor"].ToString());
return JsonMapper.ToJson(ht); }
html请求ajax代码:
function tj(newsid)
{
$.ajax("/Web/Aajx.ashx?" + Math.random(), { Action: 'NewId',NewId: newsid },
function (data) { var objs = eval('(' + data + ')');
$(".NewId").html(newsid);
$(".NewTitle").html(objs.NewTitle);
$(".NewAddTime").html(objs.NewAddTime);
$(".NewAddAuthor").html(objs.NewAddAuthor);
$(".NewContent").html(objs.NewContent); });
}