HTML page execute a procedure

• texpic

  SSCertifiable

  Points: 5887

  More actions

  November 21, 2019 at 3:40 am

  #3699427

  I have zero front end coding skills; last time I worked with any code like that was Visual Basic 6.  I'd like to have a html page on my local machine where I could organize the execution of procedures.  I have to pass a parameter.  Does anyone have a sample?  Is there some easy web site builder that I could get that would have an easy learning curve that is available?  Thanks.

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  November 21, 2019 at 2:54 pm

  #3699647

  there should be dozens of examples on codeproject

  but I did find this

  https://www.databasejournal.com/features/mssql/article.php/3589021/Executing-SQL-Stored-Procedures-from-inside-a-Web-Application-Part-1.htm

  depending on what framework you are using the parameter bit will look a bit like (pseudo code here)

  create connection

  create command

  command.add parameter

  command.execute

   

  MVDBA