This project has moved and is read-only. For the latest updates, please go here.

SPD SQL Database Connection

Jun 3, 2010 at 10:45 AM
Edited Jun 3, 2010 at 12:15 PM

- Is there a possibility to use a Database Connection as "RelationshipList" in SPServices.SPCascadeDropdowns".  If so how ?

- I used a DVDropdownlist that makes a connection to a SQL Database Connection.

<SharePoint:DVDropDownList runat="server" id="ff11{$Pos}" selectedvalue="{@CHG_x0020_or_x0020_WP}" __designer:bind="{ddwrt:DataBind('u',concat('ff11',$Pos),'SelectedValue','SelectedIndexChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@CHG_x0020_or_x0020_WP')}" datasourceid="RemedyChanges" datatextfield="CHANGEID" datavaluefield="CHANGEID" />

Which field do I have to use in as ChildColumns

Jun 3, 2010 at 11:43 PM

SPCascadeDropdowns is built to work with the dropdowns as they are rendered by default in the forms. You're using a different control and a different type of DataSource, so it's not going to work.  The whole goal with SPCascadeDropdown is to take advantage of the SharePoint Web Services for this.

I'm not saying that you can't do this, just that this isn't the right starting point.