Pubblicato da: maverick | novembre 10, 2008

Programming SharePoint List Data

Data Insertion

using (SPSite spsite = new SPSite(http://SPS01))
{
    using (SPWeb spweb = spsite.OpenWeb())
    {
     spweb.AllowUnsafeUpdates = true;
     SPList splist = spweb.Lists["Custom List"];
     SPListItem splistitem = splist.Items.Add();
     splistitem["Title"] = “Paul Joseph Adame”;
     splistitem["First_x0020_Name"] = “Luke Martin”;
     splistitem["Last_x0020_Name"] = “Adame”;
     splistitem.Update();
     }
}

Data Retrieval

using (SPSite spsite = new SPSite(“http://SPS01″))
{
    using (SPWeb spweb = spsite.OpenWeb())
    {
     spweb.AllowUnsafeUpdates = true;
     SPSiteDataQuery spsitedataquery = new SPSiteDataQuery();
     spsitedataquery.Lists = “<Lists BaseType=’0′/>”;
     spsitedataquery.Query = “<Where><Gt><FieldRef Name=’ID’ /><Value Type=’Number’>0</Value></Gt></Where>”;
     spsitedataquery.Webs = “<Webs Scope=’SiteCollection’ />”;
     spsitedataquery.ViewFields = “<FieldRef Name=’Title’ /><FieldRef Name=’First_x0020_Name’    /><FieldRef Name=’Last_x0020_Name’ />”;
     spsitedataquery.RowLimit = 10;
     DataTable datatable = spweb.GetSiteData(spsitedataquery);
     gvwList.DataSource = datatable;
     gvwList.DataBind();
     }
}


Categorie

Follow

Get every new post delivered to your Inbox.