<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[蚁文尘都〖隋〗]]></title> 
<link>http://www.aixq.com/index.php</link> 
<description><![CDATA[自强创新,复杂的东西,简单做!]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[蚁文尘都〖隋〗]]></copyright>
<item>
<link>http://www.aixq.com/post//</link>
<title><![CDATA[Repeater导入到excel]]></title> 
<author>Else &lt;sahu@qq.com&gt;</author>
<category><![CDATA[代码片段，演示也有]]></category>
<pubDate>Mon, 23 Nov 2009 07:25:18 +0000</pubDate> 
<guid>http://www.aixq.com/post//</guid> 
<description>
<![CDATA[ 
	<div class="quote"><div class="quote-title">引用</div><div class="quote-content">&nbsp;&nbsp; string sqlstr = "&nbsp;&nbsp;1=1 ";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;KD_YUEJIA kdyj = new KD_YUEJIA();<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DataSet ds = kdyj.GetList(sqlstr);<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.Repeater1.DataSource = ds.Tables[0].DefaultView;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Repeater1.DataBind();<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #FF0000;">Response.ContentType = "application/vnd.ms-excel"; </span>//关键的一行<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Response.Charset = "";<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.EnableViewState = false;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.IO.StringWriter sw = new System.IO.StringWriter();<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(sw);<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;this.Repeater1.RenderControl(hw);<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Response.Write(sw.ToString());<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Response.End();<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;searchOrders(sqlstr); <span style="color: #008000;">//导出全部之后,还要分页 如果是分页导入的话,放到searchOrders中</span></div></div><br/><br/>就是直接把repeater中的数据导入进去,这个非常方便!<br/>Tags - <a href="http://www.aixq.com/tags/repeater2excel/" rel="tag">repeater2excel</a>
]]>
</description>
</item><item>
<link>http://www.aixq.com/post//#blogcomment</link>
<title><![CDATA[[评论] Repeater导入到excel]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>http://www.aixq.com/post//#blogcomment</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>