public int UpdateList(Int32 op_id, string op_title) { SPDataSource ds = new SPDataSource(); ds.DataSourceMode = SPDataSourceMode.List; ds.UseInternalName = true; string queryString; queryString = "<View></View>"; ds.UpdateCommand = queryString; Parameter dbParam_ListId = new Parameter("ListID"); dbParam_ListId.DefaultValue = "DF806E7E-0073-4202-99E3-C4A269E2FA5D"; ds.UpdateParameters.Add(dbParam_ListId); Dictionary <string, object> keys = new Dictionary <string, object>(); keys.Add("ID", op_id); Dictionary <string, object> values = new Dictionary <string, object>(); values.Add("Title", op_title); SPDataSourceView dsw = ds.GetView(); dsw.Update(keys, values, null, null); return(1); }
public List <ProductCatalogData> GetListsOld() { SPDataSource ds = new SPDataSource(); ds.DataSourceMode = SPDataSourceMode.List; ds.UseInternalName = true; ds.Scope = SPViewScope.Recursive; ds.IncludeHidden = true; string queryString; //queryString = "<View><ViewFields><FieldRef Name='ID'/><FieldRef Name='Title'/><FieldRef Name='PermMask'/></ViewFields><Query><Where><Eq><FieldRef Name='ID' /><Value Type='Counter'>5</Value></Eq></Where></Query></View>"; //queryString = "<View><ViewFields><FieldRef Name='ID'/><FieldRef Name='Title'/><FieldRef Name='PermMask'/></View>"; queryString = "<View></View>"; ds.SelectCommand = queryString; Parameter dbParam_ListId = new Parameter("ListID"); dbParam_ListId.DefaultValue = "DF806E7E-0073-4202-99E3-C4A269E2FA5D"; ds.SelectParameters.Add(dbParam_ListId); SPDataSourceView dsw; List <ProductCatalogData> dt = new List <ProductCatalogData>(); dsw = ds.GetView(); SPList xlist = dsw.List; SPViewCollection colViews = xlist.Views; foreach (SPView vView in colViews) { } /* * SPListItem newFolder = xlist.Items.Add(xlist.RootFolder.ServerRelativeUrl, SPFileSystemObjectType.Folder, null); * if (newFolder != null) * { * newFolder["Title"] = "Min Nye Folder"; * newFolder.Update(); * } */ System.Web.UI.DataSourceSelectArguments args = new System.Web.UI.DataSourceSelectArguments(); SPDataSourceViewResultItem[] arrResult = (SPDataSourceViewResultItem[])dsw.Select(args); foreach (SPDataSourceViewResultItem Result in arrResult) { SPListItem oListItem = (SPListItem)Result.ResultItem; //SPField myField = xitem.Fields[new Guid("{FE7E79DD-DD68-438e-A960-E3686025D44B}")]; ProductCatalogData r = new ProductCatalogData(); foreach (SPField ofield in oListItem.Fields) { string tekst; try { tekst = ">" + ofield.Title + "< >" + ofield.InternalName + "<>" + oListItem[ofield.Id] + "<"; } catch { //OK } switch (ofield.InternalName) { case "ID": r.ID = (int)oListItem[ofield.Id]; break; case "Title": r.Title = (string)oListItem[ofield.Id]; break; } } dt.Add(r); } return(dt); }
protected override void BindDataSource() { var ds = new SPDataSource(List) {SelectCommand = BuildSelectCommand(false)}; ds.SelectParameters.Add("nextpagedata", Page.Request.QueryString.ToString()); ds.SelectParameters.Add("maximumrows", RowLimit.ToString()); ds.SelectParameters.Add("rootfolder", Page.Request.QueryString["RootFolder"]); ds.SelectParameters.Add("prevpagedata", ""); var view = ds.GetView(); var args = new DataSourceSelectArguments(); try { view.Select(args, DataSourceViewSelectCallback); NextPagePosition = ds.SelectParameters["nextpagedata"].DefaultValue; PrevPagePosition = ds.SelectParameters["prevpagedata"].DefaultValue; } catch (SPQueryThrottledException) { ThresholdException = true; ds = new SPDataSource(List) { SelectCommand = BuildSelectCommand(true) }; ds.SelectParameters.Add("nextpagedata", Page.Request.QueryString.ToString()); ds.SelectParameters.Add("maximumrows", RowLimit.ToString()); ds.SelectParameters.Add("rootfolder", Page.Request.QueryString["RootFolder"]); ds.SelectParameters.Add("prevpagedata", ""); view = ds.GetView(); args = new DataSourceSelectArguments(); try { view.Select(args, DataSourceViewSelectCallback); NextPagePosition = ds.SelectParameters["nextpagedata"].DefaultValue; PrevPagePosition = ds.SelectParameters["prevpagedata"].DefaultValue; } catch (SPQueryThrottledException) { // Empty data source DataSource = new DataTable(); } } if (RequiredAggregations) { BindAllDataSource(); } }