Conclusions On Forms Services Development
Using InfoPath 2007 and InfoPath Forms Services within a SharePoint environment is a powerful option to take legacy paper-based form processes and convert them to powerful electronic data entry mechanisms that streamline overall business process while easing overall development efforts. Although there are methods to generate forms for use within SharePoint by developing custom WebParts that contain the relevant .NET controls for data capture and event handling to fetch or submit data to a variety of a data sources, the inherent InfoPath development capabilities make it a lucrative option for...
read moreDeveloping A Form WebPart – Part 5 – Wiring The Submission Event
The last portion required for the Form WebPart is getting the actual data into the database by wiring a submission event to the save button declared previously, easily accomplished by calling a stored procedure to accomplish the task. By pursing the option of using stored procedures, the option exists whether to use the native CLR stored procedures or to use a standard T-SQL stored procedures. Since the submission of the data is relatively straightforward, the Forms WebPart uses three small classes to build extendable business logic. Using a base class allows the inclusion of code to enhance...
read moreDeveloping A Form WebPart – Part 4 – Setup the Validation Controls
The data that is being submitted with the Forms WebPart requires validation before it is committed to the database in order to maintain integrity of the information being stored. Doing validation with WebParts typically occurs in two main ways. One can choose to script a separate method in order to validate the entry by using an option like ServerValidateEventArgs.IsValid against the argument, or the inherent validation controls that ASP.NET 2.0 provides can be called in order to validate the information. Considering software architecture concerns and code bloat as a factor, it is typically...
read moreDeveloping A Form WebPart – Part 3 – Setup the Connection to the SQL Server with ADO.NET 2.0
In order to manage the connection to the database and perform relevant database operations, use ADO.NET functionality out of the System.Data.SqlClient namespace. For the Forms WebPart, ADO.NET provides the crux of the operations for database logic. In order to open a connection to the SQL database, the Forms WebPart can harvest the connection information out of a configuration file by using WebConfigurationManager out of the System.Web.Configuration namespace. By exposing the AppSettings public property, you can return key-value pairs from the configuration file, allowing the exposure of the...
read moreDeveloping A SharePoint Form WebPart – Part 2 – Declare Variables, Assign Controls, And Set up Exception Management
Once the class is setup for the Form WebPart, you need to declare relevant variables and instantiate the required controls by overriding the CreateChildControls() method. For the Forms WebPart, which only accepts an ID input, the only required controls are a TextBox control and a new button that is wired to a submission event. C# < view plain text > // Current Site SPSite siteThis = null; // Current Web SPWeb webThis = null; // Text Box Control private TextBox txtTextBox; //...
read moreDeveloping A SharePoint Form WebPart – Part 1 – Set Up the WebPart Class
Before accomplishing any custom development, the necessary foundational code must be added to the WebPart in order to set it up for inclusion in the SharePoint environment. You must establish the following references (shown in the code listing) in the main WebPartclass file. Doing so allows WebPart class derivation out of the WebPart base class, procures SQL connectivity using ADO.NET 2.0, allows for definition of WebPart attributes, and tolerates the binding of the appropriate user interface controls for final output by an overridden RenderWebPart method. C# < view plain text...
read more
Articles & Research
-
SharePoint Security -
SharePoint Development -
SharePoint Architecture -
Claims Authentication -
Forefront For SharePoint -
AIS / Dynamics GP -
Team Foundation Server -
Pex And Moles -
ISA/TMG/IAG/UAG -
DPM -
Cardspace -
Research Methodology -
Rural ICT Development -
Numerical Analysis -
Multi-Level Research -
Knowledge Management -
Personal/Off-Topic
Latests SharePoint Development Posts
- SharePoint 2013 High Availability And Business Continuity
- Designing Global (WAN) SharePoint 2013 Environments Part 2
- Designing Global (WAN) SharePoint 2013 Environments Part 1
- Using Information Policies In SharePoint 2013
- Information Policy Management In SharePoint 2013
- Co-authoring In SharePoint 2013
Latests SharePoint Security Posts
- Security In Business Connectivity Services In SharePoint 2013
- Planning Security When Migrating To SharePoint
- User Profile Database Architecture In SharePoint 2013
- Why Use User Profiles In SharePoint 2013
- SharePoint 2013 Planning User Profile Synchronization With Directory Services (AD DS,Novell, SJSDS)
- SharePoint 2013 User Profile Property Mapping And Synchronizing Groups