Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Stored Procedure result in Aspx page

Stored Procedure result in Aspx page

Scheduled Pinned Locked Moved ASP.NET
databasequestion
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • U Offline
    U Offline
    User 4596681
    wrote on last edited by
    #1

    Hi, How can i get my Stored procedure result in Aspx page.I have one strode procedure to insert records,if record is existed in the data base with same ID,then i need to show a message like 'Record all ready existed'.

    Vasvai

    C 1 Reply Last reply
    0
    • U User 4596681

      Hi, How can i get my Stored procedure result in Aspx page.I have one strode procedure to insert records,if record is existed in the data base with same ID,then i need to show a message like 'Record all ready existed'.

      Vasvai

      C Offline
      C Offline
      coolestCoder
      wrote on last edited by
      #2

      You need to add an output parameter and decide upon what value you will return in case if record exists. So you may return some int value to represent that record exists for example - 1000 otherwise, if record does not exists you may return 500. Something like that.


      "A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder


      coolestCoder

      N 1 Reply Last reply
      0
      • C coolestCoder

        You need to add an output parameter and decide upon what value you will return in case if record exists. So you may return some int value to represent that record exists for example - 1000 otherwise, if record does not exists you may return 500. Something like that.


        "A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder


        coolestCoder

        N Offline
        N Offline
        neerubee
        wrote on last edited by
        #3

        Using Output parameter in Stored procedure we can do this. Search in google for Output Parameter.

        Thanks & Regards Niranjan

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups