Archive for the ‘SQL & Databases’ Category


From LINQ To JSON

Friday, June 19th, 2009

This is a quick note on how to convert your LINQ Objects to JSON String. I had some issues doing so when only using the LINQ Class but did a quick fix by creating my own class and setting it up with the same information as the LINQ Object.

(more…)

SQL Stored Procedures with C#

Tuesday, December 30th, 2008

storedprocedures image

Many real-world applications interacting with the SQL server use stored procedures, which are compiled by the database in advanced of execution which offer better performance over normal SQL statements, which are compiled when called.

They are secure, because it only needs to make calls to the database and use its stored procedures, rather than having some malicious user use your connection and could delete data. Stored Procedures can also take data input via parameters.

I’m a big fan of Stored Procedures, it just makes it allot easier for me to code between my C# classes to SQL separately.

(more…)

Dynamic Database Connection With C#

Wednesday, October 8th, 2008



Very important note on how to connect to a SQL Database in Visual Studio 2008. The first interesting steps here is that, we can use C# classes to connect to our database and get data to and from it, via the class to our website.

(more…)

Java + Oracle SQL Connection

Monday, June 16th, 2008

Working forward with connecting Oracle database with java and viewing the content. This is just basic connection.

(more…)

SQL: BABY STEPS

Friday, February 1st, 2008

Make a simple database, Im using MAMP, its great. Get it from here.

The abbreviation MAMP stands for: Macintosh, Apache, Mysql and PHP. With just a few mouse-clicks, you can install Apache, PHP and MySQL for Mac OS X!

MAMP installs a local server environment in a matter of seconds on your Mac OS X computer, be it PowerBook or iMac. Like similar packages from the Windows- and Linux-world, MAMP comes free of charge.

Im going to add very simple sql “asking” “methods”. in the future, I will add notes on how to connect Flash, PHP and JAVA to the MYSQL Tables.

(more…)