This problem might be too vague for anyone to be able to fix without seeing it, but I'm interested to hear your ideas.
I am filling a dataset (using SQLHelper) using a stored procedure, and one of the tables in it isn't being filled at all. I debug at the point where I'm calling SQLHElper.FillDataset, the SP name is correct, the connection string is correct and the single parameter is being passed in. The other tables in the DS are filled fine, but the one I'm interested in has a count of zero. If I run the SP, with the same connection info and the same parameter, I get a single row - as I would expect. I can't see any structural changes, but surely that would cause it to fail anyway?
Can anyone think of something I haven't checked, or has anyoe got any ideas as to what may be causing it?
I am filling a dataset (using SQLHelper) using a stored procedure, and one of the tables in it isn't being filled at all. I debug at the point where I'm calling SQLHElper.FillDataset, the SP name is correct, the connection string is correct and the single parameter is being passed in. The other tables in the DS are filled fine, but the one I'm interested in has a count of zero. If I run the SP, with the same connection info and the same parameter, I get a single row - as I would expect. I can't see any structural changes, but surely that would cause it to fail anyway?
Can anyone think of something I haven't checked, or has anyoe got any ideas as to what may be causing it?
