Well, you could easily force that by using a where statement in your query like this:
Where (LastName = @LastName or @LastName = 'All')
When the user typed in 'All' they would get everything, if they typed in 'Munshi' they would just get that.
A for why your parameter is not causing the dataset to only return matching rows, if what you say is true, it should be.
Perhaps you can post the whole query, and I'll take a look to see if I can spot what's wrong?
No comments:
Post a Comment