<?xml version="1.0" encoding="UTF-8" standalone="no"?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:gd="http://schemas.google.com/g/2005" xmlns:georss="http://www.georss.org/georss" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:thr="http://purl.org/syndication/thread/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-4490387103798985456</atom:id><lastBuildDate>Fri, 12 Dec 2025 20:25:23 +0000</lastBuildDate><category>c#</category><category>Asp.Net</category><category>Tips and Tricks</category><category>Sql</category><category>GridView</category><category>ajax</category><category>Asp</category><category>jQuery</category><category>Google</category><category>Html</category><category>javascript</category><category>xml</category><category>API</category><category>SQL scripts</category><category>CSS</category><category>WCF</category><category>Apex</category><category>Array</category><category>CDN</category><category>Div</category><category>LINQ</category><category>Master Page</category><category>SalesForce</category><category>Silverlight</category><category>Twitter</category><category>Andriod</category><category>Blogger</category><category>Captcha</category><category>Force</category><category>Interview Question</category><category>LWC</category><category>Lightning</category><category>Personal</category><category>Seo Technique</category><category>SiteMap</category><category>VisualForce</category><category>datalist</category><category>tinyurl</category><category>web 2.0</category><title>Coding Stuffs</title><description>&amp;lt;asp:input&amp;gt;.. &amp;lt;html&amp;gt;.. &amp;lt;!DOCTYPE HTML...
..protected void Page_Load(object... &amp;lt;style type=&amp;quot;text/css ... Select Error from Database...</description><link>http://codingstuffsbykiran.blogspot.com/</link><managingEditor>noreply@blogger.com (kiran)</managingEditor><generator>Blogger</generator><openSearch:totalResults>95</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><language>en-us</language><itunes:explicit>no</itunes:explicit><itunes:summary>&amp;lt;asp:input&amp;gt;.. &amp;lt;html&amp;gt;.. &amp;lt;!DOCTYPE HTML... ..protected void Page_Load(object... &amp;lt;style type=&amp;quot;text/css ... Select Error from Database...</itunes:summary><itunes:subtitle>&amp;lt;asp:input&amp;gt;.. &amp;lt;html&amp;gt;.. &amp;lt;!DOCTYPE HTML... ..protected void Page_Load(object... &amp;lt;style type=&amp;quot;text/css ... Select Error from Database...</itunes:subtitle><itunes:owner><itunes:email>noreply@blogger.com</itunes:email></itunes:owner><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-5598228034300819762</guid><pubDate>Wed, 10 Jun 2020 02:48:00 +0000</pubDate><atom:updated>2020-06-10T03:48:50.455+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Apex</category><category domain="http://www.blogger.com/atom/ns#">Lightning</category><category domain="http://www.blogger.com/atom/ns#">LWC</category><category domain="http://www.blogger.com/atom/ns#">SalesForce</category><title>LWC - navigation in lightning community</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;&lt;font face="helvetica"&gt;
Hello&lt;br /&gt;
I recently started working on the LWC framework, which is the next version of aura framework.&lt;br /&gt;
today i came across a situation where I have to navigate to different pages or list views from the home page and I started using the different options and found below one working.&lt;/font&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;Html&lt;br /&gt;
&lt;a name='more'&gt;&lt;/a&gt;&lt;br /&gt;
&lt;div style="background-color: whitesmoke; color: #333333; font-family: menlo, monaco, &amp;quot;courier new&amp;quot;, monospace; font-size: 12px; line-height: 18px; white-space: pre;"&gt;
&lt;div&gt;
  &lt;span style="color: #91b3e0;"&gt;&amp;lt;&lt;/span&gt;&lt;span style="color: #4b69c6;"&gt;lightning-vertical-navigation-item-badge&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt; &lt;/span&gt;&lt;span style="color: #8190a0; font-style: italic;"&gt;label&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt;=&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;New&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt; &lt;/span&gt;&lt;span style="color: #8190a0; font-style: italic;"&gt;name&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt;=&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;New&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt; &lt;/span&gt;&lt;span style="color: #8190a0; font-style: italic;"&gt;badge-count&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt;=&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;9&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt; &lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #8190a0; font-style: italic;"&gt;   onclick&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt;=&lt;/span&gt;&lt;span style="color: #448c27;"&gt;{redirectNewLeadListView}&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt; &lt;/span&gt;&lt;span style="color: #8190a0; font-style: italic;"&gt;data-id&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt;=&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;00B3C000008JexJUAS&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #91b3e0;"&gt;  &amp;lt;/&lt;/span&gt;&lt;span style="color: #4b69c6;"&gt;lightning-vertical-navigation-item-badge&lt;/span&gt;&lt;span style="color: #91b3e0;"&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;br /&gt;
Js&lt;br /&gt;
&lt;br /&gt;
&lt;div style="background-color: whitesmoke; color: #333333; font-family: menlo, monaco, &amp;quot;courier new&amp;quot;, monospace; font-size: 12px; line-height: 18px; white-space: pre;"&gt;
&lt;div&gt;
&lt;span style="color: #aa3731; font-weight: bold;"&gt;redirectNewLeadListView&lt;/span&gt;&lt;span style="color: #777777;"&gt;(&lt;/span&gt;&lt;span style="color: #7a3e9d;"&gt;event&lt;/span&gt;&lt;span style="color: #777777;"&gt;)&lt;/span&gt; &lt;span style="color: #777777;"&gt;{&lt;/span&gt;  &lt;/div&gt;
&lt;div&gt;
        &lt;span style="color: #7a3e9d;"&gt;var&lt;/span&gt; &lt;span style="color: #7a3e9d;"&gt;recordIds&lt;/span&gt; &lt;span style="color: #777777;"&gt;=&lt;/span&gt; &lt;span style="color: #7a3e9d;"&gt;event&lt;/span&gt;&lt;span style="color: #777777;"&gt;.&lt;/span&gt;&lt;span style="color: #7a3e9d;"&gt;target&lt;/span&gt;&lt;span style="color: #777777;"&gt;.&lt;/span&gt;&lt;span style="color: #7a3e9d;"&gt;dataset&lt;/span&gt;&lt;span style="color: #777777;"&gt;.&lt;/span&gt;&lt;span style="color: #7a3e9d;"&gt;id&lt;/span&gt;&lt;span style="color: #777777;"&gt;;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="color: #777777;"&gt;        &lt;/span&gt;&lt;span style="color: #aaaaaa; font-style: italic;"&gt;//window.alert(recordIds);&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
        &lt;span style="color: #9c5d27;"&gt;this&lt;/span&gt;[&lt;span style="color: #7a3e9d;"&gt;NavigationMixin&lt;/span&gt;&lt;span style="color: #777777;"&gt;.&lt;/span&gt;&lt;span style="color: #7a3e9d;"&gt;Navigate&lt;/span&gt;](&lt;span style="color: #777777;"&gt;{&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
            &lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;type&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #777777;"&gt;:&lt;/span&gt; &lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;standard__webPage&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #777777;"&gt;,&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
            &lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;attributes&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #777777;"&gt;:&lt;/span&gt; &lt;span style="color: #777777;"&gt;{&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
                &lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;url&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #777777;"&gt;:&lt;/span&gt; &lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #448c27;"&gt;/communityPage/s/recordlist/Lead/Default?Lead-filterId=&lt;/span&gt;&lt;span style="color: #777777;"&gt;"&lt;/span&gt;&lt;span style="color: #777777;"&gt;+&lt;/span&gt;&lt;span style="color: #7a3e9d;"&gt;recordIds&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
            &lt;span style="color: #777777;"&gt;}&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
        &lt;span style="color: #777777;"&gt;}&lt;/span&gt;)&lt;span style="color: #777777;"&gt;;&lt;/span&gt; &lt;/div&gt;
&lt;div&gt;
    &lt;span style="color: #777777;"&gt;}&lt;/span&gt;  &lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2020/06/lwc-navigation-in-lightning-community.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-1705686345211412295</guid><pubDate>Tue, 25 Oct 2016 02:32:00 +0000</pubDate><atom:updated>2016-10-25T03:32:04.217+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Apex</category><category domain="http://www.blogger.com/atom/ns#">Force</category><category domain="http://www.blogger.com/atom/ns#">SalesForce</category><category domain="http://www.blogger.com/atom/ns#">VisualForce</category><title>Journey to Salesforce</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #444444; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"&gt;Hello Guys,&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #444444; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style="color: #444444; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"&gt;Thanks for following me. till now you have seen all .NET related post on my blog.&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #444444; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style="color: #444444; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"&gt;going forward you will also see &lt;b&gt;salesforce &lt;/b&gt;related post in my blog. I have recently started learning the salesforce. I'll keep posting tips / tricks and useful notes through this channel.&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #444444; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style="color: #444444; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"&gt;so stay tune and follow me on this new journey. Thank you ..&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #444444; font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;
&lt;br /&gt;&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2016/10/journey-to-salesforce.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-7625987983225189468</guid><pubDate>Sat, 07 Jun 2014 05:09:00 +0000</pubDate><atom:updated>2014-06-20T05:21:31.416+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ajax</category><category domain="http://www.blogger.com/atom/ns#">CSS</category><category domain="http://www.blogger.com/atom/ns#">Html</category><category domain="http://www.blogger.com/atom/ns#">javascript</category><category domain="http://www.blogger.com/atom/ns#">jQuery</category><category domain="http://www.blogger.com/atom/ns#">xml</category><title>Jquery shake effect - part 2</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Hurrey 100th post , and again on &lt;a href="http://codingstuffsbykiran.blogspot.com/search/label/jQuery" target="_blank"&gt;Jquery &lt;/a&gt;:)&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Jquery shake effect is very popular &amp;amp; more searchable topic now a days.&lt;br /&gt;&lt;br /&gt;Long back i had written a post on jquery shake effect. this is my part 2 post where here I'm going to explain what all method and what option you may find in &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;JRumble plugin&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;You must have seen that vibrant, rotate, shake and many other elements of effects. using css and other scripting language you can create more eye catch able effects.&lt;br /&gt;&lt;br /&gt;&lt;b&gt;JRumble &lt;/b&gt;is new plugin which has more elements on effects. it also a good plugin with hover and direction effect.&lt;br /&gt;&lt;br /&gt;Below are few objects &lt;br /&gt;&lt;span style="color: #4c1130;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #4c1130;"&gt;&lt;span style="background-color: white;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp; $('imgName').jrumble();&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp; // you may stop the elements like this way&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp; $('imgName').trigger('stopRumble');&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;You many even customize this options with below attributes:&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;b&gt;Rotation &lt;/b&gt;: set the range , default is 1&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;b&gt;Speed &lt;/b&gt;: set&amp;nbsp; frequency or speed between the two movements&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;b&gt;X&lt;/b&gt; : set horizontal pixels&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;b&gt;Y&lt;/b&gt; : set vertical pixels&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;and there are many other elements.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;The below code shows the example along with basic functionality. &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;$(document).ready(function() {&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; $('ImageName').jrumble({&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; y:4,&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; x:3,&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; rotation: 10,&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; speed:500,&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; opacity:100&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; });&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; $('ImageName').hover(function() {&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $(this).trigger('startRumble');&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; }, function() {&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $(this).trigger('stopRumble');&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; });&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;});​&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;br /&gt;See the below example :&lt;br /&gt;&lt;br /&gt;
&lt;iframe allowfullscreen="allowfullscreen" frameborder="1" src="http://jsfiddle.net/jquerybyexample/UdbqD/embedded/result,js,html" style="height: 180px; width: 100%;"&gt;&lt;/iframe&gt;   &lt;br /&gt;

&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2014/06/jquery-shake-effect-part-2.html</link><author>noreply@blogger.com (kiran)</author><thr:total>3</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-563035814822296223</guid><pubDate>Sun, 26 Jan 2014 05:48:00 +0000</pubDate><atom:updated>2014-01-26T06:48:03.588+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">c#</category><category domain="http://www.blogger.com/atom/ns#">Interview Question</category><category domain="http://www.blogger.com/atom/ns#">WCF</category><title>which binding we used for WCF REST protocol</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;In
 my previous post i explained, &lt;a href="http://codingstuffsbykiran.blogspot.com/2013/12/interview-questions-on-wcf.html" target="_blank"&gt;Interview question&lt;/a&gt; and few details on &lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/WCF" target="_blank"&gt;WCF&lt;/a&gt;. and &lt;a href="http://codingstuffsbykiran.blogspot.com/2013/12/transactions-in-wcf.html" target="_blank"&gt;Transaction in WCF&amp;nbsp;&lt;/a&gt; Now in this article i will explain which binding used during the WCF REST protocol.&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;most of the time this question may asked during the interview , Yes its simple.&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;For WCF REST used WebHttpBinding. You may enabled WebHttpBinding by as shown in the below code snippet. &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;endpointBehaviors&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;behavior name="NewBehavior0"&amp;gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;webHttp /&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/behavior&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/endpointBehaviors&amp;gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;You can find more details here.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;iframe allowfullscreen="" frameborder="0" height="360" src="//www.youtube.com/embed/YXIee3pcG7E?feature=player_embedded" width="640"&gt;&lt;/iframe&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2014/01/which-binding-we-used-for-wcf-rest.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-1446290418342499351</guid><pubDate>Sat, 28 Dec 2013 14:39:00 +0000</pubDate><atom:updated>2013-12-30T16:28:06.372+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Asp.Net</category><category domain="http://www.blogger.com/atom/ns#">c#</category><category domain="http://www.blogger.com/atom/ns#">WCF</category><title>Transactions in WCF</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;In
 my previous post i explained, &lt;a href="http://codingstuffsbykiran.blogspot.com/2013/12/interview-questions-on-wcf.html" target="_blank"&gt;Interview question&lt;/a&gt; and few details on &lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/WCF" target="_blank"&gt;WCF&lt;/a&gt;. Now in this article i will explain how &lt;span style="color: #990000;"&gt;WCF Transaction protocol. &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #990000;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;Transaction
 is an important factor in any business application which contain CRUD 
operations. Here in WCF we have TransactionScope class which basically 
manages the transaction and also detech the transaction scope.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #990000;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span dir="ltr"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;for
 ex. If your calling multiple methods and if any of method fails, then 
entire transaction will be rolled back unless its outside boundary of 
Scope.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;
&lt;/span&gt;&lt;/span&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;u&gt;WCF supports transaction on below bindings.&lt;/u&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;
&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #990000;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;1.&amp;nbsp; WSHttpBinding&lt;br /&gt;

2.&amp;nbsp; WSFederationHttpBinding&lt;br /&gt;

3.&amp;nbsp; NetNamedPipeBinding&lt;br /&gt;

4.&amp;nbsp; NetTcpBinding&lt;br /&gt;

5.&amp;nbsp; WSDualHttpBinding&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #990000;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;You need to specify the TransactionFlow attribute on all the contracts where it required transaction to be handled. &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #990000;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;where
 we have to specified that transaction are allowed for this specific 
method by assigning enum as 'TransactionFlowOption.Allowed'&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt; &lt;/span&gt;&lt;/span&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;blockquote class="tr_bq" style="text-align: left;"&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;[ServiceContract]&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
public interface IUserDetails&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
{&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; [OperationContract]&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; [TransactionFlow(TransactionFlowOption.Allowed)]&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; public void DeleteUserData();&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; [OperationContract]&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; [TransactionFlow(TransactionFlowOption.Allowed)]&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp; public void UpdateUserData();&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
}&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;there are following option present in TransactionFlow attribute.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;b&gt;TransactionFlowOption.Allowed&lt;/b&gt; :Transaction can be flowed.&lt;br /&gt;

&lt;b&gt;TransactionFlowOption.NotAllowed&lt;/b&gt;: Transaction should not be flowed. This is default. &lt;br /&gt;

&lt;b&gt;TransactionFlowOption.Mandatory&lt;/b&gt;: Transaction must be flowed.&lt;/span&gt;&lt;/span&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;Now implementing 'TransactionScopeRequired' attribute on specific method.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;[OperationBehavior(TransactionScopeRequired = true)]&lt;br /&gt;

public void UpdateUserData()&lt;br /&gt;

{&lt;br /&gt;

&amp;nbsp; // database call goes here.&lt;br /&gt;

}&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;Once the scope assing, the last process will be enabling the transaction flow in config file.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt; &lt;bindings&gt;&lt;wshttpbinding&gt;&lt;binding name="TransactionalBind" transactionflow="true"&gt;&lt;br /&gt;

&amp;nbsp;&lt;/binding&gt;&lt;/wshttpbinding&gt;&lt;br /&gt;

&lt;/bindings&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;Now
 consume the service by calling the UpdateUserData method and assign the
 scope block which check if the transaction method fails, if so then it 
will automatically rollback it.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;using (TransactionScope Transcope = new TransactionScope())&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
{&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp; try&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;

{&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp; Services.UserDetailsService.UserDetailsServiceClient()&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp; clientVal = new Services.UserDetailsService.UserDetailsServiceClient();&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&amp;nbsp;&amp;nbsp; // code goes here to call method and assing the value.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&amp;nbsp;&amp;nbsp; scope.Complete(); &lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&amp;nbsp;}&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
catch (Exception ex)&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #20124d;"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;span style="font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
{&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
scope.Dispose();&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
}&amp;nbsp;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span dir="ltr"&gt;&lt;span dir="ltr"&gt;&lt;span dir="ltr"&gt;&lt;span dir="ltr"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span dir="ltr"&gt;&lt;span dir="ltr"&gt;&lt;span dir="ltr"&gt;}&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span dir="ltr"&gt;&lt;span dir="ltr"&gt;&lt;span dir="ltr"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span dir="ltr"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;I
 know this will helps to understand the concepts of transaction in WCF , 
if you have any query or suggestion please put your comments to know 
more.&lt;/span&gt;&lt;span style="font-size: small;"&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #990000;"&gt;&lt;span style="color: #003366; font-family: Verdana;"&gt;&lt;span dir="ltr"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/12/transactions-in-wcf.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-2827496510212968683</guid><pubDate>Sat, 21 Dec 2013 08:46:00 +0000</pubDate><atom:updated>2013-12-21T09:53:17.135+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Sql</category><category domain="http://www.blogger.com/atom/ns#">SQL scripts</category><title>Change schema name of tables, store procedure, views and functions</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Today i come across one situation where i need to changes my current &lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/Sql" target="_blank"&gt;SQL&lt;/a&gt; schema to some other name. due to client requirement.so i searched few article and decided to write one article on same&lt;br /&gt;&lt;br /&gt;Below query will returns list of all tables along with the schema name from your database.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;blockquote&gt;
&lt;span style="color: #990000;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;SELECT TABLE_SCHEMA, TABLE_NAME&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;FROM INFORMATION_SCHEMA.TABLES&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;If you want to add new schema you need to add that into sys.schemas table then only it will be accessible else it will give an error message as&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;i&gt;&amp;nbsp;Cannot alter the schema 'xxx', because it does not exist or you do not have permission.&lt;/i&gt;&lt;br /&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #990000;"&gt;IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'Excprod'))&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #990000;"&gt;BEGIN&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #990000;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; EXEC ('CREATE SCHEMA [Excprod] AUTHORIZATION [dbo]')&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #990000;"&gt;END&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;You can also view list of schema from below query and you will find new schema "Excprod" get added.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;b&gt;SELECT * FROM sys.schemas&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;Now, below query used to alter the scheme tables&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;blockquote&gt;
&lt;span style="color: #990000;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;ALTER SCHEMA Excprod TRANSFER dbo.Temp1&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;ALTER SCHEMA Excprod TRANSFER dbo.Temp2&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;ALTER SCHEMA Excprod TRANSFER dbo.temp3&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;You may also alter the schema for store procedure as well. to find the list of all store procedures from your&lt;br /&gt;database just use.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;blockquote&gt;
&lt;span style="color: #990000;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;select * from information_schema.routines&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;where routine_type = 'PROCEDURE'&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;below query will generate the select statement for all list of sp&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #990000;"&gt;select 'ALTER SCHEMA Excprod TRANSFER ' + SPECIFIC_SCHEMA + '.' + ROUTINE_NAME&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #990000;"&gt;from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='procedure'&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Result will be :&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;blockquote&gt;
&lt;span style="color: #990000;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;ALTER SCHEMA Excprod TRANSFER synprod.Usp_Response&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;ALTER SCHEMA Excprod TRANSFER synprod.Usp_Request&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;To view list of view from database use this&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;span style="color: #990000;"&gt;SELECT * FROM information_schema.VIEWS&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #990000;"&gt;&lt;span style="color: #0c343d;"&gt;Please comment if you want more details on this.&lt;/span&gt; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/12/change-schema-name-of-tables-store.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-4439124787855928147</guid><pubDate>Wed, 11 Dec 2013 15:37:00 +0000</pubDate><atom:updated>2013-12-11T16:37:58.828+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">c#</category><category domain="http://www.blogger.com/atom/ns#">WCF</category><title>Interview questions on WCF</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;Today i would like to share something about WCF, This is my first post on Windows Communication Foundation (WCF). since last 1 year i worked on WCF, so i would like to share my experience/points with you.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;First will see what exactly 
mean by WCF . It's &lt;/span&gt;&lt;span style="font-size: small;"&gt;Microsoft&lt;/span&gt;&lt;span style="font-size: small;"&gt; programming model which helps for building 
service-oriented application.&lt;/span&gt; &lt;span style="font-size: small;"&gt;where we can send/ received the data &lt;/span&gt;&lt;span style="font-size: small;"&gt;asynchronously&lt;/span&gt;&lt;span style="font-size: small;"&gt;. service endpoint is the main channel where client can request data.&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;br /&gt;&lt;span style="font-size: small;"&gt;

&lt;b&gt;It has very good features &lt;/b&gt;&lt;/span&gt;:&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;br /&gt;&lt;span style="font-size: small;"&gt;

1. Extensibility &lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;

2. Interoperability&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;

3. Data Contracts&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;

4. Security&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;

5. Transactions&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;

6. AJAX and REST Support&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0; margin-top: 0;"&gt;
&lt;span style="font-size: small;"&gt;You may refer more &lt;/span&gt;&lt;span style="font-size: small;"&gt;&lt;a href="http://msdn.microsoft.com/en-us/library/dd456779(v=vs.110).aspx" rel="nofollow" target="_blank"&gt;about wcf here &lt;/a&gt;&lt;/span&gt;&lt;br /&gt;

&lt;/div&gt;
&lt;div style="margin-bottom: 0; margin-top: 0;"&gt;
&amp;nbsp;&lt;/div&gt;
&lt;div style="margin-bottom: 0; margin-top: 0;"&gt;
&amp;nbsp;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;Below &lt;span style="color: #351c75;"&gt;&lt;b&gt;interview question&lt;/b&gt;&lt;/span&gt; helps you to know more about WCF.&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0; margin-top: 0;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #073763;"&gt;1.How session management worked in WCF?&lt;/span&gt;&lt;br /&gt;

answer - WCF manage the session by instanciating the service class. It 
basically used the Instance Context class to manage the server side at 
server side. you can refer more about Session management in WCF.&lt;/span&gt;&lt;br /&gt;

&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;2. Is overloading possible in WCF? and How?&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;

Yes method overloading is possbile in WCF. But yes it will raise the error as contract mismatch during method overload. &lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;

By providing the unique operationcontract name you can resolved that 
issue. It has Name property which expose the wcf method to schemas.&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;Look at the below example.&lt;/span&gt;&lt;br /&gt;&lt;span style="font-size: small;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #660000;"&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;[ServiceContract]&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

public interface ICalculate&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

{&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

&amp;nbsp;&amp;nbsp;&amp;nbsp; [OperationContract(Name="ADD")]&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

&amp;nbsp;&amp;nbsp;&amp;nbsp; string methodName(int x,int y);&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

&amp;nbsp;&amp;nbsp;&amp;nbsp; [OperationContract(Name = "DISPLAY")]&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

&amp;nbsp;&amp;nbsp;&amp;nbsp; string methodName(string val1, string val2);&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

}&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;all the method get called by their attribute name and parameter value.&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;for ex&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #660000;"&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;ClientApp client = new ClientApp();&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

string method1 = client.methodName(1, 1);&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="color: #660000;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana; font-size: x-small;"&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;

string method2 = client.methodName("sample1", "sample2");&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;
&lt;div style="margin-bottom: 0; margin-top: 0;"&gt;
&lt;br /&gt;

&lt;span style="font-size: small;"&gt;3.how to track no of visit to your service.&lt;br /&gt;

WCF has very good feature which enable us to manage the service call. with the help of this you can easily track the count. &lt;b&gt;extension point&lt;/b&gt; is used.&lt;/span&gt;&lt;br /&gt;

&lt;/div&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;&lt;br /&gt;

4. list types of binding and have you worked on netMsmqBinding or netNamedPipeBinding ?&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-size: small;"&gt;If you know more unique questions, please do share it.&lt;/span&gt;&lt;/div&gt;
&lt;/span&gt;&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/12/interview-questions-on-wcf.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-6989881545316680193</guid><pubDate>Sat, 23 Nov 2013 05:40:00 +0000</pubDate><atom:updated>2013-11-23T06:40:39.883+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Asp.Net</category><category domain="http://www.blogger.com/atom/ns#">c#</category><category domain="http://www.blogger.com/atom/ns#">xml</category><title>creating word documents using open xml with asp.net</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;In my previous post i explained, &lt;a href="http://codingstuffsbykiran.blogspot.in/2013/11/microsoftofficeinteropword-how-to.html" target="_blank"&gt;how to prevent word file opening during the usage of Interop object&lt;/a&gt; using&amp;nbsp;&lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/c%23" target="_blank"&gt; C#&lt;/a&gt; and &lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/Asp.Net" target="_blank"&gt;asp.net&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Now
 in this article i will explain how to use the Office Open XML C# (alternate solution to the Interop object.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;The Open XML provides you set of .NET API. It helps helps you manipulate and creating the documents in the Open XML Formats &lt;br /&gt;in both the environments (i.e client and server both) and that is without help of MS office applications.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Before using Open XML Format, you have to add the below namespaces in your C# class. Add references to the Packaging and Spreadsheet API components with the following code.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #741b47;"&gt;using DocumentFormat.OpenXml;&lt;br /&gt;using DocumentFormat.OpenXml.Packaging;&lt;br /&gt;using DocumentFormat.OpenXml.Wordprocessing;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/blockquote&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #741b47;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt; &lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Here is the &lt;/span&gt;&lt;/span&gt;&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;CreateOpenXmlDocument &lt;/span&gt;&lt;/span&gt;function where you need to pass the filepath and it will created that doc file on specified positionl&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;public void CreateOpenXmlDocument(string filepath)&lt;br /&gt;{&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;using (WordprocessingDocument wordDocument = WordprocessingDocument.Create(filepath, WordprocessingDocumentType.Document))&lt;br /&gt;&amp;nbsp; {&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; // Add a main document part.&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; MainDocumentPart mainPart = wordDocument.AddMainDocumentPart();&lt;br /&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; mainPart.Document = new Document();&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Body body = mainPart.Document.AppendChild(new Body());&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Paragraph para = body.AppendChild(new Paragraph());&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Run run = para.AppendChild(new Run());&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; run.AppendChild(new Text("Create text sample text, coding stuffs daily..."));&lt;br /&gt;&amp;nbsp; }&lt;br /&gt;}&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #3d85c6;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Here now i am integrating that function into my page_load event.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;span style="color: #3d85c6;"&gt;protected void Page_Load(object sender, EventArgs e)&lt;br /&gt;{&lt;br /&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; string FilePath =&amp;nbsp; @"C:\\Temp";&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; CreateWordprocessingDocument(FilePath);&lt;br /&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; FileInfo myDoc = new FileInfo(FilePath);&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Response.Clear();&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Response.ContentType = "Application/msword";&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Response.AddHeader("content-disposition", "attachment;filename=" + myDoc.Name);&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Response.AddHeader("Content-Length", myDoc.Length.ToString());&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Response.ContentType = "application/octet-stream";&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Response.WriteFile(myDoc.FullName);&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Response.End();&lt;br /&gt;&lt;br /&gt;}&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #3d85c6;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #3d85c6;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #3d85c6;"&gt;This is just an sample doc creation , you may even format the document with adding images, graphs, style to para and may more. Just refer this &lt;a href="http://msdn.microsoft.com/en-us/library/dd452407%28v=office.12%29.aspx" rel="nofollow" target="_blank"&gt;Microsoft article&lt;/a&gt; on how to do this.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #3d85c6;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #3d85c6;"&gt;feel free to raise your suggestion/comments on this. Thanks you and happy coding....&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #741b47;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #741b47;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #741b47;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/11/creating-word-documents-using-open-xml.html</link><author>noreply@blogger.com (kiran)</author><thr:total>1</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-8290235670141834922</guid><pubDate>Tue, 12 Nov 2013 12:19:00 +0000</pubDate><atom:updated>2013-11-12T13:26:50.856+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Asp.Net</category><category domain="http://www.blogger.com/atom/ns#">c#</category><category domain="http://www.blogger.com/atom/ns#">Div</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>Microsoft.Office.Interop.Word how to prevent word file opening </title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;div style="text-align: left;"&gt;
&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;In my previous post i explained, how to &lt;a href="http://codingstuffsbykiran.blogspot.in/2013/10/convert-dataset-to-xml-string-using-c.html" target="_blank"&gt;Convert the dataset to xml string&lt;/a&gt; using&amp;nbsp;&lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/c%23" target="_blank"&gt; C#&lt;/a&gt; and &lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/Asp.Net" target="_blank"&gt;asp.net&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Now in this article i will explain how to prevent the word file opening, i have bunch of word document and i want to read/search text value out of it.&amp;nbsp; i tried that using Microsoft.office.Interop.Word object.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;Here is the sample code which prevent the word to opening the main window.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="background-color: #cfe2f3;"&gt;private void PreventOpenWord(string Filepath)&lt;br /&gt;{&lt;br /&gt;&amp;nbsp;Application word = new Application();&lt;br /&gt;&amp;nbsp;FileInfo fileInfo = (FileInfo)file;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;object save = false;&lt;br /&gt;object confirmConversion = false;&lt;br /&gt;object visible = false;&lt;br /&gt;object skipEncodingDialog = true;&lt;br /&gt;object readOnly = true;&lt;br /&gt;object filename = fileInfo.FullName;&lt;br /&gt;&lt;br /&gt;word.Visible = false;&lt;br /&gt;&lt;br /&gt;Document srcDoc = word.Documents.Open(ref Filepath, ref confirmConversion, ref readOnly, ref missing,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; ref missing, ref missing, ref missing, ref missing,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; ref missing, ref missing, ref missing, ref visible,&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; ref missing, ref missing, ref skipEncodingDialog, ref missing);&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="background-color: #cfe2f3;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="background-color: #cfe2f3;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="background-color: #cfe2f3;"&gt;foreach (Microsoft.Office.Interop.Word.Range docRange in doc.Words)&lt;br /&gt;{&lt;br /&gt;if (docRange.Text.Trim().Equals(textToFind,&lt;br /&gt;StringComparison.CurrentCultureIgnoreCase))&lt;br /&gt;{&lt;br /&gt;&amp;nbsp;&amp;nbsp; &lt;br /&gt;IsWordFound = true;&lt;br /&gt;break;&lt;br /&gt;}&lt;br /&gt;}&lt;br /&gt;}&lt;br /&gt;catch (Exception ex)&lt;br /&gt;{&lt;br /&gt;&amp;nbsp;Response.Write("Error while reading file : " + ex.Message);&lt;br /&gt;}&lt;br /&gt;}&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="background-color: #cfe2f3;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="background-color: #cfe2f3;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="background-color: white;"&gt;Hope this will helps you.. Happy&amp;nbsp; coding..&amp;nbsp;&lt;/span&gt; &lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/11/microsoftofficeinteropword-how-to.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-2163257929388365522</guid><pubDate>Sun, 27 Oct 2013 12:56:00 +0000</pubDate><atom:updated>2013-10-27T13:56:55.573+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">c#</category><category domain="http://www.blogger.com/atom/ns#">Sql</category><category domain="http://www.blogger.com/atom/ns#">SQL scripts</category><title>Convert Dataset to xml string using C#</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;In my previous post i explained, &lt;a href="http://codingstuffsbykiran.blogspot.com/2013/09/save-images-to-database-using-sql.html" target="_blank"&gt;Save images to database using SQL.&lt;/a&gt; &lt;a href="http://codingstuffsbykiran.blogspot.in/2009/09/count-string-occurrence.html" target="_blank"&gt;Count string occurrence&lt;/a&gt; and much more articles realted with asp.net, SQL. Now in this article i will going to explain how to Convert the dataset to xml string using&amp;nbsp;&lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/c%23" target="_blank"&gt; C#&lt;/a&gt; and &lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/Asp.Net" target="_blank"&gt;asp.net&amp;nbsp;&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;br /&gt;below is the short and sweet way to convert the dataset into &lt;a href="http://codingstuffsbykiran.blogspot.in/search/label/xml" target="_blank"&gt;xml&lt;/a&gt;.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #0c343d;"&gt;DataSet dsUser = new DataSet();&lt;br /&gt;&lt;br /&gt;SqlCommand cmdSelect = new SqlCommand("select name,age,location,ph,cell,status from userDetails ", conn);&lt;br /&gt;&lt;br /&gt;SqlDataAdapter sda = new SqlDataAdapter(cmdSelect);&lt;br /&gt;&lt;br /&gt;da.Fill(dsUser);&lt;br /&gt;&lt;br /&gt;string strUserDetails = dsUser.GetXml();&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/blockquote&gt;
&lt;br /&gt;
&lt;span style="color: #134f5c;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;Its very simple and easy method. Please post your comments for any suggestion. &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/10/convert-dataset-to-xml-string-using-c.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-4354337485696901570</guid><pubDate>Sat, 19 Oct 2013 06:35:00 +0000</pubDate><atom:updated>2013-10-19T07:44:05.564+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Html</category><category domain="http://www.blogger.com/atom/ns#">jQuery</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>Access content of iframe using jquery</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;It's very simple and straightforward.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;Lets say, your using &lt;b&gt;iframe &lt;/b&gt;and &lt;b&gt;hello.aspx&lt;/b&gt; page like&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #003366; font-size: small;"&gt;&lt;span style="color: #003366;"&gt;&lt;span style="color: #003366;"&gt;1. &lt;span style="color: #3d85c6;"&gt;&amp;lt; iframe id="frametemp" height="20px" width="90px"&amp;gt; &amp;lt;/iframe&amp;gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #003366; font-size: small;"&gt;&lt;span style="color: #003366;"&gt;&lt;span style="color: #003366;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #003366; font-size: small;"&gt;&lt;span style="color: #003366;"&gt;&lt;span style="color: #003366;"&gt;which contain some control likes&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #003366; font-size: small;"&gt;&lt;span style="color: #003366;"&gt;&lt;span style="color: #003366;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #003366; font-size: small;"&gt;&lt;span style="color: #003366;"&gt;&lt;span style="color: #003366;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366;"&gt;&lt;span dir="ltr"&gt;2.&lt;span style="color: #3d85c6;"&gt;&lt;span style="color: #003366;"&gt; &lt;span style="color: #3d85c6; font-size: small;"&gt;&amp;lt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size: small;"&gt;div id="divDisplayBox" &amp;gt; Say, Hello world! &amp;lt;/div&amp;gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-size: small;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366;"&gt;&lt;span dir="ltr"&gt;you can use .contents() method to find the specific id and like&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="color: #003366;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366;"&gt;&lt;span dir="ltr"&gt;&lt;span style="color: #003366;"&gt;&lt;span dir="ltr"&gt;3.&lt;span style="color: #3d85c6;"&gt; &lt;span style="font-size: small;"&gt;$('#frametemp').contents().find('#divDisplayBox').html();&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style="font-size: small;"&gt;Hope this will helps you, Put your comments/suggestion if any.&lt;/span&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;
&lt;/span&gt;&lt;span style="font-family: Verdana,sans-serif; font-size: small;"&gt;
&lt;/span&gt;&lt;span style="font-family: Verdana,sans-serif; font-size: small;"&gt;



&lt;/span&gt;&lt;div style="margin-bottom: 0px; margin-top: 0px;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;
&lt;/span&gt;&lt;div style="margin-bottom: 0; margin-top: 0;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style="margin-bottom: 0; margin-top: 0;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/span&gt;&amp;nbsp;&lt;/span&gt; &lt;/span&gt;&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/10/access-content-of-iframe-using-jquery.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-2996620980080657354</guid><pubDate>Sat, 28 Sep 2013 06:06:00 +0000</pubDate><atom:updated>2013-09-28T07:06:56.292+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Sql</category><category domain="http://www.blogger.com/atom/ns#">SQL scripts</category><title>Save images to database using SQL </title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-family: Verdana, sans-serif; font-size: x-small;"&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-family: Verdana, sans-serif; font-size: small;"&gt;Most of the time we want to save store/save images to database. In order to store image on sql server we need to store that in binary format. the most easiest way to do so in execute the SQL OPENROWSET command with SINGLE BLOB &amp;amp; BULK options.&lt;/span&gt;&lt;/div&gt;
&lt;span style="color: #073763; font-size: small;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-family: Verdana, sans-serif; font-size: small;"&gt;Let's create one sample table and insert the sample result in it.&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-size: small;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-size: small;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="color: #073763; font-size: small;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #674ea7;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;create table imageSave&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #674ea7;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;(&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #674ea7;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&amp;nbsp;&amp;nbsp; [img_name] varchar(250),&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #674ea7;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&amp;nbsp;&amp;nbsp; [Img_binary] varbinary(max)&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #674ea7;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;)&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/blockquote&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-family: Verdana, sans-serif; font-size: small;"&gt;will insert some sample result into the imageSave table.&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-size: small;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;blockquote&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;Insert into imageSave&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #351c75;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;SELECT 'SAMPLE Image', *&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #351c75;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="color: #351c75;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;FROM OPENROWSET(BULK N'F:\Images\sample-test.jpg', SINGLE_BLOB) image; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/blockquote&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-size: small;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-size: small;"&gt;&lt;span style="font-family: Verdana, sans-serif;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763; font-family: Verdana, sans-serif; font-size: small;"&gt;Admin(sa) &amp;amp; developer has rights to work with OPENROWSET command.&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="color: #073763;"&gt;&lt;br /&gt;&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style="text-align: left;"&gt;
&lt;span style="font-family: Verdana, sans-serif; font-size: x-small;"&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/09/save-images-to-database-using-sql.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-633737654538366606</guid><pubDate>Tue, 24 Sep 2013 16:10:00 +0000</pubDate><atom:updated>2013-09-24T17:10:30.252+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Asp.Net</category><category domain="http://www.blogger.com/atom/ns#">c#</category><title>Find Header &amp; Footer template from Repeater control in .Net</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;This article will explain you how to find the Repeater Header and Footer template details.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;I had created one user control which contain the Repeater. It generate the product showcase. i used that control in multiple pages but some where i need to update few details like header title , footer text at run time and that i have achieved it through find control.&lt;br /&gt;Below example can helps you to understand the clear idea.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;&amp;lt;asp:Repeater ID="ProductsDetails" runat="server"&amp;gt;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;lt;HeaderTemplate&amp;gt;&amp;nbsp; &lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;asp:Label ID="lblProductDetails" runat="server" Fore-Color= "Red"&amp;nbsp; Font-Bold = "true" /&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;lt;br /&amp;gt;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;lt;/HeaderTemplate&amp;gt;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;lt;ItemTemplate&amp;gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;Product Name : &amp;lt;%#Eval("Name") %&amp;gt; &amp;lt;br /&amp;gt;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;lt;/ItemTemplate&amp;gt;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;lt;FooterTemplate&amp;gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;&amp;lt;asp:Label ID="lblPriceDetails" runat="server" Fore-Color= "Green" Font-Bold = "true" /&amp;gt;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;lt;/FooterTemplate&amp;gt;&lt;br /&gt;&amp;lt;/asp:Repeater&amp;gt; &lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;Here
 i have define repeater control along with header &amp;amp; footer details ,
 now i want to change the text of label called "lblProductDetails" at run-time. below snippets will helps you to get the Repeater details and base on that you can easily find the footer&amp;nbsp; &amp;amp; header controls&amp;nbsp; and change the text.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;&lt;b&gt;//Find HeaderTemplate&lt;/b&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp; Control TempHeaderDet = ProductsDetails.Controls[0].Controls[0];&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;&amp;nbsp; Label lblHeaderDet = TempHeaderDet.FindControl("lblProductDetails") as Label;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;&amp;nbsp; lblHeaderDet.Text = "Product Description :";&lt;br /&gt;&lt;br /&gt;&lt;b&gt;//Find FooterTemplate&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp; Control FooterTemplateDet = ProductsDetails.Controls[ProductsDetails.Controls.Count - 1].Controls[0];&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;&amp;nbsp; Label lblFooterDet = FooterTemplateDet.FindControl("lblPriceDetails") as Label;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;&amp;nbsp;&amp;nbsp; lblFooter.Text = "Product Price:";&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;Yeap, i know its not very big deal... but yes some time this trick will helps you and save time as well.&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #003366; font-family: Verdana; font-size: x-small;"&gt;&lt;span dir="ltr" style="font-size: 10pt;"&gt;put your comments/ question in case of any concerns. &lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h4 style="text-align: left;"&gt;
&lt;span style="color: #0c343d;"&gt;&lt;span style="font-family: Arial,Helvetica,sans-serif;"&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;a name='more'&gt;&lt;/a&gt;&lt;/h4&gt;
&lt;div style="text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/09/find-header-footer-template-from.html</link><author>noreply@blogger.com (kiran)</author><thr:total>2</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-3332260101172566239</guid><pubDate>Fri, 06 Sep 2013 11:54:00 +0000</pubDate><atom:updated>2013-09-06T12:54:38.015+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Andriod</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>Andriod KitKat</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;Yes, once again andriod version has been named base on dessert. &lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;after the cupcake, donut, Gingerbread, ice-cream sandwish and jelly beans. new decided name of next version of andriod as favourite chocolate "Kit Kat". &lt;/span&gt;&lt;br /&gt;
&lt;h2 style="text-align: left;"&gt;
&lt;span style="color: #45818e;"&gt;Android 4.4 KitKat&lt;/span&gt;&lt;/h2&gt;
&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;As andriod says people can easily remember such name because they can't leave without chocoates. :)&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="color: #073763; font-family: Arial, Helvetica, sans-serif;"&gt;Here are the some versions of Android in Pictures&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style="text-align: center;"&gt;&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdAvX7pLQvNM0Ztdvjqk7H1nmf17-qBOVyb9YXxd1LTpQlozz365ffZOaWFxMnFiORuFeuKCcNrpmyFyyvMa0UCfc7F1QjZNhsgyd16HLVhWbGZ5lp39Fvmz2fxnft-ycrF1PvzYE6cCJT/s1600/1.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdAvX7pLQvNM0Ztdvjqk7H1nmf17-qBOVyb9YXxd1LTpQlozz365ffZOaWFxMnFiORuFeuKCcNrpmyFyyvMa0UCfc7F1QjZNhsgyd16HLVhWbGZ5lp39Fvmz2fxnft-ycrF1PvzYE6cCJT/s1600/1.jpg" /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class="tr-caption" style="text-align: center;"&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAgPJUs2HX7vZsLISverHtnw4o_nEe4xlo3lI1lmd5YdZ-ExhBAVaqM6g-EJ2kDOv5cFyWV8zZ0oxmwkMrgI6mgy8nYmh5F7A43Iq_8bfZPOYjyHNhHxupVcZBbSbBG5sqkDieNVFfkUUV/s1600/2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAgPJUs2HX7vZsLISverHtnw4o_nEe4xlo3lI1lmd5YdZ-ExhBAVaqM6g-EJ2kDOv5cFyWV8zZ0oxmwkMrgI6mgy8nYmh5F7A43Iq_8bfZPOYjyHNhHxupVcZBbSbBG5sqkDieNVFfkUUV/s1600/2.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkaXCD0kavYKVKOJ_Mc67sSnlvMW_ZMuNq8NTvqTYbyszGJfNCyRPJzdg0lZ-91SGu8iEE9q4mzgOA9C4Y3SqCVv6kAoHmzSw3OY4xLCHGPdAQvda1ZaZkYfzF02wtTwjdDRMmjalilMPQ/s1600/3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkaXCD0kavYKVKOJ_Mc67sSnlvMW_ZMuNq8NTvqTYbyszGJfNCyRPJzdg0lZ-91SGu8iEE9q4mzgOA9C4Y3SqCVv6kAoHmzSw3OY4xLCHGPdAQvda1ZaZkYfzF02wtTwjdDRMmjalilMPQ/s1600/3.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNYV5ykhcTXvKjjppwlu95aU0sA1__3vUznfbDKmIvSV51mp91meBe0eF5gcjdWtwjHUx2EhPOXZGsNqZ-yprV6G4X8QTX-1V1P1HcrbHHHH1cEmw_HXMsHQlAnW67Uq1twkPELP9e_xSj/s1600/4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNYV5ykhcTXvKjjppwlu95aU0sA1__3vUznfbDKmIvSV51mp91meBe0eF5gcjdWtwjHUx2EhPOXZGsNqZ-yprV6G4X8QTX-1V1P1HcrbHHHH1cEmw_HXMsHQlAnW67Uq1twkPELP9e_xSj/s1600/4.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6ceEJHuhts3gNNeS3EaEhY_EcN-YrXT8Y4VaFursj4Zt8lKi-dA4Tvrtsg30DNJEycxynoz32ixF3pMiuOoroT2k3k-XDy5NhaFEk3RBg3PgMSdpfckCYfAGnNz7MY4-d6AAlcSDC0JSO/s1600/5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6ceEJHuhts3gNNeS3EaEhY_EcN-YrXT8Y4VaFursj4Zt8lKi-dA4Tvrtsg30DNJEycxynoz32ixF3pMiuOoroT2k3k-XDy5NhaFEk3RBg3PgMSdpfckCYfAGnNz7MY4-d6AAlcSDC0JSO/s1600/5.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl3rpqlB3Hj6eXHAMBvrVm3NBoJJB4HpCdKAapFVoetgRsGSbEZ1WNjq4fNzFeB89178anovLXehfoMTWy3eyXvx3Tv3AtjTaJfYQuy_zsuwyf7P9NB9FnNxKLWYFdrOLrSatMrOgmkWVR/s1600/6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl3rpqlB3Hj6eXHAMBvrVm3NBoJJB4HpCdKAapFVoetgRsGSbEZ1WNjq4fNzFeB89178anovLXehfoMTWy3eyXvx3Tv3AtjTaJfYQuy_zsuwyf7P9NB9FnNxKLWYFdrOLrSatMrOgmkWVR/s1600/6.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIxnvUfDa8q2H6YdmYv7d0rh8v7RpqvJwJ7WG_GDi52pEESvldaHrW79TXEwfEJZmmUtrpGJwRoHDQGbo655I-lYuNSbjQDzEiGenhE6u_iXpMMhMmAs7e_kqm-K3-awg8arCe6i6y7pEd/s1600/7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIxnvUfDa8q2H6YdmYv7d0rh8v7RpqvJwJ7WG_GDi52pEESvldaHrW79TXEwfEJZmmUtrpGJwRoHDQGbo655I-lYuNSbjQDzEiGenhE6u_iXpMMhMmAs7e_kqm-K3-awg8arCe6i6y7pEd/s1600/7.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtw93GSe9_chRjjCiwvJtLdEXbDC7uUvefnRDniJHmGx4XrikvDBBqG9juqUy_WdeO-fKkUDrWUzjdmH85D9cG0ObxvzeyFMJqpcg8e36AraNMUqwR0acxawG0My1Ens4ryDV8egBKkPip/s1600/8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtw93GSe9_chRjjCiwvJtLdEXbDC7uUvefnRDniJHmGx4XrikvDBBqG9juqUy_WdeO-fKkUDrWUzjdmH85D9cG0ObxvzeyFMJqpcg8e36AraNMUqwR0acxawG0My1Ens4ryDV8egBKkPip/s1600/8.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxDBBeH2eChf9oTkGSIVS01qygqBIXpwvmCvGp2nw2OsB3tyZSgW4VTUHgP1sOP3vpuKQNReJbyVkuGMw0gKflt5xskaHRlYo_BT82WNBtAq22dGGCHPXqHpmVLYD4mnO6Vj3U0QK02XhV/s1600/9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" psa="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxDBBeH2eChf9oTkGSIVS01qygqBIXpwvmCvGp2nw2OsB3tyZSgW4VTUHgP1sOP3vpuKQNReJbyVkuGMw0gKflt5xskaHRlYo_BT82WNBtAq22dGGCHPXqHpmVLYD4mnO6Vj3U0QK02XhV/s1600/9.jpg" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;&lt;br /&gt;
&amp;nbsp; 
&amp;nbsp; 
&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;Looks good, isn't it?&lt;/span&gt; 
&lt;span style="font-family: Arial;"&gt;&lt;/span&gt;&amp;nbsp; 
&lt;span style="font-family: Arial, Helvetica, sans-serif;"&gt;Post your comments and queries to know more about &lt;strong&gt;KitKat&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/09/andriod-kitkat.html</link><author>noreply@blogger.com (kiran)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdAvX7pLQvNM0Ztdvjqk7H1nmf17-qBOVyb9YXxd1LTpQlozz365ffZOaWFxMnFiORuFeuKCcNrpmyFyyvMa0UCfc7F1QjZNhsgyd16HLVhWbGZ5lp39Fvmz2fxnft-ycrF1PvzYE6cCJT/s72-c/1.jpg" width="72"/><thr:total>4</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-717539679303232521</guid><pubDate>Sat, 19 Jan 2013 14:05:00 +0000</pubDate><atom:updated>2013-01-19T15:05:30.386+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">c#</category><title>C# zip unzip using window shell </title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;If you want to zip / unzip files using C# code .yes its easy and you can do that without using any third party tools. using simple dll (Windows Shell32) you can do that quickly.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;Just find below steps.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;1.Create new project in Visual Basic 2010.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;2.From the main menu, select Project -&amp;gt; Add Reference.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;3.&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;Select the COM tab and search for Microsoft Shell Controls and Automation.&lt;/span&gt; &lt;/span&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHq9Mq89GpcJVH_VQ5pyfAKKgx4BTFDeZ8vrckku3nqyk68CtIYuNxY234oN6_MsPtgFWNkW-q9ArkhXpVL70sOD1rFZJ0osNQbYYFkw1vMKq-T0X6NxFWF9yX6M2eM60uEs_zoN_0ZG6W/s1600/02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="226" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHq9Mq89GpcJVH_VQ5pyfAKKgx4BTFDeZ8vrckku3nqyk68CtIYuNxY234oN6_MsPtgFWNkW-q9ArkhXpVL70sOD1rFZJ0osNQbYYFkw1vMKq-T0X6NxFWF9yX6M2eM60uEs_zoN_0ZG6W/s320/02.png" width="320" /&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&amp;nbsp;Try using below code and zip/unzip your code.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;pre id="pre0" style="margin-top: 0px;"&gt;&lt;span class="code-keyword"&gt;Public&lt;/span&gt; &lt;span class="code-keyword"&gt;Class&lt;/span&gt; Form1
 
    &lt;span class="code-keyword"&gt;Sub&lt;/span&gt; Zip()
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;1) Lets create an empty Zip File .
&lt;/span&gt;        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;The following data represents an empty zip file .
&lt;/span&gt;
        &lt;span class="code-keyword"&gt;Dim&lt;/span&gt; startBuffer() &lt;span class="code-keyword"&gt;As&lt;/span&gt; &lt;span class="code-keyword"&gt;Byte&lt;/span&gt; = {&lt;span class="code-digit"&gt;80&lt;/span&gt;, &lt;span class="code-digit"&gt;75&lt;/span&gt;, &lt;span class="code-digit"&gt;5&lt;/span&gt;, &lt;span class="code-digit"&gt;6&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, _
                                     &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;, &lt;span class="code-digit"&gt;0&lt;/span&gt;} 
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt; Data for an empty zip file .
&lt;/span&gt;        FileIO.FileSystem.WriteAllBytes(&lt;span class="code-string"&gt;"&lt;/span&gt;&lt;span class="code-string"&gt;d:\empty.zip"&lt;/span&gt;, startBuffer, &lt;span class="code-keyword"&gt;False&lt;/span&gt;)
 
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;We have successfully made the empty zip file .
&lt;/span&gt;
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;2) Use the Shell32 to zip your files .
&lt;/span&gt;        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt; Declare new shell class
&lt;/span&gt;        &lt;span class="code-keyword"&gt;Dim&lt;/span&gt; sc &lt;span class="code-keyword"&gt;As&lt;/span&gt; &lt;span class="code-keyword"&gt;New&lt;/span&gt; Shell32.Shell()
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;Declare the folder which contains the files you want to zip .
&lt;/span&gt;        &lt;span class="code-keyword"&gt;Dim&lt;/span&gt; input &lt;span class="code-keyword"&gt;As&lt;/span&gt; Shell32.Folder = sc.&lt;span class="code-keyword"&gt;NameSpace&lt;/span&gt;(&lt;span class="code-string"&gt;"&lt;/span&gt;&lt;span class="code-string"&gt;D:\neededFiles"&lt;/span&gt;)
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;Declare  your created empty zip file as folder  .
&lt;/span&gt;        &lt;span class="code-keyword"&gt;Dim&lt;/span&gt; output &lt;span class="code-keyword"&gt;As&lt;/span&gt; Shell32.Folder = sc.&lt;span class="code-keyword"&gt;NameSpace&lt;/span&gt;(&lt;span class="code-string"&gt;"&lt;/span&gt;&lt;span class="code-string"&gt;D:\empty.zip"&lt;/span&gt;)
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;Copy the files into the empty zip file using the CopyHere command .
&lt;/span&gt;        output.CopyHere(input.Items, &lt;span class="code-digit"&gt;4&lt;/span&gt;)
 
    &lt;span class="code-keyword"&gt;End&lt;/span&gt; &lt;span class="code-keyword"&gt;Sub&lt;/span&gt;
 
    &lt;span class="code-keyword"&gt;Sub&lt;/span&gt; UnZip()
        &lt;span class="code-keyword"&gt;Dim&lt;/span&gt; sc &lt;span class="code-keyword"&gt;As&lt;/span&gt; &lt;span class="code-keyword"&gt;New&lt;/span&gt; Shell32.Shell()
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;'UPDATE !!
&lt;/span&gt;        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;Create directory in which you will unzip your files .
&lt;/span&gt;        IO.Directory.CreateDirectory(&lt;span class="code-string"&gt;"&lt;/span&gt;&lt;span class="code-string"&gt;D:\extractedFiles"&lt;/span&gt;) 
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;Declare the folder where the files will be extracted
&lt;/span&gt;        &lt;span class="code-keyword"&gt;Dim&lt;/span&gt; output &lt;span class="code-keyword"&gt;As&lt;/span&gt; Shell32.Folder = sc.&lt;span class="code-keyword"&gt;NameSpace&lt;/span&gt;(&lt;span class="code-string"&gt;"&lt;/span&gt;&lt;span class="code-string"&gt;D:\extractedFiles"&lt;/span&gt;)
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;Declare your input zip file as folder  .
&lt;/span&gt;        &lt;span class="code-keyword"&gt;Dim&lt;/span&gt; input &lt;span class="code-keyword"&gt;As&lt;/span&gt; Shell32.Folder = sc.&lt;span class="code-keyword"&gt;NameSpace&lt;/span&gt;(&lt;span class="code-string"&gt;"&lt;/span&gt;&lt;span class="code-string"&gt;d:\myzip.zip"&lt;/span&gt;)
        &lt;span class="code-comment"&gt;'&lt;/span&gt;&lt;span class="code-comment"&gt;Extract the files from the zip file using the CopyHere command .
&lt;/span&gt;        output.CopyHere(input.Items, &lt;span class="code-digit"&gt;4&lt;/span&gt;)
 
    &lt;span class="code-keyword"&gt;End&lt;/span&gt; &lt;span class="code-keyword"&gt;Sub&lt;/span&gt;
 
&lt;span class="code-keyword"&gt;End&lt;/span&gt; &lt;span class="code-keyword"&gt;Class&lt;/span&gt;&lt;/pre&gt;
&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-family: Verdana,sans-serif;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt;&lt;span style="font-size: small;"&gt; &lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/blockquote&gt;
&lt;/div&gt;
</description><link>http://codingstuffsbykiran.blogspot.com/2013/01/c-zip-unzip-using-window-shell.html</link><author>noreply@blogger.com (kiran)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHq9Mq89GpcJVH_VQ5pyfAKKgx4BTFDeZ8vrckku3nqyk68CtIYuNxY234oN6_MsPtgFWNkW-q9ArkhXpVL70sOD1rFZJ0osNQbYYFkw1vMKq-T0X6NxFWF9yX6M2eM60uEs_zoN_0ZG6W/s72-c/02.png" width="72"/><thr:total>1</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-8608339009165514343</guid><pubDate>Sun, 06 May 2012 13:11:00 +0000</pubDate><atom:updated>2012-05-06T14:11:02.713+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Sql</category><category domain="http://www.blogger.com/atom/ns#">SQL scripts</category><title>delete existing store procedure and tables</title><description>&lt;div dir="ltr" style="text-align: left;" trbidi="on"&gt;
&lt;b&gt;Delete all existing database use this scripts.&lt;/b&gt;&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;
&lt;pre class="csharpcode"&gt;DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR
SET @Cursor = CURSOR FAST_FORWARD FOR
SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME
OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql
WHILE (@@FETCH_STATUS = 0)
BEGIN
Exec SP_EXECUTESQL @Sql
FETCH NEXT FROM @Cursor INTO @Sql
END
CLOSE @Cursor DEALLOCATE @Cursor
GO
EXEC sp_MSForEachTable 'DROP TABLE ?
GO



&lt;b&gt;if you want to delete all existing store procedure use this scripts.&lt;/b&gt;



&lt;/pre&gt;
&lt;pre class="csharpcode"&gt;&lt;span class="kwrd"&gt;DECLARE&lt;/span&gt; @procedureName &lt;span class="kwrd"&gt;varchar&lt;/span&gt;(500)
&lt;span class="kwrd"&gt;DECLARE&lt;/span&gt; cur &lt;span class="kwrd"&gt;CURSOR&lt;/span&gt;
      &lt;span class="kwrd"&gt;FOR&lt;/span&gt; &lt;span class="kwrd"&gt;SELECT&lt;/span&gt; [name] &lt;span class="kwrd"&gt;FROM&lt;/span&gt; sys.objects &lt;span class="kwrd"&gt;WHERE&lt;/span&gt; type = &lt;span class="str"&gt;'p'&lt;/span&gt;
      &lt;span class="kwrd"&gt;OPEN&lt;/span&gt; cur

      &lt;span class="kwrd"&gt;FETCH&lt;/span&gt; &lt;span class="kwrd"&gt;NEXT&lt;/span&gt; &lt;span class="kwrd"&gt;FROM&lt;/span&gt; cur &lt;span class="kwrd"&gt;INTO&lt;/span&gt; @procedureName
      &lt;span class="kwrd"&gt;WHILE&lt;/span&gt; &lt;span class="preproc"&gt;@@fetch_status&lt;/span&gt; = 0
      &lt;span class="kwrd"&gt;BEGIN&lt;/span&gt;
            &lt;span class="kwrd"&gt;EXEC&lt;/span&gt;(&lt;span class="str"&gt;'DROP PROCEDURE '&lt;/span&gt; + @procedureName)
            &lt;span class="kwrd"&gt;FETCH&lt;/span&gt; &lt;span class="kwrd"&gt;NEXT&lt;/span&gt; &lt;span class="kwrd"&gt;FROM&lt;/span&gt; cur &lt;span class="kwrd"&gt;INTO&lt;/span&gt; @procedureName
      &lt;span class="kwrd"&gt;END&lt;/span&gt;
      &lt;span class="kwrd"&gt;CLOSE&lt;/span&gt; cur
      &lt;span class="kwrd"&gt;DEALLOCATE&lt;/span&gt; cur&lt;/pre&gt;
&lt;pre class="csharpcode"&gt;&amp;nbsp;&lt;/pre&gt;
&lt;pre class="csharpcode"&gt;Hope it will help you :)&lt;/pre&gt;
&lt;pre class="csharpcode"&gt;&lt;/pre&gt;
&lt;pre class="csharpcode"&gt;&lt;/pre&gt;
&lt;/div&gt;</description><link>http://codingstuffsbykiran.blogspot.com/2012/05/delete-existing-store-procedure-and.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-7029322817726576420</guid><pubDate>Mon, 28 Mar 2011 09:35:00 +0000</pubDate><atom:updated>2011-03-28T10:45:17.768+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Asp.Net</category><category domain="http://www.blogger.com/atom/ns#">GridView</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>Export Gridview to PDF</title><description>we have seen how to export the data from gridview to Excel file, today this post will helps you to export the gridview data to PDF, if you want protect you data being edit/ cut/ delete then Export to PDF will be a better option for you.there is a open source project for iTextShart. you can download the dll from them and you can use it.&lt;br /&gt;&lt;br /&gt;only you need to add this content on your page&lt;br /&gt;&lt;br /&gt;      &lt;blockquote&gt;Response.ContentType = "application/pdf";&lt;br /&gt;       Response.AddHeader("content-disposition", "attachment; filename= SampleExport.pdf");&lt;br /&gt;       Response.End();&lt;/blockquote&gt;&lt;br /&gt;&lt;br /&gt;Even you can format the text also,if you want to set the page with A4 or any other even you can also do the same.you can also specify the font size, style color all the basic things you can do with it.&lt;br /&gt;&lt;br /&gt;you can download the code from the below link. you can try that it will helps you.&lt;br /&gt;&lt;br /&gt;&lt;a href="http://www.dotnetspider.com/attachments/Resources/29759-30458-GridToPDF.zip"&gt;download Source&lt;/a&gt;</description><link>http://codingstuffsbykiran.blogspot.com/2011/03/export-gridview-to-pdf.html</link><author>noreply@blogger.com (kiran)</author><thr:total>5</thr:total><enclosure length="1100893" type="application/x-zip-compressed" url="http://www.dotnetspider.com/attachments/Resources/29759-30458-GridToPDF.zip"/><itunes:explicit/><itunes:subtitle>we have seen how to export the data from gridview to Excel file, today this post will helps you to export the gridview data to PDF, if you want protect you data being edit/ cut/ delete then Export to PDF will be a better option for you.there is a open source project for iTextShart. you can download the dll from them and you can use it. only you need to add this content on your page Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment; filename= SampleExport.pdf"); Response.End(); Even you can format the text also,if you want to set the page with A4 or any other even you can also do the same.you can also specify the font size, style color all the basic things you can do with it. you can download the code from the below link. you can try that it will helps you. download Source</itunes:subtitle><itunes:author>noreply@blogger.com (kiran)</itunes:author><itunes:summary>we have seen how to export the data from gridview to Excel file, today this post will helps you to export the gridview data to PDF, if you want protect you data being edit/ cut/ delete then Export to PDF will be a better option for you.there is a open source project for iTextShart. you can download the dll from them and you can use it. only you need to add this content on your page Response.ContentType = "application/pdf"; Response.AddHeader("content-disposition", "attachment; filename= SampleExport.pdf"); Response.End(); Even you can format the text also,if you want to set the page with A4 or any other even you can also do the same.you can also specify the font size, style color all the basic things you can do with it. you can download the code from the below link. you can try that it will helps you. download Source</itunes:summary><itunes:keywords>Asp.Net, GridView, Tips and Tricks</itunes:keywords></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-101094387039071514</guid><pubDate>Sun, 18 Jul 2010 09:43:00 +0000</pubDate><atom:updated>2010-07-18T11:02:42.352+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Blogger</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>how to add related posts on Blogger</title><description>we have seen on most of the blogger site , "Related post" section is there after every post now you want to add this Related post / Similar post on your blog ? follow the below easy steps and configure you blogger accordingly.&lt;br /&gt;&lt;ul&gt;&lt;br /&gt;&lt;li&gt; Open blogger.com site &lt;/li&gt;&lt;br /&gt;&lt;li&gt; Go to Design section under that you will get Edit Html Tab just click on it.  &lt;/li&gt;&lt;br /&gt;&lt;li&gt; now before making any changes on your xml file just take abackup for safty &lt;/li&gt;&lt;br /&gt;&lt;li&gt; just click on "Expand widget templates "&lt;/li&gt;&lt;br /&gt;&lt;li&gt; Add the below code above the &amp;lt;/head &amp;gt; section or better way is search the keyword &amp;lt;/head&amp;gt;&lt;br /&gt;&lt;!--Related Post code start --&gt;&lt;br /&gt;&lt;blockquote&gt;&amp;lt;script src='https://www.opendrive.com/files/6673148_cnSMd/RelatedPosts_Blogger.js' type='text/javascript'/&amp;gt;&lt;br /&gt;&lt;!--Related Post code end--&gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;/li&gt;&lt;br /&gt;&lt;li&gt; now search for code &amp;lt;data:post.body/&amp;gt; &lt;/li&gt;&lt;br /&gt;&lt;li&gt; After this paste the below code line &lt;/li&gt;&lt;br /&gt;&lt;li&gt;&lt;br /&gt;&lt;!-- Related post Code start --&gt;&lt;br /&gt;&lt;blockquote&gt;&amp;lt;b:if cond='data:blog.pageType == "item"'&amp;gt;&lt;br /&gt;&amp;lt;div id='related-posts'&amp;gt;&lt;br /&gt;&amp;lt;font face='Arial' size='3'&amp;gt;&amp;lt;b&amp;gt;Related Posts: &amp;lt;/b&amp;gt;&amp;lt;/font&amp;gt;&amp;lt;font color='#000000'&amp;gt;&amp;lt;b:loop values='data:post.labels' var='label'&amp;gt;&amp;lt;data:label.name/&amp;gt;&amp;lt;b:if cond='data:label.isLast != "true"'&amp;gt;,&amp;lt;/b:if&amp;gt;&amp;lt;b:if cond='data:blog.pageType == "item"'&amp;gt;&lt;br /&gt;&amp;lt;script expr:src='"/feeds/posts/default/-/" + data:label.name + "?alt=json-in-script&amp;amp;callback=related_results_labels&amp;amp;&lt;span style="color: rgb(204, 0, 0);"&gt;max-results=5&lt;/span&gt;"' type='text/javascript'/&amp;gt;&amp;lt;/b:if&amp;gt;&amp;lt;/b:loop&amp;gt; &amp;lt;/font&amp;gt;&lt;br /&gt;&amp;lt;script type='text/javascript'&amp;gt; removeRelatedDuplicates(); printRelatedLabels();&lt;br /&gt;&amp;lt;/script&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;/b:if&amp;gt;&lt;/blockquote&gt;&lt;br /&gt;&lt;!-- Related post Code start --&gt;&lt;br /&gt;&lt;/li&gt;&lt;br /&gt;&lt;li&gt; now on the above code you will see the red section line "max-results=xx" here you can enter no of post you want to see on your page&lt;br /&gt; accordingly you can mention it.&lt;/li&gt;&lt;br /&gt;&lt;li&gt; now save you template and see the magic on your post &lt;/li&gt;&lt;br /&gt;&lt;li&gt; you will see the number of post after each article , before that you need to add label on your post. hope you like it &lt;/li&gt;&lt;br /&gt;&lt;br /&gt;if you face any problem while doing this plz leave a comment.&lt;/ul&gt;</description><link>http://codingstuffsbykiran.blogspot.com/2010/07/how-to-add-related-posts-on-blogger.html</link><author>noreply@blogger.com (kiran)</author><thr:total>2</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-6032802572802025258</guid><pubDate>Fri, 11 Jun 2010 05:49:00 +0000</pubDate><atom:updated>2010-06-11T06:54:30.594+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Asp.Net</category><category domain="http://www.blogger.com/atom/ns#">c#</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>How strong name assemblies keep you out of  DLL Hell</title><description>while using Microsoft .NET framework for creating any application we are previously facing same problem with the DLL Hell.  it arises a problem while updating a components so it breaks the other application which are depend on it. to overcome such a issues developer needs to implement the concept of &lt;i&gt;Strong name &lt;/i&gt;.In this article you can through with how and why to use strong name .&lt;br /&gt;&lt;br /&gt;&lt;span style="color: rgb(0, 204, 204); font-weight: bold;"&gt; Strong Name :&lt;/span&gt;&lt;br /&gt;       what is strong name? A Strong name is of information used to identify the assembly which may consist of Text-name , four part of version number , culture information , public key  and the digital signature which may stored in a assembly manifest that get embedded on the file of the assembly.&lt;br /&gt;&lt;br /&gt;By using the Strong name the &lt;span style="font-style: italic;"&gt;CLR&lt;/span&gt; can assured that two assembly can be there with the same name. by the way strong name is basically provided the unique identification of the assembly. there are two scenarios in which the strong name can included in the assembly&lt;br /&gt;  1.Shared Assemblies&lt;br /&gt;  2. Serviced Components.&lt;br /&gt;&lt;br /&gt;on the first case the shared assemblies can be used in the multiple application which may running on the same machine on GAC. and you may get the &lt;span style="color: rgb(102, 255, 153);"&gt;benefit ares&lt;/span&gt;:&lt;br /&gt;1. Single Development&lt;br /&gt;2. Bypass verification&lt;br /&gt;3. Centralized update&lt;br /&gt;&lt;br /&gt;yes as your getting such a good benefits then surely there is also a some issues on it that is&lt;br /&gt;  1.calling a private assemblies : if the shared assemblies can load with the type of private assembly then CRL will throw an Error because it reference only shared assemblies.&lt;br /&gt;  2. Trusting assemblies :&lt;br /&gt;  3. Installation issues :&lt;br /&gt;&lt;br /&gt;How to create "Strong Name".&lt;br /&gt; To create strong name for assembly you need a (al.exe) tool which is a assembly generation tool .now to create a key pair in the file you can use Strong name utility (Sn.exe) like this way.&lt;br /&gt;Sn.exe -k filename.dat&lt;br /&gt;&lt;br /&gt;The key file could be used on Al.exe to generate the strong name.&lt;br /&gt; Al.exe /out:Input.dll  /Keyfile:output.dat&lt;br /&gt;&lt;br /&gt;Like this way you can design your strong name with the key. hope you get something from this&lt;br /&gt;if you have any query on it plz post the reply.</description><link>http://codingstuffsbykiran.blogspot.com/2010/06/how-strong-name-assemblies-keep-you-out.html</link><author>noreply@blogger.com (kiran)</author><thr:total>2</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-2940137148128355099</guid><pubDate>Sun, 25 Apr 2010 05:08:00 +0000</pubDate><atom:updated>2010-04-25T06:11:07.847+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Personal</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>my oracle interview experience</title><description>hi friends, &lt;br /&gt;&lt;br /&gt;last week i was attended "ORACLE financial services"  interview for the .NET Developer post. Here i am sharing my experience on interview hope so it will help you while going for an Oracle Interview. i was disqualify from 3rd Round (Final Technical Round).&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;Interview Process:&lt;/span&gt;&lt;br /&gt;There was 4 Round 1 st Online Test ( 47 Question 1 hrs ) but be careful there is also a negative marking as well as there is also a cutoff (if u select more than 1 answer and answer is wrong ) then again some deduction on your marks . Quite tough mostly Question on Assembly , Framework , C# , then hardly question on Datalist,Datagrid, Gridview and all basic. we totally 3  people get selected in first round out of 10.&lt;br /&gt;&lt;br /&gt;Second Round is Technical Round. it was ok only basic question get ask during the interview , but in most of them are in-depth  question just like on DataGrid DataBind() wht happen exactly , which function get executed at first onRowDataBound() or DataBind(). how .net life cycle will work on this process and all . i also got selected on this round . &lt;br /&gt;&lt;br /&gt;now There was a Final Round on again Technical . There was 2 panelist in front of me and asking question on most of the SDLC (Software Development Life Cycle) and Question on backed on Pl-sql / SQL2005 . i thing around 15+ question get ask during the interview process  i have answer most of them . but interview was cool .&lt;br /&gt;&lt;br /&gt;at last there was an only final Round Remaining which is HR Round. but sorry to say friends i was disqualified from this process (2nd Technical Round). hope my this experience will help you to get it in ORACLE or any other software farm .because most of the time same process is there every where .&lt;br /&gt;&lt;br /&gt;hope i will get good company out of this. better luck next time .but one thing is sure i am getting very  good experience from this.</description><link>http://codingstuffsbykiran.blogspot.com/2010/04/my-oracle-interview-experience.html</link><author>noreply@blogger.com (kiran)</author><thr:total>3</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-38684522095091100</guid><pubDate>Sun, 18 Apr 2010 04:41:00 +0000</pubDate><atom:updated>2010-04-18T05:42:39.820+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ajax</category><category domain="http://www.blogger.com/atom/ns#">Google</category><category domain="http://www.blogger.com/atom/ns#">jQuery</category><title>Jquery 1.4.1 released</title><description>very good news to all the Jquery users and jquery lovers. the latest version of Jquery ( which is 1.4.1 has been released).it has lot of improvement on bases of performance , new additonal features and many new functions are added to make &lt;br /&gt;jquery very popular. i really enjoy with the same.  as you can see the execution time of realease version is very  less in time as compare with the previous one.&lt;br /&gt;here are the Minified and Regular version .&lt;br /&gt;&lt;br /&gt;&lt;ul&gt;&lt;br /&gt;&lt;li&gt;&lt;a href="http://code.jquery.com/jquery-1.4.min.js"&gt;jQuery Minified&lt;/a&gt; (23kb minified version.)&lt;/li&gt;&lt;br /&gt;&lt;li&gt;&lt;a href="http://code.jquery.com/jquery-1.4.js"&gt;jQuery Regular&lt;/a&gt; (154kb regular version)&lt;/li&gt;&lt;br /&gt;&lt;/ul&gt;&lt;br /&gt;&lt;br /&gt;You can download the js frem the above link.or you can take a advantage of Google CDN on : &lt;a href="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"&gt;http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js&lt;/a&gt;&lt;br /&gt;while using CDN one is very good idea , because if anything get change on current realease then it will automatically updated on your application ,. if your using Google CDN features , Microsoft is also providing the same kind of feature of CDN  you can also take the help form there also.&lt;br /&gt;&lt;br /&gt;on new release they have added methds like , Setter , Getter and many more ajax features. the Whole API Documentation you&lt;br /&gt;can get it from here. &lt;b&gt;http://api.jquery.com/category/version/1.4/&lt;/b&gt;&lt;br /&gt;&lt;br /&gt;now guys why your waiting , just use latest version of Jquery on your application and make your application very cool and attractive .</description><link>http://codingstuffsbykiran.blogspot.com/2010/04/very-good-news-to-all-jquery-users-and.html</link><author>noreply@blogger.com (kiran)</author><thr:total>2</thr:total><enclosure length="23679" type="application/javascript; charset=utf-8" url="http://code.jquery.com/jquery-1.4.min.js"/><itunes:explicit/><itunes:subtitle>very good news to all the Jquery users and jquery lovers. the latest version of Jquery ( which is 1.4.1 has been released).it has lot of improvement on bases of performance , new additonal features and many new functions are added to make jquery very popular. i really enjoy with the same. as you can see the execution time of realease version is very less in time as compare with the previous one. here are the Minified and Regular version . jQuery Minified (23kb minified version.) jQuery Regular (154kb regular version) You can download the js frem the above link.or you can take a advantage of Google CDN on : http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js while using CDN one is very good idea , because if anything get change on current realease then it will automatically updated on your application ,. if your using Google CDN features , Microsoft is also providing the same kind of feature of CDN you can also take the help form there also. on new release they have added methds like , Setter , Getter and many more ajax features. the Whole API Documentation you can get it from here. http://api.jquery.com/category/version/1.4/ now guys why your waiting , just use latest version of Jquery on your application and make your application very cool and attractive .</itunes:subtitle><itunes:author>noreply@blogger.com (kiran)</itunes:author><itunes:summary>very good news to all the Jquery users and jquery lovers. the latest version of Jquery ( which is 1.4.1 has been released).it has lot of improvement on bases of performance , new additonal features and many new functions are added to make jquery very popular. i really enjoy with the same. as you can see the execution time of realease version is very less in time as compare with the previous one. here are the Minified and Regular version . jQuery Minified (23kb minified version.) jQuery Regular (154kb regular version) You can download the js frem the above link.or you can take a advantage of Google CDN on : http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js while using CDN one is very good idea , because if anything get change on current realease then it will automatically updated on your application ,. if your using Google CDN features , Microsoft is also providing the same kind of feature of CDN you can also take the help form there also. on new release they have added methds like , Setter , Getter and many more ajax features. the Whole API Documentation you can get it from here. http://api.jquery.com/category/version/1.4/ now guys why your waiting , just use latest version of Jquery on your application and make your application very cool and attractive .</itunes:summary><itunes:keywords>ajax, Google, jQuery</itunes:keywords></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-8742547463947927596</guid><pubDate>Wed, 17 Mar 2010 09:41:00 +0000</pubDate><atom:updated>2010-03-17T10:45:52.363+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Google</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>Tips on Google Buzz</title><description>on my previous post i was discuss on what is Google buzz , &lt;a href="http://codingstuffsbykiran.blogspot.com/2010/03/add-google-buzz-button-on-blogger.html"&gt;how you can add Google Buzz button on your Blogger / Wordpress.  &lt;/a&gt;now on this article i am just discussing tips on Google Buzz , hope u enjoy this&lt;br /&gt;&lt;br /&gt;&lt;span style="color: rgb(204, 102, 204); font-weight: bold;"&gt;1.Quick open Google Buzz&lt;/span&gt;&lt;br /&gt;yes there are some keyboards shortkuts on gmail for opening google Buzz quickly, type &lt;i&gt;g b &lt;/i&gt; from gmail view and Google Buzz will get open.&lt;br /&gt;here are few more shortcuts.&lt;br /&gt;m - mute&lt;br /&gt;r- add comments&lt;br /&gt;p/n - Go to new conversation&lt;br /&gt;o -expand conversation&lt;br /&gt;and so on.&lt;br /&gt;&lt;br /&gt;&lt;span style="color: rgb(204, 51, 204); font-weight: bold;"&gt;2. Hide buzz Counter.&lt;/span&gt;&lt;br /&gt;Now some time we dont want to view that google buzz counter on mail panal , now in this time you can remove that or hide that. Google has not given any facility to do so , but here is tricks to do this,&lt;br /&gt;simple drag your lable (Buzz(3)) and and put this into More section . look at this image you will come to know&lt;br /&gt;&lt;div style="text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhN0w-3K5plRbz0rwPf13d8z5Vu5WOx5bnBJZ3cnr1U71UNUqayScl1xQAbvqgRz2UY_1X9RDB0HJXIMCijGjZSQgGDrdbb6IZCzyHSlSNtUwYLDMlJ34AlFqqsTfZfUl423m2z9sjtSh5A/s1600-h/buzz-hide.png"&gt;&lt;img style="cursor: pointer; width: 168px; height: 182px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhN0w-3K5plRbz0rwPf13d8z5Vu5WOx5bnBJZ3cnr1U71UNUqayScl1xQAbvqgRz2UY_1X9RDB0HJXIMCijGjZSQgGDrdbb6IZCzyHSlSNtUwYLDMlJ34AlFqqsTfZfUl423m2z9sjtSh5A/s200/buzz-hide.png" alt="" id="BLOGGER_PHOTO_ID_5449536603930945922" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;span style="font-weight: bold; color: rgb(204, 51, 204);"&gt;3. Subscribe Buzz feed&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;yes google posts each scrap to there user profile page. and you can open that by using orange icon display in your browser to subscribe a feed. it will looks this way&lt;br /&gt;http://buzz.googleapis.com/feeds/&lt;username&gt;/public/posted&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold; color: rgb(204, 51, 204);"&gt;4.Add rich text&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;  again this is a cool tricks on adding a rich text on your buzz message.&lt;br /&gt;*bold message*&lt;br /&gt;_italic message_&lt;br /&gt;-deleted message-&lt;br /&gt;&lt;br /&gt;&lt;span style="color: rgb(204, 51, 204); font-weight: bold;"&gt;5.View Photos in SlideShow Effects.&lt;br /&gt;&lt;br /&gt;&lt;/span&gt;   when ever you upload the images to the Google buzz , they basically added on Picasa albums, and when ever you clikc on that image it get open from there with the Light box effects , google has give that option that you can organize that  photos according to your view and select the Slideshow option on it , then it get export those pics on picasa.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight: bold; color: rgb(204, 51, 204);"&gt;6.View Public Buzz message:&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;yes now you can search the public messages also with the help of google buzz. even though you can also restrict the&lt;br /&gt;social connection on the buzz, that means you can protect your buzz while viewing to anyone else.&lt;br /&gt;now how you can search it&lt;br /&gt;&lt;b&gt;author:&lt;enternamehere&gt;@gmail.com   &lt;/enternamehere&gt;&lt;/b&gt; : that means it will return all the buzz result with this email id. like this way&lt;br /&gt;you can search it.&lt;br /&gt;&lt;b&gt;commenter:&lt;insertname&gt;@gmail.com &lt;/insertname&gt;&lt;/b&gt; : this will search all the user that have given a comments .&lt;br /&gt;&lt;b&gt;has:photo, has:video, has:link &lt;/b&gt; : now here you can restrict the search just like if you enter has:photo that means only those result get sort out , those are hainvg photo in this buzz just like the videos and link and other&lt;br /&gt;&lt;br /&gt;&lt;span style="color: rgb(204, 51, 204); font-weight: bold;"&gt;7 .Save searches&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;now not last but main useful feature is saving the search. what ever you have been search till time that get save  automatically so later on also you can search it whtever search result your getting on previous search.&lt;br /&gt;&lt;br /&gt;hope it will help you to make your buzz perfect , enjoy it happy buzzingg..&lt;br /&gt;&lt;br /&gt;&lt;/username&gt;</description><link>http://codingstuffsbykiran.blogspot.com/2010/03/tips-on-google-buzz.html</link><author>noreply@blogger.com (kiran)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhN0w-3K5plRbz0rwPf13d8z5Vu5WOx5bnBJZ3cnr1U71UNUqayScl1xQAbvqgRz2UY_1X9RDB0HJXIMCijGjZSQgGDrdbb6IZCzyHSlSNtUwYLDMlJ34AlFqqsTfZfUl423m2z9sjtSh5A/s72-c/buzz-hide.png" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-1140092958548296349</guid><pubDate>Mon, 08 Mar 2010 09:02:00 +0000</pubDate><atom:updated>2010-03-08T10:10:45.603+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Google</category><category domain="http://www.blogger.com/atom/ns#">Tips and Tricks</category><title>Add Google Buzz Button on Blogger</title><description>now you can use google Buzz buttons to share your ideas , pics, videos, and many more just like the twitter does,here is my post on how to add twitter button on your site or blog.the same you can add it for your google buzz basically if u search on google you get the lots of search on how to add google buzz button on Word-press blog, its very easy to do so you need to download the plugin and install it on your server that's it. but now u can use same on blogger too ,&lt;br /&gt;&lt;span style="font-weight: bold;"&gt;Please follow the steps to add the Google buzz button&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;1.Sign in on your blogger account&lt;br /&gt;2.Go to Dashboard section - Layout and click on Edit HTML&lt;br /&gt;3.and it will show you HTML code , now try to search the keyword&lt;br /&gt;&amp;lt;div class='post-header-line-1'&amp;gt;&lt;br /&gt;on it,&lt;br /&gt;&lt;br /&gt;4.now below that you can paste this code , google buzz provides you two button one is bigger one&lt;br /&gt;just like this and smaller one too , here is code for large button&lt;br /&gt;&lt;br /&gt;&lt;span style="color: rgb(51, 102, 255);"&gt;&amp;lt;a href='javascript:var%20b=document.body;var%20GR________bookmarklet_domain="http://www.google.com";if(b&amp;amp;&amp;amp;!document.xmlVersion){void(z=document.createElement("script"));void(z.src="http://www.google.com/reader/ui/link-bookmarklet.js");void(b.appendChild(z));}else{}'&amp;gt; &amp;lt;img alt='Buzz this' src='http://img2.pict.com/15/da/3e/2809374/0/googlebuzz.png'/&amp;gt; &amp;lt;/a&amp;gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;which will looks like&lt;br /&gt;&lt;div style="text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWpPC9dZhPzhx5WBRhtc-x1r1G69Xg_QYNzIcoD1sYF5CqFdr02vQ0Y5t1Z-yt6b2CYp7m-FU5d1vCG8RxZ6z1JU2yPD3e7M2WmbGfD-dOotMwPDIhUeS3BQCUfwEzHvWiuT24JaG8zrg/s1600-h/google-buzz.png"&gt;&lt;img style="cursor: pointer; width: 50px; height: 58px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWpPC9dZhPzhx5WBRhtc-x1r1G69Xg_QYNzIcoD1sYF5CqFdr02vQ0Y5t1Z-yt6b2CYp7m-FU5d1vCG8RxZ6z1JU2yPD3e7M2WmbGfD-dOotMwPDIhUeS3BQCUfwEzHvWiuT24JaG8zrg/s200/google-buzz.png" alt="" id="BLOGGER_PHOTO_ID_5446186342122946722" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;5.and here is compact button code&lt;br /&gt;&lt;span style="color: rgb(51, 102, 255);"&gt;&amp;lt;a href='javascript:var%20b=document.body;var%20GR________bookmarklet_domain="http://www.google.com";if(b&amp;amp;&amp;amp;!document.xmlVersion){void(z=document.createElement("script"));void(z.src="http://www.google.com/reader/ui/link-bookmarklet.js");void(b.appendChild(z));}else{}'&amp;gt; &amp;lt;img alt='Buzz this' src='http://img2.pict.com/9c/09/57/2854010/0/buzzthis.gif'/&amp;gt; &amp;lt;/a&amp;gt;&lt;/span&gt;&lt;br /&gt;which will looks like&lt;br /&gt;&lt;br /&gt;&lt;div style="text-align: center;"&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinzmUbXZBboP5CxLHY8iZAW2OLwzXoswfsVJ1C7JFP5e_eXN06K8PdkkTqL-pFsj4C5zQ8QedijAWNpN5b_cMoDpSpnIngHOF4k3JbAnIjtL_2CcJEg-KPmOWs8U2-xGYRY3jf_0QmWEup/s1600-h/buzz-this.gif"&gt;&lt;img style="cursor: pointer; width: 79px; height: 21px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinzmUbXZBboP5CxLHY8iZAW2OLwzXoswfsVJ1C7JFP5e_eXN06K8PdkkTqL-pFsj4C5zQ8QedijAWNpN5b_cMoDpSpnIngHOF4k3JbAnIjtL_2CcJEg-KPmOWs8U2-xGYRY3jf_0QmWEup/s200/buzz-this.gif" alt="" id="BLOGGER_PHOTO_ID_5446186336781836018" border="0" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;6.now save the template and see how exactly it appering on blog.&lt;br /&gt;&lt;br /&gt;hope this article is helpful for you , thank you. if you have any problem while adding plz leave a comment we will help you.</description><link>http://codingstuffsbykiran.blogspot.com/2010/03/add-google-buzz-button-on-blogger.html</link><author>noreply@blogger.com (kiran)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvWpPC9dZhPzhx5WBRhtc-x1r1G69Xg_QYNzIcoD1sYF5CqFdr02vQ0Y5t1Z-yt6b2CYp7m-FU5d1vCG8RxZ6z1JU2yPD3e7M2WmbGfD-dOotMwPDIhUeS3BQCUfwEzHvWiuT24JaG8zrg/s72-c/google-buzz.png" width="72"/><thr:total>2</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-8013946058505312237</guid><pubDate>Sun, 28 Feb 2010 09:56:00 +0000</pubDate><atom:updated>2010-02-28T11:13:03.585+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ajax</category><category domain="http://www.blogger.com/atom/ns#">Asp.Net</category><category domain="http://www.blogger.com/atom/ns#">CDN</category><category domain="http://www.blogger.com/atom/ns#">Google</category><title>Microsoft AJAX CDN</title><description>hi guys , on my last blog you have seen how microsoft ajax minifer get work and how its useful while developing a application. fine now one more great feature today i will discuss with you . that is ajax CDN (Content Delivery Network ), yes as the name suggested content get deliver on network, no need of updation of code and all auto m atically it get updated all over the world, &lt;br /&gt;&lt;br /&gt;some time back google get introduce this in terms of Jquery and all , now microsoft is also take a part on same while using ajax cdn. at first is service is free, does not require king of  registration or anything ,and one thing is you can use it in both commercial and non-commercial purposes.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;What does a CDN ?&lt;/span&gt;&lt;br /&gt;it get composed of "edge cache" servers which are highly strategically placed in all over the world at Internet network points. These "edge cache" servers can be used to cache and deliver all types of content – which get including images, CSS and JavaScript files ,videos and many more.&lt;br /&gt;&lt;br /&gt;&lt;span style="font-weight:bold;"&gt;How to use&lt;/span&gt;&lt;br /&gt;now for example if you want to use jQuery from the Microsoft AJAX CDN you can simply add a standard script tag to your page, that you can put in you &amp;lt;Head &amp;gt; section &lt;br /&gt;&lt;script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.3.2.min.js" type="text/javascript"&gt;&lt;/script&gt;    &lt;br /&gt;now whenever the script get required the browser get send the request to the microsoft cdn for functiuon and from there automatically updation get happen &lt;br /&gt;one better advantage is it get &lt;span style="font-weight:bold;"&gt;cache automatically &lt;/span&gt; so no need to send request and make http page heavier. so from the SEO (search engine optimization ) point of view also its too good .&lt;br /&gt;&lt;br /&gt;now how you can use that on Visual Studio on your application,&lt;br /&gt;now a days The ASP.NET 4.0 &lt;asp:ScriptManager&gt; control includes a new property named EnableCdn. that means When you assign the value true to this property, your application will use the Microsoft CDN to request JavaScript files automatically:&lt;br /&gt;that means script get generate automatically so no need of write a code for same , this again useful for SEO purpose for &lt;span style="font-weight:bold;"&gt;JS minfication&lt;/span&gt; . this problem get solve ones you check you application in terms of Google page speed issue.&lt;br /&gt;&lt;br /&gt;you need to simply set EnableCDn="true" automatically it get work look at below how exactly it get work&lt;br /&gt;&lt;br /&gt;&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOsboXw8Ze6E0xDZQFdMF0bgcQZyX7sqZe2_Og_AfkS-4tZ-iDugfmxctxzw8bk1I9DmGYhqAgZZcyBUkuVUchYCArAmYacDkzpPSJSte5RoaPaXRmuvA0UULuDYZcYr7qCf9XnfwVEdRS/s1600-h/scriptmanager.png"&gt;&lt;img style="cursor:pointer; cursor:hand;width: 298px; height: 147px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOsboXw8Ze6E0xDZQFdMF0bgcQZyX7sqZe2_Og_AfkS-4tZ-iDugfmxctxzw8bk1I9DmGYhqAgZZcyBUkuVUchYCArAmYacDkzpPSJSte5RoaPaXRmuvA0UULuDYZcYr7qCf9XnfwVEdRS/s320/scriptmanager.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5443235003166796706" /&gt;&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;now hope u got the idea clear how exatly it get work and how its useful &lt;br /&gt;thanx , if u want more on same plz add a comment on this post</description><link>http://codingstuffsbykiran.blogspot.com/2010/02/microsoft-ajax-cdn.html</link><author>noreply@blogger.com (kiran)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" height="72" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOsboXw8Ze6E0xDZQFdMF0bgcQZyX7sqZe2_Og_AfkS-4tZ-iDugfmxctxzw8bk1I9DmGYhqAgZZcyBUkuVUchYCArAmYacDkzpPSJSte5RoaPaXRmuvA0UULuDYZcYr7qCf9XnfwVEdRS/s72-c/scriptmanager.png" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-4490387103798985456.post-6865766590301018348</guid><pubDate>Sun, 14 Feb 2010 05:00:00 +0000</pubDate><atom:updated>2010-02-14T06:13:06.632+01:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">ajax</category><category domain="http://www.blogger.com/atom/ns#">CDN</category><title>microsoft ajax minifier</title><description>hi all , yes long time while posting a article on my blog, now i m back , hei i have seen&lt;br /&gt;most of the people are uses Microsoft ajax control in there web application , its also working fine&lt;br /&gt;and also good looking in projects ,&lt;br /&gt;&lt;br /&gt;but at a time testing of web site  performance then so many issues get arises , they may be all related with speed , performance , ratio and all , now i also face this problem on my applicatin&lt;br /&gt;and while searching i found good article on how to minify  the   ajax control auto generated (runtime) script there are two ways&lt;br /&gt;either u can compress them or u can use ajax CDN facility to handle them , yes ajax introduces the CDN faliclity for ther JQUERY, AJAX tools , yes its really good while use them in out application.&lt;br /&gt;&lt;br /&gt;now u can see how its very important in terms of project implementation.&lt;br /&gt;you can refer this Scott 's blog post ,you wil come to know how its useful . &lt;a href="http://weblogs.asp.net/scottgu/archive/2009/10/15/announcing-microsoft-ajax-library-preview-6-and-the-microsoft-ajax-minifier.aspx" rel="nofollow"&gt;announcing-microsoft-ajax-library &lt;/a&gt;&lt;br /&gt;&lt;br /&gt;hope u like this</description><link>http://codingstuffsbykiran.blogspot.com/2010/02/microsoft-ajax-minifier.html</link><author>noreply@blogger.com (kiran)</author><thr:total>0</thr:total></item></channel></rss>