<?xml version="1.0" encoding="utf-8"?>
<rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:pingback="http://madskills.com/public/xml/rss/module/pingback/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>امیر میرکمالی</title>
    <link>http://mirkamali.ir/</link>
    <description>Amir Mirkamali</description>
    <language>en-us</language>
    <copyright>Amir Mirkamali</copyright>
    <lastBuildDate>Sun, 04 Dec 2011 08:18:44 GMT</lastBuildDate>
    <generator>newtelligence dasBlog 2.0.7226.0</generator>
    <managingEditor>amir@mirkamali.ir</managingEditor>
    <webMaster>amir@mirkamali.ir</webMaster>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=5179f9ed-af1b-4417-9957-daf948a37ee3</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,5179f9ed-af1b-4417-9957-daf948a37ee3.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <pre style="BACKGROUND: #ffffff; COLOR: #000000">
          <span style="COLOR: #800000; FONT-WEIGHT: bold">declare</span>
          <span style="COLOR: #797997">@NewCollation</span>
          <span style="COLOR: #800000; FONT-WEIGHT: bold">varchar</span>
          <span style="COLOR: #808030">(</span>
          <span style="COLOR: #008c00">255</span>
          <span style="COLOR: #808030">)</span>
          <span style="COLOR: #808030">,</span>
          <span style="COLOR: #797997">@Stmt</span> nvarchar<span style="COLOR: #808030">(</span><span style="COLOR: #008c00">4000</span><span style="COLOR: #808030">)</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@DBName</span> sysname <span style="COLOR: #800000; FONT-WEIGHT: bold">set</span><span style="COLOR: #797997">@NewCollation</span><span style="COLOR: #808030">=</span><span style="COLOR: #0000e6">'SQL_Latin1_General_CP1256_CI_AS'</span><span style="COLOR: #696969">--
change this to the collation that you need</span><span style="COLOR: #800000; FONT-WEIGHT: bold">set</span><span style="COLOR: #797997">@DBName</span><span style="COLOR: #808030">=</span> DB_NAME<span style="COLOR: #808030">(</span><span style="COLOR: #808030">)</span><span style="COLOR: #800000; FONT-WEIGHT: bold">declare</span><span style="COLOR: #797997">@CName</span><span style="COLOR: #800000; FONT-WEIGHT: bold">varchar</span><span style="COLOR: #808030">(</span><span style="COLOR: #008c00">255</span><span style="COLOR: #808030">)</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@TName</span> sysname <span style="COLOR: #808030">,</span><span style="COLOR: #797997">@OName</span> sysname <span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Sql</span><span style="COLOR: #800000; FONT-WEIGHT: bold">varchar</span><span style="COLOR: #808030">(</span><span style="COLOR: #008c00">8000</span><span style="COLOR: #808030">)</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Size</span><span style="COLOR: #800000; FONT-WEIGHT: bold">int</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Status</span> tinyint <span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Colorder</span><span style="COLOR: #800000; FONT-WEIGHT: bold">int</span><span style="COLOR: #800000; FONT-WEIGHT: bold">declare</span> curcolumns <span style="COLOR: #800000; FONT-WEIGHT: bold">cursor</span><span style="COLOR: #800000; FONT-WEIGHT: bold">read_only</span><span style="COLOR: #800000; FONT-WEIGHT: bold">forward_only</span><span style="COLOR: #800000; FONT-WEIGHT: bold">local</span><span style="COLOR: #800000; FONT-WEIGHT: bold">for</span><span style="COLOR: #800000; FONT-WEIGHT: bold">select</span><span style="COLOR: #bb7977; FONT-WEIGHT: bold">QUOTENAME</span><span style="COLOR: #808030">(</span><span style="COLOR: #800000; FONT-WEIGHT: bold">C</span><span style="COLOR: #808030">.</span>Name<span style="COLOR: #808030">)</span><span style="COLOR: #808030">,</span>T<span style="COLOR: #808030">.</span>Name <span style="COLOR: #808030">,</span><span style="COLOR: #bb7977; FONT-WEIGHT: bold">QUOTENAME</span><span style="COLOR: #808030">(</span>U<span style="COLOR: #808030">.</span>Name<span style="COLOR: #808030">)</span><span style="COLOR: #808030">+</span><span style="COLOR: #0000e6">'.'</span><span style="COLOR: #808030">+</span><span style="COLOR: #bb7977; FONT-WEIGHT: bold">QUOTENAME</span><span style="COLOR: #808030">(</span>O<span style="COLOR: #808030">.</span>Name<span style="COLOR: #808030">)</span><span style="COLOR: #808030">,</span><span style="COLOR: #800000; FONT-WEIGHT: bold">C</span><span style="COLOR: #808030">.</span>Prec <span style="COLOR: #808030">,</span><span style="COLOR: #800000; FONT-WEIGHT: bold">C</span><span style="COLOR: #808030">.</span>isnullable <span style="COLOR: #808030">,</span><span style="COLOR: #800000; FONT-WEIGHT: bold">C</span><span style="COLOR: #808030">.</span>colorder <span style="COLOR: #800000; FONT-WEIGHT: bold">from</span> syscolumns <span style="COLOR: #800000; FONT-WEIGHT: bold">C</span><span style="COLOR: #800000; FONT-WEIGHT: bold">inner</span><span style="COLOR: #800000; FONT-WEIGHT: bold">join</span> systypes
T <span style="COLOR: #800000; FONT-WEIGHT: bold">on</span><span style="COLOR: #800000; FONT-WEIGHT: bold">C</span><span style="COLOR: #808030">.</span>xtype<span style="COLOR: #808030">=</span>T<span style="COLOR: #808030">.</span>xtype <span style="COLOR: #800000; FONT-WEIGHT: bold">inner</span><span style="COLOR: #800000; FONT-WEIGHT: bold">join</span> sysobjects
O <span style="COLOR: #800000; FONT-WEIGHT: bold">on</span><span style="COLOR: #800000; FONT-WEIGHT: bold">C</span><span style="COLOR: #808030">.</span><span style="COLOR: #800000; FONT-WEIGHT: bold">ID</span><span style="COLOR: #808030">=</span>O<span style="COLOR: #808030">.</span><span style="COLOR: #800000; FONT-WEIGHT: bold">ID</span><span style="COLOR: #800000; FONT-WEIGHT: bold">inner</span><span style="COLOR: #800000; FONT-WEIGHT: bold">join</span> sysusers
u <span style="COLOR: #800000; FONT-WEIGHT: bold">on</span> O<span style="COLOR: #808030">.</span><span style="COLOR: #bb7977; FONT-WEIGHT: bold">uid</span><span style="COLOR: #808030">=</span> u<span style="COLOR: #808030">.</span><span style="COLOR: #bb7977; FONT-WEIGHT: bold">uid</span><span style="COLOR: #800000; FONT-WEIGHT: bold">where</span> T<span style="COLOR: #808030">.</span>Name <span style="COLOR: #800000; FONT-WEIGHT: bold">in</span><span style="COLOR: #808030">(</span><span style="COLOR: #0000e6">'varchar'</span><span style="COLOR: #808030">,</span><span style="COLOR: #0000e6">'char'</span><span style="COLOR: #808030">,</span><span style="COLOR: #0000e6">'text'</span><span style="COLOR: #808030">,</span><span style="COLOR: #0000e6">'nchar'</span><span style="COLOR: #808030">,</span><span style="COLOR: #0000e6">'nvarchar'</span><span style="COLOR: #808030">,</span><span style="COLOR: #0000e6">'ntext'</span><span style="COLOR: #808030">)</span><span style="COLOR: #800000; FONT-WEIGHT: bold">and</span> O<span style="COLOR: #808030">.</span>xtype <span style="COLOR: #800000; FONT-WEIGHT: bold">in</span><span style="COLOR: #808030">(</span><span style="COLOR: #0000e6">'U'</span><span style="COLOR: #808030">)</span><span style="COLOR: #800000; FONT-WEIGHT: bold">and</span><span style="COLOR: #800000; FONT-WEIGHT: bold">C</span><span style="COLOR: #808030">.</span><span style="COLOR: #800000; FONT-WEIGHT: bold">collation</span><span style="COLOR: #808030">!</span><span style="COLOR: #808030">=</span><span style="COLOR: #797997">@NewCollation</span><span style="COLOR: #800000; FONT-WEIGHT: bold">and</span><span style="COLOR: #bb7977; FONT-WEIGHT: bold">objectProperty</span><span style="COLOR: #808030">(</span>O<span style="COLOR: #808030">.</span><span style="COLOR: #800000; FONT-WEIGHT: bold">ID</span><span style="COLOR: #808030">,</span><span style="COLOR: #0000e6">'ismsshipped'</span><span style="COLOR: #808030">)</span><span style="COLOR: #808030">=</span><span style="COLOR: #008c00">0</span><span style="COLOR: #800000; FONT-WEIGHT: bold">order</span><span style="COLOR: #800000; FONT-WEIGHT: bold">by</span><span style="COLOR: #008c00">3</span><span style="COLOR: #808030">,</span><span style="COLOR: #008c00">1</span><span style="COLOR: #800000; FONT-WEIGHT: bold">open</span> curcolumns <span style="COLOR: #800000; FONT-WEIGHT: bold">SET</span> XACT_ABORT <span style="COLOR: #800000; FONT-WEIGHT: bold">ON</span><span style="COLOR: #800000; FONT-WEIGHT: bold">begin</span><span style="COLOR: #800000; FONT-WEIGHT: bold">tran</span><span style="COLOR: #800000; FONT-WEIGHT: bold">fetch</span> curcolumns <span style="COLOR: #800000; FONT-WEIGHT: bold">into</span><span style="COLOR: #797997">@CName</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@TName</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@OName</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Size</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Status</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Colorder</span><span style="COLOR: #800000; FONT-WEIGHT: bold">while</span><span style="COLOR: #797997">@@FETCH_STATUS</span><span style="COLOR: #808030">=</span><span style="COLOR: #008c00">0</span><span style="COLOR: #800000; FONT-WEIGHT: bold">begin</span><span style="COLOR: #800000; FONT-WEIGHT: bold">set</span><span style="COLOR: #797997">@Sql</span><span style="COLOR: #808030">=</span><span style="COLOR: #0000e6">'ALTER
TABLE '</span><span style="COLOR: #808030">+</span><span style="COLOR: #797997">@OName</span><span style="COLOR: #808030">+</span><span style="COLOR: #0000e6">'
ALTER COLUMN '</span><span style="COLOR: #808030">+</span><span style="COLOR: #797997">@CName</span><span style="COLOR: #808030">+</span><span style="COLOR: #0000e6">'
'</span><span style="COLOR: #808030">+</span><span style="COLOR: #797997">@TName</span><span style="COLOR: #808030">+</span> isnull <span style="COLOR: #808030">(</span><span style="COLOR: #0000e6">'('</span><span style="COLOR: #808030">+</span><span style="COLOR: #800000; FONT-WEIGHT: bold">CASE</span><span style="COLOR: #797997">@Size</span><span style="COLOR: #800000; FONT-WEIGHT: bold">WHEN</span><span style="COLOR: #808030">-</span><span style="COLOR: #008c00">1</span><span style="COLOR: #800000; FONT-WEIGHT: bold">then</span><span style="COLOR: #0000e6">'max'</span><span style="COLOR: #800000; FONT-WEIGHT: bold">else</span><span style="COLOR: #bb7977; FONT-WEIGHT: bold">convert</span><span style="COLOR: #808030">(</span><span style="COLOR: #800000; FONT-WEIGHT: bold">varchar</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Size</span><span style="COLOR: #808030">)</span><span style="COLOR: #800000; FONT-WEIGHT: bold">end</span><span style="COLOR: #808030">+</span><span style="COLOR: #0000e6">')'</span><span style="COLOR: #808030">,</span><span style="COLOR: #0000e6">''</span><span style="COLOR: #808030">)</span><span style="COLOR: #808030">+</span><span style="COLOR: #0000e6">'
COLLATE '</span><span style="COLOR: #808030">+</span><span style="COLOR: #797997">@NewCollation</span><span style="COLOR: #808030">+</span><span style="COLOR: #0000e6">'
'</span><span style="COLOR: #808030">+</span><span style="COLOR: #800000; FONT-WEIGHT: bold">case</span><span style="COLOR: #800000; FONT-WEIGHT: bold">when</span><span style="COLOR: #797997">@Status</span><span style="COLOR: #808030">=</span><span style="COLOR: #008c00">1</span><span style="COLOR: #800000; FONT-WEIGHT: bold">then</span><span style="COLOR: #0000e6">'NULL'</span><span style="COLOR: #800000; FONT-WEIGHT: bold">else</span><span style="COLOR: #0000e6">'NOT
NULL'</span><span style="COLOR: #800000; FONT-WEIGHT: bold">end</span><span style="COLOR: #696969">--exec(@Sql)
-- change this to print if you need only the script, not the action</span><span style="COLOR: #800000; FONT-WEIGHT: bold">PRINT</span><span style="COLOR: #797997">@Sql</span><span style="COLOR: #800000; FONT-WEIGHT: bold">fetch</span> curcolumns <span style="COLOR: #800000; FONT-WEIGHT: bold">into</span><span style="COLOR: #797997">@CName</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@TName</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@OName</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Size</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Status</span><span style="COLOR: #808030">,</span><span style="COLOR: #797997">@Colorder</span><span style="COLOR: #800000; FONT-WEIGHT: bold">end</span><span style="COLOR: #800000; FONT-WEIGHT: bold">close</span> curcolumns <span style="COLOR: #800000; FONT-WEIGHT: bold">deallocate</span> curcolumns <span style="COLOR: #800000; FONT-WEIGHT: bold">commit</span><span style="COLOR: #800000; FONT-WEIGHT: bold">tran</span></pre>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=5179f9ed-af1b-4417-9957-daf948a37ee3" />
      </body>
      <title>Change All string fields collation</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,5179f9ed-af1b-4417-9957-daf948a37ee3.aspx</guid>
      <link>http://mirkamali.ir/2011/12/04/ChangeAllStringFieldsCollation.aspx</link>
      <pubDate>Sun, 04 Dec 2011 08:18:44 GMT</pubDate>
      <description>&lt;pre style="BACKGROUND: #ffffff; COLOR: #000000"&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;declare&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@NewCollation&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;varchar&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #008c00"&gt;255&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@Stmt&lt;/span&gt; nvarchar&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #008c00"&gt;4000&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@DBName&lt;/span&gt; sysname &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;set&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@NewCollation&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;=&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'SQL_Latin1_General_CP1256_CI_AS'&lt;/span&gt; &lt;span style="COLOR: #696969"&gt;--
change this to the collation that you need&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;set&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@DBName&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;=&lt;/span&gt; DB_NAME&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;declare&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@CName&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;varchar&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #008c00"&gt;255&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@TName&lt;/span&gt; sysname &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@OName&lt;/span&gt; sysname &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@Sql&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;varchar&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #008c00"&gt;8000&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@Size&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;int&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@Status&lt;/span&gt; tinyint &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@Colorder&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;int&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;declare&lt;/span&gt; curcolumns &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;cursor&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;read_only&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;forward_only&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;local&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;for&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;select&lt;/span&gt; &lt;span style="COLOR: #bb7977; FONT-WEIGHT: bold"&gt;QUOTENAME&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;C&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;Name&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;T&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;Name &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #bb7977; FONT-WEIGHT: bold"&gt;QUOTENAME&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;U&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;Name&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;+&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'.'&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #bb7977; FONT-WEIGHT: bold"&gt;QUOTENAME&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;O&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;Name&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;C&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;Prec &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;C&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;isnullable &lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;C&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;colorder &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;from&lt;/span&gt; syscolumns &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;C&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;inner&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;join&lt;/span&gt; systypes
T &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;on&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;C&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;xtype&lt;span style="COLOR: #808030"&gt;=&lt;/span&gt;T&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;xtype &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;inner&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;join&lt;/span&gt; sysobjects
O &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;on&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;C&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;ID&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;=&lt;/span&gt;O&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;ID&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;inner&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;join&lt;/span&gt; sysusers
u &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;on&lt;/span&gt; O&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;&lt;span style="COLOR: #bb7977; FONT-WEIGHT: bold"&gt;uid&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;=&lt;/span&gt; u&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;&lt;span style="COLOR: #bb7977; FONT-WEIGHT: bold"&gt;uid&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;where&lt;/span&gt; T&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;Name &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;in&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;'varchar'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'char'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'text'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'nchar'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'nvarchar'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'ntext'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;and&lt;/span&gt; O&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;xtype &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;in&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;'U'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;and&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;C&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;collation&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;!&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;=&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@NewCollation&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;and&lt;/span&gt; &lt;span style="COLOR: #bb7977; FONT-WEIGHT: bold"&gt;objectProperty&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;O&lt;span style="COLOR: #808030"&gt;.&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;ID&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'ismsshipped'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;=&lt;/span&gt;&lt;span style="COLOR: #008c00"&gt;0&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;order&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;by&lt;/span&gt; &lt;span style="COLOR: #008c00"&gt;3&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #008c00"&gt;1&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;open&lt;/span&gt; curcolumns &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;SET&lt;/span&gt; XACT_ABORT &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;ON&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;begin&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;tran&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;fetch&lt;/span&gt; curcolumns &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;into&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@CName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@TName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@OName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Size&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Status&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Colorder&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;while&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@@FETCH_STATUS&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;=&lt;/span&gt;&lt;span style="COLOR: #008c00"&gt;0&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;begin&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;set&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Sql&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;=&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;'ALTER
TABLE '&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@OName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;'
ALTER COLUMN '&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@CName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;'
'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@TName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt; isnull &lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;'('&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;CASE&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Size&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;WHEN&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;-&lt;/span&gt;&lt;span style="COLOR: #008c00"&gt;1&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;then&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'max'&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;else&lt;/span&gt; &lt;span style="COLOR: #bb7977; FONT-WEIGHT: bold"&gt;convert&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;(&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;varchar&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt;&lt;span style="COLOR: #797997"&gt;@Size&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;end&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;')'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;''&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;)&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;'
COLLATE '&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@NewCollation&lt;/span&gt; &lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #0000e6"&gt;'
'&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;+&lt;/span&gt;&lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;case&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;when&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Status&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;=&lt;/span&gt;&lt;span style="COLOR: #008c00"&gt;1&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;then&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'NULL'&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;else&lt;/span&gt; &lt;span style="COLOR: #0000e6"&gt;'NOT
NULL'&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;end&lt;/span&gt; &lt;span style="COLOR: #696969"&gt;--exec(@Sql)
-- change this to print if you need only the script, not the action&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;PRINT&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Sql&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;fetch&lt;/span&gt; curcolumns &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;into&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@CName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@TName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@OName&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Size&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Status&lt;/span&gt;&lt;span style="COLOR: #808030"&gt;,&lt;/span&gt; &lt;span style="COLOR: #797997"&gt;@Colorder&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;end&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;close&lt;/span&gt; curcolumns &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;deallocate&lt;/span&gt; curcolumns &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;commit&lt;/span&gt; &lt;span style="COLOR: #800000; FONT-WEIGHT: bold"&gt;tran&lt;/span&gt; &lt;/pre&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=5179f9ed-af1b-4417-9957-daf948a37ee3" /&gt;</description>
      <category>SQL Server</category>
      <category>Troubleshooting</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=0146abdd-29e0-4cb1-b5b3-150a8d3724fc</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,0146abdd-29e0-4cb1-b5b3-150a8d3724fc.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
Online file scan with almost every antivirus ;)
</p>
        <p>
          <a href="http://www.virustotal.com/" target="_blank">http://www.virustotal.com/</a>
        </p>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=0146abdd-29e0-4cb1-b5b3-150a8d3724fc" />
      </body>
      <title>Online file virus scanner</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,0146abdd-29e0-4cb1-b5b3-150a8d3724fc.aspx</guid>
      <link>http://mirkamali.ir/2011/07/05/OnlineFileVirusScanner.aspx</link>
      <pubDate>Tue, 05 Jul 2011 06:45:28 GMT</pubDate>
      <description>&lt;p&gt;
Online file scan with almost every antivirus ;)
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.virustotal.com/" target=_blank&gt;http://www.virustotal.com/&lt;/a&gt;
&lt;/p&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=0146abdd-29e0-4cb1-b5b3-150a8d3724fc" /&gt;</description>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=a38f1c1f-47bc-4e0e-9e74-3a9843c3c479</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,a38f1c1f-47bc-4e0e-9e74-3a9843c3c479.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
I found this article that was very useful.
</p>
        <p>
          <a href="http://www.cssnewbie.com/input-button-line-height-bug/" target="_blank">http://www.cssnewbie.com/input-button-line-height-bug/</a>
        </p>
        <p>
according to this article, use padding instead of line-height for opera &amp; firefox.
</p>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=a38f1c1f-47bc-4e0e-9e74-3a9843c3c479" />
      </body>
      <title>The Firefox Input Button Line-Height Bug</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,a38f1c1f-47bc-4e0e-9e74-3a9843c3c479.aspx</guid>
      <link>http://mirkamali.ir/2011/04/18/TheFirefoxInputButtonLineHeightBug.aspx</link>
      <pubDate>Mon, 18 Apr 2011 06:16:49 GMT</pubDate>
      <description>&lt;p&gt;
I found this article that was very useful.
&lt;/p&gt;
&lt;p&gt;
&lt;a href="http://www.cssnewbie.com/input-button-line-height-bug/" target=_blank&gt;http://www.cssnewbie.com/input-button-line-height-bug/&lt;/a&gt;
&lt;/p&gt;
&lt;p&gt;
according to this article, use padding instead of line-height for opera &amp;amp; firefox.
&lt;/p&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=a38f1c1f-47bc-4e0e-9e74-3a9843c3c479" /&gt;</description>
      <category>Troubleshooting</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=fdd189d3-b3b4-4502-95a7-1830f3fcd023</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,fdd189d3-b3b4-4502-95a7-1830f3fcd023.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
Windows 7 still shows old icons after change! I found a solution but I don't think
it's the best but it works.
</p>
        <p>
Close all folders that are currently open.
</p>
        <ol>
          <li>
Press CTRL+SHIFT+ESC key sequence</li>
          <li>
Right-click on the Explorer.exe process and kill it by selecting  End Process.</li>
          <li>
At File menu of Task Manager, select New Task (Run…)</li>
          <li>
Type CMD.EXE, and click OK</li>
          <li>
At thePrompt window, type the commands line by line and press ENTER after each command:<br />
CD /d %userprofile%\AppData\Local<br />
DEL IconCache.db /a<br />
EXIT</li>
          <li>
In Task Manager, click File, select New Task (Run…)</li>
          <li>
Type EXPLORER.EXE, and click OK.<br /></li>
        </ol>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=fdd189d3-b3b4-4502-95a7-1830f3fcd023" />
      </body>
      <title>Rebuilding the Icon Cache Database in windows 7</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,fdd189d3-b3b4-4502-95a7-1830f3fcd023.aspx</guid>
      <link>http://mirkamali.ir/2011/03/27/RebuildingTheIconCacheDatabaseInWindows7.aspx</link>
      <pubDate>Sun, 27 Mar 2011 07:41:09 GMT</pubDate>
      <description>&lt;p&gt;
Windows 7 still shows old icons after change! I found a solution but I don't think
it's the best but it works.
&lt;/p&gt;
&lt;p&gt;
Close all folders that are currently open.
&lt;/p&gt;
&lt;ol&gt;
&lt;li&gt;
Press CTRL+SHIFT+ESC key sequence&lt;/li&gt;
&lt;li&gt;
Right-click on the Explorer.exe process and kill it by selecting&amp;nbsp; End Process.&lt;/li&gt;
&lt;li&gt;
At File menu of Task Manager, select New Task (Run…)&lt;/li&gt;
&lt;li&gt;
Type CMD.EXE, and click OK&lt;/li&gt;
&lt;li&gt;
At thePrompt window, type the commands line by line and press ENTER after each command:&lt;br&gt;
CD /d %userprofile%\AppData\Local&lt;br&gt;
DEL IconCache.db /a&lt;br&gt;
EXIT&lt;/li&gt;
&lt;li&gt;
In Task Manager, click File, select New Task (Run…)&lt;/li&gt;
&lt;li&gt;
Type EXPLORER.EXE, and click OK.&lt;br&gt;
&lt;/li&gt;
&lt;/ol&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=fdd189d3-b3b4-4502-95a7-1830f3fcd023" /&gt;</description>
      <category>Troubleshooting</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=408a3dbf-2779-48af-925d-7ae6a0045cca</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,408a3dbf-2779-48af-925d-7ae6a0045cca.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
The key is that you must add the all radiobuttons to your radajaxmanager updated controls.
somthing like this
</p>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">
            <p>
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn1, ddl, pnlLoading);<br />
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn1, rbtn2, 
</p>
          </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">null</font>
          </font>
        </font>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">);<br />
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn1, rbtn1, </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">null</font>
          </font>
        </font>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">);<br />
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn2, ddl, pnlLoading);<br />
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn2, rbtn2, </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">null</font>
          </font>
        </font>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">);<br />
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn2, rbtn1, </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">null</font>
          </font>
        </font>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">);</font>
        </font>
        <p>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">
              <font face="Verdana">This
will solve the problem. because after every postback all the dropdowns must updated.</font>
            </font>
          </font>
        </p>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=408a3dbf-2779-48af-925d-7ae6a0045cca" />
      </body>
      <title>RadAjaxManager problem with radiobuttons - work only on first postback</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,408a3dbf-2779-48af-925d-7ae6a0045cca.aspx</guid>
      <link>http://mirkamali.ir/2011/02/07/RadAjaxManagerProblemWithRadiobuttonsWorkOnlyOnFirstPostback.aspx</link>
      <pubDate>Mon, 07 Feb 2011 07:55:46 GMT</pubDate>
      <description>&lt;p&gt;
The key is that you must add the all radiobuttons to your radajaxmanager updated controls.
somthing like this
&lt;/p&gt;
&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt; 
&lt;p&gt;
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn1, ddl, pnlLoading);&lt;br&gt;
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn1, rbtn2, 
&lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;null&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;);&lt;br&gt;
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn1, rbtn1, &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;null&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;);&lt;br&gt;
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn2, ddl, pnlLoading);&lt;br&gt;
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn2, rbtn2, &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;null&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;);&lt;br&gt;
ajaxManager.AjaxSettings.AddAjaxSetting(rbtn2, rbtn1, &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;null&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;);&lt;/font&gt;&lt;/font&gt;&gt;
&lt;p&gt;
&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;&lt;font face=Verdana&gt;This will
solve the problem. because after every postback all the dropdowns must updated.&lt;/font&gt;
&lt;/p&gt;
&gt;&gt;&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=408a3dbf-2779-48af-925d-7ae6a0045cca" /&gt;</description>
      <category>.Net 4.0</category>
      <category>C#</category>
      <category>Telerik Controls</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=80826d52-3e5b-4381-9142-649a8d185d24</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,80826d52-3e5b-4381-9142-649a8d185d24.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">
            <p>
Add following code to your radmenu control. replace targetfieldname with your
field.
</p>
          </font>
        </font>
        <p>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">&lt;</font>
            </font>
          </font>
          <font color="#800000" size="2" face="Consolas">
            <font color="#800000" size="2" face="Consolas">
              <font color="#800000" size="2" face="Consolas">DataBindings</font>
            </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">&gt;
</font>
            </font>
          </font>
        </p>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">
            <p>
            </p>
          </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">&lt;</font>
          </font>
        </font>
        <font color="#800000" size="2" face="Consolas">
          <font color="#800000" size="2" face="Consolas">
            <font color="#800000" size="2" face="Consolas">telerik</font>
          </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">:</font>
          </font>
        </font>
        <font color="#800000" size="2" face="Consolas">
          <font color="#800000" size="2" face="Consolas">
            <font color="#800000" size="2" face="Consolas">RadMenuItemBinding</font>
          </font>
        </font>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">
          </font>
        </font>
        <font color="#ff0000" size="2" face="Consolas">
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">TargetField</font>
          </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">="TargetFieldName"</font>
          </font>
        </font>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">
          </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">/&gt;
</font>
          </font>
        </font>
        <font size="2" face="Consolas">
          <font size="2" face="Consolas">
            <p>
            </p>
          </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">&lt;/</font>
          </font>
        </font>
        <font color="#800000" size="2" face="Consolas">
          <font color="#800000" size="2" face="Consolas">
            <font color="#800000" size="2" face="Consolas">DataBindings</font>
          </font>
        </font>
        <font color="#0000ff" size="2" face="Consolas">
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">&gt;
</font>
          </font>
        </font>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=80826d52-3e5b-4381-9142-649a8d185d24" />
      </body>
      <title>RadMenu bind menu item link target</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,80826d52-3e5b-4381-9142-649a8d185d24.aspx</guid>
      <link>http://mirkamali.ir/2011/01/19/RadMenuBindMenuItemLinkTarget.aspx</link>
      <pubDate>Wed, 19 Jan 2011 08:02:57 GMT</pubDate>
      <description>&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt; 
&lt;p&gt;
Add&amp;nbsp;following code to your radmenu control. replace targetfieldname with your
field.
&lt;/font&gt;&lt;/font&gt;&gt;
&lt;p&gt;
&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&amp;lt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;DataBindings&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&amp;gt;
&lt;/p&gt;
&gt;&gt;&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt; 
&lt;p&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&amp;lt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;telerik&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;:&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;RadMenuItemBinding&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt; &lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;TargetField&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;="TargetFieldName"&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt; &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;/&amp;gt;&gt;
&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt; 
&lt;p&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&amp;lt;/&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;DataBindings&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&amp;gt;&gt;
&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=80826d52-3e5b-4381-9142-649a8d185d24" /&gt;</description>
      <category>ASP NET 2.0</category>
      <category>Telerik Controls</category>
      <category>Troubleshooting</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=24f3115f-44b0-4385-966b-7b5e21c8415f</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,24f3115f-44b0-4385-966b-7b5e21c8415f.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
Try "mstsc /admin"
</p>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=24f3115f-44b0-4385-966b-7b5e21c8415f" />
      </body>
      <title>Console Remote Desktop in Windows 7 or Widnows server 2008</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,24f3115f-44b0-4385-966b-7b5e21c8415f.aspx</guid>
      <link>http://mirkamali.ir/2011/01/19/ConsoleRemoteDesktopInWindows7OrWidnowsServer2008.aspx</link>
      <pubDate>Wed, 19 Jan 2011 07:59:41 GMT</pubDate>
      <description>&lt;p&gt;
Try "mstsc /admin"
&lt;/p&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=24f3115f-44b0-4385-966b-7b5e21c8415f" /&gt;</description>
      <category>Troubleshooting</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=5351feea-cf3d-4583-b6dc-1bc85880e8b8</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,5351feea-cf3d-4583-b6dc-1bc85880e8b8.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">When you save a table in Management Studio
that requires the table be dropped and recreated behind the scenes, the change will
fail by default with the below warning.<br /><br />
In SQL Server, tables are dropped, recreated and reloaded automatically for you without
having to worry about what's going on behind the curtains but this may create issues
for some users. This behavior is required upon a number of actions but most common
is creating a new column in a specific location in the table.<br /><br />
Warning Message:<br /><br />
Saving changes is not permitted. The changes you have made require the following tables
to be dropped and re-created. You have either made changes to a table that can't be
re-created or enabled the option Prevent saving changes that require the table to
be re-created.<br /><br />
To fix this in Management Studio, go to Tools -&gt; Options then go to the Designer
Page and uncheck "Prevent saving changes that require table re-creation".<br /><br /><p></p><img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=5351feea-cf3d-4583-b6dc-1bc85880e8b8" /></body>
      <title>SQL Server 2008 - Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. </title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,5351feea-cf3d-4583-b6dc-1bc85880e8b8.aspx</guid>
      <link>http://mirkamali.ir/2010/12/29/SQLServer2008SavingChangesIsNotPermittedTheChangesYouHaveMadeRequireTheFollowingTablesToBeDroppedAndRecreated.aspx</link>
      <pubDate>Wed, 29 Dec 2010 06:05:53 GMT</pubDate>
      <description>When you save a table in Management Studio that requires the table be dropped and recreated behind the scenes, the change will fail by default with the below warning.&lt;br&gt;
&lt;br&gt;
In SQL Server, tables are dropped, recreated and reloaded automatically for you without
having to worry about what's going on behind the curtains but this may create issues
for some users. This behavior is required upon a number of actions but most common
is creating a new column in a specific location in the table.&lt;br&gt;
&lt;br&gt;
Warning Message:&lt;br&gt;
&lt;br&gt;
Saving changes is not permitted. The changes you have made require the following tables
to be dropped and re-created. You have either made changes to a table that can't be
re-created or enabled the option Prevent saving changes that require the table to
be re-created.&lt;br&gt;
&lt;br&gt;
To fix this in Management Studio, go to Tools -&amp;gt; Options then go to the Designer
Page and uncheck "Prevent saving changes that require table re-creation".&lt;br&gt;
&lt;br&gt;
&lt;p&gt;
&lt;/p&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=5351feea-cf3d-4583-b6dc-1bc85880e8b8" /&gt;</description>
      <category>SQL Server</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=be623bbf-59ab-42a6-8c34-aa4da43e5238</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,be623bbf-59ab-42a6-8c34-aa4da43e5238.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
The problem is that when clicking on the checkbox/radiobutton, then the vertical
scrollbar jumps to the top!
</p>
        <p>
This could happen in some scenarios because of the way RadFormDecorator styles checkboxes.
When RadFormDecorator is used, the real checkboxes are hidden outside of the viewport.
When the decorated checkbox is clicked however, browsers try to focus the real checkbox,
hence the "jumping". To avoid that, the only thing that you usually need to do is
to set <strong>position:relative</strong> to the parent container.
</p>
        <p>
In this case however, because of the RTL mode, the approach is a bit different
and need to add the following CSS the page:
</p>
        <p>
          <font color="#800000" size="2" face="Consolas">
            <font color="#800000" size="2" face="Consolas">
              <font color="#800000" size="2" face="Consolas">input.rfdRealInput<br /></font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">{<br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   display</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">:</font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">block</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">;<br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   position</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">static</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">
            </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">!important</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">;<br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   float</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">right</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">;<br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   outline</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">0</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">;<br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   width</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">0</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">;<br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   height</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">0</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">;<br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   margin-top</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">-5px</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">;<br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   FILTER</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">alpha(opacity=0)</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">; <br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   -moz-opacity</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">0</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">; <br /></font>
          </font>
          <font color="#ff0000" size="2" face="Consolas">
            <font color="#ff0000" size="2" face="Consolas">
              <font color="#ff0000" size="2" face="Consolas">   opacity</font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">: </font>
          </font>
          <font color="#0000ff" size="2" face="Consolas">
            <font color="#0000ff" size="2" face="Consolas">
              <font color="#0000ff" size="2" face="Consolas">0<br /></font>
            </font>
          </font>
          <font size="2" face="Consolas">
            <font size="2" face="Consolas">}</font>
          </font>
          <br />
        </p>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=be623bbf-59ab-42a6-8c34-aa4da43e5238" />
      </body>
      <title>RadFormDecorator Problem with RTL Pages and checkboxes</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,be623bbf-59ab-42a6-8c34-aa4da43e5238.aspx</guid>
      <link>http://mirkamali.ir/2010/12/06/RadFormDecoratorProblemWithRTLPagesAndCheckboxes.aspx</link>
      <pubDate>Mon, 06 Dec 2010 06:01:09 GMT</pubDate>
      <description>&lt;p&gt;
The&amp;nbsp;problem is that when clicking on the checkbox/radiobutton, then the vertical
scrollbar jumps to the top!
&lt;/p&gt;
&lt;p&gt;
This could happen in some scenarios because of the way RadFormDecorator styles checkboxes.
When RadFormDecorator is used, the real checkboxes are hidden outside of the viewport.
When the decorated checkbox is clicked however, browsers try to focus the real checkbox,
hence the "jumping". To avoid that, the only thing that you usually need to do is
to set &lt;strong&gt;position:relative&lt;/strong&gt; to the parent container.
&lt;/p&gt;
&lt;p&gt;
In&amp;nbsp;this case however, because of the RTL mode, the approach is a bit different
and need to add the following CSS&amp;nbsp;the page:
&lt;/p&gt;
&lt;p&gt;
&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;&lt;font color=#800000 size=2 face=Consolas&gt;input.rfdRealInput&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;{&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;display&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;:&lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;block&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;position&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;static&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt; &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;!important&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;float&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;right&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;outline&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;0&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;width&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;0&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;height&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;0&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;margin-top&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;-5px&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;FILTER&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;alpha(opacity=0)&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&amp;nbsp;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;-moz-opacity&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;0&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;;&amp;nbsp;&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&lt;font color=#ff0000 size=2 face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;opacity&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;: &lt;/font&gt;&lt;/font&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;&lt;font color=#0000ff size=2 face=Consolas&gt;0&lt;br&gt;
&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size=2 face=Consolas&gt;&lt;font size=2 face=Consolas&gt;}&lt;/font&gt;&lt;/font&gt;
&lt;br&gt;
&lt;/p&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=be623bbf-59ab-42a6-8c34-aa4da43e5238" /&gt;</description>
      <category>ASP NET 2.0</category>
      <category>Troubleshooting</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=553640c7-3835-4b6c-af2a-f31470968157</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,553640c7-3835-4b6c-af2a-f31470968157.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <pre>
          <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px">To
load types in other assembly just add the assemblyname via comma at the end of your
type:</span>
        </pre>
        <pre>
          <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px">Type
mytype <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: red; FONT-SIZE: 11px">=</span> Type.GetType(<span style="BACKGROUND-COLOR: #e4e4e4; FONT-FAMILY: Courier New; COLOR: #666666; FONT-SIZE: 11px">"Class2,
Project2.Library "</span>); </span>
        </pre>
        <pre>
          <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px">for
nested class you must put plus (+) instead of dot (.):</span>
        </pre>
        <pre>
          <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px">
            <pre>
              <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px">Type
mytype <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: red; FONT-SIZE: 11px">=</span> Type.GetType(<span style="BACKGROUND-COLOR: #e4e4e4; FONT-FAMILY: Courier New; COLOR: #666666; FONT-SIZE: 11px">"Class2+SubClass1,
Project2.Library "</span>); </span>
            </pre>
          </span>
        </pre>
        <pre>
          <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px">
          </span> </pre>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=553640c7-3835-4b6c-af2a-f31470968157" />
      </body>
      <title>Load types in other assembly in C# and problem with nested classes</title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,553640c7-3835-4b6c-af2a-f31470968157.aspx</guid>
      <link>http://mirkamali.ir/2010/01/12/LoadTypesInOtherAssemblyInCAndProblemWithNestedClasses.aspx</link>
      <pubDate>Tue, 12 Jan 2010 05:50:46 GMT</pubDate>
      <description>&lt;pre&gt;&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px"&gt;To
load types in other assembly just add the assemblyname via comma at the end of your
type:&lt;/span&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px"&gt;Type
mytype &lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: red; FONT-SIZE: 11px"&gt;=&lt;/span&gt; Type.GetType(&lt;span style="BACKGROUND-COLOR: #e4e4e4; FONT-FAMILY: Courier New; COLOR: #666666; FONT-SIZE: 11px"&gt;"Class2,
Project2.Library "&lt;/span&gt;); &lt;/span&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px"&gt;for
nested class you must put plus (+) instead of dot (.):&lt;/span&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px"&gt;&lt;pre&gt;&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px"&gt;Type
mytype &lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: red; FONT-SIZE: 11px"&gt;=&lt;/span&gt; Type.GetType(&lt;span style="BACKGROUND-COLOR: #e4e4e4; FONT-FAMILY: Courier New; COLOR: #666666; FONT-SIZE: 11px"&gt;"Class2+SubClass1,
Project2.Library "&lt;/span&gt;); &lt;/span&gt;&lt;/pre&gt;
&lt;/span&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px"&gt;&lt;/span&gt;&amp;nbsp;&lt;/pre&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=553640c7-3835-4b6c-af2a-f31470968157" /&gt;</description>
      <category>ASP NET 2.0</category>
      <category>C#</category>
    </item>
    <item>
      <trackback:ping>http://mirkamali.ir/Trackback.aspx?guid=0bfc8844-3678-45c0-8ac5-d6ed9518ff4f</trackback:ping>
      <pingback:server>http://mirkamali.ir/pingback.aspx</pingback:server>
      <pingback:target>http://mirkamali.ir/PermaLink,guid,0bfc8844-3678-45c0-8ac5-d6ed9518ff4f.aspx</pingback:target>
      <dc:creator>Amir Mirkamali</dc:creator>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <pre>
          <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px">
            <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: blue; FONT-SIZE: 11px">foreach</span> (myEnum
item <span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: blue; FONT-SIZE: 11px">in</span> Enum.GetValues(<span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: blue; FONT-SIZE: 11px">typeof</span>(myEnum)))
{ ... }</span>
        </pre>
        <img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=0bfc8844-3678-45c0-8ac5-d6ed9518ff4f" />
      </body>
      <title>Loop with foreach through an Enum </title>
      <guid isPermaLink="false">http://mirkamali.ir/PermaLink,guid,0bfc8844-3678-45c0-8ac5-d6ed9518ff4f.aspx</guid>
      <link>http://mirkamali.ir/2009/09/02/LoopWithForeachThroughAnEnum.aspx</link>
      <pubDate>Wed, 02 Sep 2009 11:52:30 GMT</pubDate>
      <description>&lt;pre&gt;&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: black; FONT-SIZE: 11px"&gt;&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: blue; FONT-SIZE: 11px"&gt;foreach&lt;/span&gt; (myEnum
item &lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: blue; FONT-SIZE: 11px"&gt;in&lt;/span&gt; Enum.GetValues(&lt;span style="BACKGROUND-COLOR: transparent; FONT-FAMILY: Courier New; COLOR: blue; FONT-SIZE: 11px"&gt;typeof&lt;/span&gt;(myEnum)))
{ ... }&lt;/span&gt;&lt;/pre&gt;
&lt;img width="0" height="0" src="http://mirkamali.ir/aggbug.ashx?id=0bfc8844-3678-45c0-8ac5-d6ed9518ff4f" /&gt;</description>
      <category>ASP NET 1.0</category>
      <category>ASP NET 2.0</category>
    </item>
  </channel>
</rss>
