如何无需Postman，从浏览器URL向ASP.NET Core API发送数据并写入SQL Server数据库

Got it, let's walk through how you can send data from your browser to your SQL Server via that API endpoint without touching Postman. There are a few simple, browser-native ways to do this—here's what you can try:

If your API's Home endpoint accepts GET requests, you can append your data directly as query parameters to the URL. For example, if you need to send a name and email:

https://localhost:44378/api/Home?name=JohnDoe&email=john@example.com

Just paste this into your address bar and hit enter. Your API backend will need to read these query parameters and handle inserting them into your SQL Server.

⚠️ Heads up: GET requests aren't ideal for sensitive data (like passwords) since parameters show up in the URL, browser history, and server logs. They also have length limits for large datasets.

For inserting data into a database, POST or PUT is usually the more secure and规范 approach. You can send these requests directly through your browser's developer tools:

• Open your browser (Chrome, Firefox, Edge all work) and press F12 to launch DevTools.
• Switch to the Network tab.
• Click the "New Request" or "+" button (location varies by browser) and select POST (or PUT, depending on your API design).
• Enter your endpoint URL: https://localhost:44378/api/Home.
• Go to the Headers section and add a new header: Content-Type: application/json (assuming your API accepts JSON data).
• Switch to the Body tab, select "raw", and paste your data in JSON format:

  {
    "name": "John Doe",
    "email": "john@example.com"
  }
  

• Hit "Send"—the request will go to your API, and your backend can process the JSON body to insert into SQL Server.

If you want a more user-friendly way (no DevTools required), whip up a simple HTML page to send data via forms or JavaScript:

Option A: HTML Form (No JS Needed) #

This sends data in application/x-www-form-urlencoded format—make sure your API is set up to handle this:

<!DOCTYPE html>
<html>
<body>
  <h3>Send Data to API</h3>
  <form action="https://localhost:44378/api/Home" method="POST">
    <label for="name">Name:</label>
    <input type="text" id="name" name="name" required><br><br>
    <label for="email">Email:</label>
    <input type="email" id="email" name="email" required><br><br>
    <button type="submit">Submit Data</button>
  </form>
</body>
</html>

Save this as send-data.html, open it in your browser, fill in the fields, and click submit.

Option B: JavaScript Fetch API (More Flexible) #

This sends JSON data and gives you feedback on success/failure:

<!DOCTYPE html>
<html>
<body>
  <h3>Send Data via Fetch</h3>
  <input type="text" id="name" placeholder="Enter name" required>
  <input type="email" id="email" placeholder="Enter email" required>
  <button onclick="sendToAPI()">Send Data</button>

  <script>
    function sendToAPI() {
      const nameInput = document.getElementById('name');
      const emailInput = document.getElementById('email');
      
      const data = {
        name: nameInput.value,
        email: emailInput.value
      };

      fetch('https://localhost:44378/api/Home', {
        method: 'POST',
        headers: {
          'Content-Type': 'application/json',
        },
        body: JSON.stringify(data),
      })
      .then(response => {
        if (!response.ok) throw new Error('Request failed');
        return response.json();
      })
      .then(result => {
        alert('Data sent successfully!');
        console.log('API Response:', result);
        // Clear inputs after success
        nameInput.value = '';
        emailInput.value = '';
      })
      .catch(error => {
        console.error('Error:', error);
        alert('Failed to send data—check your API and try again.');
      });
    }
  </script>
</body>
</html>

Open this in your browser, enter data, and click the button—it will send the JSON payload to your API.

• Make sure your API endpoint is properly configured to handle the request method (GET/POST/PUT) and parse the incoming data (query params, form data, or JSON).
• If you run into CORS errors (e.g., opening the HTML file directly via file:// while your API is on https://localhost), you'll need to enable CORS on your API backend to allow local requests.
• For database write operations (like inserting data), stick with POST/PUT instead of GET—it's more secure and aligns with REST best practices.

内容的提问来源于stack exchange，提问作者hamed