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); }
private void ModifyCAMLFilter(SPDataSource dataSource) { var xml = new XmlDocument(); xml.LoadXml(dataSource.SelectCommand); if (xml.DocumentElement == null) { return; } var query = xml.DocumentElement.SelectSingleNode(CAML.Query); if (query != null) { var where = query.SelectSingleNode(CAML.Where); if (where == null) { where = xml.CreateNode(XmlNodeType.Element, CAML.Where, string.Empty); query.AppendChild(where); var w = CAMLGenerator.JoinFilters(CAMLPredicates, CAML.And); where.InnerXml = w; } else { var whereParts = new List <string> { where.InnerXml }; whereParts.AddRange(CAMLPredicates); where.InnerXml = CAMLGenerator.JoinFilters(whereParts, CAML.And); } } dataSource.SelectCommand = xml.OuterXml; Debug.WriteLine(xml.OuterXml); }
protected SPDataSource entityds() { using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current))) { SPWeb hrWeb = site.AllWebs["HRMV02"]; SPDataSource entityds = new SPDataSource(); entityds.List = hrWeb.Lists["Entity"]; return(entityds); } }
protected SPDataSource entityds() { using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current))) { SPWeb hrWeb = site.AllWebs["HRMV02"]; SPDataSource entityds = new SPDataSource(); entityds.List = hrWeb.Lists["Entity"]; return entityds; } }
protected SPDataSource resdetailds(int resfilterid) { using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current))) { SPWeb hrWeb = site.AllWebs["HRMV02"]; SPDataSource resdetds = new SPDataSource(); resdetds.SelectCommand = @"<Query> <Where> <Eq> <FieldRef Name='Department' LookupId='True' /> <Value Type='Lookup'>" + resfilterid + @"</Value> </Eq> </Where> </Query>"; resdetds.List = hrWeb.Lists["Resource Details"]; return(resdetds); } }
protected SPDataSource deptds(int deptid) { using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current))) { SPWeb hrWeb = site.AllWebs["HRMV02"]; SPDataSource deptds = new SPDataSource(); deptds.SelectCommand = @"<Query> <Where> <Eq> <FieldRef Name='Entity' LookupId='True'/> <Value Type='Lookup'>" + deptid + @"</Value> </Eq> </Where> </Query>"; deptds.List = hrWeb.Lists["Department"]; return(deptds); } }
protected SPDataSource deptds(int deptid) { using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current))) { SPWeb hrWeb = site.AllWebs["HRMV02"]; SPDataSource deptds = new SPDataSource(); deptds.SelectCommand = @"<Query> <Where> <Eq> <FieldRef Name='Entity' LookupId='True'/> <Value Type='Lookup'>" + deptid + @"</Value> </Eq> </Where> </Query>"; deptds.List = hrWeb.Lists["Department"]; return deptds; } }
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(); } }
protected SPDataSource resdetailds(int resfilterid) { using (SPSite site = new SPSite(MyConfiguration.GetSiteURL(SPContext.Current))) { SPWeb hrWeb = site.AllWebs["HRMV02"]; SPDataSource resdetds = new SPDataSource(); resdetds.SelectCommand = @"<Query> <Where> <Eq> <FieldRef Name='Department' LookupId='True' /> <Value Type='Lookup'>" + resfilterid + @"</Value> </Eq> </Where> </Query>"; resdetds.List = hrWeb.Lists["Resource Details"]; return resdetds; } }