Below is my code how to get the records from a stored procedure. I can get the correct results from sql query analyzer, but less results in .NET. Why it happened? How to solve it? Thank.
strSQL = "EXECUTE sp_Collection '" & strRECID &"','" & strPayPeriodFrom & "','" & strPayPeriodTo & "','" & intPayDays & "' "
objDB = DatabaseFactory.CreateDatabase()
objDS = objDB.ExecuteDataSet(CommandType.Text, strSQL)
*NOTE: connected to correct database
View Complete Post