Your Feild is Declare ExpDate varchar(15) then you can convert and cast below formate
set dateformat dmy
Select CONVERT(varchar(15),Cast (ExpDate as datetime),106) as date from ExpenseTable
Output:
26 Aug 2012
Friday, October 19, 2012
Display Unique Name in Gridview
Dim mstrUserName As String
Protected Sub gvDocumentList_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvDocumentList.RowDataBound
If e.Row.RowType <> DataControlRowType.Header And e.Row.RowType <> DataControlRowType.Footer Then
'' Find Unique Name
Dim meString As Label = e.Row.FindControl("meSigLabel")
If e.Row.DataItemIndex = 0 Then
mstrUserName = ""
End If
If meString.Text = mstrUserName Then
e.Row.Cells(0).Text = ""
Else
mstrUserName = meString.Text
End If
End If
End Sub
Friday, October 12, 2012
Difference between a Debug vs Release
Difference between a Debug vs Release
Release Mode
Developer use release mode for final
deployment of source code on live server. Release mode dlls contain
optimized code and it is for customers. Release mode has below features:
- While in release build the symbolic debug info is not emitted and the code execution is optimized.
- More optimized code
- Some additional instructions are removed and developer can’t set a breakpoint on every source code line.
- Less memory is used by the source code at runtime.
- Scripts & images downloaded by webresource.axd are cached.
- It has small size, and runs fast.
Debug Mode
Developer use debug mode for debugging the web
application on live/local server. Debug mode allow developers to break
the execution of program using interrupt 3 and step through the code.
Debug mode has below features:
- debug build the complete symbolic debug information is emitted to help while debugging applications and also the code optimization is not taken into account.
- Less optimized code
- Some additional instructions are added to enable the developer to set a breakpoint on every source code line.
- More memory is used by the source code at runtime.
- Scripts & images downloaded by webresource.axd are not cached.
- It has big size, and runs slower
Thursday, October 11, 2012
About Android
Android is an operating system for mobile phones and tablets.While it was only released about four years ago, the Android operating
system has gone through several different names and versions before
settling on the Android name that is commonly known today. Previous
names include Cupcake, Honeycomb and Jelly Bean among many others. The
Android company worked on developing this product since the company's
inception in 2003 in Palo Alto, California.
All with backgrounds in IT and web development as well as software
technology, the four men worked on the software and continued to do so
after the company was acquired by Google in 2005. Since Google had the
financial means as well as the man power to develop the Android software
technology to the maximum extent, this was a great move for the Android
company and led to substantial advances in the Android operating system
and the product's release in 2008.
Android itself contains the functions that are vital to using a
mobile phone, including the phone dialler, text messaging client and
phone number storage. Google also provides some additional apps,
including a Gmail email client, Google Maps (which features free
turn-by-turn satellite navigation) and YouTube.
Beyond that, you
can also buy or download for free many other apps to enable your phone
or tablet to do more. You can get these apps from the Android Market, or
from other sources, such as GetJar or Amazon's Appstore. They can also
be loaded onto an Android device manually, without using a store.
These
apps can include ways to use Facebook, create documents, access online
storage services such as Dropbox, or there's a huge range of games
available. Some social networks are integrated into certain Android
phones by default, enabling you to connect someone's contact information
in your phone to their Facebook account, for example, and automatically
pull through details such as their birthday.
Android is open
source, meaning that manufacturers don't have to pay Google to use it,
and that they're free to modify it. This means that it's used in a wide
range of hardware varying in price from small budget phones to
large-screen high-end handsets.
Android has many media features built in, so it's easy to load your
music and movies onto your device and play them without problems. Most
common audio file formats are supported, as are some of the most
often-used video formats. Many manufacturers also add support for some
of the less-common formats.
There's no official iTunes-like media
syncing client for Android (though there are some third-party tools to
do this, such as doubleTwist). In most cases, when you connect your
device to your computer, it will show up as external storage, in the
same way a USB flash drive would. You can then simply drag your music
and video files to it to copy them over. When you disconnect your
device, it will scan for media, and it to the music player app.
Google
regularly releases updates to Android, which are downloaded straight to
the phone or tablet without having to connect to a computer. These
updates often bring speed and battery life improvement, as well as other
new features.
JavaScript Confirm Dialog for Mobile
window.onload =
function
(){
setTimeout(confirmMobile, 2000);
}
function
confirmMobile(){
var
toView = window.confirm(
"are you sure?"
);
if
(toView){
}
}
Tuesday, October 9, 2012
how to write populer blog
- Ask questions to your visitors.
- Be active in Social Bookmarking websites.
- Beauty is in the eye of the beholder.
- Brand your blog with a catch phrase along with a logo.
- Build tools that your visitors might find use for.
- Buy a paid review from any famous blogger(s).
- Celebrate your birthday with your visitors. Think of innovative ways for doing this.
- Celebrate your blog’s birthday too.
- Choose what type of blog you want to create.
- Congratulate the top commentators occasionally.
- Create polls.
- Decide how often you are going to post.
- Dig up some old article that you wrote on your blog which became famous and start a discussion.
- Distribute T-shirts or merchandise with your blog name on it.
- Do surveys and publish the results to your visitors.
- Donate for a cause or become a volunteer for a non-profit organization. Ask your visitors to join you.
- Dress up your blog often (By dress-up I mean tweaking the design)
- Encourage sharing of opinions.
- Examine what worked before
- Get featured in a print magazine.
- Get some things together beforehand.
- Give away free goodies. People love them.
- Hold an auction and let people bid for something useful (For example, advertising space on your blog).
- Hold blog competitions.
- Interview other bloggers and post the interview.
- Introduce a commission based affiliate program.
- Join Yahoo! Answers and put a link on your website to your answers.
- Keep a track of websites that pick up your articles or press releases. Offer them exclusive news or content.
- Last but not the least, be yourself.
- Look around the Internet for blogs that people love to read
- Look around the Internet for blogs that people love to read.
- Make a bumper sticker with your blog’s name and stick it on your car. (Just make sure you drive often)
- Make contact with your local visitors and hold a get-together or a bloggers’ meet.
- People like to read about Web 2.0. Write about it.
- Pod-casting is another good way to make your blog popular.
- Post about one of the weirdest thing that you ever did.
- Post interesting pictures of your pets.
- Post videos that will help your visitors learn something new. Also submit them to video sharing websites like YouTube.com.
- Publicize your blog to your friends and relatives and let them do some work for you.
- Put your blog’s ad in the local newspaper or the yellow pages.
- Send messages with links.
- Send messages with links.
- Share Link Love and you will get it back.
- Share some secrets.
- Share your hopes and aspirations about your blog.
- Start a blog comic strip.
- Start a contest. Make sure to end it too.
- Start a controversy. Just remember not to cross the line.
- Start a newsletter.
- Start an award distribution system.
- Tell close friends about your blog and ask them to tell their friends.
- Tell them what you’re going to tell them.
- Tell them what you’re going to tell them.
- Tell your visitors about your latest fad or obsession.
- Try and get a photograph clicked with a real celebrity and post it on your blog. (Hold on Tiger..don’t rush to that Photoshop button!)
- Utilize your network.
- Utilize your network.
- Write about other bloggers to interest their visitors to read your blog. Keep it positive.
- Write about something that’s already famous.
- Write about your blog achievements.
- Write about your hobbies and interests. (For example, if you like cooking, post a new recipe)
- Write about your personal life sometimes.
- Write an e-book and distribute it to your visitors for free.
- Write something funny or disgusting. (Don’t make it a habit)
Monday, October 8, 2012
Excel Format Style useing asp.net
Styling Excel cells with mso-number-format
Styling Excel cells with mso-number-format
mso-number-format:"0" NO Decimals
mso-number-format:"0\.000" 3 Decimals
mso-number-format:"\#\,\#\#0\.000" Comma with 3 dec
mso-number-format:"mm\/dd\/yy" Date7
mso-number-format:"mmmm\ d\,\ yyyy" Date9
mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM
mso-number-format:"Short Date" 01/03/1998
mso-number-format:"Medium Date" 01-mar-98
mso-number-format:"d\-mmm\-yyyy" 01-mar-1998
mso-number-format:"Short Time" 5:16
mso-number-format:"Medium Time" 5:16 am
mso-number-format:"Long Time" 5:16:21:00
mso-number-format:"Percent" Percent - two decimals
mso-number-format:"0%" Percent - no decimals
mso-number-format:"0\.E+00" Scientific Notation
mso-number-format:"\@" Text
mso-number-format:"\#\ ???\/???" Fractions - up to 3 digits (312/943)
mso-number-format:"\0022£\0022\#\,\#\#0\.00" £12.76
mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ "
2 decimals, negative numbers in red and signed
(1.56 -1.56)
mso-number-format:"0" No Decimals
mso-number-format:"0\.00" 2 Decimals
mso-number-format:"mm\/dd\/yy" Date format
mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM
mso-number-format:"Short Date" 05/06/-2008
mso-number-format:"Medium Date" 05-jan-2008
mso-number-format:"Short Time" 8:67
mso-number-format:"Medium Time" 8:67 am
mso-number-format:"Long Time" 8:67:25:00
mso-number-format:"Percent" Percent - two decimals
mso-number-format:"0\.E+00" Scientific Notation
mso-number-format:"\@" Text
mso-number-format:"\#\ ???\/???" Fractions - up to 3 digits (312/943)
mso-number-format:"\0022£\0022\#\,\#\#0\.00" £12.76
mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ " 2 decimals, negative numbers in red and signed
(1.86 -1.66)
mso-number-format:”\\#\\,\\#\\#0\\.00_\\)\\;\\[Black\\]\\\\(\\#\\,\\#\\#0\\.00\\\\)” Accounting Format –5,(5)
Styling Excel cells with mso-number-format
mso-number-format:"0" NO Decimals
mso-number-format:"0\.000" 3 Decimals
mso-number-format:"\#\,\#\#0\.000" Comma with 3 dec
mso-number-format:"mm\/dd\/yy" Date7
mso-number-format:"mmmm\ d\,\ yyyy" Date9
mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM
mso-number-format:"Short Date" 01/03/1998
mso-number-format:"Medium Date" 01-mar-98
mso-number-format:"d\-mmm\-yyyy" 01-mar-1998
mso-number-format:"Short Time" 5:16
mso-number-format:"Medium Time" 5:16 am
mso-number-format:"Long Time" 5:16:21:00
mso-number-format:"Percent" Percent - two decimals
mso-number-format:"0%" Percent - no decimals
mso-number-format:"0\.E+00" Scientific Notation
mso-number-format:"\@" Text
mso-number-format:"\#\ ???\/???" Fractions - up to 3 digits (312/943)
mso-number-format:"\0022£\0022\#\,\#\#0\.00" £12.76
mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ "
2 decimals, negative numbers in red and signed
(1.56 -1.56)
mso-number-format:"0" No Decimals
mso-number-format:"0\.00" 2 Decimals
mso-number-format:"mm\/dd\/yy" Date format
mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM
mso-number-format:"Short Date" 05/06/-2008
mso-number-format:"Medium Date" 05-jan-2008
mso-number-format:"Short Time" 8:67
mso-number-format:"Medium Time" 8:67 am
mso-number-format:"Long Time" 8:67:25:00
mso-number-format:"Percent" Percent - two decimals
mso-number-format:"0\.E+00" Scientific Notation
mso-number-format:"\@" Text
mso-number-format:"\#\ ???\/???" Fractions - up to 3 digits (312/943)
mso-number-format:"\0022£\0022\#\,\#\#0\.00" £12.76
mso-number-format:"\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ " 2 decimals, negative numbers in red and signed
(1.86 -1.66)
mso-number-format:”\\#\\,\\#\\#0\\.00_\\)\\;\\[Black\\]\\\\(\\#\\,\\#\\#0\\.00\\\\)” Accounting Format –5,(5)
Subscribe to:
Posts (Atom)