Get the most of SMS messaging in greeting for the New Year

Many of us will surely text many if not all of our friends, greeting them a happy new year. An SMS message will cost us P1.00. If we greet 100.00, we will be spending P100.00 (not counting those that are sent twice--network bug). Well this is the perfect time that we avail of those promos. What I will share is from Globe and Smart networks only.

For Smart subscribers, you may want to avail of the all-text promos:


P20 = 100 texts SMART to SMART / Talk 'N Text & 10 texts to other networks
Text AT20 to 2827
Promo runs until March 31, 2009. Per DTI-NCR Permit No. 5310, Series of 2008.


P40 = 200 texts SMART to SMART / Talk 'N Text & 20 texts to other networks
Text AT40 to 2827
Promo runs until March 31, 2009. Per DTI-NCR Permit No. 5347, Series of 2008.


P50 = 300 texts SMART to SMART / Talk 'N Text & 30 texts to other networks
Text AT50 to 2827

For Globe Subscribers


Registration Keywords








Registration Fee

P20 for 1 day

P20 for 1 day

P40 for 2 days

P80 for 4 days

P15 for 1 day

P30 for 2 days

P10 for 1 day

P20 for 2 days

Access Number 2870 2870 2870
Offer Unlimited Globe-to-Globe & Globe-to-TM (starting 5/23/08) Texting

Unlimited Globe-to-Globe & Globe-to-TM (starting 5/23/08) Texting from 8:00AM - 4:59PM

Unlimited Globe-to-Globe & Globe-to-TM (starting 5/23/08) Texting from 10:00PM - 7:59AM

Offer Duration Available until January 20, 2009 Available until January 20, 2009 Available until January 20, 2009
Coverage Globe to Globe & Globe-to-TM only

Globe to Globe & Globe-to-TM only

Globe to Globe & Globe-to-TM only

Maintaining Balance P1 P1 P1


FREE Text Reminders

Free text will apply only to other network

Free text will apply only to other network

Free text will apply only to other network

Limitation Not available while Roaming Not available while Roaming Not available while Roaming


Registration Keywords SULITXT 15 ETXT 20 TO 20
Registration Fee P15 for 1 day P20 for 1 day P20 for 1 day
Access Number 2868 2868 2868
Offer 100 Globe-to-Globe & Globe-to-TM (starting 5/23/08) Texts valid for 1 day for only P15 100 Globe-to-Globe & Globe-to-TM (starting 5/23/08) and 10 Globe-to-Other Networks Texts valid for 1 day for only P20 For only P20, Globe Prepaid and TM subscribers will be able to send 40 messages to other networks* for one whole day!
Offer Duration Available until January 20, 2009 Available until January 20, 2009 Promo Period: July 28 - January 20, 2009
Coverage Globe to Globe & Globe-to-TM only Globe to Globe & Globe-to-TM only/Globe to Other Network Globe and TM to Other Network
Maintaining Balance P1 P1 P1
Reminders Free text will apply only to other network
  • Activation of the service is within 24 hours from registration.

  • EverybodyTXT20 SMS will be consumed first before the free texts

  • *Other networks are Smart, Sun, Talk 'N Text & Addict Mobile.

  • A minimum load of P21 is required for registration

  • Activation of the service is within 30 minutes from registration. A confirmation message will be received upon activation

  • TXTOTHERS SMS will be consumed first before the free texts

Limitations Not Available while Roaming Not Available while Roaming Not Available while Roaming

Port Forwarding in Edimax BR-6204WLG wireless router

It's been a few days since I started using the Edimax BR-6204WLG wireless router. Features were great. I got the computers connected to the Internet with very less effort. I got my laptop connected wirelessly, and I got the security of the router tightened so that my neighbors won't be able to connect unless they had my permission. There was one problem though: PORT FORWARDING. I just can't get it to work. The setup was fairly simple. I specified the IP address of the local computer that serves as my web server, and specified port 80. I then tried to access it using the public ip address but I get a page load error: the server is taking too long to respond. I'm using Apache web server. I thought it was the firewall I had so I disabled it and tried to access the webserver again but with no luck. I then tried a different web server which was Microsoft's Internet Information Services (IIS). Dang! it still didn't work. I added this local ip to the router's demilitarized zone and hell it still didn't work. I know I'm missing something here because when I try to ping the public ip, the local ip responds. It's a good thing I got quite some time to figure this out.

Most influential leaders of technology

TechRepublic just posted the 10 most influential leaders in business technology in 2008.
Here is a summary:
10. Bill Gates, Microsoft
9. Mark Templeton, Citrix
8. Steve Jobs, Apple
7. Safra Catz, Oracle
6. Eric Schmidt, Google
5. Marc Benioff,
4. Anne Mulcahy, Xerox
3. Craig Barrett, Intel
2. John Chambers, Cisco
1. Mark Hurd, Hewlett-Packard

Passing SQL to Crystal Reports 10 using C# express and SQL Server 2005

Tools used in this example:
1. C# Express 2008
2. MS SQL Server Express 2005
3. Crystal Reports 10

I. Create the Report File
1. Click on File->New and select "As blank report" (The Database Expert wizard shows)
2. Expand the "Create New Connection" folder, and expand OLE DB (ADO). A window will appear.

3. On the Provider section, look for SQL Native Client. Select it and click Next.
4. On the Data Source combo box, type in the name of your server. (Mine is RIXX\SQLExpress)
5. Select the Integrated Security checkbox so that it uses your windows account for authentication.
6. Choose your database from the Database combo box and click finish. I have a database with the following attributes:
Name: TestDB1
Columns: Id, Description
Id Description
1 aaa
2 bbb
3 ccc
4 ddd
5 eee

7. Add your tables to the Selected Tables section and click Ok.
8. Drag the fields to the Details section of the report. Save your report. I used Report1.rpt.

II. Making the C# Project:
1. Create a new Windows application project.
2. Right click on the Toolbox and choose "Choose Items..."
3. Select the COM components tab.
4. Select the "Crystal ActiveX Report Viewer Control 10.0"
5. Click Ok. (The Crystal Report Viewer Control icon should now be visible on the toolbox.

6. Add a Crystal Report Viewer to the form.
7. Right Click on the Solutions Explorer and click Add Reference.
8. Click the Browse tab.
9. select the following location (or depending on where you installed your crystal report): "c:\Program Files\Common Files\Crystal Decisions\2.5\bin\" and select "CRAXDRT.dll"
10. Click Ok
11. Use the following lines of code when opening a report:

CRAXDRT.Report rpt = new CRAXDRT.Report();
CRAXDRT.Application app = new CRAXDRT.Application();
rpt = app.OpenReport("", null);
axCrystalActiveXReportViewer1.ReportSource = rpt;

12. the report viewer should then show the report you have created.

III. Passing SQL statements to the report.
1. Modify the code above into:
CRAXDRT.Report rpt = new CRAXDRT.Report();
CRAXDRT.Application app = new CRAXDRT.Application();
@"RIXX\SQLExpress", "TestDB1", "", "", null, @"Provider=SQLNCLI;Server=localhost;Database=TestDB1;Trusted_Connection=yes;"); //This is used for logging in to your SQL Server
rpt = app.OpenReport("d:\\report1.rpt", null);
rpt.SQLQueryString = "select * from TestTable1 where Id=4"; //instead of displaying all 5 records, I chose to display only the one with Id # 4.
axCrystalActiveXReportViewer1.ReportSource = rpt;

Create a Hello World application in C#

I assume that readers of this post are new to C# and have basic knowledge in programming and software application installation in Windows.

  1. Download the C# Integrated Development Environment (IDE) (You can download the free express version)
  2. After downloading the IDE, install it.
  3. The latest version of the C# IDE as of this writing is the C# express 2008 version.
  4. On the upper left corner, you can find a window-like box. Click on "Project..." next to the "Create" label. The following window will appear:
  5. the default project name is WindowsFormsApplication1. Change it to your desired project name.
  6. After clicking the Ok button, the following should appear:
  7. Program.cs is the main program file which calls the Form1.cs so that when you run the application, the form appears firsthand.
  8. On the Toolbox tab at the left side of the IDE, drag and drop a "Label" control to the form.
  9. The "Label" control has its own properties which can be accessed from the lower right portion of the IDE. Look for the property labeled with "Text" and change its value with "Hello World".
  10. Run the program by pressing F5. You now have created a Hello World application.

What's new in my online life?

Got invited by one of my students to Ciao.It's a community site that is intended for the world's consumers (various products). What's interesting is that the site pays for your reviews from computer peripherals to kitchen appliances buying guide. Not only do they pay for reviews, they also pay for the comments you put on other users' reviews. Cool right? Well, if you're asking if they really pay or not, I cannot answer that yet as I have only made $4.21 as of today. They only allow payment requests when you reach $5. It's just a matter of time before I reach that amount and I verify if they really pay or not. I will be posting the results here. As far as I've heard, the site is really legit. Well, you'll never know unless you try. If you decide to join, then add me up. My user name is fiShBoN3.

Crazy over the macbook cam

Just another dull moment. Decided to take some pictures and a video from my colleagues macbook.

Abort shutdown

Sometimes we encounter something like a dialog box popping out of our computer screen saying that our computer is shutting down and we didn't even initiate it. Sometimes it's a result of an updater, a trojan, or a remote shutdown. It can actually be aborted.

Just click Start->Run and type shutdown -a.

Simple Inheritance in PHP

In object-oriented programming, inheritance means that a new class can be derived from an existing class. The concept is easily implemented in object-oriented languages such as Java or C#. Inheritance can also be implemented in php. The method is quite straightforward: Use the extends keyword. The following example is a simple implementation of the concept:

In the following example, I have 3 files: Person.class, Student.class, and TestStudent.php. The Person.class has the following attributes: Last name, First name, and Middle name. It has one display method that returns an html code that displays the attributes of the person. The Student.class inherits the Person.class and also has its own attributes: Id, Year/Level, and Course. The TestStudent.php tests the Student class by asking for inputs of all six attributes using only the Student class and displays all of them in tabular form.


class Person{
var $LastName="";
var $FirstName="";
var $MiddleName="";

//Set/Get methods *********************************
function SetLastName($LastName){
$this->LastName = $LastName;
function GetLastName(){
return $this->LastName;

function SetFirstName($FirstName){
$this->FirstName = $FirstName;
function GetFirstName(){
return $this->FirstName;

function SetMiddleName($MiddleName){
$this->MiddleName = $MiddleName;
function GetMiddleName(){
return $this->MiddleName;

function DisplayPerson(){
"<table border=1 cellpadding=1>".
"<tr>"."<td>first name</td>"."<td>middle name</td>"."<td>last name</td></tr><tr>".
return $content;




Class Student extends Person{
var $Id;
var $YearLevel;
var $Course;

//Set/Get methods *********************************
function SetId($Id){
$this->Id = $Id;
function GetId(){
return $this->Id;

function SetYearLevel($YearLevel){
$this->YearLevel = $YearLevel;
function GetYearLevel(){
return $this->YearLevel;

function SetCourse($Course){
$this->Course = $Course;
function GetCourse(){
return $this->Course;

function DisplayStudent(){
$content = $this->DisplayPerson().
"<table border=1 cellpadding=1>".
"<tr>"."<td>Id</td>"."<td>Year Level</td>"."<td>Course</td></tr><tr>".
return $content;





<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "">


<title>Sans Titre</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta name="generator" content="HAPedit 3.1">
<body bgcolor="#FFFFFF">

<form name="myform" method="post" action="<?php echo $_SERVER["PHP_SELF"] ?>" >
<td>First Name:</td>
<td><input type="text" name="FirstName" /> </td>
<td>Middle Name:</td>
<td><input type="text" name="MiddleName" /></td>
<td>Last Name:</td>
<td><input type="text" name="LastName" /> </td>
<td><input type="text" name="Id" /></td>
<td><input type="text" name="Year" /></td>
<td><input type="text" name="Course" /></td>
<td> </td>
<td align="right"><input type="submit" name="Go" value="Go" /></td>
<br /> <br />

$s = new Student();

echo $s->DisplayStudent();



Using MS SQL Server express with C# express

I think I missed this one out. Many of us connect to Microsoft's SQL Server database using controls. I don't usually use this technique because it is quite limiting for me. Here's how to connect to MSSQL Server 2005 database using C#:

1. First, create a database (I'm using MS SQL Server 2005 express edition, so I use the SQL Server Management Studio IDE which can be downloaded here.)

2. To proceed, I'm assuming that you can already connect to your server (or the instance thereof). If the Windows Authentication doesn't work, you might want to try the user 'sa'. The password actually depends on what you specified during its installation.

3. Right click on the "Databases" folder and click "New Database".
(Just leave everything default and click ok).

4. Expand the newly created database folder (in my case, it's testDB1), and create a new table with the following attributes:
Table Name: TestTable1
Id:Integer, auto increment, pk
Description: varchar(50)

(I won't go on the details on creating this table).

5. Populate your table. Mine has the following data:
Id Description
1 aaa
2 bbb
3 ccc
4 ddd
5 eee

6. Now we go to the C# express IDE. I'll be using C# express 2008. (I named my project "ConnectToSQLServer").
7. Add a DataGridView control to the form.
8. Go to the code view of your form.
9. On the upper part of the code where you can find the "using" statements, add the following:
using System.Data.OleDb;

10. Add the following code to the constructor (modify the connection string to fit your setting. In my case, the SQL server is Rixx\SQLExpress. I'm using the trusted connection since I'm using Windows Authentication for my access level):
OleDbConnection cn = new OleDbConnection(@"Provider=SQLNCLI;Server=RIXX\SQLExpress;Database=testDB1;Trusted_Connection=yes;");
OleDbDataAdapter da = new OleDbDataAdapter("select * from testTable1", cn);
DataTable dt = new DataTable();
dataGridView1.DataSource = dt;

11. run the program. The data from your database should be shown.

The codes will look like this:

Mac's camera

It's kinda funny.


Apparently, I think this blog has become supplemental (or so I think). I think the algo is playing with me. geez. I need to read more. It's just been 72 hours and it dropped again. I'm waiting for the next crawl. It should go back up. Hmmm... hopefully by Nov. 25, 2008.

Page Rank Recovered

Two months ago, my page rank dropped to 2 from 3. Last month, it became N/A and I was shocked. I thought I did a violation that got me banned from Google. Well, some of my assumptions were wrong. I managed to recover my page rank back to PR 2. I hope I manage to get it back to PR 3 in time. I need to do something with a PR 3 blog hehehe. What I did was to redesign the blogsite and tried to optimize the tags, a lot of directory submissions, and most importantly, add content. There should be continuous updates with the blog. A CSS validator helps, so does the HTML validator. Various SEO tools also help. I use the WebCEO free version. Want to check the page rank of your site? Use the tool below:

Check Page Rank of any web site pages instantly:

This free page rank checking tool is powered by Page Rank Checker service

How to cheat blog polls

Ok, I really need to post this. Many bloggers put polls on their blog sites and rely heavily on the results that they give and some even draw conclusions based on those data. The problem is that they don't check where the data those polls are generating are stored. Many polls don't even record the voter's information. Well to those of you who want to cheat polls (I mean blog polls. Some polls are really reliable), here are some points:

1. These polls don't store your IP address nor your MAC address, how then do you think are they checking for flying voters? COOKIES!
2. Now you already have an idea. Now try to vote to a blogger's poll then clear your cookies and refresh the page. You'll be able to vote again.
3. If #2 doesn't work, there's a big chance that your voting data is stored on internet temporary files. Now you know what to do. Delete those files.
4. If #3 doesn't work, then your data might have been stored elsewhere. You might want to use a different PC.
5. If #4 doesn't work, try a proxyfier.
6. If #5 doesn't work, ask yourself this question: Why do I need to cheat the poll?

Using Firebird with

In my previous post, I was able to connect a firebird 2.0 database to using controls. The next goal was to connect to a firebird database using the engine and using the repeater control. I however, was able to use the engine to connect to the firebird database but not to the repeater control. I used the html table tag. I've created a simple demo displaying the contents of a firebird database on page load. Here are the steps:

1. Things Needed:
  • Firebird 2.0 Server
  • Firebird 2.0 Client
  • Visual Web Developer
2. In Visual Web Developer, create a new Website (using C# as the programming language). The project will have a default page named Default.aspx. Make sure that the code is separate from the page (ex. Default.aspx.cs is separate from Default.aspx)
3. On the Website menu, click on Add Reference.

4. Select the Firebird - 2.0 Data Provider and click Ok.
5. Add using FirebirdSql.Data.FirebirdClient; to the "using" section;
6. On the Solution Explorer, double click on Default.aspx.cs.

The following code should appear.

7. Paste the following in the Page_Load event:

FbConnection fbCn = new FbConnection("Database=;Server=localhost;User=SYSDBA;Password=masterkey;");
FbDataAdapter fbDa = new FbDataAdapter();
FbCommand fbCmd = new FbCommand();
DataTable dt = new DataTable();

fbCmd = new FbCommand("select * from \"TableName\"", fbCn);
fbDa = new FbDataAdapter(fbCmd);
this.GridView1.DataSource = dt;
this.Repeater1.DataSource = dt;
Response.Write("< r =" 1;" cellspacing =" 1;" cellpadding="1">");
for (int j = 0; j <>" + dt.Columns[j].ToString() + "< / t d >");
for (int i = 0; i <>");
for (int j = 0; j <>" + dt.Rows[i][j].ToString() + "< / t d >");
Response.Write("< / t r >");
Response.Write("< / t a b l e >");

8. The output of my database contains the following:

New Layout

I'm picking a new template. I don't think the previous layout was readable enough. I'm practicing on making things neat. I'm quite lazy with the designs hehehe.

My page rank dropped

Apparently, I still don't understand the world of SEO. My PR in this blog dropped from PR 3 to nothing and I still don't know the reason why. The only thing I can think of is that I did something that violated some terms with Google. Maybe this blog is banned. I think I submitted this blog more than thrice in Google's directory. I hope I can get it back. I'm not in the mood for link building right now. I still have to work on the contents. :D

Seminar on Open Source Applications at Brokenshire

Yesterday, we went to Brokenshire College of Davao for a seminar on Open Source Applications. I was accompanied by three senior students (only three because they didn't allow more than that). The seminar talked about Ubuntu Linux, Open, GIMP, and Blender. The funny thing is that it turned out to be one of my students' show as he (ragingmon) was popular with blender. :D

From Seminar on Open Source Applications October 23, 2008

From Seminar on Open Source Applications October 23, 2008

From Seminar on Open Source Applications October 23, 2008

From Seminar on Open Source Applications October 23, 2008 club and Davao Bloggers Networking Event

The event was fun. The food was free and I get to drink Gloria Jean's coffee. :D (More pictures when you click the photos. Photos courtesy of Mr. Raphael Banta)

From club and Davao Bloggers Networking Event

From club and Davao Bloggers Networking Event

From club and Davao Bloggers Networking Event

From club and Davao Bloggers Networking Event

Teaching Thinking Seminar

It was quite an interesting seminar. It's about teaching students to think. The speaker was from Singapore (I'm an idiot in remembering names sigh). Well, just wanted to share some pictures (Sorry for the low quality).

Seminar on Open Source Applications

there's a seminar on open source apps on Oct. 23 1-5 pm brok avr1. food and freebies on the house. with certificate. At most 3 students only.


I have used Comodo products before and I was glad because it's free. I used their AntiVirus and Firewall. The firewall worked good. It had all the minimum requirements I expected a firewall should have. The best part of it is that it's free! Well, I was quite disappointed with the antivirus. Although it worked fine in detecting viruses, it didn't work as effectively as the free AVG. The worst experience I had was when the antivirus caused some corruption in one of the windows system file. I removed both products. But then recently, I saw a very impressive improvement of Comodo. Although they aren't still at the top 10 antivirus softwares, it's good to know that major sites use one of their products for Internet security. Take for example the dotPh Philippine domain registry. They are using Comodo's Positive SSL for Trusted Internet. For a service provider to use it means high reliability. This gets me into considering Comodo back to my computers.
I'll be starting with the Firewall as I am not comfortable using the built-in Windows Firewall. Next on my list is their Anti-Malware. I currently use RRT but it's not the full edition and it keeps on showing their site whenever I close their GUI. Well, as for the anti-virus, I'm currently using Nod32 and will be testing Comodo slowly enough.

SMS Programming in C# Part 1

It's quite difficult to find resources regarding SMS programming with C#. Well, I have gathered through some other sites on how to program mobile phones (various models including Nokia N96). Before I write about C# (I'm using C# express 2008), let's have a look at the basics first. This first part will talk about connecting to your mobile phone and testing its connectivity.
  1. Be sure that you have your mobile phone driver installed.
  2. Connect your mobile phone
  3. To test the connectivity of the phone and whether it responds to our commands, let us try hyperterminal. In XP, Start->All Programs->Accessories->Communications->Hyperterminal.
  4. Specify the Name of the connection.
  5. Choose the Communications Port (Usually, the mobile phone will from Com1 to Com3. To know which port the mobile phone is assigned to, go to Control Panel->Phone and Modem Options->Modems. It will list down all the modems attached to your PC).
  6. Specify the Bits per second, Data bits, Parity, Stop bits, and Flow Control. You may leave the default values.
  7. type in "AT" (without the quotes) to test the connectivity of the device. If it responds with "OK" then you can communicate with your device. Mobile phones have built-in AT commands that we can use to manipulate different functionalities.
Various AT commands are available for testing. Google them up, and there are many sites that give info about each command.

A good phone to test will be Nokia N96. You'll be sure that it will have the minimum (well not only the minimum) requirements for your programming needs. The best Nokia N96 deals can be found over the web. Best deals are on October.

Software for Light

Various kinds of businesses exist over the years. Many survived with the use of simple technologies. Like in the Philippines, many have not automated their business processes and some are still reluctant in doing so. We are however, in the age of Technology, where almost everything is and will be depending on IT. The need for automation will arrive sooner or later, otherwise, your business gets left behind.

How do we choose the appropriate software for our business? Well it depends on the nature of our business. Let's take for our example.

Farreys offers both product and services. They sell chandeliers, home lighting, etc. They offer lighting fixtures like bathroom light fixtures, kitchen light fixtures, and ceiling light fixtures. When selling tangible products, we either need a Point Of Sale software (if it is a direct sale basis) or a Sales Order System software (if we allow order-basis). With regards to rendering services, a Service-Order System can be acquired. Many are quite familiar with the Point Of Sale (POS) systems. Let's discuss about Sales Order System, and Service Order System (or Job Order System):

A Sales Order System is a software application that we can use to manage orders and payments thereof for certain products. Briefly, the business process runs like this:
  1. Customer makes a Purchase Order to the store (e.g. Farreys)
  2. Store checks items on hand (if available or not) and prepares an Invoice (Charge Invoice) or Delivery Receipt.
  3. Store delivers ordered items to Customer and gives the Invoice and/or Delivery Receipt.
  4. The Customer now has Accounts Payable to the Store.
  5. Store awaits for payment from Customer (may depend on the Customer's agreed payment terms).
  6. Customer pays for the ordered items, and Store records the payments and subtracts the amount to the Customer's Accounts Payable.
Imagine automating the entire process and letting technology handle the recording, monitoring, and processing of these transactions. With the use of a Sales Order System, we don't have to worry about duplicate orders, unrecorded payments, and double invoicing.

As for the Job Order System, the process is similar. Instead of the customer ordering for an item, he/she requests for a service (repair, installation, etc.) Instead of the store delivering an item, it renders the ordered service and bills the customer accordingly.

What is Active Directory?

Active Directory is a directory service created by Microsoft (MSFT) that provides three services:
* LDAP-like Directory services
* Kerberos based authentication
* DNS based naming and other network information
It is an essential part of the Windows Server Family (including 2000, and 2003).
AD is used to store information about Windows-based Networks and Domains. It allows management of users, security, and other resources on a centralized location over the network.
It's not easy managing servers if you don't have a background on network administration. It's a good thing that the industry is already flooded with service-providers. Check out It's a good place to start for businesses who want quality implementation of Active Directory, Active Directory Management, Active Directory Tools, Exchange Management and Exchange Tool.

How do we install Active Directory on a Windows server? It comes with your Windows Server installation disk. It's relatively easy to install the service. Just follow the installation wizard specifying your network's requirements (Start->Run->dcpromo.exe). After installing the Active Directory Domain Service, the server computer becomes a domain controller. A detailed or step-by-step instructions on how to install Active Directory service on a Windows 2008 server can be found at: Install Active Directory Domain Services on the Windows Server 2008-Based Member Server.

Using MySQL with C# express

1. Download and install MySQL Connector ODBC at
2. Create a new Windows Application in C# express
3. Add the System.Data.Odbc namespace
4. Add a DataGridView
5. Use the following code to fill the DataGridView
OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDatabase; User=root;Password=;Option=3;");
OdbcCommand cmd = new OdbcCommand("Select * from test",cn);
OdbcDataAdapter ad = new OdbcDataAdapter(cmd);
DataTable dt = new DataTable();
dataGridView1.DataSource = dt;

The code should look like this:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;

namespace WindowsFormsApplication1
public partial class Form1 : Form
public Form1()
OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDatabase; User=root;Password=;Option=3;");
OdbcCommand cmd = new OdbcCommand("Select * from test",cn);
OdbcDataAdapter ad = new OdbcDataAdapter(cmd);
DataTable dt = new DataTable();
dataGridView1.DataSource = dt;

Philnits. Assume that a survey of 100 students was conducted.

Assume that a survey of 100 students was conducted. The result was that 18 students were learning Spanish, 40 students were learning German, and 42 students were learning French. Of them, six were learning both Spanish and German, fifteen were learning both German and French, and five were learning both French and Spanish. Of those who were learning two or more languages, two were learning three languages. How many students were not learning any language?

a) 22 b) 24 c) 26 d) 28

P(AUBUC) = 100
P(A) = 18
P(B) = 40
P(C) = 42
P(AUB) = 6
P(BUC) = 15
P(AUC) = 5
P(A∩B∩C) = 2
P(A∩B∩C) =100 – [P(A)+P(B)+P(C) – P(AUB)- P(BUC) - P(AUC) + P(A∩B∩C)]
= 100 – [18+40+42 – 6 – 15 – 5 + 2]
= 100 – [100 – 26 + 2]
= 100 – [76]
= 24

Employee profiling

Got this email from one of my MBA classmates. There is a certain degree of truth to this email, and I know, managers will be able to use this to become more effective leaders:

*Aries Employee Profile (march 21 - April 19) *

Aries employees make excellent troubleshooters. They'll usually want to be
out in the field at a variety of different work sites fixing things. They
certainly won't be happy for very long behind a desk in a 9 to 5 schedule.
The bored Aries employee who has been forced into a square hole will
typically be restless, angry, and careless with details. No amount of money
would compensate for being stuck in a routine job. Money in fact isn't why
they are working at all. They do want to be paid fairly and need a status
position to satisfy their competitive tendencies-- but even more
importantly, they'll want challenging new projects They typically like to
have a sense of responsibility and need to feel needed. In return, they'll
give their all and provide detailed, consistent work. They will literally
work themselves to exhaustion to prove themselves. If you want to keep your
Aries co- worker productive and happy, you'll want to give them the
opportunity to work independently or let them help and lead less experienced

*Taurus Employee Profile (April 20 - may 20) *

Taureans make some of the best employees. They are loyal, hardworking, and
no-nonsense. They work methodically and follow projects through until they
are complete. Some may appear to work a little too slowly-usually because
they are so careful-but they will always finish what they start. They thrive
on structure, schedules, and routine. You'll find them doing the same exact
thing at the same time every day. Taureans, however, are not exactly the
malleable workers that they often appear to be. If they have to work in a
chaotic environment, they won't be happy and will be prone to child-like
temper tantrums and stubbornness. They might react similarly if they have to
work around ignorant people or at a job where there is no obvious potential
for advancement. Taureans will be very unhappy if there isn't a ladder for
them to climb. Even in the worst situations, they will find a way to advance
slowly, winning over the most difficult people who may stand in their way of

Taurus employees will only take so much patiently and happily before they
feel they are being taken advantage of. They will gladly accept orders and
do whatever dirty work needs to get done, but they expect rewards. They want
material gain, salary increases, and the potential for more power. To make
your Taurus employees happy, be sure to give them projects through which
they will see tangible results- hopefully something that will allow them to
express their unique creativity in addition to their practical side. They
don't want to feel mired in details for long periods of time. Make sure to
schedule regular performance and salary reviews. This show of respect should
keep them loyal to the company.

*Gemini Employee Profile (may 21 - June 21) *

Gemini employees can have difficulty concentrating on one thing for long
periods of time. They have quick-moving minds and love to talk and
communicate their ideas with others. They thrive on social interaction --
even if their jobs don't particularly support it. They can be powerful
persuaders in their speech and make ideal salespeople and mediators. They
love to negotiate and can work out the best Deal for everyone involved. When
properly stimulated, they can manage to keep their wandering mind focused
and actually be quite productive. When they are bored, bogged down with
mundane detail-work, or forced to work with people who they consider droll,
they can become mean-spirited. Their moods can fluctuate vastly day to day,
as well as their productivity. It is really against their nature to be
forced into an average workday schedule and environment. They are happier
travelling. lf they are in an office they will need constant new
stimulation. Most will be wanting advancement if they see this as a way to
escape the limitations of their jobs. This can motivate them to put extra
effort into their job. If you work with a Gemini, try to avoid getting into
any debates with them they will surely win and it could end in some hard
feelings on your part. They will need an accepting environment- one that
supports their need for multitasking.

*Cancer Employee Profile (June 22 - July 21) *

The Cancer employee isn't at work to feed their ego -- their job is just a
job and a means to get paid. They work steadily and are usually very
reliable. You'll be able to depend on them to up on time and do what is
necessary. They won't get involved in power struggles or get upset when
someone advances before them. They are able to accept the situation because
they see it simply as a rung on the ladder up. Their motivation is security.
They'll want more money the longer they've stayed at a job. They don't want
to have to worry about how they'll make ends meet tomorrow so they'll need a
stable position without much risk. Cancerian workers can slip into some dark
moods on occasion. During these periods productivity tends to drop-as well
as everyone else's in the office. Their moods can be so strong everyone
becomes affected. To avoid the frequency of these occurrences, managers and
co-workers should try to make the work environment as homey as possible-keep
it well heated, cozy, and friendly. Don't press them to reveal their true
inner thoughts-their tendency is to be secretive and protective, and they
could see prying as an attempt to disturb their security.

*Leo Employee Profile (July " - august 21) *

Leo workers want to be first and at the centre of the office. Even if they
can't lead, they'll look for every opportunity to increase their own status
and if someone else seems ahead of them, look out. They will make it clear
that they aren't happy by pouting and complaining. They want advancement so
much that they'll take on more responsibility and carry a heavier load than
anyone else does in the office. And they are self-promoters. It is likely
that they are telling everyone in the office what a great job they are doing
as well as giving everyone unwanted advice. They know they are superior and
want everyone to know it as well. This arrogance can sometimes cause
problems when working with management. But typically, they are just hard
workers out to demonstrate just how good they really are. They thrive in
sales positions - they can promote a product or company just as well as they
promote themselves. Their strength and arrogance isn't just show either. In
a crisis situation, Leos really demonstrate their true courage. Leos want to
lead and will be pushing for more responsibility and rewards. They are happy
to train and mentor new co- workers as they enjoy giving advice and being in
positions of authority. If you are trying to manage a Leo employee, you'll
need to give them plenty of praise, responsibility, and independence. They
will certainly want to help lighten your load of management
responsibilities. Just be careful- the next thing you know they could be
taking over your job.

*Virgo Employee Profile (august 22 - September 22) *

* *In the right situations Virgos love to work. They make ideal employees,
happily working late into the night to make sure everything is perfect and
in order. If you are looking for an employee who doesn't mind starting from
rock bottom in the most entry-level position at the company, hire a Virgo.
They'll have no complaints about the position being beneath them. They are
CONTENT with basic, honest hard work. Their contentment isn't always
apparent, however.. They love to complain and worry. They are quick to
criticize the way things are done around the office and are the first ones
to grumble disapprovingly at what they consider to be extravagance or
laziness. They are blunt and honest and don't mince words over what they
feel just isn't right. Usually, this will be brought on by someone doing a
half-baked job or not being considerate of other co-work ers. You'll want to
constantly reassure them, but this will do little to quell their anxieties.
They actually enjoy worrying, and there is little you can do about it. Just
give them a detail - oriented project and let them work alone on it. You
won't have to supervise a Virgo worker. They'll check all the facts before
getting started and catch their own errors when they are done. To keep a
Virgo employee happy, you should also make sure their environment is orderly
and calm. You should also provide small gestures of appreciation. They don't
need extravagance, just let them know you appreciate them in small ways that
won't embarrass them. They will probably just shrug their shoulders and
say, "It's no big deal." But deep down inside they need these little

*Libra Employee Profile (September 23 - October 22) *

Libra employees are detailed, dedicated workers with sensitive natures.
Managers and co-workers sometimes find them difficult to get a handle on.
They pick up the energy of the office and are unable to prevent it from
affecting them. Loud noise, flashy colors, and discordant vibrations will
put them off so much that they will have difficulty fulfilling their
obligations at work. One day they may seem like the most bright,
hardworking, ambitious employee around. The next day they might be down,
irritated, and unable to produce. Co-workers shouldn't fret when Libra
employees are in a dark mood. It really won't last, as a happy state of mind
can come over them just as quickly. When Libra employees are in a balanced
frame of mind, they can be a powerful presence at work-they have a way of
gracing everything they touch. Underneath that mess of moods, they really
are basically happy and stable people. They are capable of profound logical
thought and evaluate all sides of a situation before acting. They are one of
the most intelligent Signs around. They are expert researchers and
mediators. And their sensitivity to their environment makes them naturals at
keeping things looking great. They will easily help others resolve conflicts
and can act as a go-between with workers and management so that everyone
ends up happy. If you want to keep your Libran worker smiling, give them the
respect they are due and put them in a position where they can project their
great charm and diplomacy. They won't be CONTENT to take orders for very
long, either- make sure they are given increased responsibility.

*Scorpio Employee Profile (October 23 - November 21) *

Scorpio employees usually exude a quiet self-confidence. They are
self-sufficient and do not depend on others for a sense of self-worth. They
keep their private life separate from work and take complete responsibility
for their actions and their situation. They don't make excuses; they just
take care of business and expect everyone else to do the same.. Those who
don't, co- workers and managers- will have to endure the Scorpio wrath. They
don't mind being completely vocal about what they feel is wrong with any
given situation. And if you tread on their fire be sure to expect
retaliation. They won't take insults or opposition lying down. If you manage
a Scorpio employee, be sure to follow through with your word and don't break
any promises-Scorpio is keeping track and building up some heavy resentments
against you if you do. You may not even be aware of it until too late-but
when Scorpio gets too m uch, you'll be sure to know. Scorpio employees will
react towards those around them exactly as they are treated. When they get
what they want, they will be very accepting. If you are trying to work with
or motivate a Scorpio co-worker, be sure to treat them respectfully and act
professionally. Give them challenging work that allows them to utilize their
awesome self-confidence and courage.

*Sagittarius Employee Profile (November 22 - December 21) *

The Sagittarian employee is head strong, cheerful, and willing to help.
They exude self-confidence and take on tasks like there's no tomorrow. They
are willing to tackle even the toughest of projects as long as it is
challenging and gets them out of the routine. Lucky for them, their shining
personalities and honest enthusiasm seem like a bright spot in the office-
otherwise co-workers might begin to build animosity towards someone so
arrogant and extravagant. Their tendency to exaggerate and take on more then
they can handle usually results in missed deadlines and dropping the
ball-not because they are lazy of procrastinate, but because their
enthusiasm just gets the better of them sometimes. Don't let their
nonchalance fool you-they really do care about what they are doing. They
just have an easy-going attitude that allows them to keep on smiling even
when they just messed up big time. Just because they are flexible and
easy-going doesn't mean they won't tell you exactly how they feel-what is
working for them and what isn't. And they won't just blindly take orders -
they need to understand the method and reason behind the process. If you are
trying to motivate your Sagittarian employee, be sure to feed them plenty of
challenging new projects and hint that some business trips might be on the
horizon once deadlines are met. And whatever you do, try not to question
their intentions - it is the quickest way to make them upset. They aren't
capable of deceit.

*Capricorn Employee Profile (December 22 - January 20)*

A Capricorn employee with too much to do is a happy worker. They need plenty
of projects and responsibility. There is no sadder sight than a Capricorn
worker without a sense of responsibility. They need to be needed. They are
covertly ambitious - usually not flashy or obvious about it-but you will
usually know that they are serious and determined about advancing
themselves. They are completely scrupulous, so much so that they can be
self-disparaging. But they are no pushovers. They can wear down even the
toughest customers. Their persistence is incredible. Once they set their
sights on a goal, they work away at it until the bitter end-whether the goal
be that hard sell or the new hardware release. Capricorns don't work for
free, however. They expect to be paid handsomely and be given more and more
responsibility. They need to come out ahead of the pack in the end, and they
see the work environment as their primary vehicle. They won't go in for the
typical office gossip and politics, though. They want to get down to
business at work and see it as no place for fooling around. With a strong
sense of duty and respect towards their superiors, it is rare they will join
in on boss-bashing or knocking the system. They can get frustrated, however,
with blue sky management schemes that lack common sense, and they will
interject their dry sense of humour in the most critical ways. If they want
change, they will be unyielding. If all their effort leads to naught the
result will be deep moods of darkness and depression with a sense of
hopelessness. . Keep your Capricorn employee happy by paying them fairly and
giving them plenty of hard work. Arrange for a path of advancement within
your organization for them. If you don't, you might find them looking for
other opportunities.

*Aquarius Employee Profile (January 21 - February 19) *

* *The Aquarius employee can't tolerate unfairness in the office. Hair
brained schemes will get the positive attention they deserve if an Aquarian
has anything to do with it. They'll try to help everyone see the good side
of a bad situation if it's the last thing that they do. They are so
smart-they can't help but hold management in disdain if they feel that they
are being unfair and unintelligent. It isn't that they are overly ambitious
and think they could be doing a better job- just that they think people in
power should know better. Most Aquarius workers are still looking for
themselves and will want to try their hand at a variety of jobs in the
workplace. Whatever they are doing, they will do conscientiously. They
usually have strict personal codes that include a strong work ethic.Their
bright, off-beat intelligence, and trustworthiness will typically gain them
many friends-in and out of work. Beneath that sometimes odd-ball behaviour
is solid, concrete thinking and sensitivity to co-workers. Keep your smart
Aquarius co-worker happy by giving them plenty of opportunity to learn news
kills. Raises are less important to them. No amount of money will make it
worth their while to stay in a stagnant position. Don't let them get too
bored or they will simply find another job as easily as they found this
one-their genius is easy to spot.

*Pisces Employee Profile (February 20 - march 20*)

The Pisces employee can be a loyal and hard-working, if unconventional,
worker. In the right position, they are able to keep their daydreams in
check and buckle down on the detail work-giving their all to the boss and
corporation whom they feel are worthy of devotion. On the flip side, there
is no image of extreme misery like that of an ill-placed Pisces worker.
They will act as though their cubicle were a prison cell as they daydream of
their own business or next vacation. Unhappy Pisces workers usually won't
stick around too long. Often Pisceans will drift from one job to another
looking for that ideal environment to which they will be able to commit and
feel a sense of purpose. And if things are going in a bad direction at the
office, Pisces will be the first to sense it. They'd rather pick up and
leave then wait until the problem reaches a head. Pisces are often
misunderstood by their co-workers. Typically timid and introspective, they
usually keep their true nature hidden, for fear it wouldn't fit with the
corporate culture. What motivates a Pisces employee to not only stick around
but also excel? Try compliments. And show them how their work impacts the
entire organization. They need to know that what they are doing is worth
something on a grander scale. Acceptance of their unconventional
organization and planning will be necessary. Just because their sales report
isn't in the typical format doesn't mean it is any less effective. Keep
their environment bright and upbeat; and an after-work cocktail wouldn't

Web hosting and Domain Name

What is a Web host? What's the difference between Web hosting and Domain name? Oftentimes we encounter websites that advertise their web hosting services. When we avail of their services, do we have our own website (ex.

Web host is a business entity that provides web hosting services.
Web hosting is providing an online storage for data and information (text, images, videos, etc.).
Domain Name is an address in the Internet which takes an alphabetical form (we can also refer to it as the alphabetical form for the IP Address).

Companies invest on server computers with large amounts of storage to be able to provide space for those who want to have a website but don't have the resources to "host" it from their location or office. These servers will have their IP Address which takes on the form of ###.###.###.### all of which are numeric (ex.
Before we avail of a company's web hosting services, it is good to at least know these terms because there are a lot of sales talk going on over the web. It is also good to read reviews about web hosting companies. It's also good to look for best budget hosting.

Firebird Database in

Today, I successfully connected to a Firebird Database in I was disappointed though because I did it using controls. I'm still trying to connect through hard code but was unsuccessful. The data just won't show. I know I did something wrong... still trying to find out what. I'll post it here when I'm done. I'm using Microsoft Visual Web Developer 2005 Express Edition.

Connect to a firebird database using the firebird .net engine and using a repeater.

Goal successfully done. See Using Firebird with

Number to Text in Excel

I was asked today by one of my classmates about converting numeric values to literal values in excel. I thought there was a function for this but I found none. Well I was curious so I looked it up on the web. I've done a little modification here to make it more or less generic (specially when writing in checks). Here's how it's done:
  1. Click Tools->Macro->Visual Basic Editor
  2. Insert a module
  3. Paste the following code:
Option Explicit
' Main Function *

Function SpellNumber(ByVal MyNumber)
Dim Temp, WholeNumberText, DecimalText
Dim DecimalPlace, Count

ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
Place(4) = " Billion "
Place(5) = " Trillion "

' String representation of amount.
MyNumber = Trim(Str(MyNumber))

' Position of decimal place 0 if none.
DecimalPlace = InStr(MyNumber, ".")
' Convert cents and set MyNumber to dollar amount.
If DecimalPlace > 0 Then
DecimalText = Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If

Count = 1
Do While MyNumber <> ""
Temp = GetHundreds(Right(MyNumber, 3))
If Temp <> "" Then
WholeNumberText = Temp & Place(Count) & WholeNumberText
End If
If Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
MyNumber = ""
End If
Count = Count + 1

Select Case DecimalText
Case ""
DecimalText = " and 0/100"
Case Else
DecimalText = " and " & DecimalText & "/100"

End Select
SpellNumber = WholeNumberText & DecimalText
End Function

' Converts a number from 100-999 into text *
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right("000" & MyNumber, 3)
' Convert the hundreds place.
If Mid(MyNumber, 1, 1) <> "0" Then
Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
End If
' Convert the tens and ones place.
If Mid(MyNumber, 2, 1) <> "0" Then
Result = Result & GetTens(Mid(MyNumber, 2))
Result = Result & GetDigit(Mid(MyNumber, 3))
End If

GetHundreds = Result
End Function

' Converts a number from 10 to 99 into text. *

Function GetTens(TensText)
Dim Result As String

Result = "" ' Null out the temporary function value.
If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19...
Select Case Val(TensText)
Case 10: Result = "Ten"
Case 11: Result = "Eleven"
Case 12: Result = "Twelve"
Case 13: Result = "Thirteen"
Case 14: Result = "Fourteen"
Case 15: Result = "Fifteen"
Case 16: Result = "Sixteen"
Case 17: Result = "Seventeen"
Case 18: Result = "Eighteen"
Case 19: Result = "Nineteen"
Case Else
End Select
Else ' If value between 20-99...
Select Case Val(Left(TensText, 1))
Case 2: Result = "Twenty "
Case 3: Result = "Thirty "
Case 4: Result = "Forty "
Case 5: Result = "Fifty "
Case 6: Result = "Sixty "
Case 7: Result = "Seventy "
Case 8: Result = "Eighty "
Case 9: Result = "Ninety "
Case Else
End Select
Result = Result & GetDigit(Right(TensText, 1)) ' Retrieve ones place.
End If
GetTens = Result
End Function

' Converts a number from 1 to 9 into text. *

Function GetDigit(Digit)
Select Case Val(Digit)
Case 1: GetDigit = "One"
Case 2: GetDigit = "Two"
Case 3: GetDigit = "Three"
Case 4: GetDigit = "Four"
Case 5: GetDigit = "Five"
Case 6: GetDigit = "Six"
Case 7: GetDigit = "Seven"
Case 8: GetDigit = "Eight"
Case 9: GetDigit = "Nine"
Case Else: GetDigit = ""
End Select
End Function

4. Close and return to excel
5. To use the macro, write the following on the cell to which you want to display the text version of your numeric value: =SpellNumber()
refers to the cell where your number value is written.

Blog Archive