if not isDBNull(dr(“FieldName”)) then

Me.label1.text = dr(“FieldName”).ToString

else

Me.label1.text = “”

end if

however there is a much better and more efficient way….

Me.label1.text = dr.field(of String)(“FieldName”)

Sorted!

User: Temporary License

Key: tX__0PMV_CyqBQqT1BF61wIGk5o6AUfQAO0AVtVSW_TfgnyCMk85YG_3NzvPvcSQ&gjtnKCyUiQxp&R&WJZIeyVCnAiS0oyVmR4Jr2zcOJD2TbyBeclPK_i2P6jmPDbe6W25kRKZIZYLmMfn7dvOLE9D1PkDxJ7fXvnYxLuSBE4

FirstNames
Richard
Adam
James
Adam
Ryan
RICHARD
Richard

and queried this table with “SELECT DISTINCT FirstNames FROM table” you would get:

FirstNames
Richard
Adam
James
Ryan

However, there are occasions where you want the case taken into account. Change the query to include a COLLATE function with case sensitive (notice the cs) and it then does this.

“SELECT DISTINCT FirstNames COLLATE sql_latin1_general_cp1_cs_as As [FirstNames] FROM table”

now returns:

FirstNames
Richard
Adam
James
Ryan
RICHARD

Its really handy to know and remember, especially if you are getting errors when trying to select a value from a list and the distinct name isn’t there because the exact same text is in the field with a slightly different case.

Open the Finder and browse to

/Applications/Xcode.app/Contents/Developer/Platforms/iPhoneSimulator.platform/Developer/Applications/iPhone\ Simulator.app

To get to the folder for Xcode then right-click on the App and choose show package contents.

ten-top-tips-for-speeding-up-sql-server

Make sure ASPState is set to simple recovery – this will dramatically reduce the impact to the log that can be caused by the high volume of (transient and largely disposable) writes that are likely to go here:

ALTER DATABASE ASPState SET RECOVERY SIMPLE;

Usually this database does not need to be in full recovery, especially since if you are in disaster recovery mode and restoring your database, the last thing you should be worrying about is trying to maintain sessions for users in your web app – who are likely to be long gone by the time you’ve restored. I don’t think I’ve ever come across a situation where point-in-time recovery was a necessity for a transient database like ASPState.

1. Early Morning Intense Exercise – A short burst of intense exercise when you first get up can do wonders for your metabolism. Dr. Oz has advocated for this method of speeding up the metabolism. The best part is you only have to do about five minutes of intense exercise to reap the benefit all day. The exercise you do can be really simple. Examples would include running in place, jumping jacks, and lunges. Of course, if you have a stair master or a jogging machine, that would work too. Just get your heart rate up for five minutes and cool down for two minutes.

2. Eat More Spicy Foods – Hot spices like curry, cayenne pepper, black pepper, cumin, and turmeric all help the body speed up your metabolism. There are other “hot” spices that you may not think of as hot but they react in the body in this way. They include cinnamon, cardamon, ginger, and nutmeg. Try adding these tasty spices to your soups, stir-fries, casseroles, and other dishes. Curry goes great in some type of salads like quinoa salads. Some people love the taste of cinnamon in their coffee. Just add it to the grounds before you brew it.

3. Drink Lots of Water – Water is magical in this way. Drink a lot of water and your metabolism will magically increase because the metabolic process needs water to fuel it. It’s even better if you make sure you are drinking alkaline water.

4.Keep Your Thyroid Healthy – To work efficiently, the thyroid needs selenium, zinc, copper, and iodine. However, the American diet is notoriously low in these important minerals. To get more of these minerals, eat more seafood and nuts.

5. Never Skip Breakfast – Unfortunately, in this fast paced world we live in, many of us have a tendency to skip breakfast or grab something nutrient poor on the way out the door. This is one of the worst things you can do for your metabolism. Always eat a healthy breakfast. This should include a healthy protein like eggs from pasture raised chickens and fruit bursting with antioxidants like blueberries or strawberries.

6. Don’t Eat As Much Late In the Day – Unfortunately, most of us eat more at dinner than we do at breakfast. We also tend to snack at night before bedtime. This is exactly the opposite of what you want to do to speed up your metabolism. Try to eat more earlier in the day and less at dinner. Plus, try not to eat for at least three hours before bedtime.

7. Build More Muscle Mass – Weight training isn’t just for body builders. Building muscle mass should be part of all fitness programs. Even if you can’t join a gym or buy fancy equipment, you can build muscle mass. A couple of cans of food or water bottles filled with water can serve as weights for your arms and you can use those big rubber bands (cheap) or your own body weight to provide resistance to your legs to build more muscle mass.

Thanks to http://www.fitnea.com/7-ways-of-boosting-your-metabolism/ for the info…

All of Me (Jon Schmidt) – ThePianoGuys

Just the Way You Are – Bruno Mars (Piano_Cello Cover) – ThePianoGuys

Titanium _ Pavane (Piano_Cello Cover) – David Guetta _ Faure – ThePianoGuys

One Direction – What Makes You Beautiful (5 Piano Guys, 1 piano) – ThePianoGuys

Just for you until you find your actual book! Simply click on this on your iPad and choose “Open in iBooks” – enjoy!

A clash of kings.epub