minetteh

minetteh

  • NA
  • 7
  • 0

refreshing stored proc SqlParameters

Feb 23 2005 2:58 AM
I need to write a method that receives a stored procedure name and returns an array of the SqlParameters for that specific procedure. I know about the sp_help system stored procedure in Sql Server but want this done through code. I found something that seems to do this in VB.NET : Set Cmd1 = New ADODB.Command Cmd1.ActiveConnection = Conn1 Cmd1.CommandText = "sp_AdoTest" Cmd1.CommandType = adCmdStoredProc Cmd1.Parameters.Refresh But cant seem to find any equavalent in C# using SqlClient. Any kind of pointers would be appreciated.

Answers (1)