在asp.net c#中使用jquery ajax将数据插入到sql数据库中

$.ajax({
    url: 'InsertData.aspx/InsertData', // 后端处理数据的页面路径
    type: 'POST',
    dataType: 'json',
    data: { param1: 'value1', param2: 'value2' }, // 传递的参数
    success: function (response) {
        // 请求成功后的处理逻辑
        console.log(response);
    },
    error: function (xhr, status, error) {
        // 请求失败后的处理逻辑
        console.log(error);
    }
});

using System;
using System.Data.SqlClient;

public partial class InsertData : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    [System.Web.Services.WebMethod]
    public static string InsertData(string param1, string param2)
    {
        string connectionString = "YourConnectionString"; // 替换为你的数据库连接字符串
        string query = "INSERT INTO YourTable (Column1, Column2) VALUES (@Param1, @Param2)";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@Param1", param1);
                command.Parameters.AddWithValue("@Param2", param2);

                connection.Open();
                command.ExecuteNonQuery();
                connection.Close();
            }
        }

        return "Data inserted successfully!";
    }
}