Stored Procedures and other queries with parameter - Using ADO.NET with SQL Se... - The Diigo Meta page

• 25 Jul 07
  

  Matthew Potocnik

  ado.net asp.net c# development parameter procedure stored

  • // add a new parameter, we need to get the name right this time!  
    SqlParameter sqlParam = com.Parameters.Add("@Identity", SqlDbType.Int);  
    // set the direction flag so that it will be filled with the return value  
    myParm.Direction = ParameterDirection.Output;
  • com.Parameters["@Identity"].Value will contain the value that was  set in the stored procedure

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.