.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

Filtered Lookup with C#

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :SharePoint
 
Good day or night, 1)I have a problem with Sharepoint. 2)Ineed to make filter from multiple lookup(contain listbox1 and listbox2) second listbox2.(It is on NewForm.aspx in sharepoint designer) 3)Problem: get items in C# from lookup listbox2 on sharepoint site. What i have: Multiple lookup. With button "add" from listbox1 we can add multiple items to listbox2. I need get this item to C#. It needs for listbox3(which I create in C#) with CALM query to filter all items what connected only form items what we have choose in listbox2. 4)My tryings: On Shapepoint page with F12 I open source code select listbox2 and get name and ID In C# with recurson find all controls with names and ID. And find usefull control. After that with recursion and table name get litbox2 control than wont get all items from listbox2. Igave control but it anything contain, all time a have null. I thought that problem with page life cycle. Use Page Onload, prerender but result null. problem with control? can you advice how i can get items in C# from listbox2 or better with simple example (all in NewForm.axp when we wont make new row in sharepoint)?  


View Complete Post


More Related Resource Links

Filtered Lookup with C#

  
Good day or night, 1)I have a problem with Sharepoint. 2)Ineed to make filter from multimle lookup second listbox2.(It is on NewForm.aspx in sharepoint designer) 3)Problem: get items in C# from lookup listbox2 on sharepoint site. What i have: Multiple lookup. With button "add" from listbox1 we can add multiple items to listbox2. I need get this item to C#. It needs for listbox3(which I create in C#) with CALM query to filter all items what connected only form items what we have choose in listbox2. 4)My tryings: On Shapepoint page with F12 I open source code select listbox2 and get name and ID In C# with recursion find all controls with names and ID. And find usefull control. After that with recursion and table name get litbox2 control than wont get all items from listbox2. Igave control but it anything contain, all time a have null. I thought that problem with page life cycle. Use Page Onload, PreRender but result is null. Problem with control? Can you advice how i can get items in C# from listbox2 or better with simple example (all in NewForm.axp when we wont make new row in sharepoint)?   I try to use JavaSCript in C#, but suppose it is "Epic Fail" of using JS on server site. Because items not selected and tryin get them. But in script is problem the PATH i dont know how to put properly to sharepoint page. Page.RegisterStartupScript

Third Party Filtered Lookup is showing RENDER FAILED on clicking to sort Lookup Filter Column.

  

Hi,

i know this isn't a Microsoft Plug-in, but I have downloaded and installed the following third party control for WSS 3.0 (Not MOSS). 

http://filteredlookup.codeplex.com/

Has anyone had this problem. For some reason when I try and sort on a "Filtered Lookup" field I get RENDER FAILED. The column is in my Document Library that has 2,462 documents.

I need to switch off sort on it if possible. I have tried doing with JQuery (using Web Content Web Part), but no luck. 

Can anyone help as this is so important - even if someone can tell me where to start looking in the database. Could it be an incorrect/corrupt link in database or XML Schema File?

Your help would be really appreciated in this hour of need.

Thanks.

John.


Showing filtered Records in Crystal Report as per User Requirement

  

ReportDocument reportDocument = new ReportDocument();
    ParameterField paramField = new ParameterField();
    ParameterFields paramFields = new ParameterFields();
    ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            paramField.Name = "@Ext";
            //*Remember to reconstruct the paramDiscreteValue and paramField objects
            paramDiscreteValue.Value = 44854
            paramField.CurrentValues.Add(paramDiscreteValue);
            paramFields.Add(paramField);
            CrystalReportViewer1.ParameterFieldInfo = paramFields;
            reportDocument.Load(Server.MapPath("CMS_Report.rpt"));
&

lookup table query

  

we are doing our cms migration. both cms's have their own articleID/contentID, we have a lookup table that contain the article URL and its content id.  Now we want to query that table on every single click to get its respective id. 

How and where i can implement this?



BDC Entity as a Data Source for a Lookup column

  
Is it possible to create a custom lookup field type to have a BDC entity as the data source?

wss2.0 update/delete/hide lookup column that does not display any values

  

Hi All,

I have a document library that contains a Category column that is a lookup field. This is a default column that is a required field when uploading documents to the document library. The Category column is empty and I am unable to amend, hide, make it not required or delete it.

I have gone to Modify settings and columns -> clicked on the Category field to edit, but there is no option to amend the content or delete it. I am only able to amend the Column name and Description.

Since then, I have amended the column name to eg. Category1 and created a new Category field as a lookup and linked it to the correct list.

The problem I am facing now, is that I cannot hide, delete or make the Category1 (old Category) field NOT required. Either I would like to update the original field to display the correct values or alternately hide, delete or make the column not required.

Please help.


Datasheet view lookup column issue

  

When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.

http://support.microsoft.com/kb/948952

Any ideas how to get this resolved?


SSIS Lookup Transformation Issue

  
I am having a strange issue, In my data flow i have a Lookup Transformaton which will match on key columns of the fact and is followed by a condetional split that would deside if it should insert (old db destination) or go to update (oledb command) or ignore if no change. I have packages running for the last 1 year with the same logic. But in the recent packages I am experiencing a problem.  example: Key columns for join are - type_no (varchar 16) with all numeric values except one record wihh ' '(space) in it  and type_cd (decimal(18,0)) with values(0,1,2,3,4,5) It worked fine when I test the package. After couple of day running in schedule I get integrity violation and huge file with failed records which are supposed to be blocked at the condetional split as they are already in the fact. When i add a data viewer what i found is for all the llokup columns its having nulls (no match found). Workaround that is working for me for now is - I select full cash and say ok in the lookup transofrmation and again open it and set it back to no cash. Then it starts working as expected. Did anyone come accross this kind of issue? is the some standard that I have to follow to make sure this doesnot happen again  

Getting filtered data from Role based SSAS security

  
Hi everyone,I've got a heap of reports that are based on various SSAS cubes. I have roles defined on these cubes that restrict data via certain dimensions. Question is, will these restrictions filter through to the report...ie, if I have a sales person restricted in the SSAS cube to only see sales against their territory (restricted in the Territory dimension), when they run the report will it filter the result based on their SSAS credentials and only show the data they have access to (even though the SSRS report has no direct filters or parameters applied)?Cheers for any help!!

DVWP connections with multi-select lookup columns

  
I have a question concerning the Data View Web Part using SharePoint Designer 2007.   I have two list (A and B). List A has a lookup column (called B-items) with multiple selections to items in List B(using the Title column from B).   I create a web part page and insert a data view of using List A. I create another data view with data from List B. Next, I make a Web Part Connection between the two data views with A passing B-items column as parameter to List B data view. I then create a filter on the List B data view with a comparison of List B’s Title column equal to the parameter of List A’s B-items value when a user selects an item from List A data view. The problem is nothing appears in List B’s data view.   When I try the reverse of the above scenario it works fine.     I understand that this is properly functionality, but is there a way to achieve my first scenario? If so, how can it be accomplished?   I have looked through the web for help and found the answer here http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/749b7477-f37f-4724-94b3-b6ace770e73a seems to be what I’m looking for. However, I am unsure how to implement his code into the web part page.   I am a worse than a novice with xsl so if anyone gives an example I would greatly appreciate step by step on what code is needed a

Aggregate only filtered members

  
I’m creating a measure in a cube as lookup from another cube: CREATE MEMBER CURRENTCUBE.[MEASURES].[Test]  AS     lookupcube("[Cube1]",     "([Measures].[PublicPrice],     [Cube1 DimDate].[TIME Hierarchy].[" + [Cube2 DimDate].[TIME Hierarchy].currentmember.name + "]     )")     If I select in filter only January 2010 and February 2010 in Cube1, for Quarter 1  I obtain 100; in Cube2  I obtain 150. Even if March 2010 is not selected in Cube2 the aggregation level (the Quarter) considers it. Could someone help me? Thank you very much, Giada

SSIS - Lookup

  
Hi, I am using Lookup component in my SSIS workflow. I am comparing a string. Is there a way to ignore the case while comparing?

retrun dataType of filtered data using REST API ?

  
I know how to get filter data but unable to figure out return type Here is my Code if you can please correct me       ClientsItem item = (ServiceReference1.ClientsItem) client;     string cl = item.Title;     string url = @"http://sharepoint04/sites/Test/_vti_bin/listdata.svc/Projects$filter=Client eq ' " + cl + @"'" ; ServiceReference1.   TestDataContext cont = new ServiceReference1.TestDataContext(new Uri(url));

How do you change the datasource for a list based on another? ie a secondary list being a filtered

  
I'm actually using Sharepoint 2007, but am hoping this forum will help.  We want to be able to create a list based on a filtered view of another list.  I can create a Filtered List in Designer, but evidently this is saved as a query object on the server and not as another list that can be selected when using the basic Sharepoint tools.  In other words, it's only visible when in Designer.  This means that in order to use this for say a lookup column in another list object, I have to modify the datasource tags for the EditForm and NewForm.aspx pages within Designer.  Also, it means that adding a column would constantly require use of Designer.  We need this to be simple as not all those tasked with administrating pages will know how to do this.  I thought it would be easier if I could simply source a secondary list with the filtered list I created in designer.  In other words, make a secondary list source be that of a queried view of a master list.  Then this list could be used with all the simple tools provided.  Is this possible?  If so... how?

Move custom list (with lookup fields) to another Web Application

  
Is it possible to move a custom list with lookup fields to other custom lists from one web application to another? Creating list templates does not work and breaks the relationship. Thanks.   Neil

ancestor function not filtered by the where

  
Hi all! this issue might seem easy but I’m fighting it for 2 days now. All I need is to filter the month level to specific children for example with member semiMonthlySum as sum(       ancestor([Time].[Reporter Time].currentmember,[Time].[Reporter Time].[Semi Monthly])                  ,[Measures].[Interaction Count All]) select non empty {[Measures].[Interaction Count All],semiMonthlySum} on 0 , non empty [Time].[Reporter Time].[Date] on 1 from [niceKPI] where {[Time].[dtDate].&[2010-08-16T00:00:00]:[Time].[dtDate].&[2010-08-18T00:00:00]}   Gives me the folowing results Interaction Count All   semiMonthlySum 2010-08-16 00:00:00   1.00                             1,419.00 2010-08-17 00:00:00   101.00                         1,419.00 2010-08-18 00:00:00   12.00                           1,419.00   I would expect that the values for semiMonth

Problem while retrieving data from a lookup column from sharepoint linq.

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend