Wednesday, November 21, 2012

Single Line Query for Update all Records using Case Statement

update tblCreditCardConvertTypes set IsDefault=(case when IsDefault =1 then 0 else 1 end)

OR


update tblCreditCardConvertTypes set IsDefault=0 update tblCreditCardConvertTypes set IsDefault ='True'
where ConvertID=6

Language Translation in Asp.Net



  in head tag
===============

<meta name="google-translate-customization" content="ab3e055b4f44f8c9-6508da3348829d69-g56af1f4de8a2f969-13"></meta>


=============  in body==========================


<div class="translator " style="height:40px;float:right;margin:10px 5px 5px 50px;width:160px;">
<span style= "font:normal 10px verdana;color:#999;align:center; ">WEBSITE TRANSLATOR</span>
<div id="google_translate_element"></div><script type="text/javascript">
function googleTranslateElementInit() {
  new google.translate.TranslateElement({pageLanguage: 'en', layout: google.translate.TranslateElement.InlineLayout.SIMPLE, multilanguagePage: true, gaTrack: true, gaId: 'UA-6642602-1'}, 'google_translate_element');
}
</script><script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script></div>