Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Working With SqlParameter in .NET

    Try the following code, it should get you started:

    SqlCommand cmd = new SqlCommand("usp_Table_Action");

    cmd.CommandType = CommandType.StoredProcedure;

    SqlParameter param = new SqlParameter("@ReturnCode", SqlDbType.Int);

    param.Direction = ParameterDirection.ReturnValue;

    cmd.Parameters.Add(param);

  • RE: Working With SqlParameter in .NET

    Another very important reason for using parameters that I didn't see covered in the article is that of security. Using parameters provides a very important layer of defence to...

Viewing 2 posts - 1 through 2 (of 2 total)