ADO Connections over the Internet
Rating: Mike Korzeniowski - 01/27/2004 This short code shows how to establish an ADO connection over the Internet. (Added: 1-Mar-2000)
ADO.NET Exploring Cool Features of Devexpress' ASPxGridView
Rating: none Paul Kimmel - 01/06/2009 Devexpress has a commitment to providing amazing ASP.NET (and other controls), such as their latest revision of their ASPxGridView, version 8.3, which supports filtering, grouping, sorting, and much more, with little or no coding on your part.
LINQ to Entities Preview
Rating: none Paul Kimmel - 06/25/2008 ADO.NET 3.0 and the ADO.NET Entity Framework are designed to let you spend less time writing SQL and database plumbing code and more time working in the space of the problem you are trying to solve.
Implementing a Custom ConnectionString Installer for Setup
Rating: none Paul Kimmel - 10/10/2007 See how a setup project with a custom action lets the user define the connection string using the Data Links dialog and encrypt that connection string using RSA encryption.
An Oracle Query Tool, Part 1
Rating: dna2 - 03/09/2006 Learn about an Oracle query tool with Syntax Highlight and a tabbed MDI interface.
Using ADO.NET with XML and VB.NET
Rating: K Balaji - 12/19/2002 Learn about ADO.NET technology and how to connect to, query, and modify a database. Includes information on using XML with ADO.NET. (VB.NET)
DataGrid Bound Controls: Evil or Not?
Rating: dglienna - 12/28/2007 This is a fully functional sample that shows some advanced features that would be hard to do with bound controls.
Event Spy for MS Data Grid
Rating: Mark McGinty - 07/13/2004 A utility form that will show DataGrid events with parameters as they happen in realtime.
DataGrid Advanced Techniques
Rating: Mark McGinty - 07/13/2004 Demonstrates implementing "lookup" columns that let the user select a value from a list, boolean columns represented by checkboxes, context menus, and calculating parent-relative positions of controls inside containers.
One Just Needs to Know Where to Look
Rating: Paul Kimmel - 03/31/2004 The Data Form Wizard is a tool in VB6 that permits you to pick a table, and it generates a data-aware form and incorporates that form into your project.
The Big ASP.NET DataGrid Article, Part 3
Rating: Karl Moore - 03/03/2004 Implement the likes of paging and sorting into your DataGrids, but first, start off with the most gruesome of tasks: adding an editable drop-down box to your DataGrid!
The Big ASP.NET DataGrid Article, Part 2
Rating: Karl Moore - 02/26/2004 Look at using HTML, hyperlinks, and formatting in your DataGrid, plus figure out color-coding and the many different ways of allowing the user to select rows.
Nine Steps to a Quick, Editable Web Grid 02/18/2004 Setting up your own editable Windows DataGrid may be an absolute doddle, but creating the equivalent grid for the Web is a little more complicated.
DataSets Returning Multiple Tables into a DataSet 02/11/2004 Discover how to take advantage of one of the big new features of the DataSet over the old Recordset: Learn how to hold multiple tables of data at a single time.
Database Listing Available DSN / Drivers Installed
Rating: none John Pirkey - 01/27/2004 This code shows how to list the available DSN and Drivers installed on the computer. (Added: 9-Feb-2000)
A Practical Approach to Database Theory
Rating: none Jan Haugland - 01/27/2004 Like it or not, 90% of the work a Visual Basic developer does is likely to be database related. Learn to get comfortable with databases. (Added: 18-Oct-1998)
Creating a Master / Detail Form in VB
Rating: none Khalifa Ahmed Tarhoni - 01/27/2004 Learn to create a Master Detail style form (similar to those in Access) using standard Visual Basic. (Added: 24-Sep-2000)
Incorporating the Data Link Properties Editor into a VB.NET Application
Rating: none Paul Kimmel - 07/28/2003 If you want to learn a bit about COM Interop or how to incorporate the Data Link Properties applet seamlessly into your Visual Basic .NET application then this is a good article for you.
Database Access DataBinding a DropDownList in a FormView
Rating: none Paul Kimmel - 05/22/2009 Providing a drop down list in your ASP.NET Web applications help users avoid wasting time with bad data and it's a kinder, gentler thing to do.
Handling Database Writes in Data Access Layer Management
Rating: none Paul Kimmel - 01/22/2007 The write part of managing a data access layer is where things can go awry. Writing requires managing changes, validation, and transactions. Learn how to handle the challenge.
Managing SQL in Visual Studio .NET
Rating: none Paul Kimmel - 10/16/2003 You can generate perfect SQL even if you aren't a SQL programmer, and you never have to leave Visual Studio .NET for most of your day-to-day SQL tasks.
Microsoft Access [Updated] Fuzzy Matching Demo in Access
Rating: none DataClean - 01/30/2007 Dare to enter the world of approximate string matching with this introduction, tutorial, and Access 2000 database demo with a 99% precision/recall.
SQL Server Writing UDFs for Firebird Embedded SQL Server
Rating: none Apriorit Inc. - 11/17/2009 This article was written mainly for developers who use Firebird Embedded SQL Server in .Net framework applications and want to speed up or optimize DB queries.
We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications.
Converting Data to XML with LINQ to XML
Rating: none Paul Kimmel - 10/05/2009 Sometimes when you have all kinds of data what you really need is XML. LINQ to XML let's you employ functional construction to convert your data into XML.
Programming with LINQ to SQL
Rating: none Paul Kimmel - 03/07/2008 You can use LINQ to SQL to define an Object Relational Mapping between SQL tables and then query those tables with LINQ.
News: Don't Embed That Database!
Rating: Bradley Jones - 11/09/2006 Did you replace MSDE with SQL Server 2005 Express Edition? Did you make the wrong move?
[Updated] What to Know About Visual Studio 2005 — The Products
Rating: Bradley Jones - 11/11/2005 Visual Studio 2005 ("Whidbey") has released. Get a first look at answers to some up-front questions you might have. Start by simply understanding the multitude of editions that entail the Visual Studio 2005 product line. After all, how many different editions can one product have?
FREETEXT Searches with SQL Server and ADO.NET
Rating: none Paul Kimmel - 08/10/2005 Learn how to install, configure, and use the MS Search Engine with SQL Server. Once installed, MS Search permits you to perform fuzzy searches of small and large amounts of character-based data.
ADO.NET Generates SQL for You Via the SqlCommandBuilder
Rating: none Paul Kimmel - 11/30/2004 ADO.NET's SQL command builder reads a schema and generates SQL for you; this can be an excellent timesaver in the appropriate circumstances. When applied with sound judgment, this technique is a nice shortcut.
Calling Stored Procedures with ADO.NET
Rating: Paul Kimmel - 11/19/2004 If you're a Visual Basic .NET programmer who has to write stored procedures for MS SQL Server, this article is for you. Learn how to isolate SQL code from VB.NET code to clearly create divisions of labor and focus for your solution.
Database Build Wizard
Rating: none Clearcode - 09/24/2004 The database assembly build tool is a tool to allow a developer to select database schema items (tables, views, stored procedures, users, and so forth) and export the DDL to create these items to an SQL file.
Accessing The Registry From SQL Server
Rating: dinesh123 - 07/02/2004 Learn how to find the country list from a computer's registry. You see how to read and write to the directory from SQLServer.
Generate Complex Next Numbers with SQL Server
Rating: dinesh123 - 07/01/2004 Generating 'next numbers' numbers in SQLServer should not be a problem. But problema arise when a customer asks for different types of next numbers that you cannot generate directly from SQL Server. Learn how to tackle this problem in different scenarios.
Checking Whether SQL Server Is Available 02/13/2004 In building ASP.NET database applications, in addition verifying a connection to the Net, you also need to ensure that your database server is up and running.
Stored Procedures Rendering Images in ASP.NET Directly from Your Database
Rating: none Paul Kimmel - 08/01/2007 There's no need to store file system paths in a database. Just store images in your database and then directly load them to your ASP.NET pages.
Better Entities with Nullable Types
Rating: none Paul Kimmel - 04/25/2007 Tired of checking database entries for null values? This month, Paul illustrates how you can use Nullable types to make fields and properties accept nulls.
Programming with Stored Procedures in Visual Basic .NET (Part 1)
Rating: Paul Kimmel - 12/23/2002 Stored procedures are an excellent way to optimize complex business solutions for database applications. Learn how you can edit and run stored procedures in Visual Studio .NET and how to incorporate them into your Visual Basic .NET applications.
[Updated] XML Data Binding
Rating: Simon Sprott - 07/17/2007 XML Data Binding allows you to manipulate an XML document via a set of simple objects. Learn about the generation of these objects, and see a summary of the existing products on the market.
Using XML Schemas to Create Strongly Typed DataSets
Rating: Paul Kimmel - 08/26/2003 Learn the technical aspects of defining an XML schema, generating a typed DataSet, initializing, and using that typed DataSet within Visual Basic .NET.
All
