How to select Sqlparameter list element by name?

Question

How to select Sqlparameter list element by name?

        SqlParameter[] para = new SqlParameter[]
        {
             new SqlParameter("@UserID",UserID),
             new SqlParameter("@startDate",startDate)
        };

When I want to got UserID,Then I need use para[0].value to get element value.

        Response.Write(para[0].value);

but its need to use int to get element.

Have any method to get element by 'Name', like para["UserID"].value?

Answer 1

Here's a work around for you:

https://dotnetfiddle.net/WeothY

Use Linq to select the parameter

var parameter = para.Where(a=>a.ParameterName == youParameterName).FirstOrDefault();