摘要：Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.Example ApplicationThe problem is that by default Microsoft Excel as a COM object can only activated by the following accounts:AdministratorSystemInteractiveWh 阅读全文

摘要：今天在开发时，遇见Access，一条插入语句在Access的查询分析器里面执行正常，却在Ole 程序执行时候报错：insert into 语法错误。解决方案：在字段名和表名上加上[]分隔符。 同时为了避免再次犯同样的错误,现将Access的关键字列出来和大家分享：-AADDALLAlphanumericALTERANDANYApplicationASASCAssistantAUTOINCREMENTAvg-BBETWEENBINARYBITBOOLEANBYBYTE-CCHAR,CHARACTERCOLUMNCompactDatabaseCONSTRAINTContainerCountCO.. 阅读全文

摘要：设置后的效果：文件会自动带上svn:needs-lock属性，默认是只读的要签出才能修改以防止修改完后提交才发现冲突了。只要两步：第一步：新建文件时自动给文件设置强制只读属性（svn:needs-lock）具体操作：从SVN客户端的“设置”界面打开配置文件，在结尾增加：如图：[miscellany]enable-auto-props = yes[auto-props]* = svn:needs-lock第二步：对旧有文件的强制只读属性设置（svn:needs-lock）具体操作：打开项目根目录属性（文件夹空白处右键属性），设置needs-lock属性为*（记得把“递归应用该属性”勾上）添加上S 阅读全文

摘要：public partial class WebDownloadFile : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string id = Request.QueryString["ID"].ToString(); DownloadFile d = new DownloadFile(id); ... 阅读全文

摘要：内容包括三大项:1.oracle基本操作语句2.SQLServer基本操作语句3.各种数据库连接方法oracle基本操作语句打开服务器net start oracleservicebinbo打开监听器lsnrctl start关闭服务器net stop oracleservicebinbo关闭监听器lsnrctl stop===============================================================清屏clear screen数据字典 ===========desc user_views(关键词)========================= 阅读全文

摘要：KeyEventArg.csusing System;namespace EventTest{ internal class KeyEventArg : EventArgs { private char keyChar; public KeyEventArg(char k) : base() { this.keyChar = k; } public char KeyChar { get { ... 阅读全文

摘要：行转列例子： select * from grade select student ,max(decode(subject,'en',grade,null)) 英语 ,max(decode(subject,'ch',grade,null)) 语文,max(decode(subject,'ma',grade,null)) 数学 from grade group by student列转行：创建测试表create table test asselect student ,max(decode(subject,'en',grade,nu 阅读全文

摘要：Pivot如您所知，关系表是表格化的，即，它们以列-值对的形式出现。假设一个表名为 CUSTOMERS。SQL> desc customers Name Null? Type ----------------------------------------- -------- --------------------------- CUST_ID NUMBER(10) CUST_NAME ... 阅读全文