While working with ADO.NET we always perform operations and for these operations parameters are sometimes required and these parameters can be passed in the class object in number of ways.

One way is to pass these parameter in the list form.

For doing that first you need to make the object of List class and pass the parameter as its type

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

In this case my type is the SqlParameter that means Sql type values will be get and set by this list.

After this we will create list items of the list and pass it to the object of ADO.NET class object.

  List<SqlParameter> parameterList = new List<SqlParameter>();
                    parameterList.Add(new SqlParameter("@AccessToken", emp.AccessToken));
                    parameterList.Add(new SqlParameter("@FirstName", emp.FirstName));
                    parameterList.Add(new SqlParameter("@LastName", emp.LastName));
                    parameterList.Add(new SqlParameter("@ProfileImage",Convert.FromBase64String(profileImagePath)));
                    parameterList.Add(new SqlParameter("@JobRoleID", emp.JobRoleID));
                    parameterList.Add(new SqlParameter("@CompanyID", emp.CompanyId));
                    parameterList.Add(new SqlParameter("@Password", emp.Password));
                    parameterList.Add(new SqlParameter("@PasswordSalt", Guid.NewGuid().ToString()));

Then we will pass this entire list into the SQL object and perform our operation as per our requirement.

 List<SqlParameter> parameterList = new List<SqlParameter>();
                    parameterList.Add(new SqlParameter("@AccessToken", emp.AccessToken));
                    parameterList.Add(new SqlParameter("@FirstName", emp.FirstName));
                    parameterList.Add(new SqlParameter("@LastName", emp.LastName));
                    parameterList.Add(new SqlParameter("@ProfileImage",Convert.FromBase64String(profileImagePath)));
                    parameterList.Add(new SqlParameter("@JobRoleID", emp.JobRoleID));
                    parameterList.Add(new SqlParameter("@CompanyID", emp.CompanyId));
                    parameterList.Add(new SqlParameter("@Password", emp.Password));
                    parameterList.Add(new SqlParameter("@PasswordSalt", Guid.NewGuid().ToString()));
                    reader = SqlHelper.ExecuteReader(sqlConnection, CommandType.StoredProcedure, "uspUpdateUserProfile", parameterList.ToArray());
                    if (reader.HasRows)
                    { 
                        while (reader.Read())
                        {
                            emp.Id = reader["ID"] != null ? !string.IsNullOrEmpty(Convert.ToString(reader["ID"])) ? Convert.ToInt32(Convert.ToString(reader["ID"]).Trim()) : 0 : 0;
                            emp.FirstName = reader["FirstName"] != null ? Convert.ToString(reader["FirstName"]).Trim() : string.Empty;
                            emp.LastName = reader["LastName"] != null ? Convert.ToString(reader["LastName"]).Trim() : string.Empty;
                            emp.ProfileImage = reader["ProfileImage"] != null ? Convert.ToBase64String((byte[])reader["ProfileImage"]).Trim() : string.Empty;
                            emp.JobRoleID = reader["JobRoleID"] != null ? Convert.ToString(reader["JobRoleID"]).Trim() : string.Empty;
                            emp.Email = reader["Email"] != null ? Convert.ToString(reader["Email"]).Trim() : string.Empty;
                            emp.CompanyId = reader["CompanyID"] != null ? Convert.ToString(reader["CompanyID"]).Trim() : string.Empty;
                            emp.Password = reader["Password"] != null ? Convert.ToString(reader["Password"]).Trim() : string.Empty;
                            break;
                        }
                        empResponse.Status = true;
                        empResponse.Message = "Profile details successfully updated.";
                    }
                    else
                    {
                        empResponse.Status = false;
                        empResponse.Message = "Unauthorized access.";
                    }