http://school.21tx.com/2005/12/28/11895.html     
1.如果同时有多个窗口打开，想要关闭的话，可以按住shift不放然后点击窗口右 上角的关闭图标. 　　

　　2.在保存网页前，可以按一下"ESC"键(或脱机工作)再保存,这样保存很快 　　

　 　3.用电脑听CD可以不用任何的播放软件，把音箱线直接接到光驱的耳机孔，放入 CD，按光驱上的play键就可以直接听了，这样听歌可以不占用系统资源。（如果你的电脑坏了，不能启动或什么的，一时放在那不能修，千万不要浪费资源 ，把用里面的电源给光驱通上电，就可以暂时做CD机了.　　

　　4.MSN中发消息的时候是按enter的，如果想要换行而不想发出消息，可以 shift+enter或ctrl+enter 　　

　　5.浏览器的地址栏里可以调试简短的HTML代码。方法如下： 地址栏写 about :abc 回车，就看到效果了. 　　

　　6.Windows快捷键：

　　win+m 显示桌面

　　win+pause 系统属性

　　快速重新启动:按确定前先按shift(不适用于2k、xp）.

　　彻底删除:shift+del

　　不让光盘自动运行:按shift

　　Ctrl+Esc：相当于"开始"或WIN键

　　Ctrl+Home：将游标移至文字编辑区的开始始(Home单用：移至列首)

　　Ctrl+End：将光标移至文字编辑区的终点(End单用：移至列尾)

　　Alt+F4：关闭当前视窗（若是点一下桌面再按则为关机)

　　F2：更改名称

　　windows+e 资源管理器.

　　windows+r 运行.

　　windows+f 查找.

　　windows+u 关闭系统.

　　windows+d最小化所有窗口，再按一次Win+D可回到最小化前的窗口.

　　windows+m最小化所有窗口，但再按一次无法回到最小化前的窗口.

　　Shift+F10，可以打开所选项目的右键菜单.

　　按住 CTRL+SHIFT 拖动文件:创建快捷方式. 　　

　　7.关机快捷方式

　　(1). 在桌面空白位置按鼠标右键 -> <新建> -> 选<快捷方式>

　　(2). 在<指令行>键入 rundll.exe user.exe,exitwindows

　　(3). 在<选择快捷方式 的名称>键入<关闭Window>或你想要的名称 -> 按<完成 >
　　8.重新启动快捷方式

　　(1). 重复以上 (1)

　　(2). 在<指令行>键入 rundll.exe user.exe,exitwindow***ec

　　(3). 在<选择快捷方式的名称>键入<重新启动Restart>或你想要的名称 -> 按< 完成>

http://school.21tx.com/2005/12/28/11895.html

One of the possible ways is to create a SQL-based table and a table view
based on that table. Then, create C1DataSetLogic objects (from the context
menu of C1SchemaDef) and wire to the BeforeGenerateSql event.

private void dataset_DataSet1_BeforeGenerateSql(object sender, C1.Data.GenerateSqlEventArgs e)
{
    if (e.TableView.Name == "MyTableView")
    {
        e.Command = new OleDbCommand(
            "SELECT TOP 5 Field1, Field2, Field3 FROM SomeTable",
            (OleDbConnection)e.TableView.Diagram.Schema.Connections["Connection"].DbConnection);
        e.Status = DataSetEventStatusEnum.Skip;
    }
}

However, it may be more easier to use standard OleDbDataAdapter with custom SQL
statement for this purpose.

Regards,

Well, would it be possible to give 2/3 code snippets where you are using
> the new clone function to copy sheets from one book to another?

Sure, I hope this is enough:


    c1XLBook1.Load(dlg.FileName);
    C1XLBook cloneBook = CloneBook(this.c1XLBook1);
    cloneBook.Save(dlg.FileName + "clone.xls");

    private C1XLBook CloneBook(C1.C1Excel.C1XLBook book)
    {
        C1XLBook clone = new C1XLBook();
        clone.Sheets.Clear();
        foreach (XLSheet sheet in book.Sheets)
        {
            clone.Sheets.Add(sheet.Clone());
        }
        return clone;
    }

最近对.net的辅助工具比较感兴趣，网上也已经有.net的十个必备工具的帖子了，这里提供了一份全面的工具列表：
Code generation

• NVelocity
• CodeSmith
• X-Code .NET
• XGoF – NMatrix / DEVerest

Compilation

• eXtensible C# – ResolveCorp
• Mono
• DotGNU – GNU

Obfuscation

• LSW-IL-Obfuscator – Lesser Software
• Demeanor for .NET – Wise Owl
• Salamander .NET Obfuscator – Remotesoft
• Salamander .NET Protector – Remotesoft
• IL-Obfuscator – 9rays.Net
• Deploy.NET – Jungle Creatures
• Dotfuscator – PreEmptive Solutions (lite version included in Visual Studio 2003)
• XenoCode – Oak Vale Networks
• Thinstall – Jonathan Clark

Decompilation

• Salamander .NET Decompiler – Remotesoft
• Anakrino

Object Browsing

• .NET Reflector - Lutz Roeder
• LSW-DotNet-Reflection-Browser – Lesser Software
• .NET Component Inspector – nogoop software
• Object State Browser – Jeff Key

Refactoring

• C# Refactoring Tool – .NET Refactoring
• C# Refactory – Xtreme Simplicity

Persistence and data-related code generation

See also "RAD Tools – Application Development Automation" below

• OlyMars (SQL Server Centric .NET Code Generator)
• LLBLGen – Solutions Design
• .NET N-Tier Framework Generator - Gavin Joyce
• Entity Broker – Thona Consulting
• KickStarter.Net
• TierDeveloper - AlachiSoft
• SP/Invoke
• Data Tier Modeler (DTM)
• Pragmatier Data Tier Builder
• ORM.NET – Olero Software
• .Net Persistence - Netica
• ObjectSpaces – Microsoft
• Sisyphus Persistence Framework
• Objectz.NET – Mongoose solutions
• Visible Developer – Visible Systems
• NHibernate
• ObjectSpark – Firestar Software
• Bamboo.Prevalence
• ADO.NET Powertoys – The ADO Guy
• Database to .NET – Nantronix Software
• Xheo.Enterprise – Xheo

RAD Tools – Application Development Automation

• DeKlarit – ARTech
• DataPhor – Alphora
• CompileX – Atlantis DB Software

Model Driven Architecture

• Constructor() – Dot Net Builders

Modeling – UML

• Rational XDE – IBM
• Visio – Microsoft (part of Visual Studio .NET Enterprise Architect edition)
• Visual Case – Artiso

IDEs

• Visual Studio .NET – Microsoft
• SharpDevelop
• PrimalCode – Sapien
• ASP.NET Web Matrix – Microsoft
• Improve C# Plugin for Eclipse – Improve

Builds

• NAnt
• SLiNgshoT
• Draco.NET
• CruiseControl.NET
• FinalBuilder – Atozed Software
• BuildIt - Microsoft
• Visual Build Professional – Kinook Software

Testing

• NUnit
• NUnitAddin
• NUnitAsp
• csUnit
• .NET Mock
• X-Unity – MIIK Ltd.
• HarnessIt – United Binary
• SilkPerformer .NET Explorer – Segue
• Test.NET – Parasoft

Code validation – Standard verifiers

• FxCop – Microsoft
• DotEASY

Profiling – Monitoring – Performance Testing – Optimization

• nprof
• Application Center Test – Microsoft (part of Visual Studio .NET Enterprise editions)
• DevPartner Profiler – Compuware Corporation
• DevPartner Studio – Compuware Corporation
• AQtime .NET – AutomatedQA
• Rational Quantify for Windows – IBM
• .NET Memory Profiler – SciTech Software AB
• Allocation Profiler (source) - Microsoft
• ANTS Profiler – Red Gate Software
• ANTS Load – Red Gate Software
• ASPNETWatchDog – ASPNETWatchDog
• Optimizeit Profiler – Borland
• VTune Performance Analyzer – Intel

Documentation – Code commenting

• NDoc
• Documentor for .NET – Lutz Roeder
• Visual Studio .NET Help Integration Kit – Microsoft
• VB.DOC
• VB.NET XML Comments Creator – Fesersoft
• VB.NET XML Commentor – Tor-Erik Hagen
• TeeGofer – Steema Software
• CodeReview – Macadamian Technologies

Frameworks

• Mere Mortals .NET Framework – Oak Leaf Enterprises Solution Design
• Odyseus – Radical Technologies

MVC

• Maverick.NET

AOP

• AspectC#
• Weave.NET

Code versioning – Source control

• Visual SourceSafe – Microsoft (part of Visual Studio .NET Enterprise editions)
• SourceGear Vault – SourceGear
• SourceOffsite – SourceGear
• SourceOffsite Collaborative Edition – SourceGear
• Jalindi Igloo
• Ankh
• AccuRev

Localization

• Enterprise Localization Toolkit – Microsoft

Reporting

• ActiveReports – Data Dynamics
• Crystal Reports – Crystal Decisions
• Report Sharp-Shooter – 9rays.Net

Page templating

• Page Template Generator – Paul Wilson
• Xheo.WebTemplate – Xheo
• Xheo.WebSkin – Xheo

Scripting

• Alintex Script Host - Alintex
• DOTNET Scripting Host – Holger Schwichtenberg
• Toolsack DotNet Script Host – Toolsack Software

Installation

• InstallShield – InstallShield
• Wise for Visual Studio .NET - Wise Solutions

Others

• Page ViewState Parser – Paul Wilson
• FormBuilder.NET – Dan Wahlin
• RegexDesigner.NET – Chris Sells
• QuickCode.NET – Development Expertise
• Cassini Web Server – Microsoft
• Web.Config Editor – HunterStone
• Xheo.Licensing – Xheo

Hosted by FreeWebs

Reflector.FileDisassembler This add-in can be used to dump the disassembler output to files for any Reflector supported language. Website Download

Reflector.DelphiLanguage The Delphi view that is used inside .NET Reflector provided as a language add-in. Website Download

Reflector.McppLanguage This add-in extends Reflector with a Managed C++ language rendering module. Website Download

Reflector.ChromeLanguage This add-in extends Reflector with a Chrome language rendering module. Website Download

Reflector.Diff This add-in shows differences between two versions of the same assembly. Website Download

Reflector.VisualStudio This program is hosting .NET Reflector inside the Visual Studio 2003 IDE. Run Reflector.VisualStudio.exe to register the add-in with Visual Studio. Website Download

Reflector.ClassView Shows class definitions as plain text with color coding. The menu item is registered under the "Tools" menu. Website Download

Reflector.CodeModelView This add-in shows the underlying code model objects for a selected node in .NET Reflector. The menu item is registered under the "Tools" menu. Website Download

Reflector.FileGenerator This add-in can be used to dump the disassembler output to files for any Reflector supported language. Download

Reflector.Graph This add-in draws assembly dependency graphs and IL graphs. It also supports method ranking and type ranking. Website

Reflector.OpenRunningAssembly Opens an assembly or dependency from a process running on the system. The menu item is registered under the "Tools" menu. Website Download

Reflector.MbUnit This add-in allows loading and executing MbUnit unit test fixtures in Reflector. The source code is provided online. Website

http://www.codegeneration.net/tiki-index.php?page=NET

Code Region#region Code Region
public class Code // Code Class
…{
    private string source; // source variable

    public Code(string Source) …{
        source = Source; // Source constructor
    }
       
    public string Source …{ // Source property
        get …{ return source; }
        set ( source = value; }
    }
}
#endregion 

http://www.actiprosoftware.com/Products/DotNet/CodeHighlighter/PasteCode.aspx

http://www.wilsondotnet.com/Demos/CodeView.aspx

现在.NET的程序越来越多了，很多人开始关注如何破解.NET的程序。其实个人感觉，.NET程序的破解比传统的容易多了。只要没有被加密，一般的写过程序的人，都可以按照本文的步骤，破解.NET程序。

首先，要准备几样东西：
1，ILDasm，.NET的反汇编工具，.NET Framework SDK自带的，用于程序的反汇编；
2，MSIL的参考书，比如Inside Microsoft IL之类，主要是在对IL不太熟练的情况下，用来查指令码。
3，Anakrino，.NET的反编译工具，可以把.NET的Assembly反编译成c#或者c++的代码。用于分析程序流程。下载地址： http://test.saurik.net/anakrino/
4，UltraEdit，二进制编辑器，用于搜索、修改.NET可执行程序。

这次我们的目标是一个c#代码生成器，在这里下载： http://www.gavinjoyce.com/nTierGen/default.aspx 。安装了试用版之后，在 c:\program files\www.gavinjoyce.com\.net n-tier framework generator evaluation 1.2 里面找到 nTierGen.eval.1.2.exe 和 Microsoft.ApplicationBlocks.Data.DLL。后一个dll好像跟破解没有太大关系。OK，Let’’s go!

第一步：分析定位代码。用Anakrino打开 nTierGen.eval.1.2.exe。在Atweb.CodeGet.Wizard名字空间下，有一个frmWizard。这就是程序的主窗口了。在主窗口里面，有一个事件响应方法叫做 btnNext_Click，在里面找到了这样的代码：
if (this.panel2.Visible) {
local2 = Helper.IsCaseStudy(this.proj.dbTree);
if (this.chkListTables.CheckedItems.Count > this.MAX_TABLES && !(local2))
MessageBox.Show("This evaluation release is restricted to " + this.MAX_TABLES.ToString() + " tables. Extra tables have been removed.");
local3 = new TableCollection();
local4 = 0;
while (local4 < this.chkListTables.Items.Count) {
local5 = (String) this.chkListTables.Items.get_Item(local4);
if (this.chkListTables.GetItemChecked(local4) && local3.Count < this.MAX_TABLES || local2)
local3.Add(this.proj.dbTree.Tables.Item(local5));
this.proj.dbTree.Tables.Remove(this.proj.dbTree.Tables.Item(local5).ToString());
local4++;
}
this.proj.dbTree.Tables = local3;
this.Panel2Init();
this.HidePanels();
this.panel3.Visible = true;
this.RefreshViewList();
return;
}

可以看出，当用户选定了表之后，按Next按钮，他就检查选择的数量。如果>this.MAX_TABLES，就Show出一个MessageBox，接下来就只选择前this.MAX_TABLES个表。OK，目标就在这里了。

第二步：制定策略。显然，这个MAX_TABLES是程序里面的一个常量，用于限制表的个数。我们只要把这个常量改得大一些，不就行了吗？好，试试看。

.class /*0200003F*/ public auto ansi beforefieldinit ”frmWizard”
extends [”System.Windows.Forms”/* 23000002 */>”System.Windows.Forms”.”Form”/* 01000004 */
{
.field /*04000098*/ private int32 ”MAX_TABLES”
.field /*04000099*/ private bool ”ENCRYPT_TREE”
.field /*0400009A*/ private string ”LICENSED_TO”
.field /*0400009B*/ private string ”LICENSED_TO_COMPANY”
…..


instance void .ctor() cil managed
// SIG: 20 00 01
{
// Method begins at RVA 0xb0b8
// Code size 218 (0xda)
.maxstack 5
.locals /*11000049*/ init (string[> V_0)
IL_0000: /* 02 | */ ldarg.0
IL_0001: /* 19 | */ ldc.i4.3
IL_0002: /* 7D | (04)000098 */ stfld int32 ”Atweb.CodeGen.Wizard”.”frmWizard”/* 0200003F */::”MAX_TABLES” /* 04000098 */

在frmWizard的构造函数里面，IL_0001这个地方，ldc.i4.3，让MAX_TABLES=3。再看看IL的指令：
ldc.i4 <int32> (0×20) Load <int32> on the stack.
ldc.i4.s <int8> (0×1F) Load <int8> on the stack.
ldc.i4.m1 (ldc.i4.M1) (0×15) Load -1 on the stack.
ldc.i4.0 (0×16) Load 0.
ldc.i4.1 (0×17) Load 1.
ldc.i4.2 (0×18) Load 2.
ldc.i4.3 (0×19) Load 3.
ldc.i4.4 (0×1A) Load 4.
ldc.i4.5 (0×1B) Load 5.
ldc.i4.6 (0×1C) Load 6.
ldc.i4.7 (0×1D) Load 7.
ldc.i4.8 (0×1E) Load 8. (I should have listed these in reverse order so then we could imagine ourselves on Cape Canaveral.)
ldc.i8 <int64> (0×21) Load <int64> on the stack.
ldc.r4 <float32> (0×22) Load <float32> (single-precision) on the stack.
ldc.r8 <float64> (0×23) Load <float64> (double-precision) on the stack. ILAsm permits the use of integer parameters in both the ldc.r4 and ldc.r8 instructions; in such cases, the integers are interpreted as binary images of the floating-point numbers.


可以看出，IL只用了一个byte来给MAX_TABLE赋值，跟我们以往的x86 ASM有所不同。把ldc.i4.3改成ldc.i4.8，也就是把0×19改称0×1E，看看效果如何。用UltraEdit搜索出02 19 7D 98 00 00 04，然后把19改成1E，保存，运行，程序显示“最大8个表”等等，看来就着一个地方了。
从IL指令来看，一个byte最大赋值8，显然8个表还是太少了。怎么办？


IL_0197: /* 09 | */ ldloc.3
IL_0198: /* 6F | (0A)000017 */ callvirt instance int32 [”mscorlib”/* 23000001 */>”System.Collections”.”CollectionBase”/* 01000002 */::”get_Count”() /* 0A000017 */
IL_019d: /* 02 | */ ldarg.0
IL_019e: /* 7B | (04)000098 */ ldfld int32 ”Atweb.CodeGen.Wizard”.”frmWizard”/* 0200003F */::”MAX_TABLES” /* 04000098 */
IL_01a3: /* 32 | 03 */ blt.s IL_01a8

IL_01a5: /* 08 | */ ldloc.2
IL_01a6: /* 2C | 1D */ brfalse.s IL_01c5

IL_01a8: /* 09 | */ ldloc.3
IL_01a9: /* 02 | */ ldarg.0


在IL_01a3这个地方，比较MAX_TABLE，如果小于则跳转。OK，如果我们在赋值的时候，给一个-1，然后把有符号数的比较改成无符号数的比较，不就可以支持最多256个表了吗？OK!

第五步：最后的修改。搜索出上次02 19 7D 98 00 00 04的地方，把19改成15，也就是变成ldc.i4.m1；再搜索出7B 98 00 00 04 32这个地方，把blt.s改成blt.un.s，也就是把32改成37，保存，运行，程序显示支持"-1"个表，实际上支持256个表，。。。。

最后总结：.NET程序修改过程中，很容易出执行引擎的错误，所以修改的地方越少越好。当然，熟练之后可以想怎么改就怎么改了。另外，熟悉c#语言，熟悉IL也非常有帮助。怎么样，想不想马上试试看？