Answered by:
Code behind class in sharepoint

Question
-
Hi Members,pls assit me in development of the this page( https://apps.hawaiianair.com/myhawaiianmiles/Enroll/Enrollment.aspx?partner=ALINFO) in sharepointand 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.- Marked as answer by Paul AndrewMicrosoft employee Thursday, May 21, 2009 6:13 PM
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- Proposed as answer by Amir Hashemi Friday, May 15, 2009 5:18 PM
- Marked as answer by Paul AndrewMicrosoft employee Thursday, May 21, 2009 6:13 PM
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.aspxThursday, 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.- Marked as answer by Paul AndrewMicrosoft employee Thursday, May 21, 2009 6:13 PM
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- Proposed as answer by Amir Hashemi Friday, May 15, 2009 5:18 PM
- Marked as answer by Paul AndrewMicrosoft employee Thursday, May 21, 2009 6:13 PM
Thursday, May 14, 2009 10:50 PM