Create a Visual Web Part Sandbox Solution

Create a Visual Web Part Sandbox Solution

In this task, you will create a sandboxed solution compatible Visual Web Part project.

Start Visual Studio 2010.

•Click File >> New >> Project.

•In the New Project dialog, under Installed Templates, select Visual C# >> SharePoint >> 2010 and select Empty SharePoint Project as the template.

•In the Name: textbox, enter SandboxSolu.

•In the Location: textbox, enter   a convenient location and click OK.

•In the SharePoint Customization Wizard, enter the URL of the on-premises site you created.

•Select Deploy as a sandboxed solution and click Finish.

•In the Solution Explorer, right-click the SandboxSolu project and select Add >> New Item.

•In the Add New Item – SandboxVWP dialog, select the Visual Web Part (Sandboxed) item and click Add.

In the Solution Explorer, double-click to open the VisualWebPart1 project item.Switch to Source view to edit the markup of the visual web part.

Add the following markup to the body of the page to add a label, drop down list, button, and a GridView control to the body of the visual web part. 

HTML

<p> Select List:

 <asp:DropDownList ID="ddlList" runat="server" /> </p>

 <asp:Button ID="ShowGrid" runat="server" OnClick="ShowGrid_Click" 

Text="Populate Grid!" /> <p> 

<asp:GridView ID="gridListItem" runat="server" /> </p> 

Click the Design button to toggle into design view. The visual web part should now look like:

Open the code behind of the visual web part by right-clicking anywhere on the design surface and selecting View Code. Add the following using directives to the top of the code behind file to reference the proper LINQ namespaces.

using System.Linq;

using System.Collections.Generic;

if (!Page.IsPostBack)

{

    SPWeb web = SPContext.Current.Web;

    var Names = from SPList list in web.Lists

                    where list.BaseTemplate != 

                        SPListTemplateType.DocumentLibrary

                    select list.Title;

    ddlList.DataSource = Names;

    ddlList.DataBind();

}

Switch back to the Design view of the visual web part.

•Double-click on the Populate Grid! button to create the event handler for the button’s click event.

•Locate the ShowGrid_Click event handler add the following code:

SPList SourceList = 

    SPContext.Current.Web.Lists.TryGetList(ddlLists.SelectedValue);

SPQuery qry = new SPQuery();

qry.ViewFieldsOnly = true;

qry.ViewFields = "<FieldRef Name='Title' /><FieldRef Name='Author' />";

qry.RowLimit = 20;

gridListItem.DataSource = SourceList.GetItems(qry).GetDataTable();

gridListItem.EmptyDataText =

    string.Format(

        "The {0} list does not contain any items!",

        SourceList.Title);

gridListItem.DataBind();

Testing the Visual Web Part

Hit F5 to deploy the package to your local SharePoint 2010 instance and debug the project. Visual Studio 2010 will compile and deploy the project, activate the feature and open the specified SharePoint site in a browser window.

Click the Edit icon at the top of the page to put the page in Edit mode:

•Click the Web Part ribbon button to insert the web part.

•Under Categories select Custom, and under Web Parts select VisualWebPart1 Title. Click Add to add the web part to the page. The web part is now added to the page and is ready to test.

Click the Save button to save the changes you made to the page.

To test the web part, select a list in the drop down list and click the Populate Grid! button. The grid should show the items from the list or a message that the list does not contain any items.

Happy Programming..

Posted in: Creating a Visual Web Part Sandboxed Solution,sandbox solutions,sharepoint 2010