Category: SQL

• How To Make A SharePoint List System.String Column (Built From An BCS External Content Type List) Into A Clickable Hyperlink

  12/17/2015

  +

  +

  +

  +

  +

  +

  So for this example I have a SQL database that I am pulling into an external content type called OfficeLocations. From this external content type I have created a SharePoint list that is referencing it. The issue I ran into is that the GoogleMapLink text coming from SQL was in…

  +

  +

  +

  +

  +

  +

  + BCS, SharePoint, SQL, XML

  + BCS, External Content Type, Link, List, SharePoint, web part, xml, XSL

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +

• Execute An Oracle Stored Procedure With Parameters (C#)

  06/01/2015

  +

  +

  +

  +

  +

  +

  So you want to execute an Oracle stored procedure with parameters, huh? For this example I have an Oracle stored procedure called MEMBER_TYPE_UPDATE that will update what type of membership I have based on the numeric value. This sort of snippet can be used in a web application directly or called by…

  +

  +

  +

  +

  +

  +

  + C#, Oracle, Programming, SQL

  + C#, membership, oracle, parameter, SQL, stored procedure

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +

• Programmatically update the manager field from a SQL table for sharepoint user profile

  05/29/2015

  +

  +

  +

  +

  +

  +

  Oh, what a journey this was. Googling, reading, BCS this, BCS that, you can do it, you can’t do it, then a somewhat vague article that almost explained it (but not quite of course). As you may or may not know, updating the manager field in user profile is a pain. You…

  +

  +

  +

  +

  +

  +

  + C#, Email, Programming, SharePoint, SQL

  + C#, Email, SharePoint, SQL, user profile

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +

  +