This article presents to you a small web based tool, to edit and manage news information (for your colleagues). It uses RSS to provide news, so you can use RSS-Readers to collect news. Some simple web front-ends are included for IUD, configuration and to show news.
The Code Project article, "8 tips to make you more efficient as an ASP.NET developer" from Paul Heap has inspired me, to write this little tool. This tool helps to provide some development news to each developer in our company.
The RSSNewsFlash-Project supports some news categories too (configured in database, see below). In this connection, I would like to mention that I assume a database from MS SQL Server. The access to the database is using ODBC with SQL Server Authorization and the script to create the tables may include some SQL Server specific syntax or data types. To modify, read the information in the table below.
My solution should be small and nice. Therefore, I haven't implemented a very colorized and professional user interface and big database design. It's only a working beginning.
- Unzip the package to Inetpub\wwwroot.
- Add a new virtual directory in IIS called RSSNewsFlash pointed to the install dir.
- Add a new standard document in settings of the virtual directory: AddNews.aspx.
- Execute the script in CreateScript.sql included in the package on an SQL Server database.
- Create an ODBC entry to the SQL Server database (Important: SQL Server Authorization !!!).
- Modify some settings in web.config
DSN: The DSN of the created ODBC entry.
PhysicalUser: User for database login.
PhysicalPassword: Password for database login.
URL: URL of created virtual directory on ISS.
- All other keys which configure some information in the RSS-Stream.
- Now you are ready to use and open AddNews.aspx.
- Via link "Download RSS News Reader" at the bottom left of the page, you can install a freeware RSS-Reader.
- To configure the Reader to use your own RSSNewsFlash, click the link "Setup the RSS News Reader" at the bottom of the page.
- If you want to use another RSS tool, you need only the link present in the page "Setup the RSS News Reader".
Here comes some hints to expand the feature list or modify the project for your own requirements.
- If you want to use another database server, you must modify the creation script and source code. Problem areas can be the
- If you need an access to the database in a different way (not ODBC with SQL Server Authorization), you should modify the code for database connection in AddNews.aspx.vb, ShowNews.aspx.vb and RSS.aspx.vb.
- For using the categories as Filter in the RSS-Reader, you should modify the source in RSS.aspx.vb. Here you can insert a
URL parameter (i.e. "cat") to prepare the
select statement. You add this parameter in the URL calling from the RSS-Reader.
The tables and the pages
||Stores all news.|
||Stores all possible authors.|
||Stores all possible categories.|
||Stored information, which client has asked for the latest news and timestamp.|
||Adds and modifies a news. Optional |
URL parameter "
newsid" is pointed to "
rss_newsflash.temp_refid" and determines if there is a news to create or modify.
||Shows a help page to configure the Freeware RSS Reader.|
||Presents a news. Called from RSS-Reader. |
URL parameter "
newsid" is pointed to "
||Generate the RSS-Stream. Normally only called from RSS-Reader.|
This is the help page to configure the freeware RSS-Reader. The page is dynamically generated to show the correct URL.
The page where you enter a new news and/or modify/delete. This page can be accessed directly via http://yourhost/RSSNewsFlash/AddNews.aspx.
An overview in the RSS-Reader.
News are present in a simple web page with Link buttons to modify or add news and navigate previous/next.
I started 1987 when I was about 14 years old, with Basic and Pascal on 8Bit Atari with insanely 130KB of memory, later 16Bit Atari (4Megs). In study I learn C, C++, Modula-2, Assembler and other science languages (Prolog, ADA). I hold a german engineer's degree Dipl.-Ing. (FH) in "Technical Computer Science" from the University of Applied Sciences Mittweida, Germany (comparable with a Master Degree).
My main tasks are specify and write down solutions of problems and implement the first code snippets.
In my spare time I like to drive a (fast) motocycle, read many science fiction and fantasy books and I'm a enthusiastically shotokan karate fighter. In winter I falling down from hill with alpin ski on foots, because snowboards are only for drug sniffers