Referencing stored procedure parameters with c# - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Referencing stored procedure parameters with c#

Mini_MaggitMini_Maggit Posts: 28Member

I am trying to reference the parameters I've set out in my stored procedures within SQL Server 2000 using C#. What is the correct syntax to do this?

For instance, in VB.Net (using a delete stored procedure in SQL Server) you would do this:

[code]With daCategory.DeleteCommand
.Parameters("@ID").Value = aCategory.ID
End With[/code]

What is the syntax in C# to do the same thing (ie. to reference the parameters set out by the stored procedure - in this case it would be "@ID")

Sign In or Register to comment.