2010-02-11 12:09:46

不知哪一年起说要做工作室主页。
不知哪一年起发现迟迟做不出来。
不知哪一年起说暂定2010年完成。
2010已经到了，我们来实现诺言了。

1 | 2 | 3 | >

Can not access Excel file using OpenRowset

[ 2010-02-11 12:34:32 | Author: sunrise_chen ]

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Providers\Microsoft.Jet.OLEDB.4.0

NOTE: With the DisallowAdHocAccess property set to 1, SQL Server does not allow ad hoc access through the OPENROWSET and the OPENDATASOURCE functions against the specified OLE DB provider. If you try to call these functions in ad hoc queries, you will receive an error message similar to:

...

Read More...

Category: 经验&技巧 | Permalink | Comments: 0 | Trackbacks: 0 | Views: 87

用VS2005开发COM 组件

[ 2010-02-11 12:34:04 | Author: sunrise_chen ]

1, 添加引用
using System.Runtime.InteropServices;

2, 在类名前加上
[ProgId("Shanger.Sunrise")] //Com调用的名字
[Guid("CAF9E079-7A4F-46ac-9516-9A5CCAB41ABD")] //设置GUID
Guid 可以在工具-> 创建 Guid里得到

3, 设置Com可见
双击 "解决方案管理器>项目名>Properties", "应用程序">"程序集信息">"使程序集Com可见"
.或者.
AssemblyInfo.cs里修改: [assembly: ComVisible(true)]
效果一样的.

4. 本机调试(可选)
"解决方案管理器>项目名>Properties", "生成"标签里选"为 COM Interop 注册"

5. 部署
还没做,以后再讲.

...

Read More...

Category: 经验&技巧 | Permalink | Comments: 0 | Trackbacks: 0 | Views: 91

Simplified and Extended Data Binding Syntax in ASP.NET 2.0

[ 2010-02-11 12:33:16 | Author: sunrise_chen ]

Introduction

The server-side data binding techniques that were introduced in ASP.NET version 1.0 revolutionized the way developers build pages that access data. No longer was there a requirement for complex and lengthy code sections that build up HTML tables or lists of values. However, using ASP.NET 1.x, you still have to write code to perform the data access and expose the data to the

...

Read More...

Category: 经验&技巧 | Permalink | Comments: 0 | Trackbacks: 0 | Views: 90

Select data from an Excel sheet in MSSQL

[ 2010-02-11 12:32:20 | Author: sunrise_chen ]

select *
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,

...

Read More...

Category: 经验&技巧 | Permalink | Comments: 0 | Trackbacks: 0 | Views: 98

FTP via ASP without using 3rd-party components

[ 2010-02-11 12:31:22 | Author: sunrise_chen ]

<%@ Language=VBScript %>
<%
' FTP via ASP without using 3rd-party components
' Ben Meghreblian 15th Jan 2002
' benmeg at benmeg dot com / http://benmeg.com/code/asp/ftp.asp.html
'
' This script assumes the file to be FTP'ed is in the same directory as this script.
' It should be obvious how to change this (*hint* change the lcd line).
' You may specify a wildcard in ftp_files_to_put (e.g. *.txt).

'

...

Read More...

Category: 经验&技巧 | Permalink | Comments: 0 | Trackbacks: 0 | Views: 95

网页制作之在线视频播放代码

[ 2010-02-11 12:27:05 | Author: sunrise_chen ]

站长说明：

1.avi格式

...

Read More...

Category: 经验&技巧 | Permalink | Comments: 0 | Trackbacks: 0 | Views: 118

How to load HTML into mshtml.HTMLDocumentClass with UCOMIPersistFile and my ignorance

[ 2010-02-11 12:26:26 | Author: sunrise_chen ]

What a weird one. I'm looking at the source for NDoc.Document.HtmlHelp2.Compiler.HtmlHelpFile. It uses the Microsoft.mshtml interop Assembly to load an HTML file into the HTMLDocumentClass for easy parsing.

It's code looks like this (DOESN'T WORK):

private HTMLDocumentClass GetHtmlDocument( FileInfo f )

...

Read More...

Category: 经验&技巧 | Permalink | Comments: 0 | Trackbacks: 0 | Views: 95

JPivot易用性修改

[ 2010-02-11 12:26:07 | Author: 狰狞的微笑 ]

mondrianQuery TAG 修改

scriplet 输出MDX查询支持
修改 TLD文件中 mondrianQuery TAG 的 body-content 为JSP
修改 MondrianOlapModelTag 的父类 com.tonbeller.jpivot.tags.OlapModelTag
为其加入 doStartTag 方法,返回EVAL_BODY_BUFFERED，
使之在 getBodyContent 之前先对 scriplet 进行处理。
ex：public int doStartTag(){return EVAL_BODY_BUFFERED;}

Category: 经验&技巧 | Permalink | Comments: 0 | Trackbacks: 0 | Views: 94

1 | 2 | 3 | >