1 / 15

Training

Training. Learning to Build a User Control for use in DotNetNuke Module. Robin Lilly. Introduction . To build a UserControl that is usuable from DotNetNuke What will I learn? Creating a Stored Procedure How to build a User Control for DotNetNuke Use of Databound Control – Datagrid

ervin
Download Presentation

Training

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. Training Learning to Build a User Control for use in DotNetNuke Module Robin Lilly

  2. Introduction • To build a UserControl that is usuable from DotNetNuke • What will I learn? • Creating a Stored Procedure • How to build a User Control for DotNetNuke • Use of Databound Control – Datagrid • Database Interface to Stored Procedure

  3. Final Objective • Build this User Interface to HEAT database in ASP.NET

  4. Agenda • Build the Relevant SQL that will be executed. • Create interface to this SQL • A class with a method to allow separation of Database interface from the other Layers (n-tier) • Build page that has a Datagrid • Create User Control From that Page

  5. UnderstandingHeat Database

  6. Build Relevant SQL to Heat System • Identifiy fields we need

  7. DEMO SQL BUILD

  8. Create interface to SQL

  9. Create interface to this SQL • Create New Project • Add a Simple User Control • Add Control into DotNetNuke • Create Interface Class

  10. Demo Build Hello World Control • Create Hello World Control • Insert Sql Module into DotNetNuke Framework

  11. Demo HEAT control datagrid • Change HelloWorld to hook Database in. • Add Datagrid • Use default columns that are auto bound • Modify Datagrid properties to look nice. • Add Paging in.

  12. Demo 2 HEAT control datagrid • Remove AutoColumns • Add BoundColumns • Add Templated Column • Add Show Closed • Change procedure to allow show closed method

  13. Important Notes • When doing Paging with larger result sets. You would have the database handle the paging verses the control. • Many other controls • Templated columns are used quite frequently • To build more complicated things you must define a function to call from a column. • In DotNetNuke the call is easier than shown.

  14. Things You Learned • Created a Stored Procedure • Built a User Control for DotNetNuke • Learned use of Databound Control • Learned to build an interface to a stored procedure • Learned simple paging

  15. Where to Get More Information • GotDotNet.com – help files • ASP.Net • MSDN.Microsoft.com • ASPAlliance.com • Search Google.com

More Related