Using ASP, create an AJAX request to execute a straightforward SQL DELETE query

Question

Using ASP, create an AJAX request to execute a straightforward SQL DELETE query

Hello, I am looking to delete all the information from a SQL server table using an AJAX function. Below is my C# method:

[WebMethod]
    public static  void deleteCertificado()
    {
        SqlConnection conn = new 
        SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString());
        string strsql = "DELETE * FROM Fiel";
        SqlCommand comando = new SqlCommand(strsql, conn);
        comando.CommandTimeout = 36000;
        comando.ExecuteNonQuery();
    }

Here is my JavaScript function:

function testDel() {
if (confirm('Are you sure you want to delete this?')) {
    $.ajax({
        url: 'Delete.asmx/deleteCertificado',
        type: 'Delete',
        data: {},
        success: function () {
            alert("Record deleted successfully");
        }
    });
} else {}

I just want to call the method without any specific user ID or data. How can I achieve this? My field "data" is empty as I simply want to delete all the information of the table.

javascript asp.net webforms

Answer 1

Answer №1

Before we dive into the code, I want to reference a similar question on Stack Overflow from 5 years ago. It emphasizes the importance of using newer technologies like web API over the outdated asmx.

Now, looking at your code, there are a couple of issues that need addressing:

ASMX doesn't support delete requests, so you should switch your request type from 'Delete' to 'Post' in your jQuery ajax code.
Your WebMethod should not be static.

Another improvement is to utilize the using statement for proper resource disposal. Here's a better version of your Webmethod:

    [WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public void deleteCertificado()
    {
        using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))
        {
            string strsql = "DELETE * FROM Fiel";
            using (var comando = new SqlCommand(strsql, conn))
            {
                comando.CommandTimeout = 36000;
                comando.ExecuteNonQuery();
            }
        }                
    }

Answer 2

Before we dive into the code, I want to reference a similar question on Stack Overflow from 5 years ago. It emphasizes the importance of using newer technologies like web API over the outdated asmx.

Now, looking at your code, there are a couple of issues that need addressing:

ASMX doesn't support delete requests, so you should switch your request type from 'Delete' to 'Post' in your jQuery ajax code.
Your WebMethod should not be static.

Another improvement is to utilize the using statement for proper resource disposal. Here's a better version of your Webmethod:

    [WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public void deleteCertificado()
    {
        using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["default"].ToString()))
        {
            string strsql = "DELETE * FROM Fiel";
            using (var comando = new SqlCommand(strsql, conn))
            {
                comando.CommandTimeout = 36000;
                comando.ExecuteNonQuery();
            }
        }                
    }

Using ASP, create an AJAX request to execute a straightforward SQL DELETE query

Answer №1

Similar questions

Using Jquery to delete the parent element containing text that does not match

Promise.each encountered an unhandled rejection

Ensuring file extensions are validated prior to file uploads

What is the best way to iterate through an array of objects with JavaScript?

Tips for retrieving the chosen value from a dropdown list in HTML

Could this task be accomplished within a C# ASP.NET web application?

Exploring Enum properties within an angular js select drop down

"Exploring the new features of Node.js 14 with ECMAScript modules

Guide on retrieving just the time from an ISO date format using JavaScript

Disappear text gradually while scrolling horizontally

The partial class within the entity framework does not undergo serialization for its string property

How do you modify the attribute of a Label in the ItemTemplate within a FormView?

When downloading text using Angular, the file may not display new line characters correctly when opened in Notepad

Flickering of image in JavaScript when mouse is hovered over and removed

Utilizing AXIOS in React functional components for REST API integration

Transferring information from user control to main page during a postback操作

Switch the page direction in Aspx to go from right to left

Tips for transferring a geolocation lat lng to the `ll` property of a different function in React

The parameter type 'NextHandleFunction' does not match the expected type 'PathParams' in the argument

Issue with setting position to the right using jQuery CSS