adding a stored procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Luke Davis - 17 Jul 2007 21:39 GMT

I'm trying to add a stored procedure to my Visual C# Express project, but it
won't add, I try to drag it from the database explorer and drop it onto the
form like I've seen done before and it won't work. Can someone tell me a
manual way or a better method of referencing a stored procedure in C#
Express?

Thanks,

Signature

Luke Davis, MCSE: Security
DEM Networks - Senior Systems Architect
7225 N First, Suite 105
Fresno, CA 93720
Office: 1 (559) 439-1000
Fax: 1 (866) 640-2041
www.demnetworks.com

Reply to this Message

Adrian Voicu - 17 Jul 2007 22:02 GMT

You cannot drag & drop a storred procedure object onto a form in .NET. If
you want to use the results from a stored procedure you have to write some
code to call one from the database and specify where the results should go
into. Here is an example:

http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx

Adrian.
----
[Please mark my answer if it was helpful to you]

> I'm trying to add a stored procedure to my Visual C# Express project, but it
> won't add, I try to drag it from the database explorer and drop it onto the
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message

adding a stored procedure

Free Magazines