Floating Heart - All Comments

re: 一位软件工程师的6年总结

Coolboy — Sun, 28 Dec 2008 01:43:38 GMT

学历代表过去、能力代表现在、学习代表未来。

....

...“再也受不了啦！”.....

haha...

re: Visual Studio 2010 and .NET Framework 4.0 Training Kit

slash — Mon, 24 Nov 2008 06:20:35 GMT

这也太快了把...

re: Simple Assembly Explorer and Simple Reminder Open Source

Coolboy — Wed, 08 Oct 2008 06:59:15 GMT

hehe..原来reminder可以用作email轰炸机.......

re: Simple Assembly Explorer and Simple Reminder Open Source

slash — Wed, 08 Oct 2008 01:18:31 GMT

支持...

re: 爸爸的烦恼

jawance — Wed, 24 Sep 2008 01:19:10 GMT

墨尔本的经济分析家。之前也看了一下他的QQblog。比较能明白的白话论经济。

re: Web Application Stress Tool

wicky — Thu, 11 Sep 2008 11:24:42 GMT

jakarta.apache.org/jmeter

Apache JMeter features include:

Can load and performance test many different server types:

Web - HTTP, HTTPS

SOAP

Database via JDBC

LDAP

JMS

Mail - POP3

Complete portability and 100% Java purity .

Full Swing and lightweight component support (precompiled JAR uses packages javax.swing.* ).

Full multithreading framework allows concurrent sampling by many threads and simultaneous sampling of different functions by seperate thread groups.

Careful GUI design allows faster operation and more precise timings.

Caching and offline analysis/replaying of test results.

Highly Extensible:

Pluggable Samplers allow unlimited testing capabilities.

Several load statistics may be choosen with pluggable timers .

Data analysis and visualization plugins allow great extendibility as well as personalization.

Functions can be used to provide dynamic input to a test or provide data manipulation.

Scriptable Samplers (BeanShell is fully supported; and there is a sampler which supports BSF-compatible languages)

re: 残奥会点火

jawance — Tue, 09 Sep 2008 08:55:57 GMT

前段时间看了一些导盲犬的片子，这种犬被训练的很聪明，能把握住每个步阶的开始和结束，每个corner，还有红绿灯，做出很多提示。

re: 中国办公室的22条潜规则

jawance — Tue, 09 Sep 2008 08:38:46 GMT

太高深莫测了，不懂。

re: How to build an Office COM add-in by using Visual C# .NET

wicky — Wed, 03 Sep 2008 01:25:29 GMT

Hello Word Outlook Add-In using C#

weblogs.asp.net/.../93712.aspx

One thing I’d like to play with is extending Outlook through add-ins with C#. It’ll be a good opportunity to learn more about .NET development and the Windows tools. Plus, I can “fix” some of the things that annoy me about Outlook. I’ve been talking to Omar about this too, and hopefully we can collaborate on a few projects. We’ve been sharing a few links back and forth on getting started. It’s a bit hard to find the right information to get started, but it’s out there. I’ve compiled steps below for a “hello world” type Outlook project that I’ll be building off in the future. I hope this will be useful to others trying to get started on developing Outlook add-ins using managed code. Please let me know if I’m missing anything or have errors.

Install Primary Interop Assemblies

.NET can interface with COM code using interop assemblies. You can create these as needed by adding a reference to a COM type library. However, if you do this for the Outlook/Office type libraries, this will lead to strange problems like this. This doesn’t sound like the thing I want to find out about the hard way. The solution is to install “primary interop assemblies” that live in the GAC and will be used instead of custom generated ones. You can download PIAs for Outlook XP here. For Outlook 2003, you can go to Control Panels->Add/Remove programs and customize your installation to add them. Just choose “.NET Programmability” under the various components. They are initially set to install on first use – I don’t know what would actually trigger this. Once these are installed, adding a reference to the COM type libraries will add these “magic” versions instead of generating new versions with strange issues.

Create a Visual Studio.NET project

Create a new Visual Studio.Net project. For the project type, select Other Projects->Extensibility Projects->Shared Add-ins (who would think to look here?). This brings you through a wizard where you can select the language (C#, of course!) and which hosts to support. One cool thing you can do with the Office COM-plugins is support multiple apps with the same plugin, but I’m only interested in Outlook for now. Then, you have the chance to fill in some other random info, and your project is created. The project will have template code that implements the IDTExtensibility2 interface required to create an add-in.

Add references

We need to add references to a couple of things we’ll be using. Right-click References under the add-in project, select “Add Reference”, go to the COM tab, and select Microsoft Outlook 11.0 Object Library (or Outlook 10.0 if you are using Outlook XP). If the PIA stuff worked right, when you select it in the solution explorer, the path in the properties tab should be pointing into the GAC, not into the office folder. Next, select

“Add Reference” again, and add “System.Windows.Forms” from the .NET tab. This will let us do our “Hello World” dialog.

Flesh out code

First, we need to add a member variable. We’ll also change the type of the application object to be the Outlook type (since we’ll only support Outlook):

private Microsoft.Office.Interop.Outlook.Application applicationObject;

private object addInInstance;

private CommandBarButton toolbarButton;

Next, we’ll update OnConnection to cast to the Outlook object type, and add some logic from kb 302901 (why isn’t this in the template if it’s the right thing to do?):

public void OnConnection(object application, Extensibility.ext_ConnectMode connectMode, object addInInst, ref System.Array custom)

{

applicationObject = (Microsoft.Office.Interop.Outlook.Application)application;

addInInstance = addInInst;

if(connectMode != Extensibility.ext_ConnectMode.ext_cm_Startup)

{

OnStartupComplete(ref custom);

}

Likewise, we’ll update OnDisconnection according to kb 302901:

public void OnDisconnection(Extensibility.ext_DisconnectMode disconnectMode, ref System.Array custom)

{

if(disconnectMode != Extensibility.ext_DisconnectMode.ext_dm_HostShutdown)

{

OnBeginShutdown(ref custom);

}

applicationObject = null;

}

Next, when we’re done loading, we will create a toolbar button. The version in kb 302901 is more complex because it’s generalize to work in apps other than Outlook:

public void OnStartupComplete(ref System.Array custom)

{

CommandBars commandBars = applicationObject.ActiveExplorer().CommandBars;

// Create a toolbar button on the standard toolbar that calls ToolbarButton_Click when clicked

try

{

// See if it already exists

this.toolbarButton = (CommandBarButton)commandBars["Standard"].Controls["Hello"];

}

catch(Exception)

{

// Create it

this.toolbarButton = (CommandBarButton)commandBars["Standard"].Controls.Add(1, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value);

this.toolbarButton.Caption = "Hello";

this.toolbarButton.Style = MsoButtonStyle.msoButtonCaption;

}

this.toolbarButton.Tag = "Hello Button";

this.toolbarButton.OnAction = "!<MyAddin1.Connect>";

this.toolbarButton.Visible = true;

this.toolbarButton.Click += new Microsoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(this.OnToolbarButtonClick);

}

On shutdown, we’ll delete our toolbar button:

public void OnBeginShutdown(ref System.Array custom)

{

this.toolbarButton.Delete(System.Reflection.Missing.Value);

this.toolbarButton = null;

}

And, we’ll define the action when clicking the button:

private void OnToolbarButtonClick(CommandBarButton cmdBarbutton,ref bool cancel)

{

System.Windows.Forms.MessageBox.Show("Hello World","My Addin");

}

To test it out, you build the addin project, and then the setup project. Quit Outlook, then right-click the setup project and select “Install”. When you launch Outlook, a button named “Hello” will show up in the main toolbar. Selecting it will say “Hello World”. You can manage this add-in by going to the COM add-in dialog at Tools->Options->Other->Advanced Options->COM Add-Ins.

What’s missing

There are some steps that need to be taken to install the PIA when installing your add-in. See the steps here. That sample also has a lot of information about signing your plugin, which I’ve ignored so far.

What’s next

Next, I have to learn more about the Outlook object model and how to actually do interesting things. I also need to learn how to debug the add-ins.

Reference

General description of COM Add-Ins: msdn.microsoft.com/.../default.asp

A sample Visual Basic.NET plugin (describes the PIA stuff): msdn.microsoft.com/.../default.asp

KB 302901 (building an Office COM plugin using Visual C#.NET): support.microsoft.com

Niobe, a library for Outlook managed plug-ins (I’m not sure what you get above doing it from scratch, there isn’t much documentation): www.gotdotnet.com/.../workspace.aspx

re: 警惕二十九岁现象

Coolboy — Mon, 01 Sep 2008 13:35:41 GMT

还有俺还有几年才到二十九...

but it seem that many colleagues almost rich this age...

re: Microsoft SQL Server 2008 正式发布

Coolboy — Thu, 07 Aug 2008 08:23:55 GMT

听说数据达到4T之后,SQL server的性能比Oralce好很多,快很多哦.

re: 写出高质量软件的75条体会

Kamte — Wed, 06 Aug 2008 06:02:20 GMT

不错,但我们有的...

re: 写出高质量软件的75条体会

slash — Mon, 04 Aug 2008 01:19:41 GMT

不错哦...

re: 写出高质量软件的75条体会

Coolboy — Sun, 03 Aug 2008 15:30:32 GMT

22. 你们项目组有Team Morale Activity么？

MVM：每个月都要搞一次，吃饭、唱歌、Outing、打球、开卡丁车等等，一定要有。不要剩这些钱。

re: How to Restore SQL Server 2005 Suspect Database

wicky — Fri, 01 Aug 2008 10:00:21 GMT

googling found an interesting page here: www.spaceprogram.com/.../sqlserver_recover_from_deleted_log.html

Here is the text from that website:

Recovering from a deleted log file on SQL Server

Introduction

This document will give instructions on how to recover from a deleted database log file on Microsoft SQL Server. The database this was done on was SQL Server 7 with SQL Server 2000.

You will get a suspect beside the name of the database when this happens.

You may be interested in the document if one of the following happened:

You're log file got too big so you decided to shutdown SQL Server, then delete the log file.

Salvage data from a damaged SQL data (.MDF) file. ( Someone emailed about this ).

That's the only reason I can think of right now and that is the reason I have come to do figuring this out, so here goes.

Instructions

If you have a recent backup of the database, USE IT! Forget about this article and do a normal restore procedure. Otherwise read on.

First of all, you are SOL if you want a full recovery. You just can't get all the data back because the log file itself contained a lot of transactions that may never have made it to the data file.

So anyways, I read just about everything possible on this topic and nothing worked, I mean nothing. I tried going into emergency mode, running stored procedures that did squat, using sp_detach_db, then sp_attach_db, etc, even trying db_rebuild_log() (the rebuild_log thing seems to be an undocumented feature that someone must have figured out... easter egg?? not really since there are some serious warnings against using it, but hey, when you're in dire straits, you'll try anything once, right?).

This restore procedure doesn't seem to be formally documented anywhere. I guess you're just not supposed to be this stupid, but everybody makes mistakes don't they? And hey, I'm no DBA or anything! I just use the damn things. ;-)

Anyways, on to the guts of the article. I am trying to make this as simple as possible and pulling this from memory so if there is something I am missing, please don't hesitate to e-mail us at: knowledge@spaceprogram.com.

There's one thing to note here and if someone could verify it, that would be great. First thing I'd like to verify is if you can just skip to step 9 right off the bat? So as soon as you get a suspect database, can you just start at step 9? Can someone please try that and let me know. SEE UPDATE: JAN. 6, 2003 BELOW

Backup the data (.mdf) file! Just in case. We take no responsibility for anything that happens following this procedure.

EXEC sp_detach_db 'dbname' -- this will detach the database from the server

Restart SQL Server

The database may still be seen in enterprise manager, but just ignore it.

Create a new database with the same name or a different name. You will have to use a different physical file name, which is fine.

Stop SQL Server.

Rename the new data file that was created to something else (ex: add.bak to the end)

Rename the old data file that you want to restore to the name of the newly created file (the same name as the file you changed in the step above)

Start SQL Server

Now the db will still be suspect but you now have a log file.

Switch to emergency mode on the database. You do this by doing the following:

Right click on the database root node in Enterprise manager and bring up the properties.

Under the Server Settings tab, check of "Allow modifications to be made directly to the system catalogs".

click ok

Now go to the master database and open the sysdatabases table.

Find the suspected database in here and modify the status column, setting it to: 32768. This will put it into emergency mode.

stop then start sql server

Now here's the tricky part and I'm not sure how this will work on a single install, i was lucky enough to have SQL Server 2000 installed. But anyways, open up the Import and Export Data (DTS) program from the start menu. And you want to copy data from the old database to a brand new one. Just copy tables and views. And voila, this should work smoothly. Let me emphasize should.

UPDATE: Jan. 6, 2003

I just received an email from someone who tried starting at step 9 and he said it worked. If I can get someone else to confirm that, then I'll get rid of 1-8.

UPDATE: June 18, 2003

It seems that some people can just do 9-10 and some have to do all the steps.

Emails Received in Response to this Article

There have been many emails we have received about this article both sharing their experience and praising the instructions.

Read the emails here: www.spaceprogram.com/.../sqlserver_recover_emails_received.html

re: XPO 使用记录

jawance — Fri, 18 Jul 2008 00:53:41 GMT

长了见识。封装的这么多，有没有原理或原形资料参考？有没有建立这个xpo的开发人员写的指南或深入XXX 文档？

re: SimpleReminder Build 2008.06.19

slash — Fri, 20 Jun 2008 00:36:14 GMT

haha...

re: SimpleReminder Build 2008.06.10

wicky — Wed, 11 Jun 2008 03:27:32 GMT

壹壹壹壹壹壹......怒！！874一百遍啊一百遍！

re: SimpleReminder Build 2008.06.10

Coolboy — Wed, 11 Jun 2008 00:45:17 GMT

10个雪糕?不值, simple assembly exploer就值.

re: SimpleReminder Build 2008.06.05

wicky — Fri, 06 Jun 2008 09:14:54 GMT

Here there are many characters:

www.msagentring.org/chars.aspx

re: SimpleReminder Build 2008.06.05

wicky — Fri, 06 Jun 2008 01:56:50 GMT

系统设计使然。Add的时候是真的Add。没有加密，Reflector看看就是了。和源代码基本上一模一样。想要project的话至少10个雪糕。

re: SimpleReminder Build 2008.06.05

Coolboy — Fri, 06 Jun 2008 01:50:54 GMT

是不是开源的?怎样可以得到源代码啊?

re: SimpleReminder Build 2008.06.05

Coolboy — Fri, 06 Jun 2008 01:31:20 GMT

点了add, 没有save,直接按close,又会add 一个空白的event?

re: c#四种eval方法

Coolboy — Fri, 25 Apr 2008 07:07:35 GMT

up up先..

re: How to Create Linked Server for a MySQL in SQL Server

wicky — Tue, 08 Apr 2008 02:17:14 GMT

Please follow below steps to create linked server for Mysql in SQL 2000:

1. Download and Install MySQL ODBC driver

dev.mysql.com/.../3.51.html, you can choose Windows MSI Installer (x86) for simplified installation.

2. Configure ODBC

Open Administrative Tools -> Data Source (ODBC) (in Windows 2000, it may be Control Panel -> ODBC)

Click System DSN -> Add -> Choose MySQL ODBC 3.51 Driver -> Finish

Data Source Name: dotcom

Server: mysql server host name or ip address

User: mysql user account

Password: mysql user password

Database: mysql database

Advanced tab:

Flags 1:

check Don't Optimize Column width

check Return Matching Rows

check Allow Big Results

check Change BIGINT Columns to Int

check Safe

Flags 2:

check Don't Prompt Upon Connect

check Ignore # in Table Name

Flag 3:

check Return Table Names for SQLDescribeCol

check Disable Transactions

OK to save the DSN

3. Create Linked Server

Open SQL Server Enterprise Manager, go to Security -> Linked Server

Right click and select New Linked Server

General tab:

Linked Server: dotcom

Other data source: Microsoft OLE DB Provider for ODBC Driver

Provider Options:

check Nested queries

check Level zero only

check Allow InProcess

check Non transacted updates

Product name: dotcom

Data Source: dotcom

Security tab:

Be made using this security context:

Remote login: mysql user account

with password: mysql user password

OK to save the linked server

4. Test the Linked Server by SQL

select * from dotcom...[table name]

re: 制作集成SATA驱动的WindowsXP/2003安装盘

jawance — Tue, 01 Apr 2008 00:46:03 GMT

刻录进光盘，不用软驱是一个进步。

后面的留给各个厂商自己搞得人性点吧。

re: 制作集成SATA驱动的WindowsXP/2003安装盘

wicky — Sun, 30 Mar 2008 03:21:25 GMT

详细的英文教程：

forum.driverpacks.net/viewtopic.php

re: 电话激活Windows 2008

jawance — Thu, 20 Mar 2008 07:02:43 GMT

系统会返回一组48位阿拉伯数字的激活ID,记录下来....

----好长阿。48位，怎么记，用笔记。。。记错一个怎么办呢！！！

re: ASP.NET 2.0页面框架的几点新功能

jawance — Thu, 06 Mar 2008 03:25:24 GMT

what a nice post !

re: Enter Key in ASP.NET - Complete Research

jawance — Wed, 27 Feb 2008 01:01:02 GMT

怪事。。