October XMod Pro User Group, 2014
It's October and Fall is in the air! We are excited to have our next free XMod Pro online user group meeting October 23rd. Learn more about and discuss XMod Pro with other users.
Kelly Ford talked about working with Databases, SQL Server Management Studio - How to setup a Table, Stored Procedure, and setting up Index. Patrick Ryan demonstrate differences between Using traditional XMP method of using ControlDataSources populating DropDown Lists (DDLs) and another DDL vs. using Feeds and jQuery without a page post back. Patrick also talks about his new online book project “Discover XMod Pro”.
Here's the timeline for this months XMod Pro online User Group:
00:00 Welcome/Intro
02:00 Kelly Ford - Introduction
04:30 Kelly Ford - Will talk about working with Databases, SQL Server Management Studio - How to setup a Table, Stored Procedure, and setting up an Index.
05:11 - Download Microsoft SQL Server 2014 Express - http://msdn.microsoft.com/en-us/evalc...
06:30 - SQL Server Management Studio Databases demo: Tables, Views (precompiled Queries), Programmability (Stored Procedures, Functions)
09:50 - Tables
16:10 - Set up an Index in a Table, for better performance
20:30 - Manually Edit a Table
23:00 - Create a Query
24:30 - Create a Stored Procedure
30:25 - Patrick Ryan: Demonstrate differences between Using traditional XMP method of using ControlDataSources populating ddls and another ddl vs. using Feeds and jQuery without a page postback
33:30 - Using a ControlDataSources to populating a DDL and another DDL (includes page refresh) - Traditional method
37:45 - DropDowns using Feeds and jQuery (jQueryReady tag)
42:30 - the Feed (don’t forget about security)
45:15 - More about the Feed - DataType: use a numeric value if it’s going to be passed into the public - best practice against SQL injection attacks.
48:45 - Patrick’s New online book project - Discover XMod Pro