[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SqlDataReader Parameters

Posted on 2005-04-12
2
Medium Priority
?
323 Views
Last Modified: 2012-06-27
Hi,

When I used ADO for database queries there was a Refresh method on the Parameters collection of a Command object which I could use to find out what parameters were required for a stored procedure.
Is there a similar way to do this with an SqlCommand object?

Thanks...
0
Comment
Question by:bukko
2 Comments
 
LVL 8

Author Comment

by:bukko
ID: 13761573
...is that what the Prepare function is for?
0
 
LVL 21

Accepted Solution

by:
mastoo earned 2000 total points
ID: 13762360
Prepare does something different.

Dynamically querying for parameters might be frowned on in some developer circles, but try this:

http://www.dotnet247.com/247reference/msgs/15/79403.aspx
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Integration Management Part 2
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month18 days, 12 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question