how to add a new parameter to SqlParameter[ ] Collection?

Question

I want to use something similar like this:

using (DataSet ds = new DataSet())
{
    SqlParameter[] dbParams = new SqlParameter[]
    {                        
        new SqlParameter("@PromptID", promptID)
    };

    if (scenarioID != 0)
        dbParams.Concat(new SqlParameter("@ScenarioID", scenarioID));
    //OR
    if (scenarioID != 0)
        dbParams.Add(new SqlParameter("@ScenarioID", scenarioID));
    }
}

I have searched for adding IEnumarable collection but it doesn't solve my problem. Should I create two collections and concat them? I think there must be an easy way to add an item. Any suggestions?

It's not clear why you've got that DataSet at all, by the way... — Jon Skeet
– Jon Skeet, Commented May 23, 2013 at 12:57
use List<SqlParameter> dbParams and then you can do dbParams.Add(new SqlParemeter("@PromptID", promptID) — Ehsan
– Ehsan, Commented May 23, 2013 at 12:58
@EhsanUllah - It is generally recommended that you put answers to questions in an answer. Comments are not permanent and may be deleted, so they are generally reserved for questions about questions or tangential information. — JDB
– JDB, Commented May 23, 2013 at 13:00

Jon Skeet · Accepted Answer · 2013-05-23 12:57:29Z

19

Just use a list instead:

var parameters = new List<SqlParameter>
{
    new SqlParameter("@PromptID", promptID)
};
if (scenarioID != 0)
{
    parameters.Add(new SqlParameter("@ScenarioID", scenarioID));
}

If you really need an array at the end, you can always use:

var array = parameters.ToArray();

answered May 23, 2013 at 12:57

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Carlos Landeras · Accepted Answer · 2013-05-23 12:59:19Z

2

var parameters = new List<SqlParameter>
{
    new SqlParameter("@PromptID", promptID),       
};

answered May 23, 2013 at 12:59

Carlos Landeras

11.1k11 gold badges61 silver badges84 bronze badges

Comments

Ehsan · Accepted Answer · 2013-05-23 13:02:19Z

2

You should use List instead of array.

   List<SqlParameter> dbParams = new List<SqlParameter>();

and then you can do

   dbParams.Add(new SqlParameter("@PromptID", promptID);

answered May 23, 2013 at 13:02

Ehsan

32.8k6 gold badges61 silver badges66 bronze badges

Comments

S.N · Accepted Answer · 2013-05-23 13:13:29Z

0

If you know the maximum number of items (instanses of SQLParameter type) then following approach is ideal. Else you can go with List<SqlParameter> approach, which is briefed by peers.

 var dbParams = new SqlParameter[2];
 dbParams.SetValue(new SqlParameter("@PromptID", promptID),0);
 dbParams.SetValue(new SqlParameter("@ScenarioID", scenarioID), scenarioID != 0 ? 1 : 0);

answered May 23, 2013 at 13:13

S.N

5,1685 gold badges34 silver badges51 bronze badges

Comments

Jr. Pacheco · Accepted Answer · 2019-02-22 13:13:20Z

-1

Other suggestion:

SqlParameter[] sqlPar = new SqlParameter[1];
sqlPar[0] = new SqlParameter("@System", "Teste");

answered Feb 22, 2019 at 13:13

Jr. Pacheco

498 bronze badges

Collectives™ on Stack Overflow

how to add a new parameter to SqlParameter[ ] Collection?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related