how to get string value from store procedure

Question

hi ,

in storeprocedure i am select "S" value i need to fetch this record by using c#..i tried but unable to get it can you help me on this

IF @shortlisted_flg = 'S'
              BEGIN

                   SELECT 'S'
              END

 DataTable dt = new DataTable();
dt = SQL_Helper.ExecuteSelect("usp_update_creative_ideas", dbparamsUserInfo, SQL_Helper.ExecutionType.Procedure);
if (dt != null && dt.Rows.Count > 0)
{
    result = string.Empty;
} 

can you help me on this