executing a stored proc with datareader instead of dataset
<p>Can anyone explain to me how I could convert this sample function to use a DataReader instead of a DataSet?</p>

<pre><code>private void Example(int pIntValue1, pIntValue2)
{

DataSet dsExampleResults;

int i = 0;


using (var daExample = new SqlDataAccess(this.ConnectionString))
{
var cmdExample = daExample.GetStoredProcCommand("Example.dbo.GetExampleData");

                    daExample.AddInParameter(cmdExample, "@param1", DbType.String, name);
                    daExample.AddInParameter(cmdExample, "@param2", DbType.DateTime, date);

                    dsExampleResults = daExample.ExecuteDataSet(cmdExample);
                }

                if (pIntValue1 &gt;= pIntValue2)
                {
                    i = dsExampleResults.Tables[0].Rows.Count;

                    while (i &gt; 0)
                    {
                        i--;
                        decExampleColumn1 = Convert.ToDecimal(dsExampleResults.Tables[0].Rows[i]["column1"]);
                                    decExampleColumn2 = Convert.ToDecimal(dsExampleResults.Tables[0].Rows[i]["column2"]);

                    }

                }
                else
                {
                    i = 0;
                    while (i &lt; dsExampleResults.Tables[0].Rows.Count)
                    {
                        decExampleColumn3 = Convert.ToDecimal(dsExampleResults.Tables[0].Rows[i]["column3"]);
                        decExampleColumn2 = Convert.ToDecimal(dsExampleResults.Tables[0].Rows[i]["column2"]);

                        i++;
                    }
                }

    }
</code></pre>
