<?xml version="1.0" encoding="utf-8"?>
<!-- generator="FeedCreator 1.7.2" -->
<rss version="2.0">
    <channel>
        <title>Lowyat.NET: Latest topics by teochevon</title>
        <description></description>
        <link>http://forum.lowyat.net/</link>
        <lastBuildDate>Wed, 10 Jun 2026 18:40:42 +0800</lastBuildDate>
        <generator>FeedCreator 1.7.2</generator>
        <item>
            <title>How to execute lupdate for multiple Qt projects</title>
            <link>http://forum.lowyat.net/topic/2194975</link>
            <description>Hi, &lt;br /&gt;&lt;br /&gt;I am developing a QT application and it contains multiple projects and each project has one PRO file.&lt;br /&gt;&lt;br /&gt;I am wondering if there is any possibility that with one lupdate command can process multiple PRO file.&lt;br /&gt;&lt;br /&gt;Appreciate if you could provide some help/advice.</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Wed, 18 Jan 2012 17:26:45 +0800</pubDate>
        </item>
        <item>
            <title>Obfuscate Qt code</title>
            <link>http://forum.lowyat.net/topic/2121153</link>
            <description>Hi, I wonder if we could obfuscate Qt code and how to do it? Please enlighten me.</description>
            <author>teochevon</author>
            <category>Linux &amp;amp; Open Source Software</category>
            <pubDate>Wed, 23 Nov 2011 23:02:59 +0800</pubDate>
        </item>
        <item>
            <title>Ways to hide Ubuntu OS boot messages?</title>
            <link>http://forum.lowyat.net/topic/2092256</link>
            <description>Hi,&lt;br /&gt;&lt;br /&gt;I&amp;#39;m looking for a way to hide Ubuntu OS boot messages upon bootup and shutdown. What I&amp;#39;ve done so far is - in /etc/default/grub, I set &lt;b&gt;GRUB_CMDLINE_LINUX_DEFAULT=&amp;quot;quiet splash&amp;quot;&lt;/b&gt;. Significantly it shows lesser messages, but this is not exactly what I want. I need them to be completely removed. I searched through internet I found very very few helpful tricks, most of the people are looking for enabling more messages to display  &lt;!--emo&amp;:(--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/sad.gif' border='0' style='vertical-align:middle' alt='sad.gif' /&gt;&lt;!--endemo--&gt;  I&amp;#39;m not sure if it&amp;#39;s possible. Appreciate if any of you could advise.&lt;br /&gt;&lt;br /&gt;p/s: I&amp;#39;m not sure if it&amp;#39;s called boot messages. I have PostgreSQL installed in my Ubuntu machine. And it displays lines &amp;quot;&amp;quot;Starting PostgreSQL 8.4 database server&amp;quot; during bootup or shutdown. I&amp;#39;m looking for way to hide this kind of information from the black screen.</description>
            <author>teochevon</author>
            <category>Linux &amp;amp; Open Source Software</category>
            <pubDate>Tue, 01 Nov 2011 18:40:26 +0800</pubDate>
        </item>
        <item>
            <title>Error: &amp;#39;undefined&amp;#39; is null or not an object</title>
            <link>http://forum.lowyat.net/topic/1475710</link>
            <description>Hi peers,&lt;br /&gt;&lt;br /&gt;I got the Error: &amp;#39;undefined&amp;#39; is null or not an object on the second line of code in the js function below when I ran it in VS2010. It works perfectly in VS2K8. I can&amp;#39;t find any clue why is it so. Please suggest what can I do.&lt;br /&gt;&lt;br /&gt;function rememberme_check(a) {&lt;br /&gt;    var Form_1 = document.Form1;&lt;br /&gt;    Form_1.action = a;&lt;br /&gt;    Form_1.submit();&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;&amp;lt;form id=&amp;quot;Form1&amp;quot; method=&amp;quot;post&amp;quot; name=&amp;quot;Form1&amp;quot; action=&amp;quot;&amp;quot;&amp;gt;&lt;br /&gt;.....&lt;br /&gt;&lt;br /&gt;&amp;lt;a href=&amp;quot;javascript:rememberme_check(&amp;lt;url&amp;gt;);&amp;quot;&amp;gt;&lt;br /&gt;                            &amp;lt;span&amp;gt;Log In&amp;lt;/span&amp;gt;&lt;br /&gt;&amp;lt;/a&amp;gt;&lt;br /&gt;&lt;br /&gt;.....&lt;br /&gt;&amp;lt;/form&amp;gt;</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Thu, 01 Jul 2010 10:48:56 +0800</pubDate>
        </item>
        <item>
            <title>WTF Vendor who can make Human Tetris</title>
            <link>http://forum.lowyat.net/topic/0</link>
            <description></description>
            <category>The Museum Of Kopitiam</category>
            <pubDate>Thu, 01 Jan 1970 07:30:00 +0800</pubDate>
        </item>
        <item>
            <title>WTF Vendor who can make Human Tetris</title>
            <link>http://forum.lowyat.net/topic/1456727</link>
            <description>Hi peers,&lt;br /&gt;&lt;br /&gt;Does anyone of you know somebody who can help to make human tetris using big cardboard in Penang area? Please gimme the contact ASAP. I need this game for my company event.</description>
            <author>teochevon</author>
            <category>Serious Kopitiam</category>
            <pubDate>Mon, 14 Jun 2010 10:26:14 +0800</pubDate>
        </item>
        <item>
            <title>How to display 2 textboxes after a button click</title>
            <link>http://forum.lowyat.net/topic/1443972</link>
            <description>Hi peers,&lt;br /&gt;&lt;br /&gt;Please enlighten me with example (in JQuery) of how to display 2 textboxes after a button click. I would like to put a Login button in a horizontal bar, once the user clicks it, it will be disappear and 2 textboxes, Username and Password fields together with Go and Cancel buttons will appear in the horizontal bar. If the user clicks Cancel, all these will be replaced by a Login button.&lt;br /&gt;&lt;br /&gt;</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Wed, 02 Jun 2010 14:55:26 +0800</pubDate>
        </item>
        <item>
            <title>Change view in ASP.NET MVC within one aspx page</title>
            <link>http://forum.lowyat.net/topic/1388344</link>
            <description>Hi peers, &lt;br /&gt;&lt;br /&gt;As per the subject mentioned, how do we change the view from one to the other within 1 page?&lt;br /&gt;&lt;br /&gt;For example,&lt;br /&gt;&lt;br /&gt;First time visit the website, there is a top bar (one view ascx) showing Login functionality.&lt;br /&gt;&lt;br /&gt;Once you click Login, it will validate, and then if you&amp;#39;re a valid user, the top bar will be change to different bar (another view ascx)&lt;br /&gt;&lt;br /&gt;Please show me how do we do this in MVC.&lt;br /&gt;&lt;br /&gt;Appreciate your help.</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Mon, 12 Apr 2010 14:45:44 +0800</pubDate>
        </item>
        <item>
            <title>tr[@class^=child-]</title>
            <link>http://forum.lowyat.net/topic/1380244</link>
            <description>Hi.. I saw this in jquery, can someone help to explain &amp;#036;(&amp;#39;tr[@class^=child-]&amp;#39;).hide().children(&amp;#39;td&amp;#39;)?&lt;br /&gt;&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&amp;#036;&amp;#40;function&amp;#40;&amp;#41; {&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;#036;&amp;#40;&amp;#39;tr.parent&amp;#39;&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;.css&amp;#40;&amp;#34;cursor&amp;#34;, &amp;#34;pointer&amp;#34;&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;.attr&amp;#40;&amp;#34;title&amp;#34;, &amp;#34;Click to expand/collapse&amp;#34;&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;.click&amp;#40;function&amp;#40;&amp;#41; {&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;#036;&amp;#40;this&amp;#41;.siblings&amp;#40;&amp;#39;.child-&amp;#39; + this.id&amp;#41;.toggle&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;#036;&amp;#40;&amp;#39;tr&amp;#91;@class^=child-&amp;#93;&amp;#39;&amp;#41;.hide&amp;#40;&amp;#41;.children&amp;#40;&amp;#39;td&amp;#39;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&amp;#41;;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Mon, 05 Apr 2010 13:26:16 +0800</pubDate>
        </item>
        <item>
            <title>Microsoft JScript runtime error</title>
            <link>http://forum.lowyat.net/topic/1380242</link>
            <description>Hi peers, please help in the below. I&amp;#39;m totally new to jQuery. The JS file is the original jquery used in my current project developed by previous developer, now i need to enable collapsing and expanding section for my infoTable and i added the script into the html page, but in runtime it throws me &lt;b&gt;&amp;quot;Microsoft JScript runtime error: Object doesn&amp;#39;t support this property or method&amp;quot; &lt;/b&gt; with highlighting the js code pasted below. May i know how to debug in jQuery? Or do you know to read the code below and tell me what I should amend? I&amp;#39;d prefer to know how to debug than you tell me what my mistake is. Thanks.&lt;br /&gt;&lt;br /&gt;html&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&amp;#60;script&amp;#62;&lt;br /&gt;&amp;#036;&amp;#40;function&amp;#40;&amp;#41; {&lt;br /&gt;            &amp;#036;&amp;#40;&amp;#39;tr.infoSection&amp;#39;&amp;#41;&lt;br /&gt;      .css&amp;#40;&amp;#34;cursor&amp;#34;, &amp;#34;pointer&amp;#34;&amp;#41;&lt;br /&gt;      .attr&amp;#40;&amp;#34;title&amp;#34;, &amp;#34;Click to expand/collapse&amp;#34;&amp;#41;&lt;br /&gt;      .click&amp;#40;function&amp;#40;&amp;#41; {&lt;br /&gt;          &amp;#036;&amp;#40;this&amp;#41;.siblings&amp;#40;&amp;#39;.child-&amp;#39; + this.id&amp;#41;.toggle&amp;#40;&amp;#41;;&lt;br /&gt;      }&amp;#41;;&lt;br /&gt;                &amp;#036;&amp;#40;&amp;#39;tr&amp;#91;@class^=child-&amp;#93;&amp;#39;&amp;#41;.hide&amp;#40;&amp;#41;.children&amp;#40;&amp;#39;td&amp;#39;&amp;#41;;&lt;br /&gt;        }&amp;#41;;&lt;br /&gt;    &amp;#60;/script&amp;#62;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;js&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;function setupInfoTables&amp;#40;&amp;#41; {&lt;br /&gt;    var infoTables = &amp;#036;&amp;#40;&amp;#39;table.infoTable&amp;#39;&amp;#41;.stripe&amp;#40;&amp;#41;&lt;br /&gt;            .find&amp;#40;&amp;#39;tr td&amp;#58;last-child&amp;#39;&amp;#41;.css&amp;#40;&amp;#39;background-image&amp;#39;, &amp;#39;none&amp;#39;&amp;#41;&lt;br /&gt;            .end&amp;#40;&amp;#41;.find&amp;#40;&amp;#39;tr&amp;#39;&amp;#41;.hover&amp;#40;function&amp;#40;&amp;#41; { &amp;#036;&amp;#40;this&amp;#41;.addClass&amp;#40;&amp;#39;over&amp;#39;&amp;#41; }, function&amp;#40;&amp;#41; { &amp;#036;&amp;#40;this&amp;#41;.removeClass&amp;#40;&amp;#39;over&amp;#39;&amp;#41; }&amp;#41;&lt;br /&gt;            .end&amp;#40;&amp;#41;.not&amp;#40;&amp;#39;.noSort&amp;#39;&amp;#41;.tablesorter&amp;#40;&amp;#41;.bind&amp;#40;&amp;#39;sortEnd&amp;#39;, function&amp;#40;&amp;#41; { &amp;#036;&amp;#40;this&amp;#41;.stripe&amp;#40;&amp;#41;; }&amp;#41;&lt;br /&gt;            .end&amp;#40;&amp;#41;.find&amp;#40;&amp;#39;.infoSection&amp;#39;&amp;#41;.each&amp;#40;function&amp;#40;&amp;#41; {&lt;br /&gt;                var next = &amp;#036;&amp;#40;this&amp;#41;.next&amp;#40;&amp;#41;;&lt;br /&gt;                if &amp;#40;next.hasClass&amp;#40;&amp;#39;infoSection&amp;#39;&amp;#41; || next.length == 0&amp;#41; {&lt;br /&gt;                    &amp;#036;&amp;#40;this&amp;#41;.remove&amp;#40;&amp;#41;;&lt;br /&gt;                }&lt;br /&gt;                else {&lt;br /&gt;                    &amp;#036;.browser.msie == true ? &amp;#036;&amp;#40;this&amp;#41;.css&amp;#40;&amp;#39;display&amp;#39;, &amp;#39;block&amp;#39;&amp;#41; &amp;#58; &amp;#036;&amp;#40;this&amp;#41;.css&amp;#40;&amp;#39;display&amp;#39;, &amp;#39;table-row&amp;#39;&amp;#41;;&lt;br /&gt;                }&lt;br /&gt;            }&amp;#41;.end&amp;#40;&amp;#41;;&lt;br /&gt;&lt;br /&gt;    infoTables.filter&amp;#40;&amp;#39;.infoColumns&amp;#39;&amp;#41;.find&amp;#40;&amp;#39;tr&amp;#39;&amp;#41;.unbind&amp;#40;&amp;#41;&lt;br /&gt;        .find&amp;#40;&amp;#39;td&amp;#39;&amp;#41;.hover&amp;#40;function&amp;#40;&amp;#41; { &amp;#036;&amp;#40;this&amp;#41;.addClass&amp;#40;&amp;#39;over&amp;#39;&amp;#41; }, function&amp;#40;&amp;#41; { &amp;#036;&amp;#40;this&amp;#41;.removeClass&amp;#40;&amp;#39;over&amp;#39;&amp;#41; }&amp;#41;;&lt;br /&gt;&lt;br /&gt;    &amp;#036;&amp;#40;&amp;#39;table.paged tr&amp;#58;last&amp;#39;&amp;#41;.removeClass&amp;#40;&amp;#39;odd&amp;#39;&amp;#41;.unbind&amp;#40;&amp;#41;.find&amp;#40;&amp;#39;td&amp;#39;&amp;#41;.css&amp;#40;{ &amp;#39;background-image&amp;#39;&amp;#58; &amp;#39;none&amp;#39;, &amp;#39;border&amp;#39;&amp;#58; &amp;#39;none&amp;#39; }&amp;#41;;&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;&amp;#40;function&amp;#40;&amp;#036;&amp;#41; {&lt;br /&gt;    &amp;#036;.fn.stripe = function&amp;#40;&amp;#41; {&lt;br /&gt;        return this.each&amp;#40;function&amp;#40;&amp;#41; {&lt;br /&gt;            if &amp;#40;&amp;#036;&amp;#40;this&amp;#41;.is&amp;#40;&amp;#39;table&amp;#39;&amp;#41;&amp;#41; {&lt;br /&gt;                &amp;#036;&amp;#40;this&amp;#41;.find&amp;#40;&amp;#39;tr&amp;#39;&amp;#41;.removeClass&amp;#40;&amp;#39;odd&amp;#39;&amp;#41;.end&amp;#40;&amp;#41;.find&amp;#40;&amp;#39;tbody tr&amp;#58;odd&amp;#39;&amp;#41;.addClass&amp;#40;&amp;#39;odd&amp;#39;&amp;#41;;&lt;br /&gt;            }&lt;br /&gt;            else if &amp;#40;&amp;#036;&amp;#40;this&amp;#41;.is&amp;#40;&amp;#39;ul&amp;#39;&amp;#41;&amp;#41; {&lt;br /&gt;                &amp;#036;&amp;#40;this&amp;#41;.find&amp;#40;&amp;#39;li&amp;#39;&amp;#41;.removeClass&amp;#40;&amp;#39;odd&amp;#39;&amp;#41;.end&amp;#40;&amp;#41;.find&amp;#40;&amp;#39;li&amp;#58;odd&amp;#39;&amp;#41;.addClass&amp;#40;&amp;#39;odd&amp;#39;&amp;#41;;&lt;br /&gt;            }&lt;br /&gt;        }&amp;#41;;&lt;br /&gt;    };&lt;br /&gt;}&amp;#41;&amp;#40;jQuery&amp;#41;;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Mon, 05 Apr 2010 13:25:31 +0800</pubDate>
        </item>
        <item>
            <title>jQuery</title>
            <link>http://forum.lowyat.net/topic/1377478</link>
            <description>Hi can you guys help to explain what&amp;#39;s this mean?&lt;br /&gt;&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;var infoTables = &amp;#036;&amp;#40;&amp;#39;table.infoTable&amp;#39;&amp;#41;.stripe&amp;#40;&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;.find&amp;#40;&amp;#39;tr td&amp;#58;last-child&amp;#39;&amp;#41;.css&amp;#40;&amp;#39;background-image&amp;#39;, &amp;#39;none&amp;#39;&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;.end&amp;#40;&amp;#41;.find&amp;#40;&amp;#39;tr&amp;#39;&amp;#41;.hover&amp;#40;function&amp;#40;&amp;#41; { &amp;#036;&amp;#40;this&amp;#41;.addClass&amp;#40;&amp;#39;over&amp;#39;&amp;#41; }, function&amp;#40;&amp;#41; { &amp;#036;&amp;#40;this&amp;#41;.removeClass&amp;#40;&amp;#39;over&amp;#39;&amp;#41; }&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;.end&amp;#40;&amp;#41;.not&amp;#40;&amp;#39;.noSort&amp;#39;&amp;#41;.tablesorter&amp;#40;&amp;#41;.bind&amp;#40;&amp;#39;sortEnd&amp;#39;, function&amp;#40;&amp;#41; { &amp;#036;&amp;#40;this&amp;#41;.stripe&amp;#40;&amp;#41;; }&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;.end&amp;#40;&amp;#41;.find&amp;#40;&amp;#39;.infoSection&amp;#39;&amp;#41;.each&amp;#40;function&amp;#40;&amp;#41; {&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;var next = &amp;#036;&amp;#40;this&amp;#41;.next&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;if &amp;#40;next.hasClass&amp;#40;&amp;#39;infoSection&amp;#39;&amp;#41; || next.length == 0&amp;#41; {&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;#036;&amp;#40;this&amp;#41;.remove&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;else {&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;#036;.browser.msie == true ? &amp;#036;&amp;#40;this&amp;#41;.css&amp;#40;&amp;#39;display&amp;#39;, &amp;#39;block&amp;#39;&amp;#41; &amp;#58; &amp;#036;&amp;#40;this&amp;#41;.css&amp;#40;&amp;#39;display&amp;#39;, &amp;#39;table-row&amp;#39;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&amp;#41;.end&amp;#40;&amp;#41;;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;Please let me know if anything could help me to ramp up on this.</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Fri, 02 Apr 2010 15:56:41 +0800</pubDate>
        </item>
        <item>
            <title>&amp;lt;tr&amp;gt; tag</title>
            <link>http://forum.lowyat.net/topic/1373507</link>
            <description>Hi peers, please advise the below&lt;br /&gt;&lt;br /&gt;a static var being declared in this way:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;private static readonly string _compareFormatStr = &amp;#34;&amp;#60;tr{2}&amp;#62;&amp;#60;td&amp;#62;{0}&amp;#60;/td&amp;#62;{1}&amp;#60;/tr&amp;#62;&amp;#34;;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;this is the way it being used:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;return string.Format&amp;#40;_compareFormatStr, Resources.ProductFields.ResourceManager.GetString&amp;#40;fieldName&amp;#41;, cells, &amp;#34;&amp;#34;&amp;#41;;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;As my understanding, &lt;br /&gt;Resources.ProductFields.ResourceManager.GetString(fieldName) REPRESENTS {0}&lt;br /&gt;cells REPRESENTS {1}&lt;br /&gt;&amp;quot;&amp;quot; REPRESENTS {2}&lt;br /&gt;&lt;br /&gt;But what does &amp;lt;tr{x}&amp;gt; means? Anyone seen this before and can explain to me? Thanks</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Tue, 30 Mar 2010 10:49:07 +0800</pubDate>
        </item>
        <item>
            <title>Javascript</title>
            <link>http://forum.lowyat.net/topic/1372769</link>
            <description>Hi peers. I&amp;#39;m not very familiar with javascript. Recently I gotta study an existing project source code and I found this&lt;br /&gt;&amp;lt;a href=&amp;quot;javascript:{}&amp;quot; onclick=&amp;quot;clearCompareQ()&amp;quot; class=&amp;quot;button&amp;quot; style=&amp;quot;margin:2px 14px;&amp;quot;&amp;gt;Clear Queue&amp;lt;/a&amp;gt;&lt;br /&gt;&lt;br /&gt;May i know what does the &lt;b&gt;&amp;quot;javascript:{}&amp;quot;&lt;/b&gt; mean?</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Mon, 29 Mar 2010 18:22:50 +0800</pubDate>
        </item>
        <item>
            <title>Extract MS SQL Server Dump Files</title>
            <link>http://forum.lowyat.net/topic/787208</link>
            <description>Hi. Does anyone here know how to extract the dump files created by MS SQL Server? I need to restore DB with the dump files. But it seems it can only be done with .bak file, too bad I didnt get it.  &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt; From the results through google,  there are tools to extract the dump files but too bad it&amp;#39;s not free one..</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Tue, 09 Sep 2008 15:01:44 +0800</pubDate>
        </item>
        <item>
            <title>Print Preview in PDF in Web page</title>
            <link>http://forum.lowyat.net/topic/765799</link>
            <description>Hi May I know how to create a PDF file as for print preview in a web page in VS2003??</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Wed, 13 Aug 2008 15:58:45 +0800</pubDate>
        </item>
        <item>
            <title>Windows Mobile 5.0 Application</title>
            <link>http://forum.lowyat.net/topic/758181</link>
            <description>Is it possible to connect Windows Mobile 5.0 application with Web Services in VS2005? I do not know why it doesnt work and there&amp;#39;re some error came out with System.Net.WebException and some other are related to HttpRequest  &lt;!--emo&amp;:unsure:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/unsure.gif' border='0' style='vertical-align:middle' alt='unsure.gif' /&gt;&lt;!--endemo--&gt; I have tried to consume the Web Services to a web application as well as windows application and it works well, but it just cant work out in Windows Mobile application  &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Mon, 04 Aug 2008 09:46:16 +0800</pubDate>
        </item>
        <item>
            <title>How many % of what a drunker said is true?</title>
            <link>http://forum.lowyat.net/topic/714492</link>
            <description>How many % of what a drunker said is true?</description>
            <author>teochevon</author>
            <category>Serious Kopitiam</category>
            <pubDate>Sun, 08 Jun 2008 17:15:41 +0800</pubDate>
        </item>
        <item>
            <title>XML document as input into stored procedure</title>
            <link>http://forum.lowyat.net/topic/709939</link>
            <description>Hello all. I would like to allow XML document as input into stored procedure. From the examples I&amp;#39;ve seen throughout the web, mostly XML document will be converted into strings and then only can be pass into stored procedure. And if XML data size is a concern, Text is the best data type for large XML input. Now I would like to know is it the only way to pass XML data into stored procedure? Is it possible to pass whole XML document into the stored procedure without converting it into strings?  &lt;!--emo&amp;:unsure:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/unsure.gif' border='0' style='vertical-align:middle' alt='unsure.gif' /&gt;&lt;!--endemo--&gt;</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Mon, 02 Jun 2008 10:10:51 +0800</pubDate>
        </item>
        <item>
            <title>No output, no error~ Help&amp;#33;</title>
            <link>http://forum.lowyat.net/topic/706595</link>
            <description>I dont know what&amp;#39;s wrong. My data grid view do not have output &lt;!--emo&amp;:(--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/sad.gif' border='0' style='vertical-align:middle' alt='sad.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt; &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt;  &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt;  &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt; &lt;br /&gt;&lt;br /&gt;Below is my code:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;using System;&lt;br /&gt;using System.Collections.Generic;&lt;br /&gt;using System.ComponentModel;&lt;br /&gt;using System.Data;&lt;br /&gt;using System.Drawing;&lt;br /&gt;using System.Text;&lt;br /&gt;using System.Windows.Forms;&lt;br /&gt;using DatabaseConnection;&lt;br /&gt;using System.Data.SqlClient;&lt;br /&gt;using System.Xml;&lt;br /&gt;using System.Collections;&lt;br /&gt;&lt;br /&gt;namespace TestDB&lt;br /&gt;{&lt;br /&gt; &amp;nbsp; &amp;nbsp;public partial class Form1 &amp;#58; Form&lt;br /&gt; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;public Form1&amp;#40;&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;InitializeComponent&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;private void Form1_Load&amp;#40;object sender, EventArgs e&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;string strConn = &amp;#34;Data Source=localhost;Initial Catalog=Library;Integrated Security=SSPI&amp;#34;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;string strSP=&amp;#34;AUTHORS&amp;#34;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;string strParams=&amp;#34;doc&amp;#34;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;XmlDocument xm = new XmlDocument&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;xm.Load&amp;#40;&amp;#34;Authors.xml&amp;#34;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;DataSet ds = new DataSet&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ds=GetDataSetFromSP&amp;#40;strConn, strSP, strParams, xm&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;dataGridView1.DataSource=ds; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;public DataSet GetDataSetFromSP&amp;#40;string strConn, string strSP, string strInputParams, XmlDocument xmlData&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SqlConnection conn = null;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SqlCommand cmd = new SqlCommand&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;string strXML = xmlData.OuterXml;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;try&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;DataSet ds = new DataSet&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;conn = new SqlConnection&amp;#40;strConn&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.Connection = conn;&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.CommandType = CommandType.StoredProcedure;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.CommandText = strSP;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;// Use AddWithValue to assign strInputParams.&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;// SQL Server will implicitly convert strings into XML.&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.Parameters.AddWithValue&amp;#40;&amp;#34;@&amp;#34; + strInputParams, strXML&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SqlDataAdapter da = new SqlDataAdapter&amp;#40;cmd&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;da.Fill&amp;#40;ds&amp;#41;;&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;return ds;&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;catch &amp;#40;Exception ex&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;throw ex;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;finally&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.Connection.Close&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp;}&lt;br /&gt;}&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;This is my stored procedure:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;CREATE PROCEDURE AUTHORS @doc varchar&amp;#40;1000&amp;#41; AS&lt;br /&gt;DECLARE @idoc int &lt;br /&gt;EXEC sp_xml_preparedocument @idoc OUTPUT, @doc &lt;br /&gt;SELECT &amp;nbsp; &amp;nbsp;title, au_id &lt;br /&gt;FROM &amp;nbsp; &amp;nbsp; &amp;nbsp; OPENXML &amp;#40;@idoc, &amp;#39;/ROOT/authors&amp;#39;,2&amp;#41; &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WITH &amp;#40;au_id &amp;nbsp; &amp;nbsp;varchar&amp;#40;11&amp;#41;, &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;au_lname varchar&amp;#40;40&amp;#41;, &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;au_fname varchar&amp;#40;20&amp;#41;, &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;title varchar&amp;#40;20&amp;#41;, &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;phone &amp;nbsp; &amp;nbsp;char&amp;#40;12&amp;#41; &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;#41; &lt;br /&gt;EXEC sp_xml_removedocument @idoc &lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;XML data sample:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&amp;#60;ROOT&amp;#62; &lt;br /&gt; &amp;nbsp;&amp;#60;authors&amp;#62;&amp;#60;au_id&amp;#62;172-32-1176&amp;#60;/au_id&amp;#62;&amp;#60;au_lname&amp;#62;White&amp;#60;/au_lname&amp;#62; &lt;br /&gt;&amp;#60;au_fname&amp;#62;Johnson&amp;#60;/au_fname&amp;#62;&amp;#60;title&amp;#62;book1&amp;#60;/title&amp;#62; &lt;br /&gt;&amp;#60;phone&amp;#62;408 496-7223&amp;#60;/phone&amp;#62;&amp;#60;address&amp;#62;10932 Bigge Rd.&amp;#60;/address&amp;#62; &lt;br /&gt;&amp;#60;city&amp;#62;Menlo Park&amp;#60;/city&amp;#62;&amp;#60;state&amp;#62;CA&amp;#60;/state&amp;#62;&amp;#60;zip&amp;#62;94025&amp;#60;/zip&amp;#62; &lt;br /&gt;&amp;#60;contract&amp;#62;1&amp;#60;/contract&amp;#62;&amp;#60;/authors&amp;#62; &lt;br /&gt; &amp;nbsp;&amp;#60;authors&amp;#62;&amp;#60;au_id&amp;#62;213-46-8915&amp;#60;/au_id&amp;#62;&amp;#60;au_lname&amp;#62;Green&amp;#60;/au_lname&amp;#62; &lt;br /&gt;&amp;#60;au_fname&amp;#62;Marjorie&amp;#60;/au_fname&amp;#62;&amp;#60;title&amp;#62;book2&amp;#60;/title&amp;#62; &lt;br /&gt;&amp;#60;phone&amp;#62;415 986-7020&amp;#60;/phone&amp;#62;&amp;#60;address&amp;#62;309 63rd St. &lt;br /&gt;#411&amp;#60;/address&amp;#62;&amp;#60;city&amp;#62;Oakland&amp;#60;/city&amp;#62;&amp;#60;state&amp;#62;CA&amp;#60;/state&amp;#62; &lt;br /&gt;&amp;#60;zip&amp;#62;94618&amp;#60;/zip&amp;#62; &lt;br /&gt;&amp;#60;contract&amp;#62;1&amp;#60;/contract&amp;#62;&amp;#60;/authors&amp;#62; &lt;br /&gt;&amp;#60;/ROOT&amp;#62;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Wed, 28 May 2008 16:14:23 +0800</pubDate>
        </item>
        <item>
            <title>No output, no error~ Help&amp;#33;</title>
            <link>http://forum.lowyat.net/topic/706594</link>
            <description>I dont know what&amp;#39;s wrong. My data grid view do not have output &lt;!--emo&amp;:(--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/sad.gif' border='0' style='vertical-align:middle' alt='sad.gif' /&gt;&lt;!--endemo--&gt;&lt;br /&gt; &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt;  &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt;  &lt;!--emo&amp;:help:--&gt;&lt;img src='http://static.lowyat.net/style_emoticons/default/icon_question.gif' border='0' style='vertical-align:middle' alt='icon_question.gif' /&gt;&lt;!--endemo--&gt; &lt;br /&gt;&lt;br /&gt;Below is my code:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;using System;&lt;br /&gt;using System.Collections.Generic;&lt;br /&gt;using System.ComponentModel;&lt;br /&gt;using System.Data;&lt;br /&gt;using System.Drawing;&lt;br /&gt;using System.Text;&lt;br /&gt;using System.Windows.Forms;&lt;br /&gt;using DatabaseConnection;&lt;br /&gt;using System.Data.SqlClient;&lt;br /&gt;using System.Xml;&lt;br /&gt;using System.Collections;&lt;br /&gt;&lt;br /&gt;namespace TestDB&lt;br /&gt;{&lt;br /&gt; &amp;nbsp; &amp;nbsp;public partial class Form1 &amp;#58; Form&lt;br /&gt; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;public Form1&amp;#40;&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;InitializeComponent&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;private void Form1_Load&amp;#40;object sender, EventArgs e&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;string strConn = &amp;#34;Data Source=localhost;Initial Catalog=Library;Integrated Security=SSPI&amp;#34;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;string strSP=&amp;#34;AUTHORS&amp;#34;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;string strParams=&amp;#34;doc&amp;#34;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;XmlDocument xm = new XmlDocument&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;xm.Load&amp;#40;&amp;#34;Authors.xml&amp;#34;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;DataSet ds = new DataSet&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;ds=GetDataSetFromSP&amp;#40;strConn, strSP, strParams, xm&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;dataGridView1.DataSource=ds; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;public DataSet GetDataSetFromSP&amp;#40;string strConn, string strSP, string strInputParams, XmlDocument xmlData&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SqlConnection conn = null;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SqlCommand cmd = new SqlCommand&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;string strXML = xmlData.OuterXml;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;try&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;DataSet ds = new DataSet&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;conn = new SqlConnection&amp;#40;strConn&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.Connection = conn;&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.CommandType = CommandType.StoredProcedure;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.CommandText = strSP;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;// Use AddWithValue to assign strInputParams.&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;// SQL Server will implicitly convert strings into XML.&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.Parameters.AddWithValue&amp;#40;&amp;#34;@&amp;#34; + strInputParams, strXML&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SqlDataAdapter da = new SqlDataAdapter&amp;#40;cmd&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;da.Fill&amp;#40;ds&amp;#41;;&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;return ds;&lt;br /&gt;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;catch &amp;#40;Exception ex&amp;#41;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;throw ex;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;finally&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;{&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;cmd.Connection.Close&amp;#40;&amp;#41;;&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;}&lt;br /&gt; &amp;nbsp; &amp;nbsp;}&lt;br /&gt;}&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;This is my stored procedure:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;CREATE PROCEDURE AUTHORS @doc varchar&amp;#40;1000&amp;#41; AS&lt;br /&gt;DECLARE @idoc int &lt;br /&gt;EXEC sp_xml_preparedocument @idoc OUTPUT, @doc &lt;br /&gt;SELECT &amp;nbsp; &amp;nbsp;title, au_id &lt;br /&gt;FROM &amp;nbsp; &amp;nbsp; &amp;nbsp; OPENXML &amp;#40;@idoc, &amp;#39;/ROOT/authors&amp;#39;,2&amp;#41; &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;WITH &amp;#40;au_id &amp;nbsp; &amp;nbsp;varchar&amp;#40;11&amp;#41;, &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;au_lname varchar&amp;#40;40&amp;#41;, &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;au_fname varchar&amp;#40;20&amp;#41;, &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;title varchar&amp;#40;20&amp;#41;, &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;phone &amp;nbsp; &amp;nbsp;char&amp;#40;12&amp;#41; &lt;br /&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;#41; &lt;br /&gt;EXEC sp_xml_removedocument @idoc &lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;&lt;br /&gt;&lt;br /&gt;XML data sample:&lt;br /&gt;&lt;!--c1--&gt;&lt;div class='codetop'&gt;CODE&lt;/div&gt;&lt;div class='codemain'&gt;&lt;!--ec1--&gt;&amp;#60;ROOT&amp;#62; &lt;br /&gt; &amp;nbsp;&amp;#60;authors&amp;#62;&amp;#60;au_id&amp;#62;172-32-1176&amp;#60;/au_id&amp;#62;&amp;#60;au_lname&amp;#62;White&amp;#60;/au_lname&amp;#62; &lt;br /&gt;&amp;#60;au_fname&amp;#62;Johnson&amp;#60;/au_fname&amp;#62;&amp;#60;title&amp;#62;book1&amp;#60;/title&amp;#62; &lt;br /&gt;&amp;#60;phone&amp;#62;408 496-7223&amp;#60;/phone&amp;#62;&amp;#60;address&amp;#62;10932 Bigge Rd.&amp;#60;/address&amp;#62; &lt;br /&gt;&amp;#60;city&amp;#62;Menlo Park&amp;#60;/city&amp;#62;&amp;#60;state&amp;#62;CA&amp;#60;/state&amp;#62;&amp;#60;zip&amp;#62;94025&amp;#60;/zip&amp;#62; &lt;br /&gt;&amp;#60;contract&amp;#62;1&amp;#60;/contract&amp;#62;&amp;#60;/authors&amp;#62; &lt;br /&gt; &amp;nbsp;&amp;#60;authors&amp;#62;&amp;#60;au_id&amp;#62;213-46-8915&amp;#60;/au_id&amp;#62;&amp;#60;au_lname&amp;#62;Green&amp;#60;/au_lname&amp;#62; &lt;br /&gt;&amp;#60;au_fname&amp;#62;Marjorie&amp;#60;/au_fname&amp;#62;&amp;#60;title&amp;#62;book2&amp;#60;/title&amp;#62; &lt;br /&gt;&amp;#60;phone&amp;#62;415 986-7020&amp;#60;/phone&amp;#62;&amp;#60;address&amp;#62;309 63rd St. &lt;br /&gt;#411&amp;#60;/address&amp;#62;&amp;#60;city&amp;#62;Oakland&amp;#60;/city&amp;#62;&amp;#60;state&amp;#62;CA&amp;#60;/state&amp;#62; &lt;br /&gt;&amp;#60;zip&amp;#62;94618&amp;#60;/zip&amp;#62; &lt;br /&gt;&amp;#60;contract&amp;#62;1&amp;#60;/contract&amp;#62;&amp;#60;/authors&amp;#62; &lt;br /&gt;&amp;#60;/ROOT&amp;#62;&lt;!--c2--&gt;&lt;/div&gt;&lt;!--ec2--&gt;</description>
            <author>teochevon</author>
            <category>Codemasters</category>
            <pubDate>Wed, 28 May 2008 16:13:59 +0800</pubDate>
        </item>
    </channel>
</rss>
