不存在从对象类型 System.Web.HttpContext 到已知的托管提供程序本机类型的映射。
HTML:
<script type="text/javascript" src="js/jquery-1.4.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$("#sb").click(function () {
$.ajax({
type: 'post',
url: 'message.ashx',
data: {
title: $("#title").val(),
content: $("#content").val()
},
dataType: 'json',
success: function (data) {
alert(data);
},
error: function () {
alert("添加失败");
}
});
});
});
</script>
<form>
<input type="text" id="title" />
<textarea id="content"></textarea>
<button type="button" id="sb">添加</button>
</form>
ashx------------------------------------------------------------------------------------------------------
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
//context.Response.ContentType = "text/html";
string title = context.Request["title"];
string content = context.Request["content"];
string sqltext = "insert into message(title,context) values (@title,@content)";
SqlParameter[] paras = new SqlParameter[]{
new SqlParameter("title",title),
new SqlParameter("content",context)
};
//context.Response.Write(title+","+content);
int i = Helper.SQLHelper.ExecuteNonQuery(sqltext, paras);
if (i > 0)
{
context.Response.Write("添加成功");
}
else
{
context.Response.Write("添加失败");
}
}
public bool IsReusable
{
get
{
return false;
}
}
sqlhelp-------------------------------------------------------------------------------------------
private static readonly string conStr = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
public static int ExecuteNonQuery(string sqlText, params SqlParameter[] paras)
{
using (SqlConnection conn=new SqlConnection(conStr) )
{
using (SqlCommand cmd=new SqlCommand(sqlText,conn))
{
if (paras!=null)
{
cmd.Parameters.AddRange(paras);
}
conn.Open();
return cmd.ExecuteNonQuery();
}
}
}