Click here to Skip to main content
15,906,463 members
Home / Discussions / C#
   

C#

 
GeneralRe: Search Command Pin
Heath Stewart7-Jul-04 4:26
protectorHeath Stewart7-Jul-04 4:26 
GeneralHttpWebRequest Pin
Moon Boy6-Jul-04 14:23
Moon Boy6-Jul-04 14:23 
GeneralRe: HttpWebRequest Pin
Heath Stewart7-Jul-04 4:19
protectorHeath Stewart7-Jul-04 4:19 
Generalneed sp_helpdb return values Pin
betterc6-Jul-04 14:06
betterc6-Jul-04 14:06 
GeneralRe: need sp_helpdb return values Pin
leppie6-Jul-04 14:55
leppie6-Jul-04 14:55 
GeneralRe: need sp_helpdb return values Pin
betterc6-Jul-04 14:57
betterc6-Jul-04 14:57 
GeneralRe: need sp_helpdb return values Pin
betterc7-Jul-04 1:20
betterc7-Jul-04 1:20 
GeneralRe: need sp_helpdb return values Pin
Heath Stewart7-Jul-04 3:56
protectorHeath Stewart7-Jul-04 3:56 
The same as you do for any stored procedure: create a SqlCommand and fill it's Parameters collection property with parameters using the same names as the parameters defined by the stored procedure, plus one parameter with a direction of ParameterDirection.ReturnValue:
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "sp_helpdb";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@dbname", SqlDbType.NVarChar, 128).Value = "master";
SqlParameter retVal = new SqlParameter("@RETURN_VALUE", SqlDbType.NVarChar,
  128, ParameterDirection.ReturnValue, false, 0, 0, null,
  DataRowVersion.Current, null);
cmd.Parameters.Add(retVal);
try
{
  connection.Open();
  cmd.ExecuteNonQuery();
}
finally
{
  connection.Close();
}
Console.WriteLine(retVal.Value);


 

Microsoft MVP, Visual C#
My Articles
GeneralRe: need sp_helpdb return values Pin
betterc7-Jul-04 6:19
betterc7-Jul-04 6:19 
GeneralRe: need sp_helpdb return values Pin
Heath Stewart7-Jul-04 8:19
protectorHeath Stewart7-Jul-04 8:19 
GeneralShoModaDialog Pin
IamADotNetGuy6-Jul-04 13:06
IamADotNetGuy6-Jul-04 13:06 
GeneralRe: ShoModaDialog Pin
Heath Stewart7-Jul-04 3:41
protectorHeath Stewart7-Jul-04 3:41 
GeneralRe: Problems compiling class library Pin
leppie6-Jul-04 14:58
leppie6-Jul-04 14:58 
General4 different random numbers Pin
insurgentpyro6-Jul-04 11:20
insurgentpyro6-Jul-04 11:20 
GeneralRe: 4 different random numbers Pin
Christian Graus6-Jul-04 11:57
protectorChristian Graus6-Jul-04 11:57 
GeneralRe: 4 different random numbers Pin
insurgentpyro6-Jul-04 18:50
insurgentpyro6-Jul-04 18:50 
GeneralRe: 4 different random numbers Pin
Christian Graus7-Jul-04 12:22
protectorChristian Graus7-Jul-04 12:22 
GeneralRe: 4 different random numbers Pin
Anonymous7-Jul-04 17:51
Anonymous7-Jul-04 17:51 
GeneralRe: 4 different random numbers Pin
Arjan Einbu6-Jul-04 12:29
Arjan Einbu6-Jul-04 12:29 
GeneralRe: 4 different random numbers Pin
insurgentpyro6-Jul-04 18:52
insurgentpyro6-Jul-04 18:52 
GeneralRe: 4 different random numbers Pin
Arjan Einbu7-Jul-04 1:34
Arjan Einbu7-Jul-04 1:34 
GeneralRe: 4 different random numbers Pin
Anonymous7-Jul-04 5:39
Anonymous7-Jul-04 5:39 
GeneralRe: 4 different random numbers Pin
Arjan Einbu7-Jul-04 10:27
Arjan Einbu7-Jul-04 10:27 
GeneralRe: 4 different random numbers Pin
mikeschuld6-Jul-04 13:18
mikeschuld6-Jul-04 13:18 
GeneralRe: 4 different random numbers Pin
insurgentpyro6-Jul-04 18:50
insurgentpyro6-Jul-04 18:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.