Bey Wang Bey Wang ASP.Net Site Home | Plan | Project | Source
Divider
Project > Dynamic CCIS Colloquium Web Page >
  User View | Editor(Two Layers) | Editor (Three Layers)

Project Name: CCIS Web Pages from Static to Dynamic with ASP.Net Technology

Purpose and Motivation:

Current CCIS web site is primary constructed with static HTML web page. However, some web pages are majorly used of information (data) display that takes lots of statc text content maintence work. With ASP.Net technology, the maintenance work can be shipted from Web Master to office administration staff. My primary goal is to implement ASP.Net dynamic web page technology in some CCIS web page that has primary purpose of information (data) display.

Project Highlights:

  • Practice and implement various ASP.Net Data Controls.

  • The problem of switching between selected item template with normal templage: lose focus. Users will be brought back to the top of the page when open/close a selected item with detail display, regardless which part of the page the user was previous viewing. To solve this problem, I embed a JavaScript in C# codea that will dynamically capture the client id for selected item (note that the items are populated from database) to maintain the focus at selected item. To test, try clicking 'Abstract & Bio' in Colloquium Demo page. Javascript is embeded in ~/Project/CCISColloquium/Default.aspx.cs. (available in source server)

  • First implementing two layers SqlDataSource Control. Heavily relying on sql queries.

  • Finally implementing three layers ObjectDataSource & SqlDataSource Control. Thanks to Professor Rasala s advice. With 3 layers data controls, binding data is populated and mostly manipulated in C# class and code behind. C# class is a lot more powerful than pure SQL queries in manipulating and formatting data. With the incrasing data manipulating flexibility, I then implement search feature so that users can select 'search column' as well as 'search keyword'. Colloquium Editor with 3 Layers Data Object Data Source.

  • Some of my tools:

  • C# Class for generating ObjectDataSource is named: ColqData.cs. Which can be viewed in my source server.
  • TimeTableMaker.aspx (edit time grid in code behind TimeTableMaker.aspx) will generate time table for time drop downlist. The display value if format to hh:mm tt format while the select data value is in int data type.

  • Future Work:

  • I would like to propose a dynamic solution for static CCIS Research Funding Opportunities page with user personalized display. Combine my practice of dynamic data column selection and ASP.Net WebPartZone to achieve this goal.

  • Enhance and clean up C# Class file for ObjectDataSource

  • Integrate ASP.Net Login control with Colloquium Editor page.
  • Helpful Sources:

     - Transact-SQL programming language

  • SQL Server 2000 is a place to start.
  • SQL Functions
  • SQL Date and Time Functions
  • Cast & Convert
  •  - Connection Strings

  • Having troubles getting connections? Connection Strings
  •  - C# Programming Reference

  • If you are new to C#, here is C# reference

  • Created by Bey Wang • beywang@ccs.neu.edu