1 Answer
1

In the designer, the query will display the parameters it expects in the order it expects them ie you should see something like GetDataByAllInOne(@ParentID,@PaymentDate,@PaymentAmount,@SearchValue).
Can you check this first?

Thanks for the answer. I believe it's in the same order but I will have to confirm that tomorrow since my workplace was closed due to snow today.
–
Emad-ud-deenJan 16 '13 at 22:47

Intellisense shows: GetDataByAllInOne(ParentID As Integer, PaymentDate As Date?, PaymentAmount As String, SearchValue As Decimal?) I'm not sure why intellisense is sticking question marks (?) there as well. At the beginning of the post is how I defined the query in the designer. Thanks.
–
Emad-ud-deenJan 17 '13 at 14:56

The question marks indicate that they are nullable types - you are calling them with nothing as a parameter, so they do need to be nullable types for this. Intellisense is showing the params the query expects. When you say 'how I defined the query in the designer' that's not what I meant. I meant in the bottom half of the tableadapter, in the dataset designer, your queries are listed along with the parameters they expect. As you can see from the intellisense, they are not always the same order as when you typed them in.
–
peterGJan 17 '13 at 16:50

just looked at this again - it appears you have SearchValue and PaymentAmount crossed over somewhere. Try rebuilding the query in the designer.
–
peterGJan 17 '13 at 17:47

Just rebuilt it but it's still looking for a Decimal for the 4th parameter. Maybe this is a Visual Studio bug?
–
Emad-ud-deenJan 17 '13 at 18:52