views:

34

answers:

0

Ok, here is the thing, I have a stored proc which returns three sets of data results, i can use the results in code behind to databind a repeater or whatever, something like so...

        Using cmd As New SqlCommand("TICKET_TECH_S", oConn)
            cmd.CommandType = CommandType.StoredProcedure

            Using da As New SqlDataAdapter(cmd)
                Using ds As New DataSet
                    da.Fill(ds)
                    Return ds.Tables(0)
                    ''** Or table 1 or 2
                End Using
            End Using
        End Using

But what i want to do is point my SQL datasource at the stored proc and get the data contained in say 'ds.Tables(1)'. At the moment my datasource looks like so...

<asp:SqlDataSource DataSourceMode="DataSet" ID="SqlDataSourceNewTickets" runat="server" 
ConnectionString="<%$ ConnectionStrings:TP_SUPPORTConnectionString %>" 
SelectCommand="TICKET_TECH_S" SelectCommandType="StoredProcedure">
<SelectParameters>

</SelectParameters>
</asp:SqlDataSource>

Any ideas?