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


Post New Web Links

Adding a column from another List to a Dataview? Must I link sources or can I just add a new data so

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
 
Using Designer, I added a dataview to a webpart page and dragged in a single list source. It works as expected. I now want a column from another list in my view. Must I link in another datasource, or can i just insert the data source for the second list into my datasources? The new datasource is there in the code and I see the caml select for it. but my XSL still does not find data: <xsl:value-of select="/dsQueryResponse/Master/Rows/Row[@ID = current()/@Key]/@Lastname" /> I noticed my new columns are not in the <datafields> tag, I tried adding them but it did not help. If Master is my lookup list , @Key is the dataview I will match with and @ID is the column in Master, and @Lastname column I want to return, is the above syntax correct? Many Thanks.    


View Complete Post


More Related Resource Links

Use BDC data in list as multi-select column

  
I have a document library that uses values from another system for its metadata.  Right now, we copy the values from the primary system into SharePoint so users can choose them.  I want to find a way to use the BDC connection that I have set up to automatically pull those values.  The problem is that the current metadata is set to multi-select.  So, I have a file that is in the library and it can be used for multiple clients - clients is a column in my library and users can select many entries.  When I set up a column to pull BDC data, it only allows single entry.  Does anyone have any ideas?

Sharepoint list group by column data ,display in webcontrol like panel or label

  

I  have a sharepoint list[Managers] with groupby sector column. like below

1)Sector1
a)Dep1
b)Dep2

2)Sector2
a)Dep3

3)Sector3
a)Dep4
b)Dep4
c)Dep4

Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?

REgards
mansoor

 


Regards, Mansoor

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

  
Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

Best way to display data of a single column from a Sharepoint Custom List

  
I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

how to transfer data from list column to another column of the same list programmatically?

  
I have a list and i want to transfer the data from column "Test Display Name" to "Test Display Name Dummy" at renamed it back to "Test Display Name" however i'm getting problem transferring the data. pls help. thanks actually the root problem is my list is not exporting to spreadsheet. i'm getting an error "An operation that uses the database driver could not be completed If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query. For other drivers, contact your database administrator or driver vendor." any idea how can i export this Private Sub UpdateTestName() Using oSite As SPSite = New SPSite("http://test_baseline:13838/") Using oWeb As SPWeb = oSite.OpenWeb("SharedArea") Try Dim oList As SPList = oSite.RootWeb.GetList("/SharedArea/Lists/Test Names") oList.Fields.Add("Test Display Name Dummy", SPFieldType.Text, True) oList.Update() For Each oListItem As SPListItem In oList.Items If oListItem.Fields.ContainsField("Test Display Name") Then oListItem("Test Display Name Dummy") = oListItem("Test Display Na

Need to link multiple External Content List items to a single document metadata column

  
I have an external content list - for my purposes, the data isn't any fancier than a list of terms provided by a web service (read only - I don't need update/delete functionality). I want to be able to link any subset of those terms to a single document metadata column (in other words, I need it to work like a normal content list that is defined to allow multiple values in a column) but SharePoint doesn't let me do that on an ECL. I need the content list to be externally driven since more values are going to be added to an outside system over time, but I think it's possible that I may not need a full-fledged ECL list to make this work this way in SharePoint. Just to clarify: I don't need the metadata values in my documents to maintain a PERSISTENT link to the web service (if someone changes an underlying value in the web service DB, it doesn't need to be updated in the document table too). I just want SharePoint to offer up an updated set of source values from the web service if somebody goes in and edits the document metadata. Any ideas for how I can make this work?

Cannot delete external data list column due "Parameter name: combinedEncoded" error

  
Hello!   I migrated a Sharepoint 2007 to a Sharepoint 2010 by dbattach method. And now I want to delete the BDC list columns, but I'm getting this exception: System.ArgumentException:   Parameter name: combinedEncoded    at Microsoft.SharePoint.BdcClientUtil.SplitStrings(String combinedEncoded) What should I do to delete properly this columns?   Many thanks!

How to link Title to it's associated page in list view without URL path column visible -bug?

  
I don't know if this is a bug or if I'm an idiot (or perhaps both, I'm open minded).   My site I'm developing is a site with publishing features activated where all my news stories are pages. What I want to have is a sortable list (the type hypothetically achieved using the XsltListView Web Part) the lists these pages with 3 columns visible: The Date created, the title (not the page name), and the author. The tricky part is that I would like the title, when clicked on, to take the person to the page. I'm actually almost there. I've created a new view with these specifications except for one issue. To make the title linked to the page, I have to have the column "URL Path" in my list view. When I remove this column, the titles instead all link to the root of the directory I'm in (ex: if I'm in Pages/Forms/My_List.aspx it will link to Pages/Forms/) Is this a bug, or is the URL Path required for the link to work? Is there a way to hide the column? Thanks.

Adding SPListItem to a SPList with External Data Column

  
I used SharePoint 2010's BCS to create an external content type. I added a list column of the type "External Data" to a custom list. 1. When I add an Item through the SharePoint interface, the external data field is displayed correctly in the view. 2. I add the item using the following code:   SPListItem newItem = customList.Items.Add(); newItem["Title" ] = "Test" ; newItem["ExternalDataColumnTest" ] = "1111" ; newItem.Update();   Now, When i go to the list, i can see the new item, but the External Data Column is empty in the view. When I use the ECB action "View Item", i can see that the primary key of my external data type item was saved. When I use the ECB action "Edit Item", the external data column field is empty. When I compare the item I added with the one I added through code in the VS2010 debugger, they hold exactly the same value ("1111" in example above). Any advice would be greatly appreciated.  

How to copy a Column data from one List to another list whenever a new item created .

  

Hello ,

 

I have List A and List B

List A

-----------------------------------------------------

Ticket ID

Column A

Column B

Column C

 

List B

-----------------

Ticket ID

Column 1

Column 2

Column 3

I want to copy only Ticket ID from List A to List B , whenever a new item created in List A.

can you please give your thoughts?

how to do it?

Thanks in Advance!

 


Share Knowledge and Spread Love!

its showing weird binary data from the BDC data column in list

  
Hello Gentlemen,

Here I am experimenting the BDC with a simple example of pulling distinct data from a sql server 2005 to a sharepoint list column "SELECT distinct Color FROM Product" .


Blue     
Green    
Murali
red      
White    
Yellow

when i configured the bdc using Business Data List the data showing correct. But when I use this it in a list column with bdc data type its returnig me the binary type of data.
 
__bk82007400270056005600e60002000200020002000200
No exact match was found.


However in the bdc picker the data is displaying properly. The data type in sql is nvarchar. I tried changing different data types but its showing the same kind of it.

Here is the BDC:

Missing options on link data sources wizard

  

Help!!,

First of all I have 2 lists ListA and ListB, ListB is linked to ListA by its ID column and not by a lookup field.

Now, on SPD2007 I just display the data sources library, and choose the create new linked sources option, but in the 2010 version, can't seem to find this option directly, just when I'm using  or have inserted a data source of some sort.

The problem is that when I get to the wizard ( link data sources wizard) I choose both lists, choose to join them, and... that's it!!!! I don't get to choose the filter columns or anything, the only options are 'Back' and 'Finish', so needless to say that I don't get what I want, 'cause it only appears the word 'row' on the child list in the sources library.

I've been serching the web, and some people have posted this same question with no answers found. then I searched this forum, and couldn't find this topic either, so maybe it's just some especific behavior regarding bad installation or something, or its just a Beta problem. please let me know

thanks


Let's Finish This

Designing lists: Quick key combination for adding a new list column field?

  

I'm simply looking for a way to quickly design lists, and I find it rather slow to use the mouse to go to the Add New Column button in the ribbon every time when I want to add a new list field.

The only column that can't be changed type of later seems to be the Calculated column. But for all others, you can still change them afterwards.


Data View Web Part, update to Data Source / adding new list to existing data source

  

Hi all,

I have four Lists with identical columns :

List 1
List 2
List 3
List 4

I had to merge them, hence i created a data source ( Linked Source ) and merged these lists in SPD. I have used a data view webpart to display some columns from the merged lists data source and everything was working fine.

But now i have a new List : List 5 which also has the same columns like the other four lists and i need to update the data soure such that it is merged list of 5 lists not 4.

i updated the datasource property of the linked source to merge this new list as well. However the contents of List 5 dont appear in the data view webpart. 

Am i missing something here ? 

I dont want recreate the data view web part from scratch eachtime , because in future there might be List 6 , List 7 as well ... 


Need to link multiple External Content List items to a single document metadata column

  

I have an external content list - for my purposes, the data isn't any fancier than a list of terms provided by a web service (read only - I don't need update/delete functionality). I want to be able to link any subset of those terms to a single document metadata column (in other words, I need it to work like a normal content list that is defined to allow multiple values in a column) but SharePoint doesn't let me do that on an ECL. I need the content list to be externally driven since more values are going to be added to an outside system over time, but I think it's possible that I may not need a full-fledged ECL list to make this work this way in SharePoint.

Just to clarify: I don't need the metadata values in my documents to maintain a PERSISTENT link to the web service (if someone changes an underlying value in the web service DB, it doesn't need to be updated in the document table too). I just want SharePoint to offer up an updated set of source values from the web service if somebody goes in and edits the document metadata.

Any ideas for how I can make this work?


Adding checkbox column to data

  

I need to add a checkbox column to my data and do it programmatically.  I've seen a lot of other posts that address this, but can't get it to work in VB.

        Dim all3 = From p In all2
                 Let tempCost = db.maximum((p.PosVal - DollarBase) * slope + 1, 1)
                 Let Cost = String.Format("{0:$.}", Convert.ToDouble(tempCost))
                 Select p.Player, p.Team, Cost

        GridView1.DataSource = all3

        'Need to add checkbox code here

        GridView1.DataBind()



Programatically adding the "SummaryLinks" type column to the Site columns list

  

Hi,

Can anyone help me with the sample code to programatically add the "SummaryLinks" type column to the Site columns list.

Thankyou.


sarath
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