1 / 41

Using SPD and SQL Stored Procedures

Using SPD and SQL Stored Procedures. Patrick Curran, MCT. August 12, 2011. Patrick Curran. MCT, MCITP , MCTS , MCP SharePoint Architect for Planet Technologies. Working with SharePoint since 2003. Administrator / Developer Architect / Implementer Troubleshooting / Branding

olympe
Download Presentation

Using SPD and SQL Stored Procedures

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using SPD and SQL Stored Procedures Patrick Curran, MCT August 12, 2011

  2. Patrick Curran • MCT, MCITP, MCTS, MCP • SharePoint Architect for Planet Technologies. • Working with SharePoint since 2003. • Administrator / Developer • Architect / Implementer • Troubleshooting / Branding • Motto: Why code when SharePoint will do it OTB PCfromDC.blogspot.com @PCfromDC

  3. Review the SQL Tables and Stored Procedure. • Use SharePoint Designer 2010 to create a page, and add content. • Use SharePoint Designer 2010 create a database connection (Demo). • Insert a Data Source, add a GridView control and attach the data source to the GridView. • Clean up the Grid, and verify page (Demo).

  4. Objective • Pass In and Out dates to a SQL stored procedure, review a list of free resources, then send selected resource an email. Let’s get started!

  5. Quick Review of SQL… Let’s take a look at the databases.

  6. Quick Review of SQL… Our resources, roles, and email addresses:

  7. Quick Review of SQL… The resource’s current schedule:

  8. Quick Review of SQL… The stored procedure:

  9. Let’s Get Started… Let’s open up Designer and create a page to hold our information. 1- Open your site. 2- Select Master Pages. 3- Select the v4.master 4- Right click and select New from Master Page.

  10. Create A Page… 1- Save Page. I hope these guys stop looking over my shoulder soon. 2- Ignore warning and click Yes

  11. Create A Page… 1- Within the PlaceHolderMain, select the Common Content Tasks. 2- Click Create Custom Content

  12. Organize Content… 1- Click inside of the PlaceHolderMain. 2- Insert a 2x4 Table.

  13. Insert Calendars… 1- Find the 1st column, 2nd row cell of the table. 2- Drag a Calendar control into the cell. 3- Drag another Calendar control into the 2nd column, 2nd row cell.

  14. Insert Calendars… Should look something like this:

  15. Rename The Calendars… 1- Rename Calendar1 to “indate” 2- Rename Calendar2 to “enddate”

  16. Create the Data Source… 1- Click Data Sources 2- Add a Database Connection.

  17. Create the Data Source… 1 2

  18. Create the Data Source… 3 4

  19. Create the Data Source… 5 6

  20. Create the Data Source… Connection Created!

  21. Create More Content… Insert our new Data Source!

  22. Configure Data Source…

  23. Configure Data Source… 1 2

  24. Configure Data Source… 3 4

  25. Configure Data Source… 5 6

  26. Configure Data Source… 7 8

  27. Configure Data Source… 9

  28. Configure GridView… Let’s merge the 3rd row of cells. Can you believe the cat is actually playing the piano? 2- Ignore warning and click Yes

  29. Configure GridView… Grab the GridView data control and drag it into the 3rd row of our table.

  30. Configure GridView… Select the appropriate Data Source

  31. Configure GridView… Our SQL stored procedure columns!

  32. Our GridView .aspx

  33. Tweak Our GridView… Enable Paging and Sorting Paging Sorting

  34. Tweak Our GridView… 1- Edit GridView Columns 2- Remove Resource_ID Field

  35. Tweak Our GridView… 3- Clean up Header Text 4- Hide email_address field

  36. Tweak Our GridView… Since we want Resource_Full_Name to be a Hyperlink for email, we must convert it to a Template Field.

  37. Our Tweaked GridView .aspx

  38. Our Tweaked GridView .aspx Now we can email!

  39. Tweak The Table…

  40. Tweak The Table…

  41. Thank You!!! Email: pcurran@go-planet.com Blog: PCfromDC.blogspot.com Twitter: @PCfromDC

More Related