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?