C# + stored procedure

  • Thread starter Thread starter S.Ljungstedt
  • Start date Start date
S.Ljungstedt said:
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;
 
Back
Top