i am siva

Empty your memory, with a free()... like a pointer! <br /> The pointer can crash...and can overflow..!

programming against lists using the server-side object model

May 23, 2015

Hai,

Here will see programming against lists using the server-side object model. To do develop applications against SharePoint list we have to Microsoft.SharePoint namespace. To add this DLL reference to your project just go to c:\Program Files\Common Files\Microsoft Shared\Web ServerExtensions\14\ISAPI.

Before starting coding against list first will create a simple list using ShapePoint site. To do this go to SiteActions –> View All Site Content –>click Create –> Lists –> Custom List. Enter Products as the name of the list and click Create. After the site is created, we’ll add two more columns . To add two columns, click the List tab, and then List Settings –> Create Column. Add a column named Product_SKU and another column named Price, leave both columns with the default “Single line of text” type.

Now we have a list called Products with Title/Product_SKU/Price columns, will create a server side object model application to add items into the list.

Create a WPF application and create form which will take Product details. Add Micosoft.SharePoint Dll reference and add the namespace to application code file. After form design xaml file will look like the following

<Window x:Class="WPF_Lists_ServerSideObjectModel.MainWindow"
         xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
         xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
         Title="MainWindow" Height="350" Width="525">
     <Grid>
         <Label Content="Product Name" Height="28" HorizontalAlignment="Left" Margin="76,64,0,0" Name="lblProductName" VerticalAlignment="Top" />
         <Label Content="Product SKU" Height="28" HorizontalAlignment="Left" Margin="76,106,0,0" Name="lblProductSKU" VerticalAlignment="Top" />
         <Label Content="Product Price" Height="28" HorizontalAlignment="Left" Margin="76,154,0,0" Name="lblProductPrice" VerticalAlignment="Top" />
         <TextBox Height="23" HorizontalAlignment="Left" Margin="196,68,0,0" Name="txtProductName" VerticalAlignment="Top" Width="231" />
         <TextBox Height="23" HorizontalAlignment="Left" Margin="196,112,0,0" Name="txtProductSKU" VerticalAlignment="Top" Width="231" />
         <TextBox Height="23" HorizontalAlignment="Left" Margin="196,158,0,0" Name="txtProductPrice" VerticalAlignment="Top" Width="231" />
         <Button Content="Load" Height="23" HorizontalAlignment="Left" Margin="211,210,0,0" Name="btnLoad" VerticalAlignment="Top" Width="75" Click="btnLoad_Click" />
         <Button Content="Clear" Height="23" HorizontalAlignment="Left" Margin="330,210,0,0" Name="btnClear" VerticalAlignment="Top" Width="75" Click="btnClear_Click" />
     </Grid>
 </Window>

Double-click the Clear button and add the following code to clear the fields:

private void btnClear_Click(object sender, RoutedEventArgs e)
         {
             txtProductName.Text = string.Empty;
             txtProductPrice.Text = string.Empty;
             txtProductSKU.Text = string.Empty;
         }

Double-click the Load button and add the following code to add a new record to a SharePoint list 

private void btnLoad_Click(object sender, RoutedEventArgs e)
         {
             string siteURL = "http://siva-pc:46006";
             using (SPSite mySiteCollection = new SPSite(siteURL))
             {
                 using (SPWeb web = mySiteCollection.OpenWeb())
                 {
                     web.AllowUnsafeUpdates = true;
                     SPList list = web.Lists["Products"];
                     SPListItem listItem = list.Items.Add();
                     listItem["Title"] = txtProductName.Text;
                     listItem["Product_SKU"] = txtProductSKU.Text;
                     listItem["Price"] = txtProductPrice.Text;
                     listItem.Update();
                     web.AllowUnsafeUpdates = false;
                 }
             }
         }

After completion, debug the application, Fill the product information in prompted UI and press Load. go and check SharePoint site –> Products list for added product information through application.

  • 3Share on Facebook
  • 0Share on Twitter
  • 0Share on Pinterest
  • 0Share on LinkedIn
  • 0Share on WhatsApp
  • 0Share on Email
Posted in: SharePoint Tagged: SharePoint

Tags

.NET ASP.NET Azure DevOps C# Design Patterns Dot Net GoF SharePoint SqlServer TFS Visual Studio VS Windows WPF

Categories

  • .NET
  • ASP.NET
  • Azure DevOps
  • C#
  • Design Patterns
  • Dot Net
  • GoF
  • SharePoint
  • SqlServer
  • TFS
  • Uncategorized
  • Visual Studio
  • VS
  • Windows
  • WPF

Archives

  • August 2020
  • August 2019
  • May 2015
  • March 2013

Recent Comments

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Copyright © 2021 i am siva.

    Me WordPress Theme by themehall.com