Wednesday, November 12, 2008

SQL LIKE Condition

The LIKE condition allows you to use wildcards in the where clause of an SQL statement. This allows you to perform pattern matching. The LIKE condition can be used in any valid SQL statement - select, insert, update, or delete.

The patterns that you can choose from are:

% allows you to match any string of any length (including zero length)

_ allows you to match on a single character

Examples using % wildcard

The first example that we'll take a look at involves using % in the where clause of a select statement. We are going to try to find all of the suppliers whose name begins with 'Hew'.

SELECT * FROM suppliers
WHERE supplier_name like 'Hew%';

You can also using the wildcard multiple times within the same string. For example,

SELECT * FROM suppliers
WHERE supplier_name like '%bob%';

More ...

Facebook API - building Facebook applications in ASP.Net

Build social applications on Facebook Platform
The web is social. Developers just like you have built applications on Facebook Platform that millions of people use everyday. Join the developer community and help make the web even more social.
Facebook Developers

Facebook developers ASP.Net
Facebook developers ASP.Net

Facebook Developer Toolkit download

Getting Started with the Facebook Developer Toolkit
Getting Started with the Facebook Developer Toolkit

Anatomy of a Facebook application
Anatomy of a Facebook application

Facebook is a social networking website launched on February 4, 2004.[1] The free-access website is privately owned and operated by Facebook, Inc. Users can join networks organized by city, workplace, school, and region to connect and interact with other people. People can also add friends and send them messages, and update their personal profile to notify friends about themselves. The website's name refers to the paper facebooks depicting members of a campus community that some US colleges and preparatory schools give to incoming students, faculty, and staff as a way to get to know other people on campus.
Wikipedia Facebook

Inside Facebook - Latest news and Facebook applications. Tracking Facebook and the Facebook Platform for Developers and Marketers.
Inside Facebook

AppRate is a community-driven site that brings sense (and a bit of wit) to Facebook Applications. With daily reviews and ratings, we help users filter out the ‘good’ applications from the bad and ugly. Anyone and everyone is welcome to vote, and we encourage users to submit their own apps for review.

Face Reviews - Social News, Reviews and Trends. Mission is to help companies extend their brand across all social media networks. We report & publish observations, reviews and trends related to Social Media.
Face Reviews

Tuesday, November 11, 2008

Master (GridView) Detail (FormView) refresh after update

Master Detail automatic GridView/FormView refresh after an update.

The secret to having a master (GridView) trigger a detail (FormView) and see it refresh after an update.

Just add the DataBind in Page_PreRenderComplete handler.

protected void Page_PreRenderComplete(object sender, EventArgs e)

Additional information:
Master-Detail with the GridView, DetailsView and ModalPopup Controls

GridView control to show master-child or master-slave data, written in c#,, and javascript.
Subject: Display data using gridview, by generating hidden div with child data. Javascript used to show and hide (collapse and expand) grid.

More...GridView control to show master-child or master-slave data, written in c#,, and javascript.

Tuesday, November 4, 2008

Exitmercials Push Visitors to Advertiser Websites

Ad buyers jump through too many hoops for low ROI
Online advertising creates friction for the ad buyer.
Why do buyers jump through so many hoops to entice visitors to their website?
tEarn exitmercials solve the problem.

History of Advertising

Whether newspapers, magazines, coupon mailers, yellow pages, or TV broadcasts - an advertiser bundles their advertising with other content. Delivered as a media product, the advertiser is promised:
  • A minimum circulation.
  • Savings when compared to mailings.
Buyers pay a cost per thousand (CPM) like $50. When compared to minimum direct mail costs of $1.00 each, participating at $50 CPM is much cheaper than $1,000 CPM. Conversely, the $50 CPM has a cost per impression of a nickel, substantially cheaper than $1.00.

A magazine or Yellow Page book with 50,000 circulation would charge $2,500 per page - less for partial pages. This compares to $50,000 for a direct mail campaign via the USPS.

That's the core economics of advertising.

Banners, Spots, Skyscrapers, and Other Display Ads

In 1993, I participated in the early phases to standardize online advertising. Cnet proposed banners. We pushed spots. ZDnet invented skyscrapers, initially to fill the extra space on the right edge of wide-screen monitors.

Standards emulate print advertising.
  • Advertisers supplied a creative image in standard sizes.
  • Rather than show the same banner to every visitor, the practice randomizes - thus showing different ads to visitors. This made it hard for the buyer to find their own ad, since it may not show during their visit.
  • The ad server controlled delivery, to provide the buyer with the exact number of deliveries that they contracted for. The buyer can buy any quantity - not just the fixed circulation of the publisher.
  • Creative talents worked in the limited space to entice viewers to click and learn more.
  • A click takes visitors from the ad to the advertiser's web site. This is a click through.
This high friction process has become a multi-billion business with billions of ad deliveries, but low click-through rates.

Ultramercials (i.e. fancy interactive banners), in-game, in-video, and in-text advertising continue the tradition of ads embedded on a page. Each is a high-friction buy with typical single-digit or less click-through rates.

Enter Google Text Ads

Google created Adwords. Yahoo, Microsoft, and others copied the model.
  • Buyers supply two phrases of limited length. One is the headline. The other is a tagline.
  • Copy writers struggle with catchy phrases to attract buyers.
  • Buyers choose keywords that match customer interests to the advertiser's products.
  • With the complexity of synonyms, buyers often choose thousands of keywords to describe their offering.
  • Buyers bid to pay a cost per click (CPC) or cost per action (CPA). When readers click on the ad, they are directed to the advertiser webpage. Buyers pay only when clicked - a paid click.
  • A robot controls placement of ads on a page and the order of ads in a column. Buyers don't control placement and frequency - creating frustration.
Despite this high-friction process, CPC has also become a multi-billion business. CPC solved the low click-through rates of display ads. Buyers pay when there is a click-through - a paid click.

As stated by the Google CFO in 2008 Q3:
"there is insatible demand for any paid click we produce."
  • Efficient Frontier reports that CPC buyers pay from $0.30 to $0.60 per click.
  • Google has reported mortgage brokers who pay over $4.00 per click.
When compared to $50 CPM display ads:
  • If 10% of viewers click-through, the equivalent CPC would be $0.50.
  • At average click-through rates of 1%, the equivalent CPC is $5.00.
  • At lower click-throughs, the CPC would be higher.
Average CPM rates have dropped.

CPC has won increasing share of online ads.

Buyers want click-throughs.

tEarn Exitmercials Push to Advertiser Websites

tEarn's patent-pending exitmercial system pushes qualified visitors to advertiser websites.
  • Buyers supply a website or webpage.
  • Buyers choose a target audience.
  • Buyers choose a CPC or CPA.
Exitmericials push relevant visitors - a paid push - 100% ROI by definition.

There is no friction from:
  • Views that 99% don't see
  • Banner creatives in limited spaces
  • Effort to gain click-throughs
  • Keyword selection
  • SEO to optimize thousands of keywords
  • Copy writing to entice clicks
  • Fraudulent clicks
  • Habitual clickers
  • Accidental clicks
  • Ad blockers
  • Cookie-less
The paid push results in a website visit without friction. Buyers focus on their product, image, and website to retain customers.


Innovation simplifies.

Buyers want hits on their website.

tEarn pushes without friction.

How many pushes do you need?

Turn off email notifications in facebook

To turn off your email notification do the following in Facebook:
1. Click account
2. Click Notifications
3. Now untick ALL the notifications you do not wish to receive
4. Click Save Changes

ASP.Net Feeds