Friday, October 19, 2012

date formate

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

Display Unique Name in Gridview




'Declare in top
  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){
            window.location.replace("prakashbhoi.blogspot.com");
        }
    }

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)

About Me

Hi, I am Prakash bhoi From Vapi,Gujarat(India)