Programmatic Use Of SQLDataSource Not Returning Dataview

I am creating an ad-hoc reporting module for my website.  The user may select a list of columns and specify the WHERE for the report.  I build the select statement and the where statement and pass the info to a stored procedure.  The stored procedure accepts 3 select parameters and a 3 wherestmt parameters.  I finally got the SQLDatasource to work by setting the parameter values in the Selecting method of the SQLDatasource.  Binding it to a gridview shows me all my values.  Now, I am trying to programmatically call the select method of the SQLDatasource so I can get a dataview or datareader to manipulate further.  I am getting an null back when I call the select method.  Any ideas why? or a workaround?

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AssetMgmtRWConnectionString %>"SelectCommand="getAdhocRptData" SelectCommandType="StoredProcedure" DataSourceMode="DataReader">

<SelectParameters>

<asp:Parameter Name="strSelect" Type="String" />

<asp:Parameter Name="strSelect2" Type="String" />

<asp:Parameter Name="strSelect3" Type="String" />

<asp:Parameter Name="strWhere" Type="String" />

<asp:Parameter Name="strWhere2" Type="String" />

<asp:Parameter Name="strWhere3" Type="String" />

<asp:Parameter Name="bitDebug" Type="Boolean" />

</SelectParameters>

</asp:SqlDataSource>

 

<VB Code>Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

'Getting an error that the object is null? why is the above code not returning any data?

'Tried using a datareader and datasource.Dim rptview As IDataReader = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), IDataReader)

If rptview.Read Then

lblMsg.Text = "Got Rows"

End If

End Sub

Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting

'For this sp, need to set each paramater even if it is not being used. Setting it in the wizard

'does not work. Need to be set programmatically.

e.Command.Parameters("@strSelect").Value = "p.field1, p.field2 "

e.Command.Parameters("@strSelect2").Value = "s.field1, s.field2"

e.Command.Parameters("@strSelect3").Value = "a.field1, a.field2, a.field4, a.field5"

e.Command.Parameters("@strWhere").Value = "p.field3 is not null and a.field5 is null"

e.Command.Parameters("@strWhere2").Value = "'"

e.Command.Parameters("@strWhere").Value = ""

e.Command.Parameters("@bitdebug").Value = False

End Sub

 

thanks for any help.