How to access output values returned from a Sproc WPF VS2015

Sean Kiernan

Not very good at this I can't seem to be able to interact with the sp in my WPF project I know very little as this is my first time to try and use them so please bare with me.

What I have to do is send the sp two values a startDate and endDate which it uses to check for availability of the selected car. It return all the Ids of the cars that are not contained in the Booking tbl on those dates.

I want to know how to be able to assign the returned outputs from the sp into a collection so I can display only available cars to the user.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
Accepted answer
Not entirely sure how far you have gone. You also haven't mentioneddb you are using or the technology (the categorydoes say ADO.NET).
Assuming you are using SQL Server client libraries, you will have to look into SqlDataReader and ExecuteReader method of SqlCommand object. Google and you will get the sample code.
You then iterate through the SqlDataReader which will give you a value row by row. You will need to assign (or add)those valuesto a list and finally return the list. Simple.
Sean Kiernan10y ago
Perfect that solved it sorry about the lack of details but you still nailed it with your answer. Took five minutes after that.