tag:blogger.com,1999:blog-61401935923895790752023-11-15T06:42:03.972-08:00.Net Daily IssuesUnknownnoreply@blogger.comBlogger35125tag:blogger.com,1999:blog-6140193592389579075.post-88818504910087934692011-02-04T09:41:00.000-08:002011-02-04T09:41:38.940-08:00Some c# linkshttp://www.csharp-examples.net/get-files-from-directory/<br />
<br />
<br />
Arrays:<br />
<br />
http://msdn.microsoft.com/en-us/library/aa288453(v=vs.71).aspx<br />
<br />
Split:<br />
<br />
http://dotnetperls.com/string-split<br />
<br />
Foreach;<br />
<br />
http://msdn.microsoft.com/en-us/library/aa288257(v=vs.71).aspx<br />
<br />
strings:<br />
<br />
http://msdn.microsoft.com/en-us/library/ms228362.aspx<br />
<br />
Functions:<br />
<br />
http://csharp.net-tutorials.com/basics/functions/<br />
<br />
Try Catch:<br />
<br />
http://msdn.microsoft.com/en-us/library/0yd65esw(v=vs.71).aspx<br />
<br />
Byval - Byref:<br />
<br />
http://www.dotnetspider.com/forum/180058-ByVal-ByRef-example-C-net.aspx<br />
<br />
sql<br />
<br />
http://www.w3enterprises.com/articles/using.aspx<br />
<br />
http://www.codeproject.com/KB/database/sql_in_csharp.aspxUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-59497623460582257052011-02-04T09:40:00.000-08:002011-02-04T09:45:30.725-08:00c# - continuing app : Insert Mod.<div><span style="color: teal;">1</span><span style="font-size: x-small;"> <span style="color: blue;">using</span></span><span style="font-size: x-small;"><span style="color: black;"> System;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">2</span> <span style="color: black;"></span><span style="color: blue;">using</span></span><span style="font-size: x-small;"><span style="color: black;"> System.Collections.Generic;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">3</span> <span style="color: black;"></span><span style="color: blue;">using</span></span><span style="font-size: x-small;"><span style="color: black;"> System.Linq;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">4</span> <span style="color: black;"></span><span style="color: blue;">using</span></span><span style="font-size: x-small;"><span style="color: black;"> System.Text;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">5</span> <span style="color: black;"></span><span style="color: blue;">using</span></span><span style="font-size: x-small;"><span style="color: black;"> System.Data.SqlClient;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">6</span> </span><span style="color: black;"><br />
</span><span style="font-size: x-small;"><span style="color: teal;">7</span> <span style="color: black;"></span><span style="color: blue;">namespace</span></span><span style="font-size: x-small;"><span style="color: black;"> PageControlRegistry</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">8</span> </span><span style="font-size: x-small;"><span style="color: black;">{</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">9</span></span><span style="font-size: x-small;"> <span style="color: black;"></span><span style="color: blue;">class</span></span><span style="font-size: x-small;"><span style="color: black;"> Operations</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">10</span> </span><span style="font-size: x-small;"><span style="color: black;">{</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">11</span> <span style="color: black;"></span><span style="color: blue;">public</span><span style="color: black;"> </span><span style="color: blue;">int</span><span style="color: black;"> CreateObject(</span><span style="color: blue;">string</span><span style="color: black;"> strSYME_PAGE, </span><span style="color: blue;">string</span><span style="color: black;"> strSYOB_OBJECTNAME, </span><span style="color: blue;">string</span><span style="color: black;"> strSYOB_OBJECTLABEL, </span><span style="color: blue;">int</span></span><span style="font-size: x-small;"><span style="color: black;"> intSYOB_OBJECTTYPE)</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">12</span></span><span style="font-size: x-small;"> </span><span style="font-size: x-small;"><span style="color: black;">{</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">13</span> <span style="color: black;">SqlCommand cmdcommand </span><span style="color: black;">=</span><span style="color: black;"> </span><span style="color: blue;">null</span></span><span style="font-size: x-small;"><span style="color: black;">;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">14</span> </span><span style="font-size: x-small;"><span style="color: black;">Connection modCon;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">15</span> <span style="color: black;"></span><span style="color: blue;">string</span></span><span style="font-size: x-small;"><span style="color: black;"> SQLString;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">16</span> <span style="color: black;"></span><span style="color: blue;">try</span></span><span style="color: black;"><br />
</span><span style="font-size: x-small;"><span style="color: teal;">17</span> </span><span style="font-size: x-small;"><span style="color: black;">{</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">18</span></span><span style="font-size: x-small;"> <span style="color: black;">modCon </span><span style="color: black;">=</span><span style="color: black;"> </span><span style="color: blue;">new</span></span><span style="font-size: x-small;"><span style="color: black;"> Connection();</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">19</span> <span style="color: black;">cmdcommand </span><span style="color: black;">=</span><span style="color: black;"> </span><span style="color: blue;">new</span></span><span style="font-size: x-small;"><span style="color: black;"> SqlCommand();</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">20</span> <span style="color: black;">cmdcommand.Connection </span><span style="color: black;">=</span></span><span style="font-size: x-small;"><span style="color: black;"> modCon.runCon();</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">21</span> <span style="color: black;">SQLString </span><span style="color: black;">=</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;">insert into app_menu_object</span><span style="color: maroon;">"</span></span><span style="font-size: x-small;"><span style="color: black;">;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">22</span> <span style="color: black;">SQLString </span><span style="color: black;">+=</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;"> (SYME_SEQ, SYME_PAGE, SYOB_OBJECTNAME, SYOB_OBJECTLABEL, SYOB_OBJECTTYPE, SYOB_OBJECTTYPEDESC)</span><span style="color: maroon;">"</span></span><span style="font-size: x-small;"><span style="color: black;">;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">23</span> <span style="color: black;">SQLString </span><span style="color: black;">+=</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;"> SELECT SYME_SEQ, '</span><span style="color: maroon;">"</span><span style="color: black;"> </span><span style="color: black;">+</span><span style="color: black;"> strSYME_PAGE </span><span style="color: black;">+</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;">', '</span><span style="color: maroon;">"</span><span style="color: black;"> </span><span style="color: black;">+</span><span style="color: black;"> strSYOB_OBJECTNAME </span><span style="color: black;">+</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;">', '</span><span style="color: maroon;">"</span><span style="color: black;"> </span><span style="color: black;">+</span><span style="color: black;"> strSYOB_OBJECTLABEL </span><span style="color: black;">+</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;">', </span><span style="color: maroon;">"</span></span><span style="font-size: x-small;"><span style="color: black;">;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">24</span> <span style="color: black;">SQLString </span><span style="color: black;">+=</span><span style="color: black;"> intSYOB_OBJECTTYPE </span><span style="color: black;">+</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;">, dbo.ITP_GetDescription('OBJ', '</span><span style="color: maroon;">"</span><span style="color: black;"> </span><span style="color: black;">+</span><span style="color: black;"> intSYOB_OBJECTTYPE </span><span style="color: black;">+</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;">')</span><span style="color: maroon;">"</span></span><span style="font-size: x-small;"><span style="color: black;">;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">25</span> <span style="color: black;">SQLString </span><span style="color: black;">+=</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;"> FROM app_menu WHERE ACTIVE = 1 AND SYME_URL LIKE '%/</span><span style="color: maroon;">"</span><span style="color: black;"> </span><span style="color: black;">+</span><span style="color: black;"> strSYME_PAGE </span><span style="color: black;">+</span><span style="color: black;"> </span><span style="color: maroon;">"</span><span style="color: maroon;">'</span><span style="color: maroon;">"</span></span><span style="font-size: x-small;"><span style="color: black;">;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">26</span> <span style="color: black;">cmdcommand.CommandText </span><span style="color: black;">=</span></span><span style="font-size: x-small;"><span style="color: black;"> SQLString;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">27</span> </span><span style="font-size: x-small;"><span style="color: black;">cmdcommand.ExecuteNonQuery();</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">28</span> </span><span style="font-size: x-small;"><span style="color: black;">cmdcommand.Connection.Close();</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">29</span> <span style="color: black;"></span><span style="color: blue;">return</span><span style="color: black;"> </span><span style="color: purple;">0</span></span><span style="font-size: x-small;"><span style="color: black;">;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">30</span> </span><span style="font-size: x-small;"><span style="color: black;">}</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">31</span> <span style="color: black;"></span><span style="color: blue;">catch</span></span><span style="color: black;"><br />
</span><span style="font-size: x-small;"><span style="color: teal;">32</span> </span><span style="font-size: x-small;"><span style="color: black;">{</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">33</span> <span style="color: black;"></span><span style="color: blue;">if</span><span style="color: black;"> (cmdcommand </span><span style="color: black;">!=</span><span style="color: black;"> </span><span style="color: blue;">null</span></span><span style="font-size: x-small;"><span style="color: black;">)</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">34</span> </span><span style="font-size: x-small;"><span style="color: black;">{</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">35</span> </span><span style="font-size: x-small;"><span style="color: black;">cmdcommand.Dispose();</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">36</span> </span><span style="font-size: x-small;"><span style="color: black;">}</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">37</span> <span style="color: black;"></span><span style="color: blue;">return</span><span style="color: black;"> </span><span style="color: purple;">1</span></span><span style="font-size: x-small;"><span style="color: black;">;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">38</span> </span><span style="font-size: x-small;"><span style="color: black;">}</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">39</span> </span><span style="font-size: x-small;"><span style="color: black;">}</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">40</span> </span><span style="font-size: x-small;"><span style="color: black;">}</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">41</span> <span style="color: black;">}</span></span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-16804818104613101202011-02-04T09:35:00.000-08:002011-02-04T09:35:52.293-08:00c# connection.mod - App to save fcontrols from web pages in a folder.<div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;"> 1</span> <span style="color: #0000FF;">using</span><span style="color: #000000;"> System;<br />
</span><span style="color: #008080;"> 2</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Collections.Generic;<br />
</span><span style="color: #008080;"> 3</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Linq;<br />
</span><span style="color: #008080;"> 4</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Text;<br />
</span><span style="color: #008080;"> 5</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Data;<br />
</span><span style="color: #008080;"> 6</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Data.SqlClient;<br />
</span><span style="color: #008080;"> 7</span> <span style="color: #000000;"></span><span style="color: #0000FF;">namespace</span><span style="color: #000000;"> PageControlRegistry<br />
</span><span style="color: #008080;"> 8</span> <span style="color: #000000;">{<br />
</span><span style="color: #008080;"> 9</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">class</span><span style="color: #000000;"> Connection<br />
</span><span style="color: #008080;">10</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">11</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">12</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> SqlConnection runCon() {<br />
</span><span style="color: #008080;">13</span> <span style="color: #000000;"> SqlConnection conn </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">14</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">try</span><span style="color: #000000;">{<br />
</span><span style="color: #008080;">15</span> <span style="color: #000000;"> conn </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> SqlConnection(</span><span style="color: #800000;">@"</span><span style="color: #800000;">Data Source='Mysqldev2005';Initial Catalog='MYDB';User Id='kathy';Password='password';</span><span style="color: #800000;">"</span><span style="color: #000000;">);<br />
</span><span style="color: #008080;">16</span> <span style="color: #000000;"> conn.Open();<br />
</span><span style="color: #008080;">17</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> conn;<br />
</span><span style="color: #008080;">18</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">19</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">catch</span><span style="color: #000000;">{<br />
</span><span style="color: #008080;">20</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (conn </span><span style="color: #000000;">!=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">) {<br />
</span><span style="color: #008080;">21</span> <span style="color: #000000;"> conn.Dispose();<br />
</span><span style="color: #008080;">22</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">23</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">24</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">25</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">26</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">27</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">28</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">29</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">30</span> <span style="color: #000000;"> }</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-18659611516025392672011-02-04T09:29:00.001-08:002011-02-04T09:29:43.912-08:00C# - Application to save controls of web pages in a Folder<div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;"> 1</span> <span style="color: #0000FF;">using</span><span style="color: #000000;"> System;<br />
</span><span style="color: #008080;"> 2</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Collections.Generic;<br />
</span><span style="color: #008080;"> 3</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.ComponentModel;<br />
</span><span style="color: #008080;"> 4</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Data;<br />
</span><span style="color: #008080;"> 5</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Drawing;<br />
</span><span style="color: #008080;"> 6</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Linq;<br />
</span><span style="color: #008080;"> 7</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Text;<br />
</span><span style="color: #008080;"> 8</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.Windows.Forms;<br />
</span><span style="color: #008080;"> 9</span> <span style="color: #000000;"></span><span style="color: #0000FF;">using</span><span style="color: #000000;"> System.IO;<br />
</span><span style="color: #008080;"> 10</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 11</span> <span style="color: #000000;"></span><span style="color: #0000FF;">namespace</span><span style="color: #000000;"> PageControlRegistry<br />
</span><span style="color: #008080;"> 12</span> <span style="color: #000000;">{<br />
</span><span style="color: #008080;"> 13</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> </span><span style="color: #0000FF;">partial</span><span style="color: #000000;"> </span><span style="color: #0000FF;">class</span><span style="color: #000000;"> Form1 : Form<br />
</span><span style="color: #008080;"> 14</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 15</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">public</span><span style="color: #000000;"> Form1()<br />
</span><span style="color: #008080;"> 16</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 17</span> <span style="color: #000000;"> InitializeComponent();<br />
</span><span style="color: #008080;"> 18</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 19</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 20</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">private</span><span style="color: #000000;"> </span><span style="color: #0000FF;">void</span><span style="color: #000000;"> button1_Click(</span><span style="color: #0000FF;">object</span><span style="color: #000000;"> sender, EventArgs e)<br />
</span><span style="color: #008080;"> 21</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 22</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">string</span><span style="color: #000000;"> foldername </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">""</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 23</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">string</span><span style="color: #000000;"> path </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">""</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 24</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">string</span><span style="color: #000000;">[] options;<br />
</span><span style="color: #008080;"> 25</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">string</span><span style="color: #000000;">[] filesinPath;<br />
</span><span style="color: #008080;"> 26</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 27</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 28</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> i </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 29</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 30</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">try</span><span style="color: #000000;"><br />
</span><span style="color: #008080;"> 31</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 32</span> <span style="color: #000000;"> </span><span style="color: #008000;">//</span><span style="color: #008000;">Cleaning the ListBox</span><span style="color: #008000;"><br />
</span><span style="color: #008080;"> 33</span> <span style="color: #008000;"></span><span style="color: #000000;"> listBox1.Items.Clear();<br />
</span><span style="color: #008080;"> 34</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 35</span> <span style="color: #000000;"> </span><span style="color: #008000;">//</span><span style="color: #008000;">Verifying the </span><span style="color: #008000;"><br />
</span><span style="color: #008080;"> 36</span> <span style="color: #008000;"></span><span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (chkSO.Checked </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #0000FF;">true</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;"> 37</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 38</span> <span style="color: #000000;"> foldername </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">NS_So</span><span style="color: #800000;">"</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 39</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 40</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 41</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (chkProd.Checked </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #0000FF;">true</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;"> 42</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 43</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (foldername.Length </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;"> 44</span> <span style="color: #000000;"> { foldername </span><span style="color: #000000;">+=</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">|</span><span style="color: #800000;">"</span><span style="color: #000000;">; }<br />
</span><span style="color: #008080;"> 45</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 46</span> <span style="color: #000000;"> foldername </span><span style="color: #000000;">+=</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">NS_Production</span><span style="color: #800000;">"</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 47</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 48</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 49</span> <span style="color: #000000;"> options </span><span style="color: #000000;">=</span><span style="color: #000000;"> foldername.Split(</span><span style="color: #0000FF;">new</span><span style="color: #000000;"> </span><span style="color: #0000FF;">string</span><span style="color: #000000;">[] { </span><span style="color: #800000;">"</span><span style="color: #800000;">|</span><span style="color: #800000;">"</span><span style="color: #000000;"> }, StringSplitOptions.None);<br />
</span><span style="color: #008080;"> 50</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">for</span><span style="color: #000000;"> (i </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">; i </span><span style="color: #000000;"><</span><span style="color: #000000;"> options.Length; i</span><span style="color: #000000;">++</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;"> 51</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 52</span> <span style="color: #000000;"> path </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #800000;">@"</span><span style="color: #800000;">C:\DEV\</span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> options[i] </span><span style="color: #000000;">+</span><span style="color: #000000;"> </span><span style="color: #800000;">@"</span><span style="color: #800000;">\Pages</span><span style="color: #800000;">"</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 53</span> <span style="color: #000000;"> filesinPath </span><span style="color: #000000;">=</span><span style="color: #000000;"> Directory.GetFiles(path, </span><span style="color: #800000;">"</span><span style="color: #800000;">*.aspx</span><span style="color: #800000;">"</span><span style="color: #000000;">);<br />
</span><span style="color: #008080;"> 54</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">foreach</span><span style="color: #000000;"> (</span><span style="color: #0000FF;">string</span><span style="color: #000000;"> filei </span><span style="color: #0000FF;">in</span><span style="color: #000000;"> filesinPath)<br />
</span><span style="color: #008080;"> 55</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 56</span> <span style="color: #000000;"> listBox1.Items.Add(filei);<br />
</span><span style="color: #008080;"> 57</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> ival </span><span style="color: #000000;">=</span><span style="color: #000000;"> FolderFilesLookUp(filei);<br />
</span><span style="color: #008080;"> 58</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ival </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 59</span> <span style="color: #000000;"> <br />
</span><span style="color: #008080;"> 60</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 61</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 62</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 63</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 64</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 65</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 66</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 67</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">catch</span><span style="color: #000000;"> (Exception ex) {<br />
</span><span style="color: #008080;"> 68</span> <span style="color: #000000;"> lblError.Text </span><span style="color: #000000;">=</span><span style="color: #000000;"> ex.Message;<br />
</span><span style="color: #008080;"> 69</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 70</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 71</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 72</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 73</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 74</span> <span style="color: #000000;"></span><span style="color: #0000FF;">#region</span><span style="color: #000000;"> Functions</span><span style="color: #000000;"><br />
</span><span style="color: #008080;"> 75</span> <span style="color: #000000;"> </span><span style="color: #008000;">//</span><span style="color: #008000;">Function</span><span style="color: #008000;"><br />
</span><span style="color: #008080;"> 76</span> <span style="color: #008000;"></span><span style="color: #000000;"> </span><span style="color: #0000FF;">private</span><span style="color: #000000;"> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> FolderFilesLookUp(</span><span style="color: #0000FF;">string</span><span style="color: #000000;"> filei)<br />
</span><span style="color: #008080;"> 77</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 78</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">string</span><span style="color: #000000;"> sLine;<br />
</span><span style="color: #008080;"> 79</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">string</span><span style="color: #000000;"> sFile;<br />
</span><span style="color: #008080;"> 80</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">try</span><span style="color: #000000;"><br />
</span><span style="color: #008080;"> 81</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 82</span> <span style="color: #000000;"> FileStream fs </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> FileStream(filei, FileMode.Open, FileAccess.Read);<br />
</span><span style="color: #008080;"> 83</span> <span style="color: #000000;"> StreamReader d </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> StreamReader(fs);<br />
</span><span style="color: #008080;"> 84</span> <span style="color: #000000;"> d.BaseStream.Seek(</span><span style="color: #800080;">0</span><span style="color: #000000;">, SeekOrigin.Begin);<br />
</span><span style="color: #008080;"> 85</span> <span style="color: #000000;"> sFile </span><span style="color: #000000;">=</span><span style="color: #000000;"> System.IO.Path.GetFileNameWithoutExtension(filei) </span><span style="color: #000000;">+</span><span style="color: #000000;"> </span><span style="color: #800000;">"</span><span style="color: #800000;">.aspx</span><span style="color: #800000;">"</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 86</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 87</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">while</span><span style="color: #000000;"> (d.Peek() </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #000000;">-</span><span style="color: #800080;">1</span><span style="color: #000000;">) {<br />
</span><span style="color: #008080;"> 88</span> <span style="color: #000000;"> sLine </span><span style="color: #000000;">=</span><span style="color: #000000;"> d.ReadLine();<br />
</span><span style="color: #008080;"> 89</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 90</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:DropDownList</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;"> 91</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 92</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">11</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 93</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 94</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;"> 95</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:ListBox</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;"> 96</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;"> 97</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">12</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;"> 98</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;"> 99</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">100</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:Label</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">101</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">102</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">3</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">103</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">104</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">105</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:TextBox</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">106</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">107</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">5</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">108</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">109</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">110</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:ImageButton</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">111</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">112</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">15</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">113</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">114</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">115</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:Button</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">116</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">117</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">1</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">118</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">119</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">120</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:RadioButton</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">121</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">122</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">7</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">123</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">124</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">125</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:RadioButtonList</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">126</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">127</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">13</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">128</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">129</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">130</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><asp:CheckBoxList</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">131</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">132</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">14</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">133</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">134</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">135</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><telerik:RadComboBox</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">136</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">137</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">10</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">138</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">139</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">140</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (sLine.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;"><telerik:RadNumericTextBox</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)<br />
</span><span style="color: #008080;">141</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">142</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (ControlIDLookUP(sFile, </span><span style="color: #800080;">6</span><span style="color: #000000;">, sLine) </span><span style="color: #000000;">==</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">) </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">143</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">144</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">145</span> <span style="color: #000000;"> <br />
</span><span style="color: #008080;">146</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">147</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">148</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">149</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">catch</span><span style="color: #000000;"> (Exception ex)<br />
</span><span style="color: #008080;">150</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">151</span> <span style="color: #000000;"> lblError.Text </span><span style="color: #000000;">=</span><span style="color: #000000;"> ex.Message;<br />
</span><span style="color: #008080;">152</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">153</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">154</span> <span style="color: #000000;"> <br />
</span><span style="color: #008080;">155</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">156</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">157</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">private</span><span style="color: #000000;"> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> ControlIDLookUP(</span><span style="color: #0000FF;">string</span><span style="color: #000000;"> sFile, </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> intControlType, </span><span style="color: #0000FF;">string</span><span style="color: #000000;"> strText)<br />
</span><span style="color: #008080;">158</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">159</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">string</span><span style="color: #000000;"> sControl;<br />
</span><span style="color: #008080;">160</span> <span style="color: #000000;"> Operations modOper;<br />
</span><span style="color: #008080;">161</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">int</span><span style="color: #000000;"> iResult;<br />
</span><span style="color: #008080;">162</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">try</span><span style="color: #000000;"><br />
</span><span style="color: #008080;">163</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">164</span> <span style="color: #000000;"> modOper </span><span style="color: #000000;">=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Operations();<br />
</span><span style="color: #008080;">165</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">166</span> <span style="color: #000000;"> strText </span><span style="color: #000000;">=</span><span style="color: #000000;"> strText.Substring(strText.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;">ID=</span><span style="color: #800000;">"</span><span style="color: #000000;">) </span><span style="color: #000000;">+</span><span style="color: #000000;"> </span><span style="color: #800080;">4</span><span style="color: #000000;">);<br />
</span><span style="color: #008080;">167</span> <span style="color: #000000;"> sControl </span><span style="color: #000000;">=</span><span style="color: #000000;"> strText.Substring(</span><span style="color: #800080;">0</span><span style="color: #000000;">, strText.IndexOf(</span><span style="color: #800000;">"</span><span style="color: #800000;">\"</span><span style="color: #800000;">"</span><span style="color: #000000;">));<br />
</span><span style="color: #008080;">168</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">169</span> <span style="color: #000000;"> iResult </span><span style="color: #000000;">=</span><span style="color: #000000;"> modOper.CreateObject(sFile, sControl, </span><span style="color: #800000;">""</span><span style="color: #000000;">, intControlType);<br />
</span><span style="color: #008080;">170</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">171</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> iResult;<br />
</span><span style="color: #008080;">172</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">173</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">174</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">catch</span><span style="color: #000000;"> (Exception ex)<br />
</span><span style="color: #008080;">175</span> <span style="color: #000000;"> {<br />
</span><span style="color: #008080;">176</span> <span style="color: #000000;"> lblError.Text </span><span style="color: #000000;">=</span><span style="color: #000000;"> ex.Message;<br />
</span><span style="color: #008080;">177</span> <span style="color: #000000;"> </span><span style="color: #0000FF;">return</span><span style="color: #000000;"> </span><span style="color: #800080;">1</span><span style="color: #000000;">;<br />
</span><span style="color: #008080;">178</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">179</span> <span style="color: #000000;"> <br />
</span><span style="color: #008080;">180</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">181</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">182</span> <span style="color: #000000;"></span><span style="color: #0000FF;">#endregion</span><span style="color: #000000;"><br />
</span><span style="color: #008080;">183</span> <span style="color: #000000;"> }<br />
</span><span style="color: #008080;">184</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">185</span> <span style="color: #000000;"><br />
</span><span style="color: #008080;">186</span> <span style="color: #000000;">}</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-26001716676776041662011-01-25T11:02:00.000-08:002011-01-25T11:06:54.727-08:00SetValue not working for RadNumericTextbox<span style="font-size: x-small;"><strong>Situation:</strong></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;">Setting a RadNumericTextBox's value using a Javascript function was not an issue in previous versions of Telerik. However, once I updated my Telerik Version to v. 2010.3.1109.40. This SetValue property was not working anymore.</span><br />
<br />
<span style="font-size: x-small;"><strong>Solution:</strong></span><br />
<span style="font-size: x-small;">1) RadNumericTextBox definition in HTML</span><br />
<br />
<div><span style="font-size: x-small;"><span style="color: teal;">1</span> <span style="color: blue;"><</span><span style="color: maroon;">telerik:RadNumericTextBox </span><span style="color: red;">ID</span><span style="color: blue;">="txtTaxCode"</span><span style="color: red;"> runat</span><span style="color: blue;">="server"</span><span style="color: red;"> CssClass</span><span style="color: blue;">="textbox_num_enabled2"</span><span style="color: red;"> Width</span><span style="color: blue;">="40px"</span><span style="color: red;"> MaxLength</span><span style="color: blue;">="4"</span><span style="color: red;"> MinValue</span><span style="color: blue;">="0"</span><span style="color: red;"> MaxValue</span><span style="color: blue;">="9999"</span><span style="color: red;"> EnableEmbeddedSkins</span><span style="color: blue;">="false"</span><span style="color: blue;">></span></span><span style="color: black;"><br />
</span><span style="font-size: x-small;"><span style="color: teal;">2</span> <span style="color: black;"></span><span style="color: blue;"><</span><span style="color: maroon;">ClientEvents </span><span style="color: red;">OnLoad</span><span style="color: blue;">="Loadradvalue"</span><span style="color: blue;">/></span></span><span style="font-size: x-small;"><span style="color: black;"> </span><span style="color: teal;">3</span> <span style="color: black;"></span><span style="color: blue;"><</span><span style="color: maroon;">NumberFormat </span><span style="color: red;">DecimalDigits</span><span style="color: blue;">="0"</span><span style="color: red;"> GroupSeparator</span><span style="color: blue;">=""</span><span style="color: blue;">/></span></span><span style="color: black;"><br />
</span><span style="font-size: x-small;"><span style="color: teal;">4</span> <span style="color: black;"></span><span style="color: blue;"></</span><span style="color: maroon;">telerik:RadNumericTextBox</span><span style="color: blue;">></span></span></div><br />
<span style="color: #741b47; font-size: x-small;"><strong>Very Important:</strong></span><br />
<span style="color: #741b47; font-size: x-small;"><strong>Be sure to call a Javascript function in one event declared in the ClientEvents tag of the control. In the example: onload event.</strong></span><br />
<span style="font-size: x-small;"><br />
</span><br />
<span style="font-size: x-small;"><br />
</span><br />
<span style="font-size: x-small;">2) Javascript code for the function ClientEvents' event:</span><br />
<br />
<div><span style="font-size: x-small;"><span style="color: teal;">1</span> <span style="color: black;"></span><span style="color: blue;">function</span></span><span style="font-size: x-small;"><span style="color: black;"> Loadradvalue(sender, args) {</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">2</span></span><span style="font-size: x-small;"> <span style="color: black;">radvalue </span><span style="color: black;">=</span></span><span style="font-size: x-small;"><span style="color: black;"> sender;</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">3</span> <span style="color: black;">}</span></span></div><br />
<br />
<span style="font-size: x-small;">3)Javascript code to set the value:</span><br />
<div><span style="font-size: x-small;"><span style="color: teal;">1</span> <span style="color: black;"></span><span style="color: blue;">function</span><span style="color: black;"> CallBackFunction(radWindow) {</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">2</span> <span style="color: black;">radvalue.set_value(</span><span style="color: black;">5</span><span style="color: black;">);</span></span><br />
<span style="font-size: x-small;"><span style="color: teal;">3</span> <span style="color: black;">}</span></span><br />
<br />
<span style="font-size: x-small;">Now, it works well in my project. More information of properties and methods for Radnumerictextbox and other Telerik controls available here: <a href="http://www.telerik.com/help/aspnet-ajax/input_clientsideradnumerictextbox.html">http://www.telerik.com/help/aspnet-ajax/input_clientsideradnumerictextbox.html</a></span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-36282550169420463082010-08-13T09:06:00.000-07:002010-08-13T09:12:02.298-07:00Hiding GridEditCommandColumn and CommandItemDisplay<span style="font-size:85%;">It is not necessary to disable a gridEditCommandColumn in the prerender or databind event of the radgrid or datagrid.<br /><br />To hide the GridEditCommandColumn:<br /><br /><strong><span style="font-size:78%;">wgdDetails.Columns.Item(1).Visible = False</span></strong><br /><br /><br />To hide the CommandItem (Add) </span><br /><span style="font-size:85%;"><br /></span><span style="font-size:78%;"><strong>wgdDetails.MasterTableView.IsItemInserted = False<br />wgdDetails.MasterTableView.CommandItemDisplay = Telerik.Web.UI.GridCommandItemDisplay.None</strong></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-50647492004441759872010-08-03T14:09:00.000-07:002010-08-03T14:27:48.853-07:00Filter DataTable<span style="font-size:85%;">Method to filter datatable. Returns a dataset with two datatables (0ne for the filtered data and another one to show any error message defined in the caller method or event)</span><br /><br /><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Protected</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Function</span><span style="color:#000000;"> FilterDataTable(</span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> strFilterString </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">String</span><span style="color:#000000;">, </span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> dtMainTable </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> Data.DataTable, </span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> strMessage </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">String</span><span style="color:#000000;">) </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> Data.DataSet<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> ResultData </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> DataSet<br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> dtMessage </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> Data.DataTable<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> DataTableClon </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> Data.DataTable<br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> drClon </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> System.Data.DataRow()<br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> dsDataFiltered </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> Data.DataSet<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Try</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">8</span> </span><span style="font-size:78%;"><span style="color:#000000;">ResultData.Tables.Add(dtMainTable)<br /></span><span style="color:#008080;">9</span> <span style="color:#000000;">DataTableClon </span><span style="color:#000000;">=</span><span style="color:#000000;"> ResultData.Tables(</span><span style="color:#800080;">0</span></span><span style="font-size:78%;"><span style="color:#000000;">).Copy<br /></span><span style="color:#008080;">10</span> </span><span style="font-size:78%;"><span style="color:#000000;">DataTableClon.Rows.Clear()<br /></span><span style="color:#008080;">11</span> <span style="color:#000000;">drClon </span><span style="color:#000000;">=</span><span style="color:#000000;"> ResultData.Tables(</span><span style="color:#800080;">0</span></span><span style="font-size:78%;"><span style="color:#000000;">).Select(strFilterString)<br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#0000ff;">For</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Each</span><span style="color:#000000;"> dr </span><span style="color:#0000ff;">In</span></span><span style="font-size:78%;"><span style="color:#000000;"> drClon<br /></span><span style="color:#008080;">13</span> </span><span style="font-size:78%;"><span style="color:#000000;">DataTableClon.ImportRow(dr)<br /></span><span style="color:#008080;">14</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Next</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">15</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">16</span> <span style="color:#000000;">dtMessage.TableName </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">Header</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">17</span> <span style="color:#000000;">dtMessage.Columns.Add(</span><span style="color:#800000;">"</span><span style="color:#800000;">ErrorMessage</span><span style="color:#800000;">"</span><span style="color:#000000;">, </span><span style="color:#0000ff;">GetType</span></span><span style="font-size:78%;"><span style="color:#000000;">(System.String))<br /></span><span style="color:#008080;">18</span> </span><span style="font-size:78%;"><span style="color:#000000;">dsDataFiltered.Tables.Add(DataTableClon)<br /></span><span style="color:#008080;">19</span> </span><span style="font-size:78%;"><span style="color:#000000;">dsDataFiltered.Tables.Add(dtMessage)<br /></span><span style="color:#008080;">20</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> newMessageRow </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> DataRow </span><span style="color:#000000;">=</span><span style="color:#000000;"> dsDataFiltered.Tables(</span><span style="color:#800000;">"</span><span style="color:#800000;">Header</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">).NewRow()<br /></span><span style="color:#008080;">21</span> <span style="color:#000000;">newMessageRow(</span><span style="color:#800000;">"</span><span style="color:#800000;">ErrorMessage</span><span style="color:#800000;">"</span><span style="color:#000000;">) </span><span style="color:#000000;">=</span></span><span style="font-size:78%;"><span style="color:#000000;"> strMessage<br /></span><span style="color:#008080;">22</span> <span style="color:#000000;">dsDataFiltered.Tables(</span><span style="color:#800000;">"</span><span style="color:#800000;">Header</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">).Rows.Add(newMessageRow)<br /></span><span style="color:#008080;">23</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">24</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Catch</span><span style="color:#000000;"> ex </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> Exception<br /></span><span style="color:#008080;">25</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Call</span><span style="color:#000000;"> ManageError(strGlobalUser, strAppName, strModName, </span><span style="color:#800000;">"</span><span style="color:#800000;">FilterDataTable</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">, intGlobalMain, Err, strGlobalPathError, ApplicationType.Web)<br /></span><span style="color:#008080;">26</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Finally</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">27</span> <span style="color:#000000;">FilterDataTable </span><span style="color:#000000;">=</span></span><span style="font-size:78%;"><span style="color:#000000;"> dsDataFiltered<br /></span><span style="color:#008080;">28</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Try</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">29</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End Function</span></span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-20504369283516785722010-08-03T13:36:00.001-07:002010-08-03T14:09:52.992-07:00Export to a formatted excel file as an attachment (safe mode)<span style="font-size:85%;">If you want to export a datatable into an excel file keeping each columns place in an excel file and you want also to be asked where you want your excel file to be saved. Then you should use the method I have bellow.<br /><br />If you are also one of those programmers who had this:<br /><strong><span style="color:#ff0000;">Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.,</span></strong> then, you should also use this code instead of the one you are currently trying to make work.<br /><br />I've tried before and it worked fine locally. However, once I deployed it didn't work at all. I tried to find out how to solve that issue and even though I did everything suggested on the net it never worked. May be the reason is because Microsoft doesn't support server side automation at office. You can read more about that </span><a href="http://support.microsoft.com/kb/257757/"><span style="font-size:85%;">here</span></a><br /><br /><strong><span style="font-size:85%;">The method:</span></strong><br /><br /><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Public</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Sub</span><span style="color:#000000;"> ExportToSpreadsheet(</span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> tblTable </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> Data.DataTable, </span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> strName </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">String</span></span><span style="font-size:78%;"><span style="color:#000000;">)<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Try</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> context </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> HttpContext </span><span style="color:#000000;">=</span></span><span style="font-size:78%;"><span style="color:#000000;"> HttpContext.Current<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> grid </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> System.Web.UI.WebControls.DataGrid<br /></span><span style="color:#008080;">5</span> <span style="color:#000000;">grid </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> System.Web.UI.WebControls.DataGrid<br /></span><span style="color:#008080;">6</span> <span style="color:#000000;">grid.HeaderStyle.Font.Bold </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">True</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">7</span> <span style="color:#000000;">grid.DataSource </span><span style="color:#000000;">=</span></span><span style="font-size:78%;"><span style="color:#000000;"> tblTable<br /></span><span style="color:#008080;">8</span> <span style="color:#000000;">grid.DataMember </span><span style="color:#000000;">=</span></span><span style="font-size:78%;"><span style="color:#000000;"> tblTable.TableName<br /></span><span style="color:#008080;">9</span> </span><span style="font-size:78%;"><span style="color:#000000;">grid.DataBind()<br /></span><span style="color:#008080;">10</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">11</span> </span><span style="font-size:78%;"><span style="color:#000000;">context.Response.Clear()<br /></span><span style="color:#008080;">12</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">13</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> sw </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> StringWriter<br /></span><span style="color:#008080;">14</span> <span style="color:#000000;">sw </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> StringWriter()<br /></span><span style="color:#008080;">15</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">16</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> hw </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> HtmlTextWriter<br /></span><span style="color:#008080;">17</span> <span style="color:#000000;">hw </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> HtmlTextWriter(sw)<br /></span><span style="color:#008080;">18</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">19</span> </span><span style="font-size:78%;"><span style="color:#000000;">grid.RenderControl(hw)<br /></span><span style="color:#008080;">20</span> </span><span style="font-size:78%;"><span style="color:#000000;">context.Response.Write(sw.ToString)<br /></span><span style="color:#008080;">21</span> <span style="color:#000000;">context.Response.AppendHeader(</span><span style="color:#800000;">"</span><span style="color:#800000;">content-disposition</span><span style="color:#800000;">"</span><span style="color:#000000;">, </span><span style="color:#800000;">"</span><span style="color:#800000;">attachment; filename=</span><span style="color:#800000;">"</span><span style="color:#000000;"> </span><span style="color:#000000;">&</span><span style="color:#000000;"> strName </span><span style="color:#000000;">&</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">.xls</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">)<br /></span><span style="color:#008080;">22</span> <span style="color:#000000;">context.Response.ContentType </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">application/excel</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">23</span> <span style="color:#000000;">context.Response.Charset </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">String</span></span><span style="font-size:78%;"><span style="color:#000000;">.Empty<br /></span><span style="color:#008080;">24</span> </span><span style="font-size:78%;"><span style="color:#000000;">context.Response.Flush()<br /></span><span style="color:#008080;">25</span> </span><span style="font-size:78%;"><span style="color:#000000;">context.Response.End()<br /></span><span style="color:#008080;">26</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Catch</span><span style="color:#000000;"> ex1 </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> System.Threading.ThreadAbortException<br /></span><span style="color:#008080;">27</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Exit Sub</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">28</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Catch</span><span style="color:#000000;"> ex </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> Exception<br /></span><span style="color:#008080;">29</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Call</span><span style="color:#000000;"> ManageError(</span><span style="color:#800000;">"</span><span style="color:#800000;">ExportToSpreadsheet</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">, Err)<br /></span><span style="color:#008080;">30</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Try</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">31</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">32</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End Sub</span></span></div><div><span style="font-size:78%;color:#0000ff;"></span></div><div><span style="font-size:78%;color:#0000ff;"></span></div><div><span style="font-size:78%;color:#0000ff;"></span></div><br /><br /><br /><span style="font-size:85%;"><strong>Important Considerations:</strong><br />1.ManageError is a method I use to manage errors, so that you can replace for a simple exit sub or another customized method you use to manage errors.<br /><br />2. Make sure you will hava an exception type System.Threading.ThreadAbortException in your caller method since that exception will be catched there too.<br />Apparently the context.response.end automatically runs System.Threading.ThreadAbortException and the only way of avoiding it is catching it. I tried what <a href="http://support.microsoft.com/kb/312629/">Microsoft suggest</a>. However, it shows my filter screen page instead of the datatable data.<br /><br />3. If you don't really need to ask the user where to save your excel file you can simply use the code suggested in <a href="http://www.codeproject.com/KB/office/ExcelDataTable.aspx">this page </a>and forget about that exception.<br /><br /></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-88806000927888100012010-07-13T11:15:00.000-07:002010-07-13T11:38:02.475-07:00ToolTip - RadToolTip<span style="font-size:85%;">RadTooltip is used as a tooltip to show aditional information that can be formatted in any way you need and, most importantly doesn't disappear after some seconds as the standard tooltip, so it is the user who decides when he/she doesn't want to see it anymore by clicking in a close button.<br />RadTooltip belongs to the Telerik controls family, so you will need to have it installed.</span><br /><br /><strong>Quick example - How to use it</strong><br /><br /><span style="font-size:85%;">1. On the MouseOver event of the txtSUMSGDesc textbox, show a customized tooltip with a textarea inside of it.<br /><br />The HTML code for the textboxes:</span><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#0000ff;"><</span><span style="color:#800000;">td</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:TextBox </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="txtSUMSG"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> CssClass</span><span style="color:#0000ff;">="textbox_disabled2"</span><span style="color:#ff0000;"> ReadOnly</span><span style="color:#0000ff;">="False"</span><span style="color:#ff0000;"> MaxLength</span><span style="color:#0000ff;">="5"</span><span style="color:#ff0000;"> width</span><span style="color:#0000ff;">="33px"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">></</span><span style="color:#800000;">asp:TextBox</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:TextBox </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="txtSUMSGDesc"</span><span style="color:#ff0000;"> CssClass</span><span style="color:#0000ff;">="textbox_disabled2"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> Width</span><span style="color:#0000ff;">="180px"</span><span style="color:#ff0000;"> AutoPostBack</span><span style="color:#0000ff;">="true"</span><span style="color:#0000ff;">></</span><span style="color:#800000;">asp:TextBox</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">td</span><span style="color:#0000ff;">></span></span><br /><br /><br /><span style="font-size:85%;">the HTML code for the RadToolTip<br /></span><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">telerik:RadToolTip </span><span style="color:#ff0000;">runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> ID</span><span style="color:#0000ff;">="RadToolTip1"</span><span style="color:#ff0000;"> Position</span><span style="color:#0000ff;">="TopRight"</span><span style="color:#ff0000;"> HideEvent</span><span style="color:#0000ff;">="ManualClose"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#ff0000;">ShowEvent</span><span style="color:#0000ff;">="OnMouseOver"</span><span style="color:#ff0000;"> Width</span><span style="color:#0000ff;">="350px"</span><span style="color:#ff0000;"> RelativeTo</span><span style="color:#0000ff;">="Element"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#ff0000;">TargetControlID</span><span style="color:#0000ff;">="txtSUMSGDesc"</span><span style="color:#ff0000;"> OnClientBeforeShow</span><span style="color:#0000ff;">="CheckIfShow"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">table </span><span style="color:#ff0000;">width</span><span style="color:#0000ff;">="100%"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">tr</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">td</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:TextBox </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="txtMessageDesc"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> TextMode</span><span style="color:#0000ff;">="MultiLine"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">8</span> <span style="color:#ff0000;">Width</span><span style="color:#0000ff;">="300px"</span><span style="color:#ff0000;"> CssClass</span><span style="color:#0000ff;">="MessageText"</span><span style="color:#0000ff;">></</span><span style="color:#800000;">asp:TextBox</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">9</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">td</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">10</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">tr</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">11</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">table</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">telerik:RadToolTip</span><span style="color:#0000ff;">></span><br /></span><span style="color:#0000ff;"></span><br /><br /><span style="font-size:85%;">The JavaScript functions needed to show the RadToolTip (only when there is information in the textbox)</span><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;">function</span></span><span style="font-size:78%;"><span style="color:#000000;"> HideTooltip() {<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;">var</span><span style="color:#000000;"> tooltip </span><span style="color:#000000;">=</span></span><span style="font-size:78%;"><span style="color:#000000;"> Telerik.Web.UI.RadToolTip.getCurrent();<br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;">if</span></span><span style="font-size:78%;"><span style="color:#000000;"> (tooltip) tooltip.hide();<br /></span><span style="color:#008080;">4</span> </span><span style="font-size:78%;"><span style="color:#000000;">}<br /></span><span style="color:#008080;">5</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;">function</span></span><span style="font-size:78%;"><span style="color:#000000;"> ShowTooltip() {<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;">window.setTimeout(</span><span style="color:#0000ff;">function</span></span><span style="font-size:78%;"><span style="color:#000000;"> () {<br /></span><span style="color:#008080;">8</span> <span style="color:#000000;"></span><span style="color:#0000ff;">var</span><span style="color:#000000;"> tooltip </span><span style="color:#000000;">=</span><span style="color:#000000;"> $find(</span><span style="color:#000000;">"</span><span style="color:#000000;">RadToolTip1</span><span style="color:#000000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">);<br /></span><span style="color:#008080;">9</span> <span style="color:#000000;"></span><span style="color:#008000;">//</span><span style="color:#008000;">API: show the tooltip</span></span><span style="font-size:78%;"><span style="color:#008000;"><br /></span><span style="color:#008080;">10</span> <span style="color:#008000;"></span></span><span style="font-size:78%;"><span style="color:#000000;">tooltip.show();<br /></span><span style="color:#008080;">11</span> <span style="color:#000000;">}, </span><span style="color:#000000;">10</span></span><span style="font-size:78%;"><span style="color:#000000;">);<br /></span><span style="color:#008080;">12</span> </span><span style="font-size:78%;"><span style="color:#000000;">}<br /></span><span style="color:#008080;">13</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">14</span> <span style="color:#000000;"></span><span style="color:#0000ff;">function</span></span><span style="font-size:78%;"><span style="color:#000000;"> CheckIfShow(sender, args) {<br /></span><span style="color:#008080;">15</span> <span style="color:#000000;"></span><span style="color:#0000ff;">var</span><span style="color:#000000;"> Elem </span><span style="color:#000000;">=</span><span style="color:#000000;"> document.getElementById(</span><span style="color:#000000;">"</span><span style="color:#000000;"><%=txtSUMSGDesc.ClientID%></span><span style="color:#000000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">);<br /></span><span style="color:#008080;">16</span> <span style="color:#000000;"></span><span style="color:#008000;">//</span><span style="color:#008000;">check if summary is visible</span></span><span style="font-size:78%;"><span style="color:#008000;"><br /></span><span style="color:#008080;">17</span> <span style="color:#008000;"></span><span style="color:#000000;"></span><span style="color:#0000ff;">if</span><span style="color:#000000;"> (Elem.value </span><span style="color:#000000;">==</span><span style="color:#000000;"> </span><span style="color:#000000;">""</span></span><span style="font-size:78%;"><span style="color:#000000;">) {<br /></span><span style="color:#008080;">18</span> <span style="color:#000000;"></span><span style="color:#008000;">//</span><span style="color:#008000;">API: if there are no errors, do not show the tooltip</span></span><span style="font-size:78%;"><span style="color:#008000;"><br /></span><span style="color:#008080;">19</span> <span style="color:#008000;"></span><span style="color:#000000;">args.set_cancel(</span><span style="color:#0000ff;">true</span></span><span style="font-size:78%;"><span style="color:#000000;">);<br /></span><span style="color:#008080;">20</span> </span><span style="font-size:78%;"><span style="color:#000000;">}<br /></span><span style="color:#008080;">21</span> <span style="color:#000000;">}</span></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-53187898293130371082010-07-07T09:49:00.000-07:002010-07-07T09:54:40.197-07:00Formatting textbox : RadNumericTextBox<span style="font-size:85%;">If we need to format a textbox, so that we don't need to validate the input and if you can use telerik controls. You should use RadNumericTextBox control.<br /><br /><br />Before you need something like this in order to validate a number with maximum 4 decimals.<br /><br /><br /></span><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:TextBox </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="txtTaxRate"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> CssClass</span><span style="color:#0000ff;">="textbox_num_enabled2"</span><span style="color:#ff0000;"> Width</span><span style="color:#0000ff;">="50px"</span><span style="color:#ff0000;"> MaxLength</span><span style="color:#0000ff;">="7"</span><span style="color:#ff0000;"> text</span><span style="color:#0000ff;">='<%#DataBinder.Eval(Container, </span><span style="color:#ff0000;">"DataItem.TaxRate") %</span><span style="color:#0000ff;">></span><span style="color:#000000;">'></span><span style="color:#0000ff;"></</span><span style="color:#800000;">asp:TextBox</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:RegularExpressionValidator </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="revTaxRate"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#ff0000;">ErrorMessage</span><span style="color:#0000ff;">="RegularExpressionValidator"</span><span style="color:#ff0000;"> CssClass</span><span style="color:#0000ff;">="error2"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#ff0000;">ControlToValidate</span><span style="color:#0000ff;">="txtTaxRate"</span><span style="color:#ff0000;"> ValidationExpression</span><span style="color:#0000ff;">="^\d{0,2}(\.\d{1,4})?$"</span><span style="color:#0000ff;">></</span><span style="color:#800000;">asp:RegularExpressionValidator</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> </span><span style="color:#000000;"><br /></span><span style="font-size:85%;"><span style="font-size:78%;color:#008080;">6</span> <span style="color:#000000;"></span><br /><br />Now, you just need a RadNumeric Textbox like this:<br /><br /></span><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#0000ff;"><</span><span style="color:#800000;">telerik:RadNumericTextBox </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="txtTaxRate"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> DataType</span><span style="color:#0000ff;">="System.Int64"</span><span style="color:#ff0000;"> MaxLength</span><span style="color:#0000ff;">="9"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#ff0000;">MaxValue</span><span style="color:#0000ff;">="99.9999"</span><span style="color:#ff0000;"> MinValue</span><span style="color:#0000ff;">="0"</span><span style="color:#ff0000;"> Skin</span><span style="color:#0000ff;">=""</span><span style="color:#ff0000;"> CssClass</span><span style="color:#0000ff;">="textbox_num_enabled2"</span><span style="color:#ff0000;"> EnableEmbeddedSkins</span><span style="color:#0000ff;">="False"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#ff0000;">Width</span><span style="color:#0000ff;">="80px"</span><span style="color:#ff0000;"> text</span><span style="color:#0000ff;">='<%#DataBinder.Eval(Container, </span><span style="color:#ff0000;">"DataItem.TaxRate") %</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;">'><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">NumberFormat </span><span style="color:#ff0000;">DecimalDigits</span><span style="color:#0000ff;">="4"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">telerik:RadNumericTextBox</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">6</span> </span><span style="color:#000000;"><br /></span><span style="font-size:85%;"><span style="font-size:78%;color:#008080;">7</span> <span style="color:#000000;"></span></span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-69073252689846823982010-07-07T07:38:00.000-07:002010-07-07T08:08:01.779-07:00Datagrid column's formatting<span style="font-size:85%;">Formatting a datagrid or radgrid column is really easy. We just need to verify the following:<br /><br />1. Source Datatype to apply the format.<br />2. The format itself.<br /><br />To clarify this:<br />Let's say we need to format a numeric field "Qty", so that instead of having 12 value, it shows 12.00, then, We need to ensure ourselves that "Qty" datatype is decimal or numeric in the case we are planning to use the {0:F4} format. Otherwise, it will always show 12.<br /><br />Ways of formatting a radgrid or datagrid column in the aspx page:<br />1. Formatting with String.Format.<br />2. Formatting with Databinder.Eval<br /><br />Even though, both can do exactly the same thing. The theory said (I couldn't verify this) that the String.Format method is faster than Databinder.Eval; However, some programmers said that the difference is just miliseconds and the code is a little bit more complicated so that is worthless.<br />Anyways, I will develop here the second method: Formatting with Databinder.Eval.<br /><br />When using a BoundColumn:<br /><br /><br /></span><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">telerik:GridBoundColumn </span><span style="color:#ff0000;">DataField</span><span style="color:#0000ff;">="TaxRate"</span><span style="color:#ff0000;"> HeaderText</span><span style="color:#0000ff;">="Tax Rate"</span><span style="color:#ff0000;"> UniqueName</span><span style="color:#0000ff;">="TaxRate"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#ff0000;">DataFormatString</span><span style="color:#0000ff;">="{0:F4}"</span><span style="color:#ff0000;"> HtmlEncode</span><span style="color:#0000ff;">="false"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">HeaderStyle </span><span style="color:#ff0000;">Font-Names</span><span style="color:#0000ff;">="Arial"</span><span style="color:#ff0000;"> HorizontalAlign</span><span style="color:#0000ff;">="Right"</span><span style="color:#ff0000;"> Width</span><span style="color:#0000ff;">="35px"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">ItemStyle </span><span style="color:#ff0000;">HorizontalAlign</span><span style="color:#0000ff;">="Right"</span><span style="color:#ff0000;"> Wrap</span><span style="color:#0000ff;">="True"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">telerik:GridBoundColumn</span><span style="color:#0000ff;">></span></span><span style="font-size:85%;"><br /><br /><br />When Using a TemplateColumn:<br /><br /><br /></span><span style="font-size:85%;"></span><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">telerik:GridTemplateColumn </span><span style="color:#ff0000;">HeaderText</span><span style="color:#0000ff;">="Tax Rate"</span><span style="color:#ff0000;"> UniqueName</span><span style="color:#0000ff;">="TaxRate"</span><span style="color:#ff0000;"> Visible</span><span style="color:#0000ff;">="True"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">HeaderStyle </span><span style="color:#ff0000;">Font-Names</span><span style="color:#0000ff;">="Arial"</span><span style="color:#ff0000;"> HorizontalAlign</span><span style="color:#0000ff;">="Right"</span><span style="color:#ff0000;"> Width</span><span style="color:#0000ff;">="35px"</span><span style="color:#ff0000;"> Wrap</span><span style="color:#0000ff;">="True"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">ItemStyle </span><span style="color:#ff0000;">HorizontalAlign</span><span style="color:#0000ff;">="Right"</span><span style="color:#ff0000;"> Wrap</span><span style="color:#0000ff;">="False"</span><span style="color:#ff0000;"> Font-Names</span><span style="color:#0000ff;">="Arial"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">ItemTemplate</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:Label </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="lblTaxRate"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> CssClass</span><span style="color:#0000ff;">="label2"</span><span style="color:#ff0000;"> Width</span><span style="color:#0000ff;">="35px"</span><span style="color:#ff0000;"> Text</span><span style="color:#0000ff;">='<%# </span><span style="color:#ff0000;">DataBinder.Eval (Container, "DataItem.TaxRate", "{0:F4}") %</span><span style="color:#0000ff;">></span><span style="color:#000000;">'></span><span style="color:#0000ff;"></</span><span style="color:#800000;">asp:Label</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">ItemTemplate</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">telerik:GridTemplateColumn</span><span style="color:#0000ff;">></span></span><br /><br /><br /><span style="font-size:85%;">Formatting with String Format:<br /><br /><br /></span><span style="font-size:85%;"></span><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="BACKGROUND-COLOR: #ffff00;color:#000000;" ><%</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#000000;" ># </span><span style="BACKGROUND-COLOR: #f5f5f5;color:#0000ff;" >String</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#000000;" >.Format(</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#800000;" >"</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#800000;" >{0:c}</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#800000;" >"</span></span><span style="font-size:78%;"><span style="BACKGROUND-COLOR: #f5f5f5;color:#000000;" >,<br /></span><span style="color:#008080;">2</span> <span style="BACKGROUND-COLOR: #f5f5f5;color:#000000;" >((System.Data.Common.DbDataRecord)Container.DataItem)[</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#800000;" >"</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#800000;" >TaxRate</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#800000;" >"</span><span style="BACKGROUND-COLOR: #f5f5f5;color:#000000;" >]) </span><span style="BACKGROUND-COLOR: #ffff00;color:#000000;" >%></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span></span><span style="font-size:85%;"> <span style="color:#000000;"></span></span><br /><br /><br /><span style="font-size:85%;">Format Expressions:<br /><br /><br />1. This will display a text Price: followed by the numeric text in currency format<br /><br />Format String: Price: {0:C}<br /><br />NOTE : THE ABOVE MENTIONED FORMAT IS USING A ZERO IT IS NOT THE ALPHABET O<br /><br />Applied to numeric and decimal data types.<br /><br />The currency format is according to the culture info set in the web config file.<br /><br /><br />2. Integers are displayed in a zero-padded field four characters wide.<br /><br />Format String : {0:D4}<br /><br />Applied to integer datatype only.<br /><br /><br />3. To show two decimal places followed by "%"<br /><br />Format String : {0:N2}%<br /><br />Applied to integer datatype only.<br /><br /><br />4. To round the numbers to one decimal place and are zero padded for numbers less than three digits.<br /><br />Format String : {0:000.0}<br /><br />Applied to numeric and decimal datatype only.<br /><br /><br />5. Long Date format<br /><br />Format String: {0:D}<br /><br />Applied to date and datetime datatype only.<br /><br />( the above formatting is as set in the web config)<br /><br /><br />6. Short Date format<br /><br />Format String : {0:d}<br /><br />Applied to date and datetime datatype only.<br /><br />( the above formatting is as set in the web config)<br /><br /><br /><br />6. Numeric Date format<br /><br />Format String : {0:yy-MM-dd}<br /><br />Applied to date and datetime datatype only.<br /><br /><br /></span><span style="font-size:85%;"><p></span><span style="font-size:85%;"></span> </p><p><span style="font-size:85%;">Reorted Issues:</span></p><p><span style="font-size:85%;">When the formatting doesn't work, verify the datatype and in the case of BoundColumns, try by setting: HtmlEncode = false.</span></p>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-81451886420278446342010-06-23T13:42:00.000-07:002010-06-25T12:56:17.471-07:00Adding a Root Node to RadTreeView<span style="font-size:85%;">How to?<br />1. Create a node (Root Node) from zero.</span><br /><span style="font-size:85%;">2. Add the nodes of our existing treeview to the new node.<br /></span><br /><span style="font-size:85%;">Example:</span><br /><span style="font-size:85%;">(rtvFrom is my radtreeview)</span><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> node </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span><span style="color:#000000;"> RadTreeNode(</span><span style="color:#800000;">"</span><span style="color:#800000;">Root Menu</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">)<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;">node.Nodes.AddRange(rtvFrom.Nodes.Cast(</span><span style="color:#0000ff;">Of</span></span><span style="font-size:78%;"><span style="color:#000000;"> RadTreeNode)())<br /></span><span style="color:#008080;">3</span> </span><span style="font-size:78%;"><span style="color:#000000;">rtvFrom.Nodes.Add(node)<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;">rtvFrom.ExpandAllNodes()</span></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-14419790347750707202010-06-23T13:08:00.000-07:002010-06-23T14:05:26.550-07:00RadTreview conected to DB example<span style="font-size:85%;">It is very easy to work with treeviews and DB. The table structure is one of the most important things to take into consideration (It must be a table that has recursivity). Let's see a small example.<br /><br />Description:<br />This treeview will show the available menu options for an application. Normally it varies depending on the environment:DEV(1), TEST(2), PRODUCTION(3). However, for this small example we are just sending 1 (Dev environment) hardcoded. You could use a combobox and send its value.<br /></span><br /><span style="font-size:85%;">1) The table:</span><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#0000ff;">CREATE</span><span style="color:#000000;"> </span><span style="color:#0000ff;">TABLE</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">dbo</span><span style="color:#ff0000;">]</span><span style="color:#000000;">.</span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">Metal_Menu</span><span style="color:#ff0000;">]</span></span><span style="font-size:78%;"><span style="color:#000000;">(<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ME_SEQ</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">uniqueidentifier</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">ROWGUIDCOL</span><span style="color:#000000;"> </span><span style="color:#808080;">NOT</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Metal_Menu_ME_SEQ</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> (</span><span style="color:#ff00ff;">newid</span></span><span style="font-size:78%;"><span style="color:#000000;">()),<br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ME_PARENT</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">uniqueidentifier</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:78%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ME_DESC</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >100</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:78%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ME_URL</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >500</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:78%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ME_PAGE</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >100</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:78%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ME_TYPE</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">int</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:78%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">8</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">Active</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">bit</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Metal_Menu_Active</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> ((</span><span style="FONT-WEIGHT: bold;color:#800000;" >1</span></span><span style="font-size:78%;"><span style="color:#000000;">)),<br /></span><span style="color:#008080;">9</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">CreatedBY</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >255</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Metal_Menu_CreatedBY</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> (</span><span style="color:#ff0000;">'</span><span style="color:#ff0000;">web\iuser</span><span style="color:#ff0000;">'</span></span><span style="font-size:78%;"><span style="color:#000000;">),<br /></span><span style="color:#008080;">10</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">CreatedDate</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">datetime</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Metal_Menu_CreatedDate</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> (</span><span style="color:#ff00ff;">getdate</span></span><span style="font-size:78%;"><span style="color:#000000;">()),<br /></span><span style="color:#008080;">11</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ModifBy</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >255</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Metal_Menu_ModifBy</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> (</span><span style="color:#ff0000;">'</span><span style="color:#ff0000;">web\iuser</span><span style="color:#ff0000;">'</span></span><span style="font-size:78%;"><span style="color:#000000;">),<br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ModifDate</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">datetime</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Metal_Menu_ModifDate</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> (</span><span style="color:#ff00ff;">getdate</span></span><span style="font-size:78%;"><span style="color:#000000;">()),<br /></span><span style="color:#008080;">13</span> <span style="color:#000000;"></span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">PK_Metal_Menu</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">PRIMARY</span><span style="color:#000000;"> </span><span style="color:#0000ff;">KEY</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CLUSTERED</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">14</span> </span><span style="font-size:78%;"><span style="color:#000000;">(<br /></span><span style="color:#008080;">15</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">ME_SEQ</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">ASC</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">16</span> <span style="color:#000000;">)</span><span style="color:#0000ff;">WITH</span><span style="color:#000000;"> (PAD_INDEX </span><span style="color:#808080;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">OFF</span><span style="color:#000000;">, STATISTICS_NORECOMPUTE </span><span style="color:#808080;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">OFF</span><span style="color:#000000;">, IGNORE_DUP_KEY </span><span style="color:#808080;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">OFF</span><span style="color:#000000;">, ALLOW_ROW_LOCKS </span><span style="color:#808080;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">ON</span><span style="color:#000000;">, ALLOW_PAGE_LOCKS </span><span style="color:#808080;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">ON</span><span style="color:#000000;">) </span><span style="color:#0000ff;">ON</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">PRIMARY</span><span style="color:#ff0000;">]</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">17</span> <span style="color:#000000;">) </span><span style="color:#0000ff;">ON</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">PRIMARY</span><span style="color:#ff0000;">]</span></span><br /><br /><br /><span style="font-size:85%;">2. The HTML portion of the RADTREEVIEW:</span><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">telerik:RadTreeView </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="rtvFrom"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> EnableDragAndDrop</span><span style="color:#0000ff;">="True"</span><span style="color:#ff0000;"> OnNodeDrop</span><span style="color:#0000ff;">="RadTreeView1_HandleDrop"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#ff0000;">OnClientNodeDropping</span><span style="color:#0000ff;">="onNodeDropping"</span><span style="color:#ff0000;"> OnClientNodeDragging</span><span style="color:#0000ff;">="onNodeDragging"</span><span style="color:#ff0000;"> MultipleSelect</span><span style="color:#0000ff;">="true"</span><span style="color:#ff0000;"> EnableDragAndDropBetweenNodes</span><span style="color:#0000ff;">="true"</span><span style="color:#ff0000;"> CheckBoxes</span><span style="color:#0000ff;">="false"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">DataBindings</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">telerik:RadTreeNodeBinding </span><span style="color:#ff0000;">Expanded</span><span style="color:#0000ff;">="True"</span><span style="color:#ff0000;"> AllowDrop</span><span style="color:#0000ff;">="false"</span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">DataBindings</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">telerik:RadTreeView</span><span style="color:#0000ff;">></span></span><br /><br /><br /><span style="font-size:85%;">3. The code behind (VB.Net) for this radtreeview:<br /></span><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> </span><span style="font-size:78%;"><span style="color:#000000;">rtvFrom.Nodes.Clear()<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;">rtvFrom.DataTextField </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">SYME_DESC</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;">rtvFrom.DataFieldID </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">SYME_SEQ</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;">rtvFrom.DataValueField </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">SYME_SEQ</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;">rtvFrom.DataFieldParentID </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">SYME_PARENT</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">6</span> <span style="color:#000000;">ViewState.Add(</span><span style="color:#800000;">"</span><span style="color:#800000;">TreeFrom</span><span style="color:#800000;">"</span><span style="color:#000000;">, GetMenuTreeSync(</span><span style="color:#0000ff;">1</span></span><span style="font-size:78%;"><span style="color:#000000;">, strUser))<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;">rtvFrom.DataSource </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CType</span><span style="color:#000000;">(ViewState(</span><span style="color:#800000;">"</span><span style="color:#800000;">TreeFrom</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">), Data.DataSet)<br /></span><span style="color:#008080;">8</span> <span style="color:#000000;">rtvFrom.DataBind()</span></span><br /><br /><br /><span style="font-size:85%;">4. As you can see, up to his point. I am using a method <strong>"GetMenuTreeSync"</strong> to retrieve the information from the database. The method actually calls a stored procedure to get the information, but it could just execute a SQL sentence like this:<br /></span><br />select * from ME_menu WHERE Active = 1 order by me_parent<br /><br /><span style="font-size:85%;">Comments:<br />In this example I used a Viewstate object to store the dataset returned from the query, however you can use a simple local variable of dataset or datatable type.<br /></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-73911315530667725962010-06-21T14:44:00.000-07:002010-06-21T15:11:22.001-07:00RadScriptManager strange error : method get_EnableCdn ...<span style="font-size:85%;">The error:<br /><br />method get_EnableCdn in type system.web.ui.scriptmanager from assembly system.web.extensions, version=3.5.0.0, culture=neutral PublicKeyToken=31bf3856ad364e35' does not have an implementation.<br /><br />The solution:<br /><br />1. Delete this line from the pages you have it:<br /><br /><br /></span><span style="font-size:85%;"><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#0000ff;"><</span><span style="color:#800000;">%@ Register </span><span style="color:#ff0000;">Assembly</span><span style="color:#0000ff;">="Telerik.Web.UI"</span><span style="color:#ff0000;"> Namespace</span><span style="color:#0000ff;">="Telerik.Web.UI"</span><span style="color:#ff0000;"> TagPrefix</span><span style="color:#0000ff;">="telerik"</span><span style="color:#ff0000;"> %</span><span style="color:#0000ff;">></span></span><br /><br /><br />2. Verify this section in your web config:<br /><br /></span><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">runtime</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">assemblyBinding </span><span style="color:#ff0000;">appliesTo</span><span style="color:#0000ff;">="v2.0.50727"</span><span style="color:#ff0000;"> xmlns</span><span style="color:#0000ff;">="urn:schemas-microsoft-com:asm.v1"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">dependentAssembly</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">assemblyIdentity </span><span style="color:#ff0000;">name</span><span style="color:#0000ff;">="System.Web.Extensions"</span><span style="color:#ff0000;"> publicKeyToken</span><span style="color:#0000ff;">="31bf3856ad364e35"</span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">bindingRedirect </span><span style="color:#ff0000;">oldVersion</span><span style="color:#0000ff;">="1.0.0.0-1.1.0.0"</span><span style="color:#ff0000;"> newVersion</span><span style="color:#0000ff;">="3.5.0.0"</span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">dependentAssembly</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">dependentAssembly</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">8</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">assemblyIdentity </span><span style="color:#ff0000;">name</span><span style="color:#0000ff;">="System.Web.Extensions.Design"</span><span style="color:#ff0000;"> publicKeyToken</span><span style="color:#0000ff;">="31bf3856ad364e35"</span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">9</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">bindingRedirect </span><span style="color:#ff0000;">oldVersion</span><span style="color:#0000ff;">="1.0.0.0-1.1.0.0"</span><span style="color:#ff0000;"> newVersion</span><span style="color:#0000ff;">="3.5.0.0"</span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">10</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">dependentAssembly</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">11</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">assemblyBinding</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">runtime</span><span style="color:#0000ff;">></span></span><br /><br /><br /><span style="font-size:85%;">Very important: Make sure you use the: <span style="color:#ff0000;"><strong>appiesTo</strong></span> in the following line:</span><br /><br /><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#0000ff;"><</span><span style="color:#800000;">assemblyBinding </span><span style="color:#ff0000;">appliesTo</span><span style="color:#0000ff;">="v2.0.50727"</span><span style="color:#ff0000;"> xmlns</span><span style="color:#0000ff;">="urn:schemas-microsoft-com:asm.v1"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">2</span></span> <span style="color:#000000;"></span></div><br /><p><?xml:namespace prefix = schemas-microsoft-com /><schemas-microsoft-com:asm.v1:assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1" appliesto="v2.0.50727"></schemas-microsoft-com:asm.v1:assemblybinding></p><p><schemas-microsoft-com:asm.v1:assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1" appliesto="v2.0.50727"></schemas-microsoft-com:asm.v1:assemblybinding></p><schemas-microsoft-com:asm.v1:assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1" appliesto="v2.0.50727"><span style="font-size:85%;">3. If the error message remains or in the case you were not able to see your telerik controls in design mode (you have a very big an strange error instead of it), you could also try:</span></schemas-microsoft-com:asm.v1:assemblybinding><br /><schemas-microsoft-com:asm.v1:assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1" appliesto="v2.0.50727"><span style="font-size:85%;">- Make sure you have Telerik.Web.UI.dll, Telerik.Web.Design.dll and Telerik.Web.UI.xml in your bin folder.</span></schemas-microsoft-com:asm.v1:assemblybinding><br /><schemas-microsoft-com:asm.v1:assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1" appliesto="v2.0.50727"><span style="font-size:85%;"></span></schemas-microsoft-com:asm.v1:assemblybinding><br /><schemas-microsoft-com:asm.v1:assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1" appliesto="v2.0.50727"><span style="font-size:85%;">4. Verify that you have only one reference to System.Web.Extensions in your project (whether you have it in your bin folder or in your GAC)</span></schemas-microsoft-com:asm.v1:assemblybinding><br /><schemas-microsoft-com:asm.v1:assemblybinding xmlns="urn:schemas-microsoft-com:asm.v1" appliesto="v2.0.50727"><br />More Info:</schemas-microsoft-com:asm.v1:assemblybinding><br /><br />http://www.telerik.com/community/forums/aspnet-ajax/general-discussions/236690-error-rendering-control.aspx<br /><br />http://forums.asp.net/p/1497738/3661536.aspxUnknownnoreply@blogger.com8tag:blogger.com,1999:blog-6140193592389579075.post-75917424218406046672010-06-17T09:23:00.000-07:002010-06-19T13:58:07.976-07:00Is it possible to change RadDatePicker language?<span style="font-size:85%;"></span><br /><span style="font-size:85%;">Yes, It is possible. We just need to put this line of code in the Page_Load event.<br /></span><span style="font-size:85%;"><br /></span><span style="font-size:85%;"></span><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;">radDateFrom.Calendar.CultureInfo </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span><span style="color:#000000;"> System.Globalization.CultureInfo(strLang)</span></span><br /><span style="font-size:78%;"></span><br /><span style="font-size:85%;">radDateFrom = your radDatePicker control.</span><br /><span style="font-size:85%;">strLang = Your Selected Language</span><br /><span style="font-size:85%;"></span><br /><span style="font-size:85%;">See a Complete small example</span><br /><span style="font-size:85%;"></span><br /><span style="font-size:85%;">The Client code:</span><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">form </span><span style="color:#ff0000;">id</span><span style="color:#0000ff;">="form1"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:ScriptManager </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="ScriptManager1"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">div</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:DropDownList </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="ddl1"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> AutoPostBack</span><span style="color:#0000ff;">="True"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:ListItem </span><span style="color:#ff0000;">Text</span><span style="color:#0000ff;">="en-US"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:ListItem </span><span style="color:#ff0000;">Text</span><span style="color:#0000ff;">="bg-BG"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:ListItem </span><span style="color:#ff0000;">Text</span><span style="color:#0000ff;">="es-ES"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">8</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">asp:DropDownList</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">9</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">telerik:RadDateTimePicker </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="RadDateTimePicker1"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> meta:resourcekey</span><span style="color:#0000ff;">="RadDateTimePicker1Resource1"</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">10</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">Calendar </span><span style="color:#ff0000;">AutoPostBack</span><span style="color:#0000ff;">="false"</span><span style="color:#ff0000;"> RangeMinDate</span><span style="color:#0000ff;">="01/01/2009"</span><span style="color:#ff0000;"> RangeMaxDate</span><span style="color:#0000ff;">="12/12/2009"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">11</span> <span style="color:#ff0000;">EnableViewSelector</span><span style="color:#0000ff;">="true"</span><span style="color:#ff0000;"> MultiViewColumns</span><span style="color:#0000ff;">="2"</span><span style="color:#ff0000;"> MultiViewRows</span><span style="color:#0000ff;">="2"</span><span style="color:#ff0000;"> EnableNavigation</span><span style="color:#0000ff;">="true"</span></span><span style="font-size:78%;"><span style="color:#ff0000;"><br /></span><span style="color:#008080;">12</span> <span style="color:#ff0000;">meta:resourcekey</span><span style="color:#0000ff;">="RadCalendar1Resource1"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">13</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">telerik:RadDateTimePicker</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">14</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">div</span><span style="color:#0000ff;">></span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">15</span> <span style="color:#000000;"></span><span style="color:#0000ff;"></</span><span style="color:#800000;">form</span><span style="color:#0000ff;">></span></span><br /><span style="color:#0000ff;"></span><br /><span style="color:#0000ff;"></span><br /><span style="color:#0000ff;"></span><br /><span style="font-size:85%;color:#000000;">The code behind:</span><br /><span style="color:#0000ff;"></span><br /><br /><span style="color:#0000ff;"></span><br /><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#0000ff;">Partial</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Class</span></span><span style="font-size:78%;"><span style="color:#000000;"> Pages_RadExample<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Inherits</span></span><span style="font-size:78%;"><span style="color:#000000;"> System.Web.UI.Page<br /></span><span style="color:#008080;">3</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">4</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Protected</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Overrides</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Sub</span></span><span style="font-size:78%;"><span style="color:#000000;"> InitializeCulture()<br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> selectedLanguage </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">String</span><span style="color:#000000;"> </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">en-US</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#0000ff;">If</span><span style="color:#000000;"> Request.Form(</span><span style="color:#800000;">"</span><span style="color:#800000;">ddl1</span><span style="color:#800000;">"</span><span style="color:#000000;">) </span><span style="color:#0000ff;">IsNot</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Nothing</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Then</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">8</span> <span style="color:#000000;">selectedLanguage </span><span style="color:#000000;">=</span><span style="color:#000000;"> Request.Form(</span><span style="color:#800000;">"</span><span style="color:#800000;">ddl1</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">)<br /></span><span style="color:#008080;">9</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">If</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">10</span> <span style="color:#000000;">System.Threading.Thread.CurrentThread.CurrentCulture </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> System.Globalization.CultureInfo(selectedLanguage)<br /></span><span style="color:#008080;">11</span> <span style="color:#000000;">System.Threading.Thread.CurrentThread.CurrentUICulture </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> System.Globalization.CultureInfo(selectedLanguage)<br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#0000ff;">MyBase</span></span><span style="font-size:78%;"><span style="color:#000000;">.InitializeCulture()<br /></span><span style="color:#008080;">13</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End Sub</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">14</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">15</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Protected</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Sub</span><span style="color:#000000;"> Page_Load(</span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> sender </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Object</span><span style="color:#000000;">, </span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> e </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> System.EventArgs) </span><span style="color:#0000ff;">Handles</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Me</span></span><span style="font-size:78%;"><span style="color:#000000;">.Load<br /></span><span style="color:#008080;">16</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> selectedLanguage </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">String</span><span style="color:#000000;"> </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">en-US</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">17</span> <span style="color:#000000;"></span><span style="color:#0000ff;">If</span><span style="color:#000000;"> Request.Form(</span><span style="color:#800000;">"</span><span style="color:#800000;">ddl1</span><span style="color:#800000;">"</span><span style="color:#000000;">) </span><span style="color:#0000ff;">IsNot</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Nothing</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Then</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">18</span> <span style="color:#000000;">selectedLanguage </span><span style="color:#000000;">=</span><span style="color:#000000;"> Request.Form(</span><span style="color:#800000;">"</span><span style="color:#800000;">ddl1</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">)<br /></span><span style="color:#008080;">19</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">If</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">20</span> <span style="color:#000000;">RadDateTimePicker1.Calendar.CultureInfo </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">New</span></span><span style="font-size:78%;"><span style="color:#000000;"> System.Globalization.CultureInfo(selectedLanguage)<br /></span><span style="color:#008080;">21</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End Sub</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">22</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End Class</span></span>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6140193592389579075.post-72473820472280293522010-06-16T11:27:00.000-07:002010-06-16T11:38:35.878-07:00Edit button visible per row in DataGrid<span style="font-size:85%;">This is an issue that we always need to do. However, sometimes we are not sure about where to do the coding and how.</span><br /><br /><span style="font-size:85%;">The event:</span><br /><span style="font-size:85%;">Grid_ItemDatabound</span><br /><span style="font-size:85%;"></span><br /><span style="font-size:85%;">How to - Example:</span><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Protected</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Sub</span><span style="color:#000000;"> wgdLots_ItemDataBound(</span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> sender </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Object</span><span style="color:#000000;">, </span><span style="color:#0000ff;">ByVal</span><span style="color:#000000;"> e </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> Telerik.Web.UI.GridItemEventArgs) </span><span style="color:#0000ff;">Handles</span></span><span style="font-size:78%;"><span style="color:#000000;"> wgdLots.ItemDataBound<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> txtQtyPlannedGrid </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> Telerik.Web.UI.RadNumericTextBox<br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> txtQtyPickGrid </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> TextBox<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Try</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#0000ff;">If</span><span style="color:#000000;"> e.Item.ItemType </span><span style="color:#000000;">=</span><span style="color:#000000;"> GridItemType.EditItem </span><span style="color:#0000ff;">Then</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">6</span> <span style="color:#000000;">txtQtyPlannedGrid </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CType</span><span style="color:#000000;">(e.Item.FindControl(</span><span style="color:#800000;">"</span><span style="color:#800000;">txtQtyPlannedGrid</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">), Telerik.Web.UI.RadNumericTextBox)<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;">txtQtyPickGrid </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CType</span><span style="color:#000000;">(e.Item.FindControl(</span><span style="color:#800000;">"</span><span style="color:#800000;">txtQtyPickGrid</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">), TextBox)<br /></span><span style="color:#008080;">8</span> <span style="color:#000000;"></span><span style="color:#0000ff;">If</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Not</span><span style="color:#000000;"> txtQtyPickGrid </span><span style="color:#0000ff;">Is</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Nothing</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Then</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">9</span> <span style="color:#000000;">strPallet </span><span style="color:#000000;">=</span><span style="color:#000000;"> e.Item.Cells(</span><span style="color:#800080;">1</span></span><span style="font-size:78%;"><span style="color:#000000;">).Text<br /></span><span style="color:#008080;">10</span> <span style="color:#000000;"></span><span style="color:#0000ff;">If</span><span style="color:#000000;"> strPallet </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">""</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Or</span><span style="color:#000000;"> strPallet </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800000;">"</span><span style="color:#800000;">&nbsp;</span><span style="color:#800000;">"</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Then</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">11</span> <span style="color:#000000;">txtQtyPickGrid.Enabled </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">False</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">If</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">13 </span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">If</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">14</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Else</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">15</span> <span style="color:#000000;"></span><span style="color:#0000ff;">If</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CDbl</span><span style="color:#000000;">(txtQtyPlanned.Text) </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#800080;">0</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Then</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">16</span> <span style="color:#000000;">e.Item.Cells(</span><span style="color:#800080;">12</span><span style="color:#000000;">).Visible </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">False</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">17</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">If</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">18</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">If</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">19</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">20</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Catch</span><span style="color:#000000;"> ex </span><span style="color:#0000ff;">As</span></span><span style="font-size:78%;"><span style="color:#000000;"> Exception<br /></span><span style="color:#008080;">21</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Call</span><span style="color:#000000;"> ManageError(strGlobalUser, strAppName, strModName, </span><span style="color:#800000;">"</span><span style="color:#800000;">wgdLots_ItemDataBound</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">, intGlobalMain, Err, strGlobalPathError, ApplicationType.Web)<br /></span><span style="color:#008080;">22</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">Try</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">23</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">24</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End Sub</span></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-42496199713031818872010-06-15T09:21:00.000-07:002010-06-15T11:21:20.452-07:00RPC calls between SQL Servers<span style="font-size:85%;">Lately, I've been trying to call an stored procedure from another server without success. The reason is that SQL Servers last versions need some additional configuration in order to make it possible.<br />In the previous versions of SQL Server, we just needed to add a linked server and then call the procedures. Nowadays, we need to configure the servers in order for them to allow RPC.<br /><br />The error:<br /><span style="color:#cc0000;">OLE DB provider "SQLNCLI" for linked server "[REMOVE-SERVER]" returned<br />message "The partner transaction manager has disabled its support for<br />remote/network transactions.".<br />Msg 7391, Level 16, State 2, Procedure [LocalStoredProc], Line 42<br />The operation could not be performed because OLE DB provider "SQLNCLI"<br />for linked server "[REMOVE-SERVER]" was unable to begin a distributed<br />transaction.</span><br /><br /><br /><br />The solution:<br />1. Execute sp_addlinkedserver: </span><a href="http://msdn.microsoft.com/en-us/library/aa259589(v=SQL.80).aspx"><span style="font-size:85%;">More Information</span></a><span style="font-size:85%;"><br />2. Configure both SQL servers (the one that calls and the one that is being called)<br />2.1. Start the Component Services administrative tool. To do this, click Start, click Run, type dcomcnfg.exe, and then click OK.<br />2.2. In the console tree of the Component Services administrative tool, expand Component Services, expand Computers, right-click My Computer, and then click Properties.<br />2.3. Click the MSDTC tab, and then click Security Configuration.<br /></span><a href="http://support.microsoft.com/kb/899191/"><span style="font-size:85%;">More Information</span></a><span style="font-size:85%;"><br /><br />Up to this point it worked for me. However, should you have still issues with RPC, you could always see for more configurations </span><a href="http://support.microsoft.com/kb/306212"><span style="font-size:85%;">here</span></a><span style="font-size:85%;"><br /><br />And also, If you have issues with nested transactions when using explicit transactions. Verify that: SET XACT_ABORT is ON in your session.<br /></span><a href="http://technet.microsoft.com/en-us/library/ms188792.aspx"><span style="font-size:85%;">More Information</span></a><span style="font-size:85%;"><br /><br />Just to make sure, to execute an external stored procedure from a local one. It should be called as follows:</span><br /><br />EXEC [REMOTE-SERVER].[DB].dbo.[StoredProc]Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-41044980236232017432010-06-07T12:40:00.000-07:002010-06-15T09:40:52.550-07:00SQL Tips - Output within Insert - Very useful to get last UniqueIdentifier<span style="font-size:85%;">Each time we want to get the last value inserted for an Identity or UniqueIdentifier field in our SQL table, we face a problem.<br />In the case of Identity fields, we can recover the last value easily using the SQL function @@identity; However, there is no SQL function to recover a uniqueidentifier field since it is not an incremental field, so what to do in such case?<br /><br />It is pretty simple, the only thing we need to know is that we are able to recover any value JUST inserted into a table using OUTPUT.<br /><br />Example:<br />1) My table definition: </span><br /><span style="font-size:85%;"><br /></span><br /><span style="font-size:85%;"><span style="color:#008080;">1</span> <span style="color:#0000ff;">CREATE</span><span style="color:#000000;"> </span><span style="color:#0000ff;">TABLE</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">dbo</span><span style="color:#ff0000;">]</span><span style="color:#000000;">.</span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">Synergy_Menu</span><span style="color:#ff0000;">]</span></span><span style="font-size:85%;"><span style="color:#000000;">(<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">SYME_SEQ</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">uniqueidentifier</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">ROWGUIDCOL</span><span style="color:#000000;"> </span><span style="color:#808080;">NOT</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Synergy_Menu_SYME_SEQ</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> (</span><span style="color:#ff00ff;">newid</span></span><span style="font-size:85%;"><span style="color:#000000;">()),<br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">SYME_PARENT</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">uniqueidentifier</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:85%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">SYME_DESC</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >100</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:85%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">5</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">SYME_POS</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">int</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:85%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">SYME_URL</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >500</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:85%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">SYME_PAGE</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >100</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:85%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">8</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">SYME_TYPE</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">int</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span></span><span style="font-size:85%;"><span style="color:#000000;">,<br /></span><span style="color:#008080;">9</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">Active</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">bit</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Synergy_Menu_Active</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> ((</span><span style="FONT-WEIGHT: bold;color:#800000;" >1</span></span><span style="font-size:85%;"><span style="color:#000000;">)),<br /></span><span style="color:#008080;">10</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">CreatedBY</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">varchar</span><span style="color:#ff0000;">]</span><span style="color:#000000;">(</span><span style="FONT-WEIGHT: bold;color:#800000;" >255</span><span style="color:#000000;">) </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Synergy_Menu_CreatedBY</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> (</span><span style="color:#ff0000;">'</span><span style="color:#ff0000;">web\user</span><span style="color:#ff0000;">'</span></span><span style="font-size:85%;"><span style="color:#000000;">),<br /></span><span style="color:#008080;">11</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">CreatedDate</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">datetime</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Synergy_Menu_CreatedDate</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> (</span><span style="color:#ff00ff;">getdate</span></span><span style="font-size:85%;"><span style="color:#000000;">()),<br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">Visible</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">int</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">NULL</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">DF_Synergy_Menu_Visible</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">DEFAULT</span><span style="color:#000000;"> ((</span><span style="FONT-WEIGHT: bold;color:#800000;" >1</span></span><span style="font-size:85%;"><span style="color:#000000;">)),<br /></span><span style="color:#008080;">13</span> <span style="color:#000000;"></span><span style="color:#0000ff;">CONSTRAINT</span><span style="color:#000000;"> </span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">PK_Synergy_Menu</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">PRIMARY</span><span style="color:#000000;"> </span><span style="color:#0000ff;">KEY</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CLUSTERED</span></span><span style="font-size:85%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">14</span> </span><span style="font-size:85%;"><span style="color:#000000;">(<br /></span><span style="color:#008080;">15</span> <span style="color:#000000;"></span><span style="color:#ff0000;">[</span><span style="color:#ff0000;">SYME_SEQ</span><span style="color:#ff0000;">]</span><span style="color:#000000;"> </span><span style="color:#0000ff;">ASC</span></span><span style="font-size:85%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">16</span> <span style="color:#000000;">)</span></span><br /><br /><br /><span style="font-size:85%;">2) Getting the last inserted UniqueIdentifier value:<br /><br /><br /><span style="color:#008080;">1</span> <span style="color:#0000ff;">DECLARE</span><span style="color:#000000;"> </span><span style="color:#008000;">@OutputTable</span><span style="color:#000000;"> </span><span style="color:#0000ff;">TABLE</span><span style="color:#000000;"> (SYME_SEQ </span><span style="FONT-WEIGHT: bold;color:#000000;" >UNIQUEIDENTIFIER</span></span><span style="font-size:85%;"><span style="color:#000000;">)<br /></span><span style="color:#008080;">2</span> </span><span style="color:#000000;"><br /></span><span style="font-size:85%;"><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;">insert</span><span style="color:#000000;"> </span><span style="color:#0000ff;">into</span></span><span style="font-size:85%;"><span style="color:#000000;"> dbo.synergy_menu<br /></span><span style="color:#008080;">4</span> </span><span style="font-size:85%;"><span style="color:#000000;">(SYME_PARENT,SYME_DESC,SYME_POS,<br /></span><span style="color:#008080;">5</span> </span><span style="font-size:85%;"><span style="color:#000000;">SYME_URL,SYME_PAGE,SYME_TYPE,<br /></span><span style="color:#008080;">6</span> </span><span style="font-size:85%;"><span style="color:#000000;">Active,CreatedBY,Visible)<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;">output inserted.SYME_SEQ </span><span style="color:#0000ff;">INTO</span><span style="color:#000000;"> </span><span style="color:#008000;">@OutputTable</span></span><span style="font-size:85%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">8</span> <span style="color:#000000;"></span><span style="color:#0000ff;">SELECT</span><span style="color:#000000;"> </span><span style="color:#008000;">@TextMenuOption</span></span><span style="font-size:85%;"><span style="color:#000000;">,SYME_DESC,<br /></span><span style="color:#008080;">9</span> </span><span style="font-size:85%;"><span style="color:#000000;">SYME_POS,SYME_URL,<br /></span><span style="color:#008080;">10</span> <span style="color:#000000;">SYME_PAGE,</span><span style="color:#008000;">@Type</span><span style="color:#000000;">,Active, </span><span style="color:#008000;">@User</span></span><span style="font-size:85%;"><span style="color:#000000;">, Visible<br /></span><span style="color:#008080;">11</span> <span style="color:#000000;"></span><span style="color:#0000ff;">FROM</span></span><span style="font-size:85%;"><span style="color:#000000;"> dbo.synergy_menu<br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#0000ff;">where</span><span style="color:#000000;"> SYME_SEQ </span><span style="color:#808080;">=</span><span style="color:#000000;"> </span><span style="color:#008000;">@MenuOption</span></span><span style="font-size:85%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">13</span> <span style="color:#000000;"></span><span style="color:#808080;">and</span><span style="color:#000000;"> Active </span><span style="color:#808080;">=</span><span style="color:#000000;"> </span><span style="FONT-WEIGHT: bold;color:#800000;" >1</span></span><span style="font-size:85%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">14</span> </span><span style="color:#000000;"><br /></span><span style="font-size:85%;"><span style="color:#008080;">15</span> <span style="color:#000000;"></span><span style="color:#0000ff;">SELECT</span><span style="color:#000000;"> </span><span style="color:#808080;">*</span><span style="color:#000000;"> </span><span style="color:#0000ff;">from</span><span style="color:#000000;"> </span><span style="color:#008000;">@OutputTable</span><br /><br />3) Just try it!<br /></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-49862119152479633462010-06-03T13:25:00.000-07:002010-06-03T14:28:16.111-07:00Programatically changing the text of a GridButtonColum / GridEditCommandColumn / CommandItem<span style="font-size:85%;"><strong>Task:</strong> Be able of programatically change the text of a Grid's GridButtonColum, GridEditCommandColumn and CommandItem.<br /><br /><strong>Valid for:</strong> RadGrid and DataGrid<br /><br /><strong>Process:<br /></strong>Firstly, identify the event. I've decided to use teh ItemDataBound, but it can be done using the PreRender as well.<br /><br />Secondly, identify the Grid control and the columns id and types of what we need to modify.<br /></span><br /><span style="font-size:85%;">Thirdly, do the programming in the chosen event. In this case ItemDatabound:</span><br /><br /><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;">If</span><span style="color:#000000;"> (</span><span style="color:#0000ff;">TypeOf</span><span style="color:#000000;"> e.Item </span><span style="color:#0000ff;">Is</span><span style="color:#000000;"> GridHeaderItem) </span><span style="color:#0000ff;">Then</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> columnView </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> GridButtonColumn </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CType</span><span style="color:#000000;">(e.Item.OwnerTableView.GetColumn(</span><span style="color:#800000;">"</span><span style="color:#800000;">View</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">), GridButtonColumn)<br /></span><span style="color:#008080;">3</span> <span style="color:#000000;">columnView.Text </span><span style="color:#000000;">=</span><span style="color:#000000;"> GetCommonMessage(strGlobalUser, </span><span style="color:#800000;">"</span><span style="color:#800000;">View</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">, strLang)<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;"></span><span style="color:#0000ff;">Dim</span><span style="color:#000000;"> columnEdit </span><span style="color:#0000ff;">As</span><span style="color:#000000;"> GridEditCommandColumn </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">CType</span><span style="color:#000000;">(e.Item.OwnerTableView.GetColumn(</span><span style="color:#800000;">"</span><span style="color:#800000;">EditCommandColumn</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">), GridEditCommandColumn)<br /></span><span style="color:#008080;">5</span> <span style="color:#000000;">columnEdit.EditText </span><span style="color:#000000;">=</span><span style="color:#000000;"> GetCommonMessage(strGlobalUser, </span><span style="color:#800000;">"</span><span style="color:#800000;">Edit</span><span style="color:#800000;">"</span></span><span style="font-size:78%;"><span style="color:#000000;">, strLang)<br /></span><span style="color:#008080;">6</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">If</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">7</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">8</span> </span><span style="color:#000000;"><br /></span><span style="font-size:78%;"><span style="color:#008080;">9</span> <span style="color:#000000;"></span><span style="color:#0000ff;">If</span><span style="color:#000000;"> e.Item.ItemType </span><span style="color:#000000;">=</span><span style="color:#000000;"> GridItemType.CommandItem </span><span style="color:#0000ff;">Then</span></span><span style="font-size:78%;"><span style="color:#000000;"><br /></span><span style="color:#008080;">10</span> <span style="color:#000000;"></span><span style="color:#0000ff;">CType</span><span style="color:#000000;">(e.Item.FindControl(</span><span style="color:#800000;">"</span><span style="color:#800000;">lblAddProduct</span><span style="color:#800000;">"</span><span style="color:#000000;">), Label).Text </span><span style="color:#000000;">=</span><span style="color:#000000;"> GetCommonMessage(strGlobalUser, </span><span style="COLOR: #800000">"</span><span style="COLOR: #800000">AddNewLine</span><span style="COLOR: #800000">"</span></span><span style="font-size:78%;"><span style="color:#000000;">, strLang)<br /></span><span style="color:#008080;">11</span> <span style="color:#000000;"></span><span style="color:#0000ff;">CType</span><span style="color:#000000;">(e.Item.FindControl(</span><span style="COLOR: #800000">"</span><span style="COLOR: #800000">lnkAddProduct</span><span style="COLOR: #800000">"</span><span style="color:#000000;">), LinkButton).ToolTip </span><span style="color:#000000;">=</span><span style="color:#000000;"> GetCommonMessage(strGlobalUser, </span><span style="COLOR: #800000">"</span><span style="COLOR: #800000">ClickHereToAddaNewLine</span><span style="COLOR: #800000">"</span></span><span style="font-size:78%;"><span style="color:#000000;">, strLang)<br /></span><span style="color:#008080;">12</span> <span style="color:#000000;"></span><span style="color:#0000ff;">End</span><span style="color:#000000;"> </span><span style="color:#0000ff;">If</span></span></div><br /><span style="font-size:85%;">Finally, The code is ready to test.<br /></span><br /><br /><span style="font-size:78%;"><span style="color:#0000ff;"><span style="font-size:78%;"><span style="font-size:78%;"><span style="font-size:78%;"><span style="font-size:78%;"><span style="font-size:78%;"><span style="font-size:78%;"><span style="font-size:78%;"></span></span></span></span></span></span></span></span></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-11817725981696057732009-12-02T11:31:00.000-08:002009-12-02T11:38:47.280-08:00Adding HTML/Javascript block scriptsFor quite a long time I wanted to know how could I include HTML / JavaScript / Visual Basic scripts (including their original editor colors) into my blog. I looked up on the internet for the answer finding nothing useful. Finally, I got this:<br /><br />Somewhere I found that I needed a third party program that could do the translation job. This is the one I use now:<br /><br /><a href="http://www.stevetrefethen.com/highlighter/default.aspx">http://www.stevetrefethen.com/highlighter/default.aspx</a><br /><br /><br />However, there are also some others that I haven't try yet. You can find more information here:<br /><br /><a href="http://stackoverflow.com/questions/557961/html-examples-syntax-highlighting-and-encoding-for-blog-posts">http://stackoverflow.com/questions/557961/html-examples-syntax-highlighting-and-encoding-for-blog-posts</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-6922446794438311082009-12-01T14:13:00.000-08:002010-06-19T14:36:24.625-07:00Identifying if a page is called from a popupSituation:<br />I need to identify whether a page has been redirected from a popup window or it has been redirected from a full page, in order for me to perform a Redirect to "Main Menu" or "Close" from a button.<br /><br />Solution:<br />1. Create two buttons (one that performs a PostBackUrl="/") and another one that executes (window.close() javascript event)<br /><br /><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color:#008080;">1</span> <span style="color:#0000ff;"><</span><span style="color:#800000;">asp:Button </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="cmdBackToMenu"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> PostBackUrl</span><span style="color:#0000ff;">="/"</span><span style="color:#ff0000;"> Text</span><span style="color:#0000ff;">="Back to Main Menu"</span><span style="color:#ff0000;"> </span><span style="color:#0000ff;">/></span><span style="color:#000000;"><br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;"><</span><span style="color:#800000;">asp:Button </span><span style="color:#ff0000;">ID</span><span style="color:#0000ff;">="cmdClose"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> Text</span><span style="color:#0000ff;">="Close"</span><span style="color:#ff0000;"> OnClientClick</span><span style="color:#0000ff;">="window.close();"</span><span style="color:#0000ff;">/></span></div><br /><br />2. Create a javascript event that will be called in the form.onload event.<br /><br /><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color:#008080;">1</span> <span style="color:#0000ff;"><</span><span style="color:#800000;">body </span><span style="color:#ff0000;">bgcolor</span><span style="color:#0000ff;">="#CCCCCC"</span><span style="color:#ff0000;"> onload</span><span style="color:#0000ff;">="SettingButton();"</span><span style="color:#0000ff;">></span></div><br /><br /><br />3. The javascript event should be able to identify whether a page was redirected from a popup window or from a full page and depending on the situation make visible or invisible the buttons created in the first step.<br /><br /><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="color:#008080;">1</span> <span style="color:#000000;"></span><span style="color:#0000ff;">function</span><span style="color:#000000;"> SettingButton() {<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"><br /></span><span style="color:#008080;">3</span> <span style="color:#000000;"></span><span style="color:#0000ff;">if</span><span style="color:#000000;"> (opener) {<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;">document.form1.cmdClose.style.visibility </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#000000;">"</span><span style="color:#000000;">visible</span><span style="color:#000000;">"</span><span style="color:#000000;">;<br /></span><span style="color:#008080;">5</span> <span style="color:#000000;">document.form1.cmdBackToMenu.style.visibility </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#000000;">"</span><span style="color:#000000;">hidden</span><span style="color:#000000;">"</span><span style="color:#000000;">;<br /></span><span style="color:#008080;">6</span> <span style="color:#000000;">}<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;"></span><span style="color:#0000ff;">else</span><span style="color:#000000;"> {<br /></span><span style="color:#008080;">8</span> <span style="color:#000000;">document.form1.cmdClose.style.visibility </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#000000;">"</span><span style="color:#000000;">hidden</span><span style="color:#000000;">"</span><span style="color:#000000;">;<br /></span><span style="color:#008080;">9</span> <span style="color:#000000;">document.form1.cmdBackToMenu.style.visibility </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#000000;">"</span><span style="color:#000000;">visible</span><span style="color:#000000;">"</span><span style="color:#000000;">;<br /></span><span style="color:#008080;">10</span> <span style="color:#000000;">}<br /></span><span style="color:#008080;">11</span> <span style="color:#000000;">}</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-43195041148055609202009-11-12T13:50:00.000-08:002010-06-19T15:10:48.461-07:00Cancelling default buttons when keypress enterThe javascript code :<br /><br /><br /><span style="font-size:78%;"><span style="color:#008080;">1</span> </span><span style="font-size:78%;"><span style="color:#000000;">function SaveTerms() {<br /></span><span style="color:#008080;">2</span> <span style="color:#000000;"></span><span style="color:#0000ff;">if</span><span style="color:#000000;"> (window.event.keyCode </span><span style="color:#000000;">==</span><span style="color:#000000;"> </span><span style="color:#000000;">13</span></span><span style="font-size:78%;"><span style="color:#000000;">) {<br /></span><span style="color:#008080;">3</span> <span style="color:#000000;">window.event.cancelBubble </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">true</span></span><span style="font-size:78%;"><span style="color:#000000;">;<br /></span><span style="color:#008080;">4</span> <span style="color:#000000;">window.event.returnValue </span><span style="color:#000000;">=</span><span style="color:#000000;"> </span><span style="color:#0000ff;">false</span></span><span style="font-size:78%;"><span style="color:#000000;">;<br /></span><span style="color:#008080;">5</span> <span style="color:#000000;">document.getElementById(</span><span style="color:#000000;">'</span><span style="color:#000000;">ctl00_ContentPlaceHolder1_cmdSaveTerms</span><span style="color:#000000;">'</span></span><span style="font-size:78%;"><span style="color:#000000;">).click();<br /></span><span style="color:#008080;">6</span> </span><span style="font-size:78%;"><span style="color:#000000;">}<br /></span><span style="color:#008080;">7</span> <span style="color:#000000;">}</span><span style="color:#000000;"><</span></span><br /><br /><br /><br />The button :<br /><br /><div><!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --><span style="font-size:78%;"><span style="color:#008080;">1</span> <span style="color:#0000ff;"><</span><span style="color:#800000;">asp:textbox </span><span style="color:#ff0000;">id</span><span style="color:#0000ff;">="txtPerc1"</span><span style="color:#ff0000;"> runat</span><span style="color:#0000ff;">="server"</span><span style="color:#ff0000;"> cssclass</span><span style="color:#0000ff;">="textbox_enabled2"</span><span style="color:#ff0000;"> readonly</span><span style="color:#0000ff;">="False"</span><span style="color:#ff0000;"> width</span><span style="color:#0000ff;">="58px"</span><span style="color:#ff0000;"> onkeypress</span><span style="color:#0000ff;">="javascript:SaveTerms();"</span><span style="color:#0000ff;">></</span><span style="color:#800000;">asp:TextBox</span><span style="color:#0000ff;">></span></span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-4323539165756510902009-10-20T09:15:00.000-07:002009-10-20T09:43:44.222-07:00JavaScriptSome Javascript scripts that are always useful:<br /><br />1) Disabling an item in a dropdown list:<br /><br /><textarea style="WIDTH: 606px; HEIGHT: 146px" rows="6" cols="66">function ValidateInactive(obj) {<br />var selectedCombobox = obj.options[obj.selectedIndex].text;<br />if (selectedCombobox.indexOf('*') >= 0) {<br /> obj.selectedIndex = 0;<br /> return false;<br /> }<br />}</textarea><br /><br />2) Restriction in number of characters or lines in a multiline textbox<br /><textarea style="WIDTH: 677px; HEIGHT: 234px" rows="10" cols="73">strScript = "function isMaxLength(txtBox) {"<br />strScript += " if(txtBox) { "<br />strScript += " var split = txtBox.value.split('\n'); "<br />strScript += " if (split.length > 5) { "<br />strScript += " return false;}"<br />strScript += " else {"<br />strScript += " return ( txtBox.value.length <= 499);" strScript += " }}" strScript += "}" <br />txtRemarks.Attributes.Add("onkeypress", "return isMaxLength(this);") txtRemarks.Attributes.Add("onkeyup", "return isMaxLength(this);") ClientScript.RegisterClientScriptBlock(Me.GetType(), "txtRemarks", strScript, True) </textarea><br /><br /><br />3) Blocking the right click / left click<br /><br /><textarea style="WIDTH: 610px; HEIGHT: 132px" rows="7" cols="66">function whichButton(event) { <br /> if (event.button == 2)//RIGHT CLICK <br /> { window.clipboardData.clearData();<br /> return false;<br /> }<br /> }</textarea><br /><br />To call it:<br />onMouseDown="whichButton(event)"<br /><br />4) Cleaning the clipboard:<br /><textarea style="WIDTH: 608px; HEIGHT: 36px" cols="66">window.clipboardData.clearData();</textarea>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-64845690276811387892009-10-20T08:30:00.000-07:002009-10-20T09:15:01.772-07:00Encoding ProblemsSometimes we have trouble handling strange characters that must be transferred from one page to another. In general, should we have the habit of transferring strings using encode. In ASP.Net we do so like this:<br /><br /><textarea style="WIDTH: 672px; HEIGHT: 36px" cols="73">strLink = "ShipDatePopup.aspx?BypassUser=&" & strGlobalUser & "&Inco2=" & Server.UrlEncode(txtIncoterm2.Text</textarea><br /><br />To Recover this value, we do not need to do anything special just:<br /><textarea style="WIDTH: 670px; HEIGHT: 36px" cols="73">txtIncoterm2.Text = Request.QueryString("Inco2")</textarea><br /><br /><br />References:<br /><a href="http://msdn.microsoft.com/en-us/library/zttxte6w.aspx">http://msdn.microsoft.com/en-us/library/zttxte6w.aspx</a><br /><a href="http://www.w3.org/International/tutorials/tutorial-char-enc/">http://www.w3.org/International/tutorials/tutorial-char-enc/</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6140193592389579075.post-27296405170673119152009-07-22T12:35:00.000-07:002009-07-22T12:36:20.069-07:00Difference between NULL and DBNull<a href="http://bhaidar.net/cs/archive/2006/03/04/128.aspx">Difference between NULL and DBNull</a>Unknownnoreply@blogger.com0