woah! its 6pm wen i left the office. The sky ‘stil dis light! :) kewl! summer is here!

www.stepinme-witnessofchristlove.tumblr.com

Reading data from MS Excel sheets without using the ODBC Command (C#)

Owrytee, for months, I have been googling this statement and all I got are also problems unsolved. Only my software development trainor had the exact solution I am looking for. n_n
I am blogging this stuff to help people like me who has the same frustration. hihihihi :D

using Excel = Microsoft.Office.Interop.Excel;

object m = Type.Missing;

Excel.Application ExcelApp = new Excel.Application();

Excel.Workbook ImportWorkBook = ExcelApp.Workbooks.Open(“C://Names.xsls”, m, m, m, m, m, m, m, m, m, m, m, m, m, m); -----> first parameter here is the location of the Excel file. You can change this to the OpenFileDialog.FileName if you are using one.

Excel.WorkSheet ImportWorkSheet = (Excel.Worksheet) ImportWorkBook.Sheets[1]; --->; “1” here is the sheet number (Sheet1, Sheet2, ….)

Excel.Range SheetRange= ImportWorkSheet.UsedRange; --> .UsedRange indicates the rows that contains data

Int32 rowCount = SheetRange.Rows.Count;
Int32 i = 1;

While(i< rowCount)

{ 
     ImportWorkSheet.get_Range("A" + i.ToString(), "A" + i.ToString()).Value2.ToString();

---->; reading the Excel cell value (.getRange("A1", "A1"))

i++;

}

I don’t advise that you copy-paste-run this stuff. Analyzing it will do. n_n
And yes, dont forget to close  your .Close and .ReleaseCOMObject() after everything. owrytee? :)

So that's it. No complicated stuff right? 
All credits to my software development trainor. :)

If you have clarifications you can leave comments below.

God bless yea! Happy programming!

Review: Etude House Collagen Moistfull First Essence

Owryteee! Ive been using this product for three weeks before writing this review. What I needed was no.1: a moisturizer to put before face powder; 2: tighten the visible pores on my face.

I cannot find concrete reviews on this product but I am decided to have one from Etude House Collagen Moistfull line. I was convinced to purchase the Collagen Moistfull Cream because I have no idea what the Balm, Primer, First Essence, and the rest do. Hehehhe.

So how did I end up choosing First Essence? The Etude House Lady told me that this product has the most percentage of collagen (very well known to tighten skin and improve its elasticity) compared to the other products. It contains 90% hydrolyzed collagen. Cool! It gets absorbed in the skin quickly compared to creams/foundations  because it is in liquid form. It costs 700+ in peso.

Well, I use it every morning and sometimes at night before going to bed.

Smell is feminine and not too strong. I feel that it contains more natural ingr and not superb chemicals. It does not have any harsh effects on my face skin. Rather, I feel it's tighter and more supple.

I give it a 10/10 grade! I'll try the MC BB Cream next!
God bless Fiore Etude House' chemists :)

Review: Kolours Caramel Brown Dual Conditioning Color

Alrightee! It is a long time desire for me to color my hair! (◕‿◕✿)  This is going to be meh first time! (~˘▽˘)~Originally I want CL's blondie look but then I went on searching for a light brown shades for the mean time. ლ(⌒▽⌒ლ)  I first decided to try Kolours Dual Conditioning Hair Color. (~˘▽˘)~ (~˘▽˘)~

Okay. So my checklist before trying for the first time a DIY hair color is:
1. will not cause over damage
2. will give me a satisfactory light brown shade. 
3. noticeable change. hahahah.
ヾ(-_-;)  ヾ(-_-;) ヾ(-_-;) 


There are few reviews for this product available online compared to EH's (yea, 'was my first choice but then it was out of stock that night) ヾ(-_-;) ヾ(-_-;)  The price is amazingly not so expensive too -costs only 249php something. ヽ(‘ ∇‘ )ノ  What made me try this one is my sister. She recommended this saying that it gives a shiny finish. (◕‿◕✿)

I thought the solution/colorant was too many for my hair length so I offered some to my mom.  (￣▽￣)ノheheheh. Then I realized that applying cream-type hair colorant is more tricky than that of mousse (or bubble) type. (¬д¬。) This is because, the result on my mom's hair was more evenly spread compared to mine. With the plastic gloves, It was difficult to tell which part on your own hair has less cream applied  unlike doing it on someone's. Hmm.. However I was quite satisfied with the results. (´･ω･`)(´･ω･`)

the product contents

at first wash

weird eh? it looks somewhat reddish. Somehow after a number of washes, the color will be more likely to be caramely in color (according to some reviews Ive read).

so ..  after 5 days

after more than 7 days .. yey!

Recommended? yes! besides the cheap price, I found it effective and friendly especially for those first-timers like me. Just a lil tip, the next morning, I soaked my hair with pure VCO (the food supplement one) and let it stay for like 6 hours I think. After that, I shampooed with Suave for sleek hair plus a Nature Care conditioner as a follow up treatment. The effect was superbly smooth! No trace of damage. ヽ(‘ ∇‘ )ノ 
Why dont you try one? (◕‿◕✿) 

☺☺☺

Hello 2012!

taken January 1, 2012 eve.

www.stepinme-witnessofchristlove.tumblr.com

Celebrating Christmas 2011

the lootbags

lil conversation with Dagulii

OM! I will never forget the feeling

ahmm .. we met Lei Alviz hihi

met Angela and her siblings

happy hearts!

During college days, me and my nengs' favorite way of celebrating whichever event is simply traveling to Manila, spend quality time with one another at the zoo, gardens,  Intramuros historical streets, etc then have a little picnic on the Luneta Park. Happy and not spendy!

We met two kids namely Antonette and JunJun who lived by the Manila Bay shore.
 That time, we would simply plan, "Sa susunod dalhan natin sila ng pagkain. (Next time let us bring them some food.) "

God used these moments to let our hearts remember them this Christmas. (though we havent met the two particular kids anymore :(
Instead of planning a party to celebrate, we decided to make our dream happen this year!

Many heartbreaking moments were used by God to let us feel that our purpose in doing this was fulfilled.
It just feels so meaningfully fulfilling to share God's love with the children!

We just graduated on the same year. atat, eh? A dream come true for us in an unbelievable period of time!
This is because when God provides, He gives abundantly and no delays!

happy new year nails

Kris Kringle Day 1

Dec 20 2011
- something funny and noisy day!
☺☺☺

(photos taken by our superb photographer boss!)


www.stepinme-witnessofchristlove.tumblr.com

Kamay Kainan buffet desserts

We had our PMIT (Publications, Multimedia, IT) Christmas celebration at Kamay Kainan at Market! Market!


The place has a comfy and not awkward rather than that 'formal' feel. Nevertheless, Perfect place to indulge Pinoy delicacies!

Desserts offered were healthy too! Hmm! Good news for sugar-consume conscious folks!
Kamay Kainan Market! Market! offers veggie salad, green mango with bagoong (hmm i think this doesnt count as dessert hehehe), gelatin (the orange one upper right), pandan salad (super sweeet), puddings, sorbetes, fresh fruits like pineapple, sweetened banana, etc



Overall, yummy and very sulit experience!

stepinme*