twit88.com

For the SQL “select … from table where value in (v1, v2)”, in SubSonic you need to use the SqlQuery statement 1: // numbers is a List<string> 2: SqlQuery query = new Select().From("Pick44D").Where(Pick44DTable.MatchedNoColumn).In(numbers).OrderDesc(new string[] { "DrawDate" }); 3: List<Pick44D> result = query.ExecuteTypedList<Pick44D>(); To add the BETWEEN clause 1: // SqlDateFormat = yyyy-MM-dd 2: SqlQuery query [...]

int maps to Int32 integer maps to Int64 bit maps to boolean guid maps to Guid long maps to Int64 For the complete listing, please see below code snippet from SubSonic 1: switch(sqlType) 2: { 3: case "varchar": 4: return DbType.AnsiString; 5: 6: case "nvarchar": 7: return DbType.String; 8: 9: case "int": 10: return DbType.Int32; [...]

To do a select distinct from a column for a database table using SubSonic, it is very straightforward Below is the code to get the unique customer number from the Customer table, and order them in descending order 1: Customer.All().Select(c => c.CustomerNo).Distinct().OrderByDescending(c => c) .

When developing a user control in .NET, if certain codes are not meant to be run in design mode, then you should check for it and avoid executing those code 1: /// <summary> 2: /// Handles the Load event of the MenuPanel control. 3: /// </summary> 4: /// <param name="sender">The source of the event.</param> 5: [...]

ObjectListView is a C# wrapper around a .NET ListView. It makes the ListView much easier to use and provides some neat extra functionality. Automatically transforms a list of model objects into a fully functional ListView, including automatically sorting and grouping rows. Supports owner drawing, including rendering animated graphics and images stored in a database. Easily [...]

To easily detect control text or value changes in a Form, you can use reflection and attach the event handler to the TextChanged or ValueChanged event 1: /// <summary> 2: /// Sets the form state change handlers. 3: /// </summary> 4: /// <param name="parent">The parent.</param> 5: private void SetFormStateChangeHandlers(Control parent) 6: { 7: isFormChanged = [...]

NLog is a free logging platform for .NET with rich log routing and management capabilities. It makes it easy to produce and manage high-quality logs for your application regardless of its size or complexity. NLog is open source software, distributed under the terms of BSD license and source is available on GitHub. NLog can process [...]

WebMatrix is everything you need to build Web sites using Windows. It includes IIS Developer Express (a development Web server), ASP.NET (a Web framework), and SQL Server Compact (an embedded database). It streamlines Web site development and makes it easy to start Web sites from popular open-source apps. The skills and code you develop with [...]

“Hilo” is a series of articles and sample applications that demonstrate how you can leverage the power of Windows 7, Visual Studio 2010 and Visual C++ to build high performance, responsive rich client applications. Hilo provides both source code and guidance that will help you design and develop compelling, touch-enabled Windows applications of your own.

Quartz.NET is a port of very propular open source Java job scheduling framework, Quartz . This project owes very much to original Java project, it’s father James House and the project contributors. Quartz.NET is a pure .NET library written in C# which currently targets Framework version 1.1 and above. Quartz.NET is feature-wise equal to Quartz [...]

Softerra™ SPML2 Library is an open source library written in C# for creating SPML enabled applications using Microsoft’s .Net development framework. It supports the Service Provisioning Markup Language (SPML) version 2.0 specification based on DSML v2 Profile. However, it is flexible enough to be extended for using with any custom capabilities and profiles.

DotNetZip is an easy-to-use, FAST, FREE class library and toolset for manipulating zip files or folders. Zip and Unzip is easy: with DotNetZip, .NET applications written in VB, C# – any .NET language – can easily create, read, extract, or update zip files. For Mono or MS .NET. DotNetZip works on PCs with the full [...]

One of the things that I got when I migrated my C# application from 32 bits machine to 64 bits machine is the driver problem. 1: The ‘OraOLEDB.Oracle’ provider is not registered on the local machine The reason that you could have this problem Your application is running as a 64-bit application and the 64-bit [...]

This codeplex project is the revival of good old .NET Webservice Studio tool. Its objective is to adds the support for WCF, Nullable Types and REST style API to allow a complete composite type testing from one tool. Web Service Studio is a tool to invoke webmethods interactively. The user can provide a WSDL endpoint. [...]

#ziplib (SharpZipLib, formerly NZipLib) is a Zip, GZip, Tar and BZip2 library written entirely in C# for the .NET platform. It is implemented as an assembly (installable in the GAC), and thus can easily be incorporated into other projects (in any .NET language). The creator of #ziplib put it this way: "I’ve ported the zip [...]

EasyHook supports extending (hooking) unmanaged code (APIs) with pure managed ones, from within a fully managed environment like C# using Windows 2000 SP4 and later, including Windows XP x64, Windows Vista x64 and Windows Server 2008 x64. Also 32- and 64-bit kernel mode hooking is supported as well as an unmanaged user-mode API which allows [...]

oSpy is a tool which aids in reverse-engineering software running on the Windows platform. With the amount of proprietary systems that exist today (synchronization protocols, instant messaging, etc.), the amount of work required to keep up when developing interoperable solutions will quickly become a big burden when limited to traditional techniques. However, when the sniffing [...]

Now you can send and receive both SMS and MMS starting release 1.1. MMS can be sent using the built-in MMS slide feature, or you can build the MMS message yourself. You can also save the MMS file to be sent out later. The software is available at http://twit88.com/platform/projects/show/messagingtoolkit

Microsoft Solver Foundation is an extensible framework that helps you model and solve complex problems by: Modeling and solving scenarios by using constraints, goals, and data. Programming in the Optimization Modeling Language (OML), in C# imperatively, in F# functionally, or in any .NET Framework language. Integrating third-party solvers, such as Gurobi, Mosek™, FICO™ Xpress, LINDO, [...]

ELMAH (Error Logging Modules and Handlers) is an application-wide error logging facility that is completely pluggable. It can be dynamically added to a running ASP.NET web application, or even all ASP.NET web applications on a machine, without any need for re-compilation or re-deployment. Once ELMAH has been dropped into a running web application and configured [...]