Breaking News: Grepper is joining You.com. Read the official announcement!

Now I want for Sql server stored procedure

theenescresta answered on August 10, 2023 Popularity 1/10 Helpfulness 1/10

answer Now I want for Sql server stored procedure

Now I want for Sql server stored procedure

Comment

using System.Data;
using System.Data.SqlClient;
using Newtonsoft.Json;

[HttpGet]
public IActionResult ExecuteQuery(string requestType, string parameter)
{
    string connectionString = Configuration.GetConnectionString("DefaultConnection");
    string storedProcedureName;

    // Retrieve the stored procedure name for the specified request type from the configuration settings
    storedProcedureName = Configuration.GetSection("StoredProcedures").GetValue<string>(requestType);

    if (string.IsNullOrEmpty(storedProcedureName))
    {
        return BadRequest("Invalid requestType parameter");
    }

    // Execute the stored procedure using the connection string and parameter
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        using (SqlCommand command = new SqlCommand(storedProcedureName, connection))
        {
            command.CommandType = CommandType.StoredProcedure;
            command.Parameters.Add("@param", SqlDbType.VarChar).Value = parameter;

            connection.Open();
            DataTable dataTable = new DataTable();
            using (SqlDataReader dataReader = command.ExecuteReader())
            {
                dataTable.Load(dataReader);
            }
            connection.Close();

            // Convert the DataTable to a JSON string and return it as the response
            string jsonResult = JsonConvert.SerializeObject(dataTable, Formatting.Indented);
            return Ok(jsonResult);
        }
    }
}

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: javascript procedure sql-server

Link to this answer
Share Copy Link

Contributed on Aug 10 2023

theenescresta

0 Answers Avg Quality 2/10

Now I want for Sql server stored procedure

Contents

More Related Answers

Now I want for Sql server stored procedure

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.