<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Kenyon的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Kenyon0313</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Kenyon0313]]></copyright><item><title><![CDATA[获取网页图片字节数组]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/5740522</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/5740522</guid><author>Kenyon0313</author><pubDate>Fri, 16 Jul 2010 18:18:00 +0800</pubDate><description><![CDATA[网页图片保存到数据库Image字段，]]></description><category></category></item><item><title><![CDATA[图片上下间歇滚动]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/5715180</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/5715180</guid><author>Kenyon0313</author><pubDate>Tue, 06 Jul 2010 09:43:00 +0800</pubDate><description><![CDATA[<br /><html xmlns="http://www.w3.org/1999/xhtml" ><br /><head runat="server"><br />    <title>无标题页</title><br />    <style><br />html { overflow:hidden; }  <br />    </style><br /></head><br /><body><br />    <form id="form1" runat="server"><br /><script t]]></description><category></category></item><item><title><![CDATA[XML字符串读入DataSet]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/5715164</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/5715164</guid><author>Kenyon0313</author><pubDate>Tue, 06 Jul 2010 09:37:00 +0800</pubDate><description><![CDATA[<br />using System.IO;<br />using System.Xml;<br /> <br />string result = 获取XML字符串;            <br />XmlTextReader reader = new XmlTextReader(new StringReader(result));<br />reader.WhitespaceHandling = WhitespaceHandling.None;<br />ds.ReadXml(reader);]]></description><category></category></item><item><title><![CDATA[XML字符串读入DataSet]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/5685581</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/5685581</guid><author>Kenyon0313</author><pubDate>Tue, 22 Jun 2010 10:14:00 +0800</pubDate><description><![CDATA[<br />using System.IO;<br />using System.Xml;<br /> <br />string result = 获取XML字符串;            <br /> XmlTextReader reader = new XmlTextReader(new StringReader(result));<br />reader.WhitespaceHandling = WhitespaceHandling.None;<br />ds.ReadXml(reader);]]></description><category></category></item><item><title><![CDATA[下拉框选项链接]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1876320</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1876320</guid><author>Kenyon0313</author><pubDate>Fri, 09 Nov 2007 16:11:00 +0800</pubDate><description><![CDATA[                             请选择                            http://www.baidu.com/">百度                            http://www.sohu.com/">搜狐                           http://www.163.com/">网易       ]]></description><category></category></item><item><title><![CDATA[从两个ListBox将ListItem选择到一个ListBox]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1871672</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1871672</guid><author>Kenyon0313</author><pubDate>Wed, 07 Nov 2007 15:33:00 +0800</pubDate><description><![CDATA[从ListBox控件lbx_Personal( 个人生命周期)和lbx_Enterprise( 企业生命周期)选择ListItem到lbx_LifeCircle(综合生命周期),使用隐藏域hdn_LifeCircle( 类别:选择的是个人类型还是企业类型还是个人企业类型都有)和hdn_LCList(具体生命周期ID)1.页面加载时给ListBox添加Attribute:lbx_LifeCi]]></description><category></category></item><item><title><![CDATA[企业管理器中将Excel手动导入Sql Server 2000]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1834889</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1834889</guid><author>Kenyon0313</author><pubDate>Sat, 20 Oct 2007 21:59:00 +0800</pubDate><description><![CDATA[1、打开企业管理器，打开要导入数据的数据库，在表上按右键，所有任务-->导入数据，弹出DTS导入/导出向导，按 下一步 ，2、选择数据源 Microsoft Excel 97-2000，文件名 选择要导入的xls文件，按 下一步 ，3、选择目的 用于SQL Server 的Microsoft OLE DB提供程序，服务器选择本地(如果是本地数据库的话，如 VVV)，使用SQL Server身份验证]]></description><category></category></item><item><title><![CDATA[sql 查询结果随机排序]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1807941</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1807941</guid><author>Kenyon0313</author><pubDate>Sun, 30 Sep 2007 13:34:00 +0800</pubDate><description><![CDATA[查询结果随机排序:select * from [TableName] order by newid()]]></description><category></category></item><item><title><![CDATA[页面加载时显示日期时间星期几并自动更新]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1795272</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1795272</guid><author>Kenyon0313</author><pubDate>Fri, 21 Sep 2007 20:24:00 +0800</pubDate><description><![CDATA[页面加载时显示年月日时分秒星期几并自动更新function getDateAndWeekDay(){   var dt = new Date();   var myYear = dt.getYear();   var myMonth = dt.getMonth() + 1;   var myDay = dt.getDate();   var myHour = dt.getHours]]></description><category></category></item><item><title><![CDATA[Sql技巧:获取带序号的数据]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1747659</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1747659</guid><author>Kenyon0313</author><pubDate>Fri, 17 Aug 2007 09:07:00 +0800</pubDate><description><![CDATA[获取带序号的查询结果:假设有Customer表，该表有CustomerID,CustomerName等列,其中CustomerID为Identity列，假设现在需要对Customer表做一项排名，列出前十名的Customer,并在查询结果中带上名次思路:建立一个procedure,在procedure中建立一个带Identity列的临时表,将数据插入临时表,再从临时表中检索数据Crea]]></description><category></category></item><item><title><![CDATA[ASP.NET页面预览的小问题]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1740605</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1740605</guid><author>Kenyon0313</author><pubDate>Mon, 13 Aug 2007 14:19:00 +0800</pubDate><description><![CDATA[前段时间项目中某个ASPX页面做了一个页面预览 的功能,在页面中用Session保存预览信息，然后在预览页面中Remove掉。实现过程中遇到了一些小麻烦,一度很抓狂,比如某些信息改变以后预览结果还是原来的信息、比如有些信息第一次预览时存在，更改以后不存在了，但是再次预览信息还是存在，后来自己新建一个工程试了一下，还是用原来的思路，在页面中用Session保存预览信息，在预览页面中将Session ]]></description><category></category></item><item><title><![CDATA[GridView 全选]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1735656</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1735656</guid><author>Kenyon0313</author><pubDate>Fri, 10 Aug 2007 10:05:00 +0800</pubDate><description><![CDATA[在使用GridView控件的时候，有时候需要GridView控件有选择框列，勾选或反选某一行数据，选择所有行数据或者反选所有行数据，勾选某一行数据时可能还要判断是否所有行数据都已勾选从而控制“全选”选项是否需要选中，下面的实例将实现以上功能：第一步：在页面中加一个隐藏域，用来放置选择的键值第二步：给GridView添加模板列，包括头模板和项模板：头模板加一个选择框，选择的时候调用一个名]]></description><category></category></item><item><title><![CDATA[JS 关闭窗口的小问题]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1731790</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1731790</guid><author>Kenyon0313</author><pubDate>Wed, 08 Aug 2007 16:43:00 +0800</pubDate><description><![CDATA[点击页面上的关闭窗口按钮的时候，页面首先弹出了自定义的对话框，点击“确定”以后又弹出了“您查看的网页真该试图关闭窗口。是否关闭此窗口？” 的对话框，要去掉“您查看的网页真该试图关闭窗口。是否关闭此窗口？” 的对话框，需要在加一条JS语句：if(confirm(是否真的退出系统？)){    window.opener = null;   //加上此语句，不会弹出“您查看的网页真该试]]></description><category></category></item><item><title><![CDATA[ASP.NET Excel数据导入SQL Server]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1731760</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1731760</guid><author>Kenyon0313</author><pubDate>Wed, 08 Aug 2007 16:28:00 +0800</pubDate><description><![CDATA[ASP.NET Excel数据导入SQL Server的示例:string FileName = file_Customer.PostedFile.FileName.Trim();  //获取带路径的文件名 string excelConnectionStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FileNam]]></description><category></category></item><item><title><![CDATA[C# 发送邮件]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1686592</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1686592</guid><author>Kenyon0313</author><pubDate>Thu, 12 Jul 2007 15:14:00 +0800</pubDate><description><![CDATA[//引入System.Web.Mail名称空间using System.Web.Mail;//发送邮件的代码段 MailMessage mail = new MailMessage();        mail.From = "发件邮箱地址";        mail.To = "收件箱地址";        mail.Subject = "邮件主题";        mail.Body ]]></description><category></category></item><item><title><![CDATA[ASP.NET下载文件(弹出打开保存文件对话框)]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1685511</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1685511</guid><author>Kenyon0313</author><pubDate>Wed, 11 Jul 2007 17:29:00 +0800</pubDate><description><![CDATA[//fileURL为带路径的文件全名System.IO.FileInfo fileInfo = new System.IO.FileInfo(fileURL);            Response.Clear();            Response.AddHeader("content-disposition","attachment;filename="+Server.UrlEnc]]></description><category></category></item><item><title><![CDATA[JS 文本框中只允许输入数字]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1642408</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1642408</guid><author>Kenyon0313</author><pubDate>Thu, 07 Jun 2007 14:51:00 +0800</pubDate><description><![CDATA[function handleEvent(oEvent)    {//数字"0"的keyCode为48,"1"为49,依此类推       if(oEvent.keyCode != 48 && oEvent.keyCode != 49 && oEvent.keyCode != 50 && oEvent.keyCode != 51 && oEvent.keyCode != 52 && oEven]]></description><category></category></item><item><title><![CDATA[根据表名获取列名]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1591459</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1591459</guid><author>Kenyon0313</author><pubDate>Sun, 29 Apr 2007 11:12:00 +0800</pubDate><description><![CDATA[select name from  syscolumns where id = (select id from Sysobjects where name = 表名) ]]></description><category></category></item><item><title><![CDATA[JavaScript KeyCode]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1568858</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1568858</guid><author>Kenyon0313</author><pubDate>Wed, 18 Apr 2007 11:34:00 +0800</pubDate><description><![CDATA[key code   键8                BackSpace9                Tab Tab12              Clear13              Enter16              Shift_L17              Control_L18              Alt_L19              Pause20  ]]></description><category></category></item><item><title><![CDATA[将子窗口选择内容写入父窗口]]></title><link>https://blog.youkuaiyun.com/Kenyon0313/article/details/1545157</link><guid>https://blog.youkuaiyun.com/Kenyon0313/article/details/1545157</guid><author>Kenyon0313</author><pubDate>Thu, 29 Mar 2007 12:48:00 +0800</pubDate><description><![CDATA[在父窗口的TextBox输入文字时弹出子窗口,将子窗口选择内容写入父窗口的TextBox父窗口cs:txt_Phone.Attributes.Add("onkeydown","ShowDialog()");父窗口js: function ShowDialog()    {        window.open("CustomersInfo.aspx","newwindow","Wd]]></description><category></category></item></channel></rss>