public IList<ParamInfo> GetParamByParamName(string paramname) { IList<ParamInfo> paramall = new List<ParamInfo>(); SqlParameter param = new SqlParameter(PARAM_PARAM_NAME, SqlDbType.NVarChar); param.Value = paramname; using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_PARAM_BY_PARAMNAME, param)) { while (rdr.Read()) { ParamInfo newparam = new ParamInfo(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3)); paramall.Add(newparam); } } return paramall; }