setting datasource params
Posted on 2007-10-14
I have the following functions inside my class.
Private Sub GetData()
Select Case _strRequired
_dsData.SelectCommand = "SP_TEAM_FIXTURES"
_dsData.SelectCommandType = SqlDataSourceCommandType.StoredProcedure
_dsData.ConnectionString = "xyz"
The_dsData is then returned as a property of the class as a datasource.
It is then used in the code behind my page as :
(_FixtureResult.DataSource.SelectParameters(0)) IS A RESULT OF THE CODE ABOVE.
However when i run this i am being told that:
'SP_TEAM_FIXTURES' expects parameter '@Team', which was not supplied.
Can any1 see why this is occuring?
Thanks in advance