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

The ExecutePgSql command that I am using to execute the query also has the option to take in a list of parameters. Can you make an adjustment to your previous response to allow for the parameterized query and a separeate list of parameters that I can pass

Joshua Melrose answered on July 21, 2023 Popularity 1/10 Helpfulness 1/10

answer The ExecutePgSql command that I am using to execute the query also has the option to take in a list of parameters. Can you make an adjustment to your previous response to allow for the parameterized query and a separeate list of parameters that I can pass

The ExecutePgSql command that I am using to execute the query also has the option to take in a list of parameters. Can you make an adjustment to your previous response to allow for the parameterized query and a separeate list of parameters that I can pass

Comment

public DataSet GetSupplyChainUsageData(List<string> products, List<string> customers)
{
    DA_OCD_COMMON.BaseDataAccessElement dataAccessElement = new DA_OCD_COMMON.BaseDataAccessElement();
    StringBuilder query = new StringBuilder();
    query.Append("SELECT * FROM supply_chain_usage WHERE ");

    List<string> parameterNames = new List<string>();
    List<object> parameterValues = new List<object>();

    if (products != null && products.Count > 0)
    {
        query.Append("reagentName IN (");
        for (int i = 0; i < products.Count; i++)
        {
            string paramName = $"@product{i}";
            parameterNames.Add(paramName);
            parameterValues.Add(products[i]);
            query.AppendFormat("{0},", paramName);
        }
        query.Length--; // Remove the last comma
        query.Append(") AND ");
    }

    if (customers != null && customers.Count > 0)
    {
        query.Append("customerName IN (");
        for (int i = 0; i < customers.Count; i++)
        {
            string paramName = $"@customer{i}";
            parameterNames.Add(paramName);
            parameterValues.Add(customers[i]);
            query.AppendFormat("{0},", paramName);
        }
        query.Length--; // Remove the last comma
        query.Append(") AND ");
    }

    // Remove the last "AND" in the query and execute the SQL with parameters
    query.Length -= 4;

    DataSet ds = new DataSet();
    dataAccessElement.ExecutePgSql(ds, query.ToString(), "REDSHIFT_ECONN_DB", "supplyChainUsage", parameterNames, parameterValues.ToArray());
    return ds;
}

Popularity 1/10 Helpfulness 1/10 Language sql

Source: chat.openai.com

Tags: adjustment command execute list parameterized-query parameters response sql take using

Link to this answer
Share Copy Link

Contributed on Jul 21 2023

Joshua Melrose

0 Answers Avg Quality 2/10

The ExecutePgSql command that I am using to execute the query also has the option to take in a list of parameters. Can you make an adjustment to your previous response to allow for the parameterized query and a separeate list of parameters that I can pass

Contents

More Related Answers

The ExecutePgSql command that I am using to execute the query also has the option to take in a list of parameters. Can you make an adjustment to your previous response to allow for the parameterized query and a separeate list of parameters that I can pass

Grepper

Documentation

Social

Legal

Contact

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