Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy. Here's an Excel automation scenario that reflects solutions that I've seen requested by multiple clients.
The LightSwitch RAD platform generates apps with "no coding required." What's in it for you? .NET apps that are easier to maintain and extensions built on the Managed Extensibility Framework.
In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.
There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, doing so may not be as easy as it seems.
WebMatrix is an exciting new tool for creating ASP.NET Web applications. Unfortunately, Visual Basic developers face an additional challenge because Microsoft only surfaces C# templates. Here's how to get access to the VB templates.
On VB columnist Joe Kunk says coding errors can lead to trouble, but the vast majority of big mistakes are due to poor or misguided project management.
Tips on Windows Phone 7 development and app design with sample code for a Windows Phone Pivot application.
When "Oops!" becomes "OMG!" On VB columnist Joe Kunk shows how a simple oversight when using SQL Server 2000 Data Transformation Services (DTS) nearly ended in disaster.
On VB columnist Joe Kunk explores the new BigInteger structure in .NET 4 and how it lets you work with astronomically large numbers.
On VB columnist Joe Kunk explores the benefits and drawbacks of commenting source code, and finds that the answer is not as clear cut as many might think.
Visual Basic .NET possesses naturally expressive syntax that is almost always clear in its intent. Even so, there are still surprises in Visual Basic that can trip up even experienced VB developers.
Find out how to use memory-mapped files to index and search the contents of document collections.
The Enum or enumeration is one of the fundamental constructs in the .NET Framework, serving as an easy-to-remember set of names for a series of fixed values that are logically related. It turns out that there is a surprising amount to know about the Enum construct.
Simplify the task of validating Web form input by using attributes. If standard validators don't meet your needs, you can create custom data annotations for richer validations.
- By Joe Kunk, Vijay Jagdale
On VB author Joe Kunk shows how you can quickly discover the orientation of an unknown database using dynamic queries.