<![CDATA[]]> http://www.ccopus.com/blog/ zh-cn LBS v2.0.304 Thu, 28 Aug 2008 06:59:37 +0800 60 <![CDATA[Select data from an Excel sheet in MSSQL]]> ]]> Fri, 22 Jun 2007 15:10:08 +0800 from openrowset('Microsoft.Jet.OLEDB.4.0'
,'Excel 8.0;HDR=YES;IMEX=1;DATABASE=d:\folder\excel.xls',Sheet1$)

-------NOTE------
Setting IMEX=1 tells the driver to use Import mode. In this state, the registry setting ImportMixedTypes=Text will be noticed. This forces mixed data to be converted to text. For this to work reliably, you may also have to modify the registry setting, TypeGuessRows=8. The ISAM driver by default looks at the first eight rows and from that sampling determines the datatype. If this eight row sampling is all numeric, then s]]> <![CDATA[Send Mail with CDO]]> ]]> Thu, 25 Jan 2007 16:58:22 +0800 <!--METADATA TYPE="typelib" UUID="CD000000-8B95-11D1-82DB-00C04FB1625D" NAME="CDO for Windows 2000 Library" -->
<%
    myMail = new ActiveXObject("CDO.Message");
    myMail.Configuration.Fields.Item(cdoSendUsingMethod) = cdoSendUsingPort;
    myMail.Configuration.Fields.Item(cdoSMTPServer) = "mail.mailserver.com";
    myMail.Configuration.Fields.Item(cdoSMTPServerPort) = 25;
    myMail.Configuration.]]> <![CDATA[Send Mail with JMail]]> ]]> Thu, 25 Jan 2007 16:44:22 +0800  Dim JMail
 Set JMail = Server.CreateObject("JMail.Message")
 JMail.Logging = true
 JMail.Silent = true
 JMail.MailServerUserName = "serverusername"
 JMail.MailServerPassword = "password"
 JMail.Charset = "utf-8"
 JMail.From = "sender@xxx.com"
 JMail.AddRecipient("recipient@xxx.com")]]> <![CDATA[Send Mail in ASP.NET 2.0]]> ]]> Wed, 17 Jan 2007 23:17:21 +0800 {
System.Net.Mail.SmtpClient client = new SmtpClient(strSmtpServer);
client.UseDefaultCredentials = false;
client.Credentials = new System.Net.NetworkCredential(strFrom, strFromPass);
client.DeliveryMethod = SmtpDeliveryMethod.Network;
]]> <![CDATA[Send Mail in ASP.NET 1.x]]> ]]> Wed, 17 Jan 2007 23:16:35 +0800 {
MailMessage mail = new MailMessage();
mail.To = "me@mycompany.com";
mail.From = "you@yourcompany.com";
mail.Subject = "this is a test email.";
mail.Body = "Some text goes here";
mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1"); //basic authentication
]]> <![CDATA[第一次做Gadget，有兴趣的朋友看看，呵呵~，写得比较烂]]> ]]> Wed, 15 Nov 2006 17:12:33 +0800 http://www.ccopus.com/sodoku/Gadget.xml

要装到www.live.com上才能玩]]> <![CDATA[一段未完成的代码（推箱子游戏）]]> ]]> Wed, 11 Oct 2006 11:06:23 +0800
<script language=javascript>
  var R = 10, C = 10;

  var MAPS = [];
  MAPS[0] = "0000000000000111000000012100000001011110011130321001203511100111131000000012100000001110000000000000";
  MAPS[1] = "1111100000100510000010331011101030101210111011121001100002100100010010010001111001111100000000000000";
  MAPS[2] = "00000000000111111
]]> <![CDATA[制作简单的服务器性能测试页面]]> ]]> Sun, 08 Oct 2006 11:10:26 +0800 <HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft System Monitor">
<META NAME="Author" CONTENT="sunrise_chen@msn.com">
<META HTTP-EQUIV="Content-Type" content="text/html; charset=iso-8859-1">
</HEAD><BODY>
<OBJECT ID="DISystemMonitor1" WIDTH="100%" HEIGHT="100%"
CLASSID="CLSID:C4D2D8E0-D1DD-11CE-940F-008029004347">
 <PARAM NAME="Counter00001.Path" VALUE="\\SUNRISE\Memory\Available MBytes">]]> <![CDATA[ASP封成DLL]]> ]]> Sun, 08 Oct 2006 11:09:31 +0800
服务器端组件

首先,服务器端的组件要有别于客户端的组件.客户端的组件是通过网络传输,依靠HTML来起作用.而且只能在IE上有用.但是服 务器端的组件是运行在服务器端,它在服务器上执行各种操作.因此,所有的浏览器都能享用,它依*的是服务器而不是浏览器.

当IIS被请求执行一个ASP程序,它首先会在ASP文件中找到<%%>标签之间的代码,并且执行它(也可以是<script runat=server></script>之间的代码).如果这个ASP程序在先前被调用过,那么它就会用 内存中的编译过的程序来向用户返回HTML代码,如果没有,那么它就重新编译.这里ASP就比CGI多一点速度优势,因为CGI 是每一个请求都使用一个线程.这样就大大消耗了服务器的资源.

想不想你写的程序自己就能在IIS运行!?!现在你就行了!使用VB5(当然现在是VB6了),你就能建立DynamicLin ]]> <![CDATA[JScript on the server: GetRows example]]> ]]> Sun, 08 Oct 2006 10:43:31 +0800
by Peter Johnson
Translated by Sunrise_Chen <sunrise_chen@msn.com>

Who should read this article: Programmers writing ASP in JScript instead of VBScript
谁适合读这篇文章: 用JScript替代VBScript写ASP的程序员。

I've found many sites that advocate the use of GetRows, including LearnASP (which also has GetRows functionality on steroids available in JScript in the form of ]]>