Business Data List web part, format field from database as hyperlink

 

I'm having a devil of a time joining two tables for a BDC to be used as a Business Data field in a list. I've seen plently of examples  connecting two tables to use with web parts, however i haven't seen anything about using an association in a list. Before i continue to beat myself up i need to know that this is possible.

 

If that's confusing here's what i'm trying to do.

I have two tables Locations and Region. I need the Region_Name from the region table based on the Location_Id (primary key) from the Location table. Locations is connected to Region by Region_id as a foreign key.

 

Any help would be immensely appreciated.

Hi guys,

I'm building a Sharepoint page with a data form web part that uses custom SELECT and UPDATE statements with an SQL Server connection in order to retrieve and store records of information.

I'm getting along fine, records seem to update how they should etc, but I've ran into a problem with one thing: Sharepoint dropdownlists in 'Edit Template'

So the issue is this: if I replace a textbox field with a dropdown list that is populated with a separate SQL datasource, the dropdown list seems to be unable to show the current value of the field.

E.g. I have a dataview which has a field "FruitID", which I can update just fine by setting the ID value to different numbers. The SQL datasource uses the FruitID to display a list of all available Fruits, (e.g. 1 = Banana, 2 = Apple, 3 = Cherry, etc).

If i open the dataview in editmode, the default value in the dropdown is null, despite the real value of the field being "2", which should show "Apple" in the dropdown.

I can select a fruit and click save, and it will update just fine. But the initial display needs to show the correct value to start with.

Is there a custom binding I should be coding to make this work? I can't configure dropdown <items> on an individual level as they are populated from the SQL server. I can't set "SelectedI

Hi there,

I am working with sharepoint 2007and I am trying to add a webpart list, specifically a Business Data List.

I am trying to do it through Site Actions> Edit Page.

Any clue?

 

Thanks in advance,

Joss83

I have a BDC entity whose fields contain a variety of data – numbers, dates and strings.  When I use the business data list web part I find that some of the columns’ dynamic filtering (accessed from the list’s column header) doesn’t work.  For these problem fields, the filter values load correctly but when I select a value all records disappear.  Initially I thought this was limited to just string columns but there is one string column that does filter correctly.

Here are some things that may be useful to know:

1.       The datasource is a SQL view and all fields are varchar(255)

2.

Hi, I want to read the data from BLOB field and write it into sharepoint list item. Please provide some pointer to archive above objective.   Thanks in Advance.

In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due).  The calculation is =[Created]+7.  I'm trying to display this data on a page using a DVWP.  But first, for testing purposes, I also created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created]. In the List View from within SharePoint, the dates show as expected (for example): Created = 8/12/2010 3:45 PM Due = 8/19/2010 3:45 PM TestCreate = 8/12/2010 3:45 PM In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt).  I see the time displayed for the example list item as: Created = 8/12/2010 3:45:30 PM Due = 8/19/2010 10:45:00 AM TestCreate = 8/12/2010 10:45:00 AM I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds).  It seems like the DVWP is returning the date in a different time zone (with no seconds).  The lcid is set right (1033).  I didn't see any time zone settings for the DVWP specifically.  I'm basically stuck.  Could someone help me figure this one out. Thanks.

hi, is it posible if i add some data in a sharepoint list that i can export these data to my sql server tables. or if i create a dataview for exapmle from databse A in SPD to use in my wss3 site and then export it to database B in sql server? thnx

I've got two questions relating to the business data list.  I took a look at the following article which seems to indicate this can happen, but I wasn't clear on how: http://sharepointmagazine.net/technical/administration/everything-you-need-to-know-about-bdc-part-4-of-8 First, in the section where it discusses the Business Data Actions, at one point it says "Incidentally, you can also access these actions by clicking the View Profile context menu as shown here", but I have yet to be able to get said context menu to appear in the data list.  I setup my BDC connection, have the data list displaying data, connected it to the actions webpart which shows the available actions, but there seems to be no context menu.  No dice here.   Second, in the Business Data List Advanced Settings section, it mentions "Keep in mind that the XSL contains not only the HTML results, it also contains the HTML for the selection criteria, the Actions toolbar, and the column headers."  I am wanting to add options in the mentioned Actions toolbar, but I don't seem to understand how to do so at this point.   Hopefully someone in this community can shed some light.  If I come across the answer, I'll be sure to update.

I have a webform that writes respondent info to a sql data base. I want to send a email campaign and use a unique identifier so that if 1. joe clicks on his link http://www.test1.aspx?209and 2. tim clicks on his link http://www.test1.aspx?603that when they click the form submit the data gets written into the correct row where 209 and 603 are their respondent numbers already in the data base.This is my first attempt using c# and I couldn't find anything in my books about it.ThanksBob