Categories
Forums
Premium Sponsor
Premium Sponsor
fullcontrol.net

Search


Advanced Search
Popular Articles
Popular Authors
Partners
 
SubMain - Developer Tools
 »  Home  »  Data Programming
Data Programming

ADO.NET (11)
Microsoft Access (7)
SQL Server (6)
XML (12)

» ADO.NET 3.5, LINQ, and the Entity Framework
by Larry Blake | Published 08/14/2009 |  | Rating:

Murach's ADO.NET 3.5, LINQ, and the Entity Framework by Anne Boehm, comes in both Visual Basic and C# 2008 versions.  Larry Blake reviews it.

[read article...]
» Business Mate: Using the Generic Database Class
by Charles Profitt | Published 02/10/2005 |  | Rating:

In the last segment I showed you how to make a generic database class which allows you to create a DataSet from any other part of your code. I also promised to eventually develop an application that would be useable. This is the next step in that process.

[read article...]
» Business Mate: Generic Database Class
by Charles Profitt | Published 02/08/2005 |  | Rating:
The first item I want to cover is the generic database class. Beginners books show you how to make a DataConnection, DataAdapter and DataSet using the IDE.   Although that does work, I find it a poor way to do things. I prefer to understand a little more and excercise a little more control. [read article...]
» The Hidden Power of the DataGrid Control - Part 1
by Dmytro Lapshyn | Published 01/13/2005 |  | Rating:

Data Grid is one of the most widely used types of controls among developers. Many kinds of data have a tabular nature and are best represented as a grid on a computer screen. The importance of providing users with really consistent and intuitive user interface can hardly be underestimated, and a well-tailored grid could play a primary role in many user interface concepts.

Windows Forms developers are lucky, as Microsoft has included a ready-made DataGrid control into both of the Windows Forms and Web Forms sub-systems of its .NET Framework. However, many developers who have used the Windows Forms DataGrid control might have had a feeling of it being somewhat rigid or even limited. In other words, while some customization can be achieved with several mouse clicks or keystrokes, and some others can be done with just a few lines of code, there are amendments which either require significant efforts or cannot be implemented at all. For example, there is no way to alter column header appearance other than taking over painting of the whole grid exterior.

Having bumped into several such limitations myself, and having spent long hours on searching the Internet and digging the MSDN Library, I have decided to share my DataGrid experience with the developer community in the hope of saving valuable time and even more valuable nerve cells for those who accept the DataGrid challenge in a quest for better user interface experience.

[read article...]
» My First Access Database Program. Part 2
by George Poth | Published 01/21/2004 |  | Rating:
Database applications are quite popular among programmers. At the beginning, however, it seems so awfully complicated. While I can't and don't want to answer all the questions you might have, here's something to get you started. [read article...]
» My First Access Database Program. Part 1
by George Poth | Published 01/20/2004 |  | Rating:
Database applications are quite popular among programmers. At the beginning, however, it seems so awfully complicated. While I can't and don't want to answer all the questions you might have, here's something to get you started. [read article...]
» Migrating Delimited Files into XML
by Tiberius OsBurn | Published 05/05/2002 |  | Rating:
Tab delimited and Comma delimited files once were the standard in representing data outside of a relational database. With the inception of XML, developers can now represent their data in a much richer and more descriptive environment without the overhead or cost of relational databases. Converting legacy delimited files into an XML format allows developers to take advantage of many of the new technologies that have been created around XML. This article will demonstrate the conversion of a delimited file into a DataSet or an XML file. [read article...]
» Working with MS Access Stored Procedures in VB.NET. Part 2
by David Wasserman | Published 04/18/2002 |  | Rating:
Part two demonstrates how to utilize the MS Access stored procedures by assembling a Database Tier that can be modelled and used in your own applications. This article will describe in detail one implementation of a Database Tier for Visual Basic.NET. [read article...]
» Encapsulation in the Databases World
by John Bailo | Published 03/01/2002 |  | Rating:
How is the object oriented principle of encapsulation really carried out in real code? Are middleware objects the right place for encapsulation? How does the growth of web databases embody or refute encapsulation and can encapsulation save us from homgeneous data models? Can we design truly heterogeneous data models different from uniform data record structures and using encapsulation? These are the matters covered in the article. [read article...]
» Working with MS Access Stored Procedures in VB.NET. Part 1
by David Wasserman | Published 02/27/2002 |  | Rating:
One of the new features of the MS Jet 4.0 engine is to allow the creation and execution of stored procedures in MS Access database. This feature is often brushed over quickly in even the greatest of books about MS Access. Using stored procedures for both MS Access ans SQL Server, will greatly cut down on development time of the database tier, along with other benefits. Part one describes in detail how to create stored procedures in Access using ADO.NET and Visual Basic.NET. [read article...]