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!

Categories

Referencing stored procedure parameters with c#

Mini_MaggitMini_Maggit Posts: 28Member
Hi

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
.Connection.Open()
.Prepare()
.ExecuteNonQuery()
.Connection.Close()
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")

TIA
Sign In or Register to comment.