C# + stored procedure

[S.Ljungstedt]

Hallo!
How do I set parameters to a Stored procedures in the application?

 

[Joyjit Mukherjee]

Hi,

see this in MSDN: -

http://msdn.microsoft.com/library/d...ofparameterizedstoredprocedurevisualbasic.asp

Regards
Joyjit

 

[Ben Bloom]

Hallo!
How do I set parameters to a Stored procedures in the application?

string Username = "Me";
SqlCommand comm = new SqlCommand("exec sp_GetUser @Username",conn);
comm.Parameters.Add("@Username",SqlDbType.Char);
comm.Parameters["@Username"].Value = Username;