Creating a Log Visit Report

oops.. today I’d decided to post a new article but surprisingly noticed that the blog was suspended! Thanks to Matt, it is alive and kicking now! Anyway, lets see how we can generate a log visit report for our ASP.NET web site. By the term of Log Visit, I mean the statistics of a website [...]

Read Full Post »

Reading and writing images from/to database

Hi, This post will show you how to save/load images to/from a database. This approach lets you do it without having to save the image on to disk. On a real hosting computer, you probably will not have write permissions. Therefore, it is sometimes vital to do image saving/loading on the fly. In this post [...]

Read Full Post »

Implementing a 3-Tier architecture with C# – Part 5

Hi back, In this post we will finalize the implementation of our 3-tier asp.net architecture, by developing a Web-based presentation layer. So far, we have developed the data access and business layers. The implementation of UI, consists of methods and approaches for handling business and crud operations thorough a Web UI. In fact, there are [...]

Read Full Post »

Implementing a 3-Tier architecture with C# – Part 4

Up to now, we have finished implementing the data access layer. However, we can reduce the dependency between the deriver DAL classes and Web.config file. As you remember, we have specified the DB provider name in Web.config file so that DAL classes must have access to this file to read the provider name. Another method [...]

Read Full Post »

Implementing a 3-Tier architecture with C# – Part 3

The Fill method we have developed so far, executes the Select command on the underlaying server and picks up RowCount records from startRowIndex position. For example, if Select * from Person returnS 20 rows, and startRowIndex is 0, only the first RowCount records will be fetched. This means that the complete result set will be [...]

Read Full Post »

Implementing a 3-Tier architecture with C# – Part 2

Hi again, Let’s keep on going and work on the Data Access Layer. The DAL layer we are going to design can be used with, theoretically, any sort of RDBMS because it will take advantage of ADO.NET generic classes. For this reason, I have written a base class for DAL classes and have placed in [...]

Read Full Post »

Implementing a 3-Tier architecture with C# – Part 1

Hi again, Nearly two years a go I probed Internet to find out a good reference architecture for my ASP.NET applications. What I meant GOOD ARCHITECTURE was an architecture that: IS FAIRLY SIMPLE IS BASED ON N-TIED ARCHITECTURE IS PRODUCTIVE IS EASY TO IMPLEMENT DOES NOT NEED A NY 3rd PARTY CLASSES (I.E. NHIBERNATE) CAN [...]

Read Full Post »

A practical use of Serialization and Extension methods in C# 3.0

\Recently, reviewing a colleague’s design diagrams, I noticed that in order to keep the history of changes of a particular field, he had created a small table in SQL Server! For example, in a contract management program, we are asked to keep track of changes in Due Date and Contract Payments. A primitive way for [...]

Read Full Post »

Exporting a DataTable to Excel

In many cases Microsoft Excel can do much for you and reduce your programming efforts. For example, if you must provide a printable version of a data collection or you need to provide a report with grouping, you may send all information to Excel and let the end-user do it with Excel. Therefore, knowing how [...]

Read Full Post »

DataTable.Compute method is lovely…

For some reasons I do like to use DataSets (and Datatables) rather than DataReaders or other sort of IList collections to hold a list of records. Especially, typed DataSets are very helpful and am intended to write some articles about exploiting them later in this weblog. For example we can fill DataTables’s data/metadata by retrieving [...]

Read Full Post »