首先将json对象转为json字符串
var aToStr = JSON.stringify(graphicStr); //json转字符串
然后ajax 通过post请求
$.ajax({
type: 'post',
url: 'saveG.ashx',
data: aToStr,
dataType:'text ',
success: function () { alert('成功了!'); },
});
在ashx.cs文件中
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Xml;
using System.IO;
using System.Data.SqlClient;//必须引入
using System.Collections.Generic;
using System.Text;
namespace WebApplication1
{
public partial class saveG : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//接收字符串
string strJSON = string.Empty;
using (StreamReader reader = new StreamReader(Context.Request.InputStream))
{
strJSON = reader.ReadToEnd();
}
Context.Response.Write(strJSON);
//连接字符串
string myconn = "Server=数据库地址;Database=数据库名称;User ID='用户名';Password='密码'";
//建立数据库连接。
SqlConnection myconnection = new SqlConnection(myconn);
//打开数据库连接
myconnection.Open();
string sql = "SELECT * FROM [zhouhaitest].[dbo].[test]";
SqlCommand cmd = new SqlCommand(sql, myconnection) ;
//写入数据库
cmd.CommandText = "INSERT into [zhouhaitest].[dbo].[test] values (newid(),@GRAPHIC)"; //需要执行的sql语句
cmd.Parameters.Add("@GRAPHIC ", SqlDbType.Text).Value = strJSON;
cmd.CommandType = CommandType.Text;
cmd.Connection = myconnection;
try
{
cmd.ExecuteNonQuery();
Response.Write("</br>写入成功");
}
catch (Exception ex)
{
Response.Write("写入失败");
}
finally
{
myconnection.Close();
}
}
}
}