How to pass parameter from an array in c#?

Question

I want to assign a value parameter dynamic through an array. For example, the array arr_param will contain two value [0] = "abc", [1] = "ZYX" .Now, I will assign them .The problem here is that i must specify the correct elements [0],[1] after run foreach, I tried do it but failed convert to int

string[] arr_param  =  array_parameter.Split(';');
foreach (DataRow parmRow in parmsDataTable.Rows)
{
    string parmName = parmRow[parmNameDataColumn].ToString();
    cmd.Parameters.AddWithValue(parmName, arr_param[Convert.ToInt32(parmsDataTable.Rows)]);
}

I get error Unable to cast object of type 'System.Data.DataRowCollection' to type 'System.IConvertible'.

You get this exception because of this line : cmd.Parameters.AddWithValue(parmName, arr_param[Convert.ToInt32(parmsDataTable.Rows)]); You're trying to convert a collection of DataRow which is parmsDataTable.Rows to an Int32 type. You can't do that convertion. — CodeNotFound
– CodeNotFound, Commented May 7, 2016 at 13:46

Zein Makki · Accepted Answer · 2016-05-07 13:46:20Z

1

parmsDataTable.Rows is a DataRowCollection and it can't be converted to int.

A Simple Solution:

string[] arr_param  =  array_parameter.Split(';');
int counter = 0;
foreach (DataRow parmRow in parmsDataTable.Rows)
{
   string parmName = parmRow[parmNameDataColumn].ToString();
   cmd.Parameters.AddWithValue(parmName, arr_param[counter++)]);
}

Or:

string[] arr_param  =  array_parameter.Split(';');
foreach (DataRow parmRow in parmsDataTable.Rows)
{
   string parmName = parmRow[parmNameDataColumn].ToString();
   cmd.Parameters.AddWithValue(parmName,arr_param[parmsDataTable.Rows.IndexOf(parmRow))]);
}

answered May 7, 2016 at 13:46

Zein Makki

30.2k6 gold badges58 silver badges66 bronze badges

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

1 Comment

Brian Crist Over a year ago

oh,two ways work and I think the first way easier to understand because it is clear.Thank you so much.

Collectives™ on Stack Overflow

How to pass parameter from an array in c#?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related