title: How to pass value to a stored procedure using C#
body: <p>--Stored procedure           </p>
  
  <pre><code>  ALTER PROCEDURE [dbo].[Test]             
  @USERID varchar(25)              
  
   AS               
   BEGIN                  
  SET NOCOUNT ON                    
  IF NOT EXISTS Select * from Users where USERID = @USERID)         
      BEGIN                          
          INSERT INTO Users (USERID,HOURS) Values(@USERID, 0);                   
      END
  </code></pre>
  
  <p>I have this stored procedure in sql server 2005 and want to pass userid from a C# application. How can I do that. Many Thanks.</p>