[sourcecode language="csharp"] public SqlDataReader executeSPHelper(string cmdStr, ArrayList cmdParams) { SqlDataReader rd = null; SqlCommand sqlCmd = null; try { sqlCmd = new SqlCommand(cmdStr, yourConnection); sqlCmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter sqlParam in cmdParams) { sqlCmd.Parameters.Add(sqlParam); } rd = sqlCmd.ExecuteReader(); return rd; } catch (Exception e) { } finally { sqlCmd = null; } } public System.Data.SqlClient.SqlCommand [...]