Ranga Fernando's Web Log

Loop through Enums in C#

2008-11-10T00:44:00.000-08:00

option 01
public enum myEnum
{
Enum01= 1,
Enum02= 2,
Enum03= 3
};

foreach (typeof(myEnum) item in myEnum)
{
ddl.Items.Add(item.null,eventhandler)
}

option 02
if you want to bind DropDownList to Enum
then this is what you need

myDropDownList.DataSource = Enum.GetNames( typeof( MyEnum ) );
myDropDownList.DataBind();

or like that

foreach (string item in Enum.GetNames(typeof(MyEnum)))
{
int value = (int) Enum.Parse( typeof(MyEnum), item );
ListItem listItem = new ListItem( item, value.ToString() );
ddl1.Items.Add( listItem );
}

option 03
foreach ( string s in Enum.GetNames(typeof(MyEnum)) )
{
whatever.add(s);
}

More on:
http://msdn2.microsoft.com/en-us/library/system.enum(VS.71).aspx

How do I… Uninstall Microsoft Internet Explorer 7?

2008-05-08T03:32:00.000-07:00

How do I… Uninstall Microsoft Internet Explorer 7?

http://blogs.techrepublic.com.com/window-on-windows/?p=680

SELECT/DropDown Box Free Layer

2008-04-30T01:31:00.000-07:00

Select /dropdown box overlapping with your div tags ?
Solution with CSS.
http://www.hedgerwow.com/360/bugs/css-select-free.html

Solution with JavaScript
http://xlib.wordpress.com/2006/04/12/bug-fix-select-box-displayed-through-dynamic-div-in-internet-explorer/

Give me a break

2007-12-17T22:51:00.001-08:00

I got this nice/funny/interesting mail from one of my best friends Ramesh!

Thought of share this interesting mail with others.

MY Dear ON-LINE FRIENDS,

I want to thank all my friends and other unknown people who have forwarded chain letters to me in 2003, 2004, 2005, 2006, 2007 & YOU because of your kindness.

I stopped drinking Coca-Cola after I found out that it's good only for removing toilet stains.

I stopped going to the movies for fear of sitting on a needle infected with AIDS.

I stopped using my ATM card because I am afraid that someone might have installed a small device on the ATM machine that will stole my ATM card number and my pin number when typing it.

I smell like a wet dog since I stopped using deodorants because they cause cancer.

I don't leave my car in the parking lot or any other place and sometimes I even have to walk about 7 blocks for fear that someone will drug me with a perfume sample and try to rob me.

I also stopped answering the phone for fear that they may ask me to dial a stupid number and then I get a phone bill from hell with calls to Uganda, Singapore and Tokyo.

I also stopped drinking anything out of a can for fear that I will get sick from the rat faeces and urine.

When I go to parties, I don't look at any girl, no matter how hot she is, for fear that she will take me to a hotel, drug me, then take my kidneys and leave me taking a nap in a bathtub full of ice.

I also donated all my savings to the Amy Bruce account. A sick girl that was about to die in the hospital about 7,000 times. (Poor girl! she's been 7 since 1993...)

I went bankrupt from bounced checks that I made, expecting the $15,000 that Microsoft and AOL were supposed to send me (when I participated in their special-mail program) would arrive soon.

My free Nokia phone never arrived and neither did the free passes for a paid vacation to Disneyland.

Still open to help someone from Bulgaria who wants to use my account to transfer his uncle's property of some hundred millions $.

Made some Hundred wishes before forwarding those Dalai Lama, most of those "Wishes" are already married (to someone else)

IMPORTANT NOTE: If you do not send this e-mail to at least 913760 people in the next 10 seconds, a bird will sh*t on your head today at 04.00 p.m.

Now give me a break !!!

MSSQL Select Top 10 and Next 10 (fwd ...n)

2007-12-17T21:38:00.001-08:00

The following query will emulate a

SELECT emp_id,lname,fname FROM employee LIMIT 20,10

That says, give me 10 records starting at record 21. So what will be
returned are rows 21-30. This is used heavily in web-based apps so you can
do recordset paging.

Here is what you can do in MS SQL to emulate it (this runs on the PUBS
db):

select * from (
select top 10 emp_id,lname,fname from (
select top 30 emp_id,lname,fname
from employee
order by lname asc
) as newtbl order by lname desc
) as newtbl2 order by lname asc

The main thing to remember is to deal with all your ORDER BY clauses and
also to use the inner TOP as the sum of what you are looking for. In this
example - 30 since you start at 20 and want 10 rows (20+10=30).

Hope this helps you as it has helped me improve performance greatly on my
web-based apps since I no longer have to transfer loads of data across the
wire to get just the 10 results I display on a page.

Don't even think about using the internal ADO paging stuff if you have a
lot of records to deal with, it will kill your performance as it must pull
the entire recordset down to the local machine before it can do its work.
Why bring down 20,000 records if you only want to display 10?

6 Truths of Life.

2007-12-12T23:20:00.001-08:00

1.  You cannot touch all your teeth with your tongue.
2.  All idiots, after reading the first truth try it.
3.  The first truth is a lie.
4.  You're smiling now because you're an idiot.
5.  You soon will forward this to another idiot.
6.  There's still a stupid smile on your face.

Get only one ( top most) record from relation table.

2007-11-26T05:01:00.001-08:00

select
(select flightnumber as fn
from routing r
where r.involvedinformationid=ii.id
and r.id=(select MIN(id) from routing where involvedinformationid=r.involvedinformationid)),ip.*, ii.*
from involvedperson ip left outer join involvedinformation ii on ip.id=ii.involvedpersonid
where ip.emergencysituationcaseid=561

PEOPLE WONDER WHY THE CALL CENTRE GUYS R PAID SO MUCH.

2007-08-22T21:36:00.001-07:00

PEOPLE WONDER WHY THE CALL CENTRE GUYS R PAID SO MUCH......FOR JUST BEING
ON THE PHONE.
TAKE A LOOK:
1 ) Tech Support : "I need you to right-click on the Open Desktop."
Customer : "Ok."
Tech Support : "Did you get a pop-up menu?"
Customer : "No."
Tech Support : "Ok. Right click again. Do you see a pop-up menu?"
Customer : "No."
Tech Support : "Ok, sir. Can you tell me what you have done up until this
point?"
Customer : "Sure, you told me to write 'click' and I wrote 'click'."
----------------------------------------
2) Customer : "I received the software update you sent, but I am still
getting the same error message."
Tech Support : "Did you install the update?"
Customer: "No. Oh, am I supposed to install it to get it to work?"
--------------------------------------------------
3)Customer : "I'm having trouble installing Microsoft Word."
Tech Support : "Tell me what you've done."
Customer : "I typed 'A: SETUP'."
Tech Support : "Ma'am, remove the disk and tell me what it says."
Customer : "It says '[PC manufacturer] Restore and Recovery disk'."
Tech Support : "Insert the MS Word setup disk."
Customer : "What?"
Tech Support: "Did you buy MS word?"
Customer: "No..."
--------------------------------------------------
4).Customer : "Do I need a computer to use your software?"
Tech Support : ?!%#$ (welll pretend to smile)
--------------------------------------------------
5). Tech Support : "Ok, in the bottom left hand side of the screen, can you
see the 'OK' button displayed?"
Customer : "Wow. How can you see my screen from there?"
Tech support : ##### ***
--------------------------------------------------
6) Tech Support : "What type of computer do you have?"
Customer : "A white one."
Tech support : ******_____####
--------------------------------------------------
7). Tech Support : "What operating system are you running?"
Customer : "Pentium."
Tech support : ////-----+++
--------------------------------------------------
8). Customer : "My computer's telling me I performed an illegal abortion."
Tech support : ??????
--------------------------------------------------
9)Cus tomer : "I have Microsoft Exploder."
Tech Support : ?!%#$
--------------------------------------------------
10). Customer : "How do I print my voicemail?"
Tech support : ??????
--------------------------------------------------
11). Customer : "You've got to fix my computer.. I urgently need to print
document, but the computer won't boot properly."
Tech Support : "What does it say?"
Customer : "Something about an error and non-system disk."
Tech Support : "Look at your machine. Is there a floppy inside?"
Customer : "No, but there's a sticker saying there's an Intel inside."
Tech support : @@@@@
--------------------------------------------------
12). Tech Support: "Just call us back if there's a problem. We're open 24
hours."
Customer: "Is that Eastern time?"
--------------------------------------------------
13). Tech Support : "What does the screen say now?"
Customer : "It says, 'Hit ENTER when ready'."
Tech Support : "Well?"
Customer : "How do I know when it's ready?"
Tech support : *** ---- ++++
--------------------------------------------------
The best of the lot
14). A plain computer illiterate guy rings tech support to report that his
computer is faulty.
Tech: What's the problem?
User: There is smoke coming out of the power supply.
Tech: (keep quite)
Tech: You'll need a new power supply.
User: No, I don't! I just need to change the startup files.
Tech: Sir, the power supply is faulty. You'll need to replace it.
User: No way! Someone told me that I just needed to change the startup and
it will fix the
problem! All I need is for you to tell me the command.
Tech support::
10 minutes later, the User is still adamant that he is right. The tech is
frustrated and fed up.
Tech support:: (hush hush)
Tech: Sorry, Sir. We don't normally tell our customers this, but there is
an undocumented DOS
command that will fix the problem.
User: I knew it!
Tech : Just add the line LOAD NOSMOKE.COM at the end of the CONFIG.SYS. Let
me know how it goes.
10 minutes later.
User : It didn't work. The power supply is still smoking.
Tech : Well, what version of DOS are you using?
User : MS-DOS 6.22 .
Tech : That's your problem there. That version of DOS didn't come with
NOSMOKE. Contact Microsoft and ask them for a patch that will give you the
file. Let me know how it goes.
1 hour later.
User : I need a new power supply.
Tech support : How did you come to that conclusion?
Tech support : (hush hush)
User : Well, I rang Microsoft and told him about what you said, and he
started asking questions about the make of power supply.
Tech: Then what did he say?
User: He told me that my power supply isn't compatible with NOSMOKE.
-------------------------------------------------
Hight Of all (Too Good)
15) customer care officer: I need a product identification number right now
and may I help u in
finding it out?
Cust: sure
CCO: could u left click on start and do u find 'My Computer'?
Cust: I did left click but how the hell do I find your computer?

Google Starts Selling its mail storage. ( no more free ? )

2007-08-09T20:55:00.000-07:00

Today in the morning when I checked my gmail. I noticed new message appraing in the top left conner in my gmail acount page. see the attached image.

Opps my inbox exceeding its free quota given by Gmail :(. If I want to manage my quota need to follow their instructions or need to PURCHASE extra storage.

I never thought that google asked money for thier services. No wonder they will asked for some money for thier SMS reminder services implemented in Google-Calender. :(

Poems found in toilets

2007-08-01T21:15:00.001-07:00

I received this nice email one of my cousins. I thought to share it with my friends .. here it is...

THE "FUTURE" IS IN YOUR HAND , HOLD IT GENTLY"

Excellent poems by not so famous poets...

Found on toilet doors and walls.......
...
A budding poet trying his best...

Here I lie in stinky vapor,
Because some bastard stole the toilet paper,
Shall I lie, or shall I linger,
Or shall I be forced to use my finger.

Before he graduated to be a poet, he wrote this...

Here I sit
Broken hearted
Tried to shit
But only farted

Someone who had a different experience wrote,

You're lucky
You had your chance
I tried to fart,
And shit my pants!

Perhaps it's true that people find inspiration in toilets.

I came here
To shit and stink,
But all I do
Is sit and think.

There are also people who come in for a different purpose...

Some come here to sit and think,
Some come here to shit and stink,
But I come
here to scratch my balls ,
And read the bullshit on the walls...

Toilets walls also double as job advertisement space.......

(written high upon the wall)
If you can piss above this line, the Singapore Fire Department wants you.

Ministry of Environment advertisement.

We aim to please!
You aim too! Please

On the inside of a toilet door:

Patrons are requested to remain seated throughout the entire performance.

And finally, this should teach some a lesson...

Sign seen at a restaurant:

The hands that clean these toilets also make your food...please aim properly.

Bill Gates: “Dad, I always told you I’d come back and get my degree” - And he did

2007-06-10T22:45:00.001-07:00

Microsoft Chairman and Co-Founder Bill Gates has been waiting for over 30 years, 32 years to be more specific, to finally get his degree from Harvard University. And, yesterday June 7, 2007, William H. Gates III (Bill Gates) was awarded a honorary degree at Commencement’s Morning Exercises at Harvard. Gates is now the proud possessor of a Doctor of Laws degree from the American University. Gates quit Harvard in his junior year following the first successful sale of the programming language BASIC he had authored for the MITS Altair. After he left Harvard, Gates dedicated himself to Microsoft, the company he had founded with Paul Allen in 1975.

Adding Images to my blog.

2007-05-24T21:23:00.000-07:00

I was trying to add images to my blog using "Windows Live Writer (Beta)" for some reason it didn't allow me to upload images, here is the error that i'm getting.

may be FTP has been bloked by our adminstrators.

how ever i'm testing uploading images thought blogger.com interface.

Market Share for Top Servers Across All Domains.

2007-05-21T21:46:00.001-07:00

Apache web servers becomming the TOP runners in web server arena.
Not just only hosting, Apache has overtaken Microsoft as the leading developer of secure web servers. Apache now runs on 44.0% of secure web sites, compared to 43.8% for Microsoft.

Market Share for Top Servers Accross All Domains August 1995 -May 2007

[www.netcraft.com]

Apache Now the Leader in SSL Servers

[www.netcraft.com]

How to add columns and rows into a DataTable and then add this table into a DataSet.

2007-05-11T01:53:00.001-07:00

This is qucik respond to one of my friends quiz, taht is how to add records to a table and then add this table into a dataset in Runtime.

Here is the C# code.

//Declaring Dataset and DataTable
DataSet ds = new DataSet("myDataset");
DataTable dt = new DataTable("myDataTable");

//Creating Datatable columns
dt.Columns.Add("ID", Type.GetType("System.Int32"));
dt.Columns.Add("Name", Type.GetType("System.String"));

//Datarow variable to use in adding rows
DataRow dr;

//Adding Rows
for(int i=0; i<10; i++)
{
dr = dt.NewRow();
dr["ID"] = i;
dr["Name"]=i.ToString();
dt.Rows.Add(dr);
}

//If you need to add the table in Dataset you can do like this
ds.Tables.Add(dt);

//Query the dataset.datatable to see the added values

foreach(DataRow r in ds.Tables[0].Rows)
{

//r[0] is the first columns. inseted r[0] you can use r["ID"]
Response.Write( r[0].ToString() + "-----" + r[1].ToString() + "<br>");
}

Pictures of my new House.

2007-05-07T22:18:00.001-07:00

Front Elevation
@ the stage of construction.	@ the stage of plastering.	@ the stage of completed.

Sitting Room
@ the stage of construction.	@ the stage of plastering.	@ the stage of completed.

Back after a long time.

2007-04-24T22:11:00.001-07:00

Hi friends, I'm back in my blog space after long time (almost after 2 years). Existence of my bolg space really surprised me. Thankful to blogspot.com :).

However, there are lots of things happened during this 2 years time, new employer, new home and so many things.

New Employer

I have changed my employer (doit-e lanka) in May 2006 and joined JKCS ( John Keells Computer Services) in June 19th 2006. Almost completing my one year with the new employer.

Millstones

I have achieved one of the greats millstones in my life someone who can achieve in their life, that is to have your own home. I did it !!!!!!!!!!!

I will update latest pics of my new home later in this blog.

More to come....

There are so many things in the raw to be happened in near future. Will post them as well :).

Just Arrived

2005-03-23T01:14:00.000-08:00

Just arrived here .. will post something sooner or later related to my field ..

Cheers
Ranga