<?xml version="1.0" encoding="utf-8"?><?xml-stylesheet href='http://feeds.feedsky.com/styles/temp01.xsl' type='text/xsl' ?><!--这是一个由Feedsy提供技术支持的Feed，为了提高读者阅读的体验，以及满足用户美化自己Feed的需要，我们设计了多种精美的Feed模板，提供给大家选择，所有最终呈现出来的样式，皆由用户自愿选择使用，未经许可，任何团体和个人，请不要擅自修改样式或者盗用，这是对于用户选择权的尊重。--><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:fs="http://www.feedsky.com/namespace/feed" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0"><channel><atom:link href="http://feeds.feedsky.com/csdn.net/pfworld" type="application/rss+xml" ref="self"></atom:link><fs:self_link href="http://feeds.feedsky.com/csdn.net/pfworld" type="application/rss+xml"></fs:self_link><lastBuildDate>Tue, 26 Feb 2008 14:41:00 GMT</lastBuildDate><title>pfworld的专栏</title><description>平凡世界</description><item><title>水晶报表简单传参</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722224/1186955/1/item.html</link><wfw:comment>comments/2122283.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/2122283.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=2122283</trackback:ping><description>今天由于需要涉及到水晶报表传参，查了很多网上方法发现都不太实用!(我直接使用报表文件)后来经过多次测试后解决，特把解决方案写出来和大家共享！&lt;img src =&quot;aggbug/2122283.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Tue, 26 Feb 2008 22:41:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2008/02/26/2122283.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2008/02/26/2122283.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2008/02/26/2122283.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722224/1186955</fs:itemid></item><item><title>通过程序自定义纸张[方法来自www.codeproject.com]</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722225/1186955/1/item.html</link><wfw:comment>comments/2104499.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/2104499.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=2104499</trackback:ping><description>解决 “ESC/P 打印指令使用,3种票据打印方法” 中手动定义纸张的方法！&lt;img src =&quot;aggbug/2104499.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Tue, 19 Feb 2008 08:30:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2008/02/19/2104499.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2008/02/19/2104499.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2008/02/19/2104499.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722225/1186955</fs:itemid></item><item><title>ESC/P 打印指令使用,3种票据打印方法。</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722226/1186955/1/item.html</link><wfw:comment>comments/2084666.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/2084666.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=2084666</trackback:ping><description>具体内容大家自己看！如有好的解决方案大家共同研究！&lt;img src =&quot;aggbug/2084666.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Wed, 06 Feb 2008 05:08:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2008/02/05/2084666.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2008/02/05/2084666.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2008/02/05/2084666.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722226/1186955</fs:itemid></item><item><title>多功能DataGridView打印类(WinForm C#)</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722227/1186955/1/item.html</link><wfw:comment>comments/2058746.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/2058746.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=2058746</trackback:ping><description>论坛里的朋友要DataGridView的打印类，所以把这个版本的也发出来和大家共享！！&lt;img src =&quot;aggbug/2058746.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Tue, 22 Jan 2008 21:27:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2008/01/22/2058746.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2008/01/22/2058746.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2008/01/22/2058746.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722227/1186955</fs:itemid></item><item><title>水晶报表——文件导出</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722228/1186955/1/item.html</link><wfw:comment>comments/2022145.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/2022145.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=2022145</trackback:ping><description>水晶报表在C#使用中经常需要事先导出 功能，但是crystalReportViewer在界面上不太美观，所以贴出来共享。 

&lt;img src =&quot;aggbug/2022145.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Fri, 04 Jan 2008 01:11:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2008/01/03/2022145.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2008/01/03/2022145.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2008/01/03/2022145.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722228/1186955</fs:itemid></item><item><title>通过串口收发短消息(下)</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722229/1186955/1/item.html</link><wfw:comment>comments/1967088.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/1967088.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1967088</trackback:ping><description>PDU的核心编码方式已经清楚了，如何实现用AT命令收发短消息呢？&lt;img src =&quot;aggbug/1967088.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Wed, 26 Dec 2007 04:38:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/12/25/1967088.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/12/25/1967088.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/12/25/1967088.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722229/1186955</fs:itemid></item><item><title>通过串口收发短消息(上)</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722230/1186955/1/item.html</link><wfw:comment>comments/1967074.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/1967074.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1967074</trackback:ping><description>用串口连接GSM手机发送和接收短消息，在应用程序中如何编程实现？&lt;img src =&quot;aggbug/1967074.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Wed, 26 Dec 2007 04:33:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/12/25/1967074.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/12/25/1967074.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/12/25/1967074.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722230/1186955</fs:itemid></item><item><title>国粹——诗经</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722231/1186955/1/item.html</link><wfw:comment>comments/1912136.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/1912136.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1912136</trackback:ping><description>对于诗经你知道多少？&lt;img src =&quot;aggbug/1912136.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Mon, 03 Dec 2007 01:57:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/12/02/1912136.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/12/02/1912136.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/12/02/1912136.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722231/1186955</fs:itemid></item><item><title>语音提示器</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722232/1186955/1/item.html</link><wfw:comment>comments/1867371.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/1867371.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1867371</trackback:ping><description>http://microsoft.csdn.net/vs/dev_contest/Ms_rich_Detail.aspx?pointid=83&lt;img src =&quot;aggbug/1867371.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Mon, 05 Nov 2007 20:03:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/11/05/1867371.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/11/05/1867371.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/11/05/1867371.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722232/1186955</fs:itemid></item><item><title>语音技术——自定义播放中文语音</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722233/1186955/1/item.html</link><wfw:comment>comments/1819404.aspx</wfw:comment><slash:comments>2</slash:comments><wfw:commentRss>comments/commentRss/1819404.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1819404</trackback:ping><description>在做称重软件过程中，由于要使用语音播报称重量的功能因此做了如下代码，希望能为初学语音技术的朋友带来帮助。（个人技术有限，欢迎大家指点） &lt;img src =&quot;aggbug/1819404.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Thu, 11 Oct 2007 15:27:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/10/11/1819404.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/10/11/1819404.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/10/11/1819404.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722233/1186955</fs:itemid></item><item><title>水晶报表的使用(1)——动态数据填充技巧[PUSH 模式]</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722234/1186955/1/item.html</link><wfw:comment>comments/1715299.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/1715299.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1715299</trackback:ping><description>使我在学习中充满了无奈，因此本着我为人人、人人为我的原则把自己的经验介绍给别的网友。
            ReportDocument reportDocument1 = new ReportDocument()
            reportDocument1.Load(Application.StartupPath + &quot;\\piaoju.rpt&quot;);      //水晶报表绝对地址
            ds = selectPJ();
            reportDocument1.SetDataSource(ds);               //填充数据到水晶报表
            reportDocument1.Refresh();&lt;img src =&quot;aggbug/1715299.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Mon, 30 Jul 2007 04:08:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/07/29/1715299.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/07/29/1715299.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/07/29/1715299.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722234/1186955</fs:itemid></item><item><title>算法(1)——判断作好事的人</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722235/1186955/1/item.html</link><wfw:comment>comments/1660012.aspx</wfw:comment><slash:comments>1</slash:comments><wfw:commentRss>comments/commentRss/1660012.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1660012</trackback:ping><description>判断作好事的人！！已知三个人说真话一个人说假话!&lt;img src =&quot;aggbug/1660012.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Thu, 21 Jun 2007 06:21:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/06/20/1660012.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/06/20/1660012.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/06/20/1660012.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722235/1186955</fs:itemid></item><item><title>论如何设计关系数据库结构</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722236/1186955/1/item.html</link><wfw:comment>comments/1634125.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/1634125.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1634125</trackback:ping><description>表结构主要是为了给存储表内容(insert,update,del),查询表内容(select) 

1.     存储表内容: 

当需要大批量的更新数据库时: 

(1. 减少更新表的中的索引关系内容 

(2. 让每次更新的数据量要尽量的少,同时要考虑到更新效率要高,最好做完整的测试 

(3. 更新多个表时,最好写到存储过程中 

2.     查询表内容:
当需要从大量的数据中查询数据库表内容时: 

(1. 减少一次性从数据库中查询的数据量(sql + ddl) 

(2. 减少大范围搜索表中的数据内容(sql 中尽量的减少表间的关联) 

(3. 对常查询的字段,适量的增加索引关系 
&lt;img src =&quot;aggbug/1634125.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Fri, 01 Jun 2007 21:42:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/06/01/1634125.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/06/01/1634125.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/06/01/1634125.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722236/1186955</fs:itemid></item><item><title>SQL Server 2005 笔试题</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722237/1186955/1/item.html</link><wfw:comment>comments/1634122.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/1634122.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1634122</trackback:ping><description>Question 1 Can you use a batch SQL or store procedure to calculating the Number of Days in a Month?I am trying to find a way to calculate the total number of days in each month.I am trying to avoid using a case statement, as it fails for February on leap years.
理解题意，也想到了使用DateDiff这样的日期处理函数。

但是由于传入的参数是整数而非日期类型，当传入参数错误时缺乏对异常的捕获和控制处理。
例如： 
    exec sp_DayOfthisMonth 2006, 13
    exec sp_DayOfthisMonth 2006, -1   将会发生数据类型转换错误。

并且由于在计算下一月份时没有使用DateAdd函数，而是简单的让@month加1，
当传入月份参数为12时将会出错，也即该存&lt;img src =&quot;aggbug/1634122.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Fri, 01 Jun 2007 21:40:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/06/01/1634122.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/06/01/1634122.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/06/01/1634122.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722237/1186955</fs:itemid></item><item><title>ClnOSGarbage 自動清除系統垃圾文件</title><link>http://item.feedsky.com/~csdn.net/pfworld/~1186975/53722238/1186955/1/item.html</link><wfw:comment>comments/1632483.aspx</wfw:comment><slash:comments>0</slash:comments><wfw:commentRss>comments/commentRss/1632483.aspx</wfw:commentRss><trackback:ping>http://tb.blog.csdn.net/TrackBack.aspx?PostId=1632483</trackback:ping><description>@echo off  
echo Cleanning system garbage, please wait a moment......  
del /f /s /q %systemdrive%\*.tmp  
del /f /s /q %systemdrive%\*._mp  
del /f /s /q %systemdrive%\*.log  
del /f /s /q %systemdrive%\*.gid  &lt;img src =&quot;aggbug/1632483.aspx&quot; width = &quot;1&quot; height = &quot;1&quot; /&gt;</description><pubDate>Thu, 31 May 2007 19:09:00 +0800</pubDate><author>pfworld</author><comments>http://blog.csdn.net/pfworld/archive/2007/05/31/1632483.aspx#Feedback</comments><guid isPermaLink="false">http://blog.csdn.net/pfworld/archive/2007/05/31/1632483.aspx</guid><dc:creator>pfworld</dc:creator><fs:srclink>http://blog.csdn.net/pfworld/archive/2007/05/31/1632483.aspx</fs:srclink><fs:srcfeed>http://blog.csdn.net/pfworld/rss.aspx</fs:srcfeed><fs:itemid>csdn.net/pfworld/~1186975/53722238/1186955</fs:itemid></item></channel></rss>