locked
Code behind class in sharepoint RRS feed

  • Question

  • Hi Members,
      
                  pls assit me in  development of the this  page( https://apps.hawaiianair.com/myhawaiianmiles/Enroll/Enrollment.aspx?partner=ALINFO) in sharepoint

     and how we can connect to the database from the sharepoint environment.


     this page consisting of some Textboxs and one button(Enroll Now) to save the data.
     
     if we develope as a DB webpart it will be fine.

    my question is:

                     i  read  in the forums  we can acheive this by using  manually hook up server side code in code behinde calss.

      what is the server side  code in sharepoint and what is code behind class?

     
     how it is possible can u pls assist me.

    thanks,
    raju.
    • Edited by Sharepointingindepth Thursday, May 14, 2009 9:49 AM
    • Moved by Mike Walsh FIN Thursday, May 14, 2009 10:26 AM prog q (From:SharePoint - General Question and Answers and Discussion)
    Thursday, May 14, 2009 9:40 AM

Answers

  • Build a custom list that contains that same information (columns) as the webform plus a column (exID) that will contain a Primary key from
    the external record.
    Create a Visual Studio workflow that is associated to that custom list.
    Within that workflow add a code activity to write to the external database (please use a proper INSERT/UPDATE monolithic stored procedure that returns the registrations
    Primary key)
    Write back the Primary key to the worflowproperties.Item["exID"]
    Create a custom New and Edit Form for the list that leaves the exID field as non editable.

    After development of the workflow set the Start on Item Created and Start on Item Changed  properties to true
    I'm assuming that the external database is where the information needs to reside since airmiles progam subscription information
    in a sharepoint content database might not be too useful.
    Thursday, May 14, 2009 1:41 PM
  • Below is link to site that has a very good explanation on what you trying to achieve.

    http://www.andrewconnell.com/blog/articles/UsingCodeBehindFilesInSharePointSites.aspx


    Thursday, May 14, 2009 10:50 PM

All replies

  • > read  in the forums  we can acheive this by using  manually hook up server side code in code behinde calss.

    > what is the server side  code in sharepoint and what is code behind class?


    Moving to the Programming forum (where I wish them joy).
    WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx
    Thursday, May 14, 2009 10:25 AM
  • Build a custom list that contains that same information (columns) as the webform plus a column (exID) that will contain a Primary key from
    the external record.
    Create a Visual Studio workflow that is associated to that custom list.
    Within that workflow add a code activity to write to the external database (please use a proper INSERT/UPDATE monolithic stored procedure that returns the registrations
    Primary key)
    Write back the Primary key to the worflowproperties.Item["exID"]
    Create a custom New and Edit Form for the list that leaves the exID field as non editable.

    After development of the workflow set the Start on Item Created and Start on Item Changed  properties to true
    I'm assuming that the external database is where the information needs to reside since airmiles progam subscription information
    in a sharepoint content database might not be too useful.
    Thursday, May 14, 2009 1:41 PM
  • Below is link to site that has a very good explanation on what you trying to achieve.

    http://www.andrewconnell.com/blog/articles/UsingCodeBehindFilesInSharePointSites.aspx


    Thursday, May 14, 2009 10:50 PM