Storing HTML in my MSSQL Database

yukscck — Thu, 28 Feb 2008 01:17:57 +0800

Hi, I'm a university student and currently developing a web-based system for my Final Year Project and I'm supposed to build an online mathematics learning system in C# with ASP.NET 2.0 technology (as provided by Ms Visual Studio 2005), with the MsSQL database system.

Well, basically what i am supposed to put up all the relevant learning materials up into my system. But to add more features, I've decided to enable the Admins to add/update the learning materials from time to time.
To do that, I've added a page for the Admin to add the materials, either by uploading the HTML into the server, or by manually keying into a HTML TextArea, then save it in the server.

The thing i'm concerned about is not how to perform this task. Instead, i'm more concerned about the system design issue here.
In my mind, i've come out with 2 possible methods in performing this task.
When the Admin uploads or keys in a new HTML file,

Method 1 - Create a new HTML file in one specific folder (namely Chapters) to store the HTML file, and at the same time, create a new record in my database (more specific, table Learning), where the column FileURL contains the URL to that HTML.

Method 2 - Store the entire HTML content (the entire HTML markup codes) into my database table Learning; Here, instead of having the column FileURL, i'll add a column Learning_Contents to store the HTML codes.

If i were to use Method 2, the column Learning_Contents will be of type VARCHAR, but i'm clueless of what will be the optimum capacity for it...

I'm here to seek advice and tips for such issue, as i wonder what is the standard method being used in other systems over the Net.
Thanks for the help in advance

[WTF] Visual C++ E-Book?

yukscck — Sat, 02 Dec 2006 12:14:24 +0800

Anyone knows where to get free Visual C++ 6.0 E-Books?

I hope i'm not reposting this... Thanks

spoolsv.exe as a malicious process?

yukscck — Thu, 30 Nov 2006 02:11:42 +0800

I was facing this problem before i reformatted my computer. This situation is a little weird, as none of the virus scanners were able to detect any malicious process.

But when i monitor the task manager, it shows that the process spoolsv.exe is eating up all my resources!! i understand that spoolsv.exe is some sort of printer related process but i didn't have any printing processes going on...

And as i ended the process, it popped up again after a few minutes, continue to hog my PC...

does anyone know what's going on??

Lowyat.NET: Latest topics by yukscck

Storing HTML in my MSSQL Database

[WTF] Visual C++ E-Book?

spoolsv.exe as a malicious process?