|
|||
|
Data AccessThis section contains articles covering ADO.NET, SQL Server, MSDE, Access and other data access methods and technologies.
How To Use a LIKE in a Stored Procedure - 1/11/2010 How do I code the Stored Procedure and the parameter to it to use the LIKE operator? more... Get Data From DataGridView SelectedRows - 12/31/2008 How do I get a collection of selected rows in a DataGridView? Sometimes the simpliest things can appear to be complex and consume an inordinate amount of time to figure out. more... Searching through your Sql Statements - 2/1/2007 If you use Sql Server 2000 or Sql Server 2005, chances are that you will want/need to be able to search through your stored procedures and find instances of some text. So if you are using Visual Studio 2005 Team Edition for Database Professionals (the subject of my next upcoming article series) then life is grand b/c it provides a tremendous amount of find/replace and refactoring capabilities. If you aren't using Team Edition though, you're choices are a little less abundant. more... Making Updates Safely - 12/5/2006 This trick is certainly nothing new but it's immensely helpful in many cases. Have you ever forgot to highlight a WHERE clause when you were making an Update and accidentally (or almost accidentally) updated a whole bunch of data that you didn't intend to? Well I have, more times than I can count. more... Must Implement IConvertible With Microsoft Data Application Block - 8/22/2006 What causes "Must Implement IConvertible With Microsoft Data Application Block" error? more... Find Duplicate Records in SQL - 5/16/2006 How can I find duplicate records on a field in a database table? This works in SQL Server, Oracle, or Access. more... Converting Access SQL to Oracle - 3/27/2006 Numerous differences are found between Access and Oracle SQL. This article will describe many of them. more... Getdate() In SQL Server - 3/23/2006 Be careful when using getdate() in SQL Server as a Start or End date for a sql statement or Stored Procedure. more... A Day with NJDX - 11/30/2005 I've been on the O/R Mapper bandwagon for a while and just came across NJDX from Software Tree. I think that Deklarit and LLBLGenPro are two of the finest on the market, but I have to admit that I've also taken a liking to NJDX quite a bit. more... Stored Procedures, Enums, Microsoft Data Access Application Block - 6/17/2005 How can I do Data Access right, and how do I Refactor my Data Access Code if I didn't do it right to begin with? more...
Getting The Age of an Person in SQL Server Query Using UDF - 4/8/2006 Need to determine the age of a person in a SQL Server Query? DateDiff will not work! Build a UDF that works. more... Search Stored Procedures with SQL in SQL Server - 3/27/2006 Ever need to find all stored procedures that have certain text in them? Ever need to find all stored procedures that have a specified text in the procedure name? This article will give you the SQL statements for doing just that. more... Search Stored Procedures with SQL in SQL Server - 3/27/2006 Ever need to find all stored procedures that have certain text in them? Ever need to find all stored procedures that have a specified text in the procedure name? This article will give you the SQL statements for doing just that. more... Multiple Column Formats in Windows Forms DataGrid - 3/12/2004 KDNGrid Class enhances the Windows Forms Datagrid with CheckBox, ComboBox, NumericUpDown, DateTimePicker, and MultiLine TextBox columns. more... Sort Your Data with the DataView - 12/25/2003 It's no secret that I think ADO.NET is one of the coolest things about the .NET framework. And the more I play with it, the more I love it. One of my favorite objects is the DataView becuase it allows you to do some really cool things with little or no effort. more... Formatting DataGrid Columns with the CGrid Class - 10/30/2003 Have you ever needed to format the columns of a Windows Form Datagrid in .NET, or create one or more CheckBox columns. Do you need to add rows to an existing DataTable. All of this functionality and more exists in the Class developed for this article. more... Reusability of Data Access Code in ADO.NET Applications - 10/30/2003 Reusability is the key to rapid application development in Visual Studio .NET, especially when it relates to data access via ADO.NET. This article discusses the use of a data access class that I wrote many months ago and use daily in every application I develop. more... |
|
 |
|
|