sql parameter

[MikeJ]

example below can we get a parameter by name or have to use the indexOf

SqlCommand cmd = new SqlCommand("proc_ERRORLOG_INSERT", oConn);

cmd.CommandType = CommandType.StoredProcedure;

SqlParameter param = new SqlParameter();

cmd.Parameters.Add("@Fileid", SqlDbType.Int).Value=99999;

cmd.Parameters.Add("@ErrorMessage", SqlDbType.VarChar).Value="Service Failed
on APP Server1";

cmd.Parameters.Add("@Retvalue",
SqlDbType.Int).Direction=ParameterDirection.Output ;

int iret = cmd.ExecuteNonQuery();

Console.WriteLine("return value "+iret.ToString()); //iRet is Rows
Affected

Console.WriteLine(cmd.Parameters.IndexOf("@Retvalu e")); // Proc Return
Number (value)

console.Read();

how can i get the @retvalue by name , Not by its index position in the
collection

TIA MJ

[Nicholas Paldino [.NET/C# MVP]]

MikeJ,

You should be able to do:

SqlParameter = cmd.Parameters["@retvalue"];

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"MikeJ" <ve***********@yahoo.comwrote in message
news:eQ*****************@newssvr21.news.prodigy.ne t...

example below can we get a parameter by name or have to use the indexOf

SqlCommand cmd = new SqlCommand("proc_ERRORLOG_INSERT", oConn);

cmd.CommandType = CommandType.StoredProcedure;

SqlParameter param = new SqlParameter();

cmd.Parameters.Add("@Fileid", SqlDbType.Int).Value=99999;

cmd.Parameters.Add("@ErrorMessage", SqlDbType.VarChar).Value="Service
Failed on APP Server1";

cmd.Parameters.Add("@Retvalue",
SqlDbType.Int).Direction=ParameterDirection.Output ;

int iret = cmd.ExecuteNonQuery();

Console.WriteLine("return value "+iret.ToString()); //iRet is Rows
Affected

Console.WriteLine(cmd.Parameters.IndexOf("@Retvalu e")); // Proc Return
Number (value)

console.Read();

how can i get the @retvalue by name , Not by its index position in the
collection

TIA MJ

[Alberto Poblacion]

"MikeJ" <ve***********@yahoo.comwrote in message
news:eQ*****************@newssvr21.news.prodigy.ne t...

how can i get the @retvalue by name , Not by its index position in the
collection

cmd.Parameters["@retvalue"] should work.

[MikeJ]

Thank you
MJ

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:%2****************@TK2MSFTNGP03.phx.gbl...

MikeJ,

You should be able to do:

SqlParameter = cmd.Parameters["@retvalue"];

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"MikeJ" <ve***********@yahoo.comwrote in message
news:eQ*****************@newssvr21.news.prodigy.ne t...

>example below can we get a parameter by name or have to use the indexOf

SqlCommand cmd = new SqlCommand("proc_ERRORLOG_INSERT", oConn);

cmd.CommandType = CommandType.StoredProcedure;

SqlParameter param = new SqlParameter();

cmd.Parameters.Add("@Fileid", SqlDbType.Int).Value=99999;

cmd.Parameters.Add("@ErrorMessage", SqlDbType.VarChar).Value="Service
Failed on APP Server1";

cmd.Parameters.Add("@Retvalue",
SqlDbType.Int).Direction=ParameterDirection.Outpu t;

int iret = cmd.ExecuteNonQuery();

Console.WriteLine("return value "+iret.ToString()); //iRet is Rows
Affected

Console.WriteLine(cmd.Parameters.IndexOf("@Retval ue")); // Proc Return
Number (value)

console.Read();

how can i get the @retvalue by name , Not by its index position in the
collection

TIA MJ

[MikeJ]

here is a piece of my code...the parameter fileid is not returning
SqlCommand Cmd = new SqlCommand("oa_SERVICE_OA2_getFileToProcess",
oConnect);

Cmd.CommandType = CommandType.StoredProcedure;

Cmd.CommandTimeout = 600;

Cmd.Parameters.Add("Statusid", SqlDbType.Int).Value = 123; //Direction =
ParameterDirection.Input;

Cmd.Parameters.Add("FormTypeid", SqlDbType.Int).Value = 2;//Direction =
ParameterDirection.Input;

Cmd.Parameters.Add("SetStatusIdTo", SqlDbType.Int).Value = 139; //Direction
= ParameterDirection.Input;

Cmd.Parameters.Add("FileId", SqlDbType.Int).Direction =
ParameterDirection.Output;

Cmd.Parameters.Add("FilePath", SqlDbType.VarChar,244).Direction =
ParameterDirection.Output;

Cmd.Parameters.Add("ReturnCode", SqlDbType.Int).Direction =
ParameterDirection.ReturnValue;

int iRet = Cmd.ExecuteNonQuery();

Console.WriteLine(Cmd.Parameters["ReturnCode"].Value); //shows
correct value

Console.WriteLine(Cmd.Parameters["Fileid"].Value); //shows
empty

Console.WriteLine(Cmd.Parameters["FilePath"].Value); //Empty

Console.WriteLine("Ret {0}", iRet.ToString()); // Shows
Correct Value

Console.Read();
Tia
MJ


"Alberto Poblacion" <ea******************************@poblacion.orgwro te
in message news:%2****************@TK2MSFTNGP06.phx.gbl...

"MikeJ" <ve***********@yahoo.comwrote in message
news:eQ*****************@newssvr21.news.prodigy.ne t...

>how can i get the @retvalue by name , Not by its index position in the
collection

cmd.Parameters["@retvalue"] should work.

[Alberto Poblacion]

"MikeJ" <ve***********@yahoo.comwrote in message
news:T3*****************@newssvr27.news.prodigy.ne t...

here is a piece of my code...the parameter fileid is not returning
[...]
Cmd.Parameters.Add("FileId", SqlDbType.Int).Direction = [...]
Console.WriteLine(Cmd.Parameters["Fileid"].Value);
//shows empty

I suspect a casing problem: you are creating the parameter as "FileId"
(uppercase "I") and then looking for "Fileid" (lowercase "i").