KnowDotNet NetRefactor

William Ryan

Bill is currently a software developer in Atlanta, GA and helps run .  Bill is very active in the mobile computing world, helping out at OpennetCF and many other Compact Framework Forums.  He was recently awarded Microsoft's
MVP award.   When he has time, he also writes book reviews like this one on Slashdot.

Prior to his current position, Bill has worked extensively in mutliple business sectors including securities, manufacturing, pharmaceuticals and public utilities.  For most of his career Bill worked in advanced data warehousing/OLAP and Reporting.  Although he hasn't had a chance to play around with multi-million record Stars and Snowflakes for a while, he oversees a pretty large scale Sql Server 2000 database in his current capacity.

In addition to the Compact Framework and Database theory, Bill spends a lot of time with his other favorites, ADO.NET, VB.NET and C#.  Learning new and cool technologies like Infragistics and Deklarit occupies the rest of his time these days.  Bill has also been asked to sit on Macromedia's Flash Advisory Board and help them with their ASP.NET/Flash integration initiative.

Articles by William Ryan

Searching through your Sql Statements -
Making Updates Safely -
A Day with NJDX -
Book Review - Building Intelligent .NET Applications by Sara Morgan Rea -
Understanding Types, Data and a lot more -
Multi Language Support in ASP.NET 2.0 -
Making life easier in ASP.NET -
All roads lead back to Rowstate -
Linked List in the 2.0 Framework -
Data Access Patterns [Retryer] -
BackgroundWorker Class in the 2.0 Framework -
Book Review: Visual Studio .NET Tips and Tricks -
Advanced Cofiguration Section Manipulation - Part II -
Editing your Class Templates in Visual Studio .NET -
Overloaded Constructors in C# -
Book Review: Pro ADO.NET with VB.NET 1.1 -
Going Remote - Part I -
Book Review: Code Generation in Microsoft .NET - Kathleen Dollard -
Book Review: Enterprise Development with Visual Studio .NET, UML and MSF -
Book Review: Best Kept Secrets in .NET -
The Serialization Exception that's not what it appears to be... -
Adjusting for Culture -
Playing with the SqlCeResultSet -
A Hodge Podge of ADO.NET 2.0 -
A cool new feature of the DataAdapter in ADO.NET 2.0 -
Binary Serialization of a DataSet - ADO.NET 2.0 -
Using the SqlBulkInsert in ADO.NET 2.0 -
DataBinding in .NET - Another cool trick -
Getting feedback from your data objects -
Polymorphism Done Right -
Refactoring - Consolidate Duplicate Conditional Fragments -
Refactoring - Extract Class -
Dynamic SQL Needs to die -
Getting Ready to Refactor -
Walking through a DataView -
Efficiently Using ADO.NET - IV -
Harnessing SSCEDirect for fast SQLCE data loading -
Make a Searchable ComboBox with .NET -
Asynchronous Programming - Part II -
DataSet.Merge and Transferring Data -
Asynchronous Programming - Part I -
Microsoft Mobile Developer's Conference 2004 -
Efficient ADO - Part III -
Multiple Column Formats in Windows Forms DataGrid -
Building Better Properties - Part II -
Efficiently Using ADO.NET - Part II -
Building SQL Tables at Runtime -
Efficiently Using ADO.NET - Part I -
Book Review: Building Applications and Components with Visual Basic .NET -
Communicating with a Device from the Desktop -
Determining Network Connectivity -
Default Buttons on a Form -
.NET Security and Attributes -
Alex Yahkin's Animation Control in VB.NET -
Stored Procedures -
Dealing with Colors in VB.NET -
Your First PL/SQL Function -
Creating Packages with PL/SQL -
Taking advantage of the DataView's Rowfilter -
Comparing Objects in VB.NET -
VB.NET Control Characters -
Check Constraints in SQL Server 2000 -
ADO.NET- Supply Default Values for your Parameters -
IDataReader and the CommandBehavior Enumeration -
Getting Intimate with your Connection -
Send Email Message with SMTP -
ADO.NET Gotcha - Remember System.Data -
Writing to Event Logs -
Getting Schema Information from your Database -
Change Databases Without Closing Connection -
ADO.NET Gotcha - Why is my Query Blowing Up -
Book Review: Building Solutions with the Microsoft .NET Compact Framework -
Sort Your Data with the DataView -
Fun with VB.NET Arrays -
To Val or not to Val, That is the Question -
VB.NET Optional Paramaters -
A Little More To Reflect On -
Using your Environment -
Debugging Gotcha -
System.IO and Bit Flags -
Code Access Security and .NET -
Fun with the StreamWriter -
ADO.NET's DataRelation Object -
Take advantage of .NET's Built in Attributes -
Examining Special Folders -
ADO.NET Gotcha When Calling Stored Procedures -
DataBinding VB6 vs. VB.NET -
Convert Number of Seconds to 00:00:00 Format -
Building Better Properties -
Book Review: Microsoft ADO.NET Core Reference -
Temp Tables and Passing a Delimited Field as a Parameter -
Attributes and Declarative Programming -
Using Com Interop to do the "Impossible" -
Visiting Sysytem.Runtime.Interopservices.... -
Is Your Code Checked? -
Using .Config Files -
Use a Cursor to Reindex your tables -
Creating a DataSet with Code -
Keeping it Contiguous in SQL Server -
A Quick Look at Directory Services -
Query an Excel Worksheet Without using Interop -
Get an IP Name from its Numeric Address -
Kill all the Active Connections to Your Database -
Create a Gradient background on your Forms or Controls -
Count Occurences of a Token in a String -
Making a Form Transparent -
Watch How You Declare Those Parameters -
++ and -- in VB.NET - Why it aint so -
A Brief Intro to PL/SQL -
A Brief Introduction to the Process Class -
Enumerate a Directory in .NET -
Reference and Value Types -
Reflecting All of The Members of a Class -
A Few Shortcuts in .NET -
Call a Parameterized Stored Procedure in SQL Server 2000 -
Send a Message to Everyone Logged into a SQL Server -
Using Windows Temp Files -
Doing Transactions in C# and ADO.NET -
Understand Types in .NET -
Broadcast UDP Message -
The Validating Event -
Validating Text Controls withan ErrorProvider -
Getting to Know Indexers -
How to Create a Numeric Only TextBox Control -
ADO.NET DataViews -
A Quick Introduction to Boxing -
Doing Things the .NET Way -
Writing Add-Ins for Visual Studio .NET
Writing Add-ins for Visual Studio .NET
by Les Smith
Apress Publishing