Connecting .NET application to a MySQL Database is as easy as 123

By Aurelie A. Peralta

I have a website client that commissioned me to create a website with some portions of it are active server pages that uses a database to display vital informations for its users. I developed the website using ASP.NET technology but immediately after showing him the homepage design of his website, told me to use MySQL for the database. Although it is not the popular choice for an ASP.NET application database, he opted to use MySQL probably because of its low cost in terms of hosting fees. Besides, there is no great deal in granting his request because in .NET, connecting to a MySQL database is as easy as 123. (more…)

Always backup your database..OK!

By Aurelie A. Peralta

I have already deployed two ASP.NET content management systems, the PSU Eastern Cluster Community Server (http://202.91.163.10/cs) and the Pangasinan State University Official Website (http://www.psu.edu.ph). Both websites uses Microsoft SQL Server, version 2000 for the Eastern Cluster Site and 2005 Express for the PSU Official Site. The Eastern Cluster Site’s database is working well since November 2006 and have not encountered any errors as of now. With the number of postings in the site, its database actually is a large one now. (more…)