Title	Keywords
Tip: Database Programming With MSDE	database programming, ADO, MSDE, Access, SQL Server

Joins

Title	Keywords
HowTo: Use DAO to make a database lookup table	DAO, database, lookup, table
HowTo: Join two tables in different databases	ADO, ADOX, join, databases

ADO

Title	Keywords
HowTo: Use combo boxes and text boxes to let the user pick search criteria for a database query in Visual Basic 6	database, DataGridView, DataTable, DataAdapter, OleDbDataAdapter, data adapter, bind, DataSet, Visual Basic 6, VB 6
Tip: Use ADOX to make a database without leaving the database files locked	Visual Basic, Visual Basic .NET, ADO, ADOX, create database, make database, file locking, .ldb file
HowTo: Use ADOX to search the table columns in an Access database for a string in Visual Basic .NET	ADOX, Access, database, table, column, table columns, search columns, VB.NET
HowTo: Use ADOX to search the table columns in an Access database for a string in Visual Basic 6	ADOX, Access, database, table, column, table columns, search columns, Visual Basic 6
HowTo: Use ADOX to list the tables in an Access database and give their types in Visual Basic .NET	ADOX, Access, database, table, table type, VB.NET
HowTo: Use ADOX to list the queries in an Access database and give their command text in Visual Basic .NET	ADOX, Access, database, query, command text, VB.NET
HowTo: Use ADOX to search the queries in an Access database for a string in Visual Basic .NET	ADOX, Access, database, query, command text, search query, VB.NET
HowTo: Use ADOX to list the queries in an Access database and give their command text in Visual Basic 6	ADOX, Access, database, query, command text, Visual Basic 6
HowTo: Use ADOX to search the queries in an Access database for a string in Visual Basic 6	ADOX, Access, database, query, command text, search query, Visual Basic 6
HowTo: Use ADOX to list the tables in an Access database and give their types in Visual Basic 6	ADOX, Access, database, table, table type, Visual Basic 6
HowTo: Use an ALTER TABLE statement to change a column's data type in an Access database in Visual Basic 6	ALTER TABLE, database, ADO, Access, Visual Basic 6
HowTo: Use ADO to insert records into a database when fields contain quotes	ADO, database, insert, quotes
HowTo: Use a INSERT INTO statement in ADO to copy data from one table into two existing tables	ADO, data, database, INSERT, INSERT INTO, copy data
HowTo: Use a SELECT INTO statement in ADO to copy data from one table into two new tables	ADO, data, database, SELECT, SELECT INTO, copy data
HowTo: Use ADOX to get and set the description of a column in an Access database	ADOX, ADO, column description, Access
HowTo: Use ADO to add and drop columns from a database	database, data, ADO
HowTo: Use ADOX to add and drop columns from a database	database, data, ADO, ADOX
HowTo: Make a class that manages arrays retrieved by calling Recordset.GetRows	Recordset, GetRows, array
HowTo: Connect an ADO Recordset to an XML file located at a URL	ADO, Recordset, XML, URL, Web, data, Access
HowTo: Save an ADO Recordset's data into an XML file	ADO, Recordset, XML, URL, Web, data, Access
HowTo: Use ADOX to get lots of information about an Access database	ADOX, information, database, Access
HowTo: Create and invoke a stored procedure in an Access database	stored procedure, Access, database,
HowTo: Count the records in a Recordset two ways and compare their speeds	records, count records, ADO
HowTo: Determine how many records were inserted by an INSERT ... SELECT statement	ADO, data, database, Access, INSERT, INSERT SELECT, SELECT, records, INSERT INTO ... SELECT
HowTo: Let the user search a recordset using a ComboBox	ComboBox, database, ADO, Recordset, search
HowTo: Load and sort a CSV file by using ADO	CSV, sort, ADO, database, data
HowTo: Open a password-protected Access database with ADO	ADO, database, data, password, Access
HowTo: Copy data from an Access database into an Excel spreadsheet	ADO, Access, Excel, database
HowTo: Validate a user name/password in a database	password, cryptography, database
HowTo: Display data from a database in a ListView control	ListView, database, ADO
HowTo: Load internationalization data from a resource file with a single string table	database, internationalization, language, resource file
HowTo: Load internationalization data from a resource file with multiple string tables	database, internationalization, language, resource file
HowTo: Load internationalization strings from a database	database, internationalization, language
HowTo: Use a database to build Web pages using different templates	database, ADO, Web, HTML, template
HowTo: Copy data from an Access database into an Excel spreadsheet using a SQL SELECT statement	ADO, Access, Excel, database
HowTo: Make an HTML page showing an Access database's structure	ADO, database, structure, schema, OpenSchema
HowTo: Connect a DataReport to an ADO Recordset	DataReport, ADO, Recordset
HowTo: Use ADOX to create a database	database, ADOX, create database
HowTo: Execute an ad hoc query using ADO and display the results in a grid	database, ado, query, SQL, ad hoc query
HowTo: Let the user specify fields to select from a database using ADO	database, ado, query, SQL, ad hoc query, connectionless
HowTo: Bind controls to an Access 2000 database using the ADO Data Control (ADODC)	bound control, database, data, ADO, ADODC
HowTo: Use a Recordset to copy data from an Access database into an Excel workbook	ADO, Access, Excel, database
HowTo: Copy data from an Excel spreadsheet into an Access database	ADO, Access, Excel, database
HowTo: Load ComboBox and ListBox controls from a database using ADO	ComboBox, ListBox, load, initialize, ADO, database, data
HowTo: Import SQL Server data into an Access database	ADO, import, SQL Server
HowTo: Execute ad hoc SQL scripts with ADO	build database, DB, ADO, SQL, ad hoc, query, script
HowTo: Use a database to build a Web page	database, ADO, Web, HTML
HowTo: Build an Access database and a table with records using ADOX	build database, DB, ADO, ADOX, make table, Access
HowTo: Join tables in two different databases using an ADO join	ADO, join, two databases, multiple databases
HowTo: Make a class that manages arrays retrieved by calling Recordset.GetRows	Recordset, GetRows, array
HowTo: Use ADO to page through records 10 at a time	ADO, CREATE TABLE, database, page
HowTo: Use ADO to create a database table	ADO, CREATE TABLE, database
HowTo: Use ADO to display SQL Server tables and records in a TreeView control	ADO, SQL Server, database
HowTo: Use ADO to list database tables and their records in a TreeView	ADO, database, tables, records, TreeView
HowTo: Bind TextBoxes to an ADO Recordset at run time	ADO, database, bind, data binding
HowTo: Use ADO to list the tables and fields in a database	ADO, database, tables, fields
HowTo: Use ADO to make a database table with default column values	ADO, database, create table, default column value
HowTo: Use ADO to load data into a FlexGrid control	ADO, database, FlexGrid
HowTo: Use ADO's GetRows method to quickly load data into an array	ADO, database, load array, fill array, GetRows
HowTo: Use ADO to populate a ListBox with data values	ADO, database, ListBox, populate, fill
HowTo: Use ADO to get data from a read-only Access database	ADO, Access, database, connect, read-only
HowTo: Use ADO to insert records into a database	ADO, database, insert
HowTo: Open an Oracle database using ADO	ADO, Oracle, database, connect
HowTo: Use ADO to display database tables and records in a TreeView control	ADO, TreeView, database
HowTo: Use ADO to convert between various database formats	ADO, database, Jet, Access, dBase, Paradox, Excel, text files, HTML
HowTo: Use SQL to copy data from an Excel spreadsheet into an Access database	ADO, Access, Excel, database, SQL
HowTo: Loop through database records and modify them individually	database, ADO, update, records
HowTo: Load data from a database using ADO and display it in a tabbed list	database, ADO, tabs

ADO.NET

Title	Keywords
HowTo: Use combo boxes and text boxes to let the user pick search criteria for a database query in Visual Basic .NET	database, DataGridView, DataTable, DataAdapter, OleDbDataAdapter, data adapter, bind, DataSet, Visual Basic .NET, VB.NET
Visual Basic 2010 Programmer's Reference	Visual Basic 2010, Visual Studio 2010, programming
HowTo: Execute ad hoc database commands such as CREATE TABLE, INSERT INTO, DROP TABLE, and so forth in Visual Basic .NET	database, ADO.NET, OleDb, OLE DB, CREATE TABLE, INSERT INTO, DROP TABLE, execute database commands, connection, command, Visual Basic, VB.NET
HowTo: Make a DataGridView display numbered row headers in Visual Basic .NET	DataGridView, row headers, header, Visual Basic .NET, VB.NET
Visual Basic 2005 with .NET 3.0 Programmer's Reference	Visual Basic 2005, Visual Studio 2005, .NET Framework 3.0, programming
Visual Basic 2005 Programmer's Reference	Visual Basic 2005, Visual Studio 2005, programming
HowTo: Define a DataSet at design time in Visual Basic 2005	DataSet, design time, VB.NET, Visual Basic 2005
HowTo: Programmatically add a record to a DataSet bound to a DataGrid in Visual Basic 2005	DataSet, DataGrid, add record, Visual Basic 2005
HowTo: Programmatically add a record to a DataSet bound to a DataGridView in Visual Basic 2005	DataSet, DataGridView, add record, Visual Basic 2005
HowTo: Load a ListView control from a database in Visual Basic .NET	ListView, load ListView, database, ADO.NET, Access, VB.NET
HowTo: Select random records from a database table in Visual Basic .NET	database, random records, select records, VB.NET
HowTo: Color a column header in a DataGridView in Visual Basic 2005	color header, header, DataGridView, VB 2005, database
HowTo: Color a DataGridView control's cells dynamically as their data changes in Visual Basic 2005	color cell, dynamic, DataGridView, VB 2005, database
HowTo: Color specific cells in a DataGridView control in Visual Basic 2005	color cells, DataGridView, VB 2005, database
HowTo: Verify a username and password in a database in Visual Basic .NET	password, user name, user id, verify passwoord, database, ADO.NET, VB.NET
HowTo: Make a DataGridView control use a DataTable built at run time in Visual Basic 2005	DataGridView, DataTable, VB 2005
HowTo: Make a DataGridView control that has its own data source loaded at run time in Visual Basic 2005	DataGridView, DataTable, VB 2005
Visual Basic 2005 Programmer's Reference	Visual Basic 2005, Visual Studio 2005, programming
HowTo: Make a lookup cache using ADO.NET in Visual Basic .NET	ADO.NET, cache, lookup, lookup table, table
HowTo: Make a DataTable at run time without a database and bind it to a DataGrid in VB .NET
HowTo: Make a DataSet at run time without using any design time controls in VB .NET	DataSet, runtime, database, ADO.NET
HowTo: Update a DataSet that doesn't have primary keys in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database, primary key
HowTo: Bind a DataGrid to a DataTable at run time in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database
HowTo: Define a relationship between two tables in a DataSet in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database, relationship
HowTo: Display parent and child records in two DataGrid controls in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database, relationship, parent/child, master/detail
HowTo: Bind a DataGrid to a DataTable with read-only columns in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database, read only
HowTo: Bind a DataGrid to a DataSet at run time in VB .NET	ADO.NET, database, DataGrid, DataSet, bind
HowTo: Bind a CurrencyManager to objects in a collection and use it for navigation in VB .NET	CurrencyManager, binding, data binding, VB.NET, DataBinding
HowTo: Bind controls' properties to each other in VB .NET	binding, data binding, VB.NET, DataBinding, properties, property
HowTo: Display the data in a DataSet by using as DataGrid control in VB .NET	DataSet, DataGrid, VB.NET, data, database, ADO.NET
HowTo: Create records that have an AutoNumber field and find out what the newly created field value is in VB .NET	DataSet, VB.NET, data, database, ADO.NET, AutoNumber, Auto Number, AutoIncrement
HowTo: Create a foreign key constraint between two DataTables in VB .NET	DataSet, VB.NET, data, database, ADO.NET, foreign key, constraint
HowTo: Use ADO.NET to make an Excel report on an Access database's structure in VB.NET	Access, database, ADO.NET, Excel, index, relation, table, VB.NET
HowTo: Load a ListBox from a database query in VB .NET	database, VB.NET, ListBox, load
HowTo: Execute a parameterized query in VB .NET	database, VB.NET, parameter, parameterized query, query
HowTo: Use database transactions in VB .NET	transaction, database, VB.NET
HowTo: Bind a ComboBox to a database lookup table in VB .NET	database, ADO.NET, VB .NET, bound controls, data binding, ComboBox, lookup table
HowTo: Bind simple controls to a database in VB .NET	database, ADO.NET, VB .NET, bound controls, data binding
HowTo: Open a database in the project's main directory during development in VB .NET	database, ADO.NET, VB .NET
HowTo: Navigate a database with bound controls in VB .NET	navigate, database, bound control, VB.NET
HowTo: Use a DataGrid in VB.NET	VB.NET, NET, DataGrid, ADO.NET
HowTo: Get and set a single database value in VB .NET	VB .NET, database, update, get, set
HowTo: Create a unique constraint on data in VB.NET	VB.NET, NET, DataGrid, ADO.NET, unique, constraint
HowTo: Enhance the performance of the ExecuteReader method in ADO .NET	SQL Server, database, ExecuteReader, SqlCommand, OleDbCommand, ADO.NET
Visual Basic .NET Database Programming	ADO.NET, VB.NET, database programming
HowTo: Display read-only data from an Access database using ADO.NET	VB.NET, NET, DataGrid, ADO.NET, Access, read-only data
HowTo: Display read-only data from an MSDE or SQL Server database using ADO.NET	VB.NET, NET, DataGrid, ADO.NET, MSDE, SQL Server, read-only data
HowTo: Use compiled-in data with ADO.NET	VB.NET, NET, DataGrid, ADO.NET, inline data, compiled-in data

SQL Server

Title	Keywords
HowTo: Combine fields in a SELECT statement	database, SELECT statement, combine
HowTo: Import SQL Server data into an Access database	ADO, import, SQL Server
Bug: Valid Access dates may overflow in SQL Server	SQL, SQL Server, Access, database, dates, overflow
Tip: Work safely with Access and SQL Server dates	SQL Server, Access, database, dates, delimiter
Tip: Use email with SQL Server	email, SQL Server, database

DAO

Title	Keywords
HowTo: Generate CREATE TABLE statements for an Access database in Visual Basic 6	CREATE TABLE, SQL, Access, database
HowTo: See if a table exists in a DAO database by using an On Error statement	DAO, database, table, table exists
HowTo: See if a table exists in a DAO database	DAO, database, table, table exists
HowTo: Make a lookup cache using ADO.NET in Visual Basic .NET	ADO.NET, cache, lookup, lookup table, table
HowTo: Make a lookup cache from a DAO database	DAO, cache, lookup, lookup table, table
HowTo: Read properties from a DAO recordset	DAO, recordset, property
HowTo: Use DAO to make a database lookup table	DAO, database, lookup, table
HowTo: Use DAO to copy the values in matching fields from one table to another	DAO, database, field, match, copy, record
HowTo: Use DAO to copy records from one table to another, remapping source and destination fields	DAO, database, field, match, copy, record, map
HowTo: Use DAO to compare tables in two Access databases	DAO, database, compare, DB, Access, tables
HowTo: Use DAO to compare two Access databases' structure	DAO, database, compare, DB, Access
HowTo: Copy corresponding fields from one table to another in an Access database	Access, field, table, copy
HowTo: Use DAO to compact an Access database	DAO, compact, database, Access
HowTo: Use DAO to copy data from a CSV file into an Access database	DAO, CSV, Access, delimited, database, data, SELECT
HowTo: Use DAO to search for a string in database table and field names	database, search, table, field, DAO
HowTo: Use DAO to make an Excel report on an Access database's structure	Access, database, DAO, Excel, index, relation, table
HowTo: Use DAO to list database properties and their values	DAO, database, property, database property, database properties
HowTo: Use DAO to set, get, and delete database properties	DAO, database, property, database property, database properties
HowTo: Use DAO to display a database's structure in a TreeView control	database, DAO, structure, TreeView
HowTo: Compare different methods for using DAO to find records	database, DAO, index, key, Seek, FindFirst
HowTo: Build an Access database and a table with records using DAO	build database, DB, DAO, make table, Access
HowTo: Display weekly database data with the calendar control	calendar, weekly, database
HowTo: Use a password protected phone database with DAO	DAO, password, database, password protected database
HowTo: Graph data in a database using MSChart	MSChart, graph, database, chart
Bug: DAO sometimes finishes MoveFirst and MoveLast asynchronously	DAO, MoveFirst, MoveLast, asynchronous
HowTo: List the tables in a database by using DAO	database, table, list tables, DAO
HowTo: Import data in columns into a database	database, data, column, column data
HowTo: Manually import a delimited text file into a database	database, import, delimited file
HowTo: Export a database file into a text file using DAO	database, export, text file, data
HowTo: Use the Data control with a password protected Access 2000 database	Data control, Access, password, DAO
HowTo: Use DAO to add records to a database	database, DAO, add record, insert record
HowTo: Use DAO to create and delete tables	DAO, database, table, CREATE TABLE, DROP TABLE
HowTo: Join tables in two different databases using linked tables	DAO, ADO, join, two databases, multiple databases

General

Title	Keywords
Beginning Database Design Solutions	Database Design, Database, MySQL, Access, Microsoft Access, programming
Beginning Database Design Solutions	Database Design, Database, MySQL, Access, Microsoft Access, programming
Tip: Use ADOX to make a database without leaving the database files locked	Visual Basic, Visual Basic .NET, ADO, ADOX, create database, make database, file locking, .ldb file
Tip: Use proper data delimiters for different databases	Visual Basic, Visual Basic .NET, database, delimiter, date, ADO, ADOX, SQL Server, Access, Jet
HowTo: Create a DataTable with row cell errors, and display it in a DataGridView in Visual Basic .NET	DataGridView, DataTable, error, row error, cell error, Visual Basic .NET, VB.NET
HowTo: Programmatically select an entire row in a DataGrid control in Visual Basic 6	DataGrid, select row, data grid, Visual Basic 6
HowTo: Use ADOX to search the table columns in an Access database for a string in Visual Basic .NET	ADOX, Access, database, table, column, table columns, search columns, VB.NET
HowTo: Use ADOX to search the table columns in an Access database for a string in Visual Basic 6	ADOX, Access, database, table, column, table columns, search columns, Visual Basic 6
HowTo: Use ADOX to list the tables in an Access database and give their types in Visual Basic .NET	ADOX, Access, database, table, table type, VB.NET
HowTo: Use ADOX to list the queries in an Access database and give their command text in Visual Basic .NET	ADOX, Access, database, query, command text, VB.NET
HowTo: Use ADOX to search the queries in an Access database for a string in Visual Basic .NET	ADOX, Access, database, query, command text, search query, VB.NET
HowTo: Use ADOX to list the queries in an Access database and give their command text in Visual Basic 6	ADOX, Access, database, query, command text, Visual Basic 6
HowTo: Use ADOX to search the queries in an Access database for a string in Visual Basic 6	ADOX, Access, database, query, command text, search query, Visual Basic 6
HowTo: Use ADOX to list the tables in an Access database and give their types in Visual Basic 6	ADOX, Access, database, table, table type, Visual Basic 6
HowTo: Select random records from a database table in Visual Basic .NET	database, random records, select records, VB.NET
HowTo: Generate CREATE TABLE statements for an Access database in Visual Basic 6	CREATE TABLE, SQL, Access, database
HowTo: Color a column header in a DataGridView in Visual Basic 2005	color header, header, DataGridView, VB 2005, database
HowTo: Color a DataGridView control's cells dynamically as their data changes in Visual Basic 2005	color cell, dynamic, DataGridView, VB 2005, database
HowTo: Color specific cells in a DataGridView control in Visual Basic 2005	color cells, DataGridView, VB 2005, database
HowTo: Draw certain cells in a DataGrid with different colors in Visual Basic .NET	DataGrid, color, cell, colored cell, cutoff, VB.NET
HowTo: Format the columns displayed by a DataTable in a DataGrid control in Visual Basic .NET	DataTable, column, format, align, alignment, DataGrid, VB.NET
HowTo: Display a caption for a DataTable in a DataGrid in Visual Basic .NET	DataTable, caption, DataGrid, VB.NET
HowTo: See if a table exists in a DAO database by using an On Error statement	DAO, database, table, table exists
HowTo: See if a table exists in a DAO database	DAO, database, table, table exists
HowTo: Use a INSERT INTO statement in ADO to copy data from one table into two existing tables	ADO, data, database, INSERT, INSERT INTO, copy data
HowTo: Use a SELECT INTO statement in ADO to copy data from one table into two new tables	ADO, data, database, SELECT, SELECT INTO, copy data
HowTo: Make a lookup cache using ADO.NET in Visual Basic .NET	ADO.NET, cache, lookup, lookup table, table
HowTo: Make a lookup cache from a DAO database	DAO, cache, lookup, lookup table, table
HowTo: Read properties from a DAO recordset	DAO, recordset, property
HowTo: Convert an Access database to Access2002	Access, Office, Microsoft Office, MS Office, convert
HowTo: Use DAO to make a database lookup table	DAO, database, lookup, table
HowTo: Update a DataSet that doesn't have primary keys in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database, primary key
HowTo: Bind a DataGrid to a DataTable at run time in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database
HowTo: Define a relationship between two tables in a DataSet in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database, relationship
HowTo: Display parent and child records in two DataGrid controls in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database, relationship, parent/child, master/detail
HowTo: Bind a DataGrid to a DataTable with read-only columns in VB .NET	DataGrid, DataTable, bind, ADO.NET, data, database, read only
HowTo: Use DAO to copy the values in matching fields from one table to another	DAO, database, field, match, copy, record
HowTo: Use DAO to copy records from one table to another, remapping source and destination fields	DAO, database, field, match, copy, record, map
HowTo: Bind a DataGrid to a DataSet at run time in VB .NET	ADO.NET, database, DataGrid, DataSet, bind
HowTo: Use DAO to compare tables in two Access databases	DAO, database, compare, DB, Access, tables
HowTo: Use DAO to compare two Access databases' structure	DAO, database, compare, DB, Access
HowTo: Connect an ADO Recordset to an XML file located at a URL	ADO, Recordset, XML, URL, Web, data, Access
HowTo: Save an ADO Recordset's data into an XML file	ADO, Recordset, XML, URL, Web, data, Access
HowTo: Copy corresponding fields from one table to another in an Access database	Access, field, table, copy
HowTo: Store and retrieve an image in an Access database	Access, image, picture, memo
HowTo: Bind a CurrencyManager to objects in a collection and use it for navigation in VB .NET	CurrencyManager, binding, data binding, VB.NET, DataBinding
HowTo: Bind controls' properties to each other in VB .NET	binding, data binding, VB.NET, DataBinding, properties, property
HowTo: Use ADOX to get lots of information about an Access database	ADOX, information, database, Access
HowTo: Use DAO to compact an Access database	DAO, compact, database, Access
HowTo: Use a bound DataGrid in VB.NET	DataGrid, binding, bind, bound, VB.NET
HowTo: Use IIF in a SQL SELECT statement to make a DataReport display a warning if a value is too low in VB.NET	DataReport, VB.NET, IIF, warning, CrystalReportViewer, CrystalReport, CrystalReports
HowTo: Use IIF in a SQL SELECT statement to display a warning if a value is too low in VB.NET	DataGrid, binding, bind, bound, VB.NET, IIF, warning
HowTo: Display query results in a bound grid control	database, bound controls, grid
HowTo: Use IIF in a SQL SELECT statement to make a DataReport display a warning if a value is too low	IIF, SQL, SELECT, database, warning, DataReport
HowTo: Use IIF in a SQL SELECT statement to display a warning if a value is too low	IIF, SQL, SELECT, database, warning
HowTo: Use DAO to copy data from a CSV file into an Access database	DAO, CSV, Access, delimited, database, data, SELECT
HowTo: Make a PictureBox control that has a bindable FileName property in VB .NET	bind, data, bindable, PictureBox, NamedPicture
HowTo: Deter an SQL injection attack	SQL injection, attack, hacker, data, safe
HowTo: Use DAO to search for a string in database table and field names	database, search, table, field, DAO
HowTo: Use DAO to make an Excel report on an Access database's structure	Access, database, DAO, Excel, index, relation, table
HowTo: Use ADO.NET to make an Excel report on an Access database's structure in VB.NET	Access, database, ADO.NET, Excel, index, relation, table, VB.NET
HowTo: Use DAO to list database properties and their values	DAO, database, property, database property, database properties
HowTo: Use DAO to set, get, and delete database properties	DAO, database, property, database property, database properties
HowTo: Use DAO to display a database's structure in a TreeView control	database, DAO, structure, TreeView
HowTo: Compare different methods for using DAO to find records	database, DAO, index, key, Seek, FindFirst
HowTo: Display weekly database data with the calendar control	calendar, weekly, database
HowTo: Count the records in a Recordset two ways and compare their speeds	records, count records, ADO
HowTo: Determine how many records were inserted by an INSERT ... SELECT statement	ADO, data, database, Access, INSERT, INSERT SELECT, SELECT, records, INSERT INTO ... SELECT
HowTo: Use a password protected phone database with DAO	DAO, password, database, password protected database
HowTo: Define a program's queries in text files	data, database, query, configuration
Bug: Access uses # to delimit dates while SQL Server uses quotes	SQL, Access, database, date
HowTo: Use ADOData controls to and a DataGrid control to display master/detail data	master/detail, master, detail, ADOData control, DataGrid
HowTo: Graph data in a database using MSChart	MSChart, graph, database, chart
HowTo: Build master/detail records using an auto-incremented key	master/detail, master, detail, autoincrement, auto-increment, autonumber, auto-number
HowTo: Use Data controls to display master/detail data	master/detail, master, detail, data control
HowTo: List the tables in a database by using DAO	database, table, list tables, DAO
HowTo: List the ODBC system DSNs	DSN, ODBC, database
HowTo: Manually import a delimited text file into a database	database, import, delimited file
HowTo: Refresh a DataReport	DataReport, refresh
HowTo: Build a DataReport using a program-created Recordset	DataReport, Recordset
HowTo: Build a hierarchical DataReport using a program-created Recordset	hierarchical DataReport, Recordset
HowTo: Perform field- and form-level validations	field, form, validation
HowTo: Create a DSN in code using an ActiveX DLL	DSN, database, ActiveX DLL
HowTo: Let the user select and edit a database table in a DBGrid control	DBGrid, edit database, edit table
HowTo: Create a DSN in code	DSN, database
HowTo: Export a database file into a text file using DAO	database, export, text file, data
HowTo: Use ADO to read a database's structure	database, structure, TreeView, DataGrid, schema
HowTo: Count the records in a database table	database, table, count records
HowTo: Display one field with a DBCombo control but update another when the user changes the value	DBCombo, update field
HowTo: Populate ListBoxes from three related Access tables and display TreeView data when records are selected	database, TreeView, master/detail
HowTo: Use the DataGrid control to display master/detail relationships	master/detail, DataGrid, database
HowTo: Let the user select database records using a ComboBox	ComboBox, database records, select
HowTo: Connect a DataReport to an ADO Recordset	DataReport, ADO, Recordset
HowTo: Use the DBGrid control's BeforeUpdate event	DBGrid, BeforeUpdate, validation
HowTo: Make a database with a password and then open it with DAO	database, password
HowTo: Use an unbound DBGrid control	DBGrid, unbound, unbound data
HowTo: Use a TabStrip to manage multiple DBGrid controls	DBGrid, tab
HowTo: Use a DBList control	database, DBList
HowTo: Use DAO to add records to a database	database, DAO, add record, insert record
HowTo: Print data from a database	database, print
HowTo: Save and display images in a database using a PictureBox	database, image, picture, PictureBox
HowTo: Display images with file names stored in a database	database, image, picture, filename, file name
HowTo: Save and restore pictures in a database using ADO with AppendChunk and GetChunk	database, AppendChunk, GetChunk
HowTo: Build an HTML table from a database	database, HTML
HowTo: Use a bound DBGrid control	DBGrid, bound DBGrid
HowTo: Use ADOX to create a database	database, ADOX, create database
HowTo: Use DAO to create and delete tables	DAO, database, table, CREATE TABLE, DROP TABLE
HowTo: Use DAO and SQL to create and drop database tables	SQL, DROP TABLE, CREATE TABLE
HowTo: Create a Recordset and attach it to a DBCombo control	DBCombo, Recordset, bound column, ADO, database
HowTo: Use Zlib and DIBs to save and restore compressed pictures in a database without using temporary files	DIB, picture, image, database, SetDIBits, GetDIBits, Zlib, compress
HowTo: Use DIBs to save and restore pictures in a database without using temporary files	DIB, picture, image, database, SetDIBits, GetDIBits
Tutorial: Dynamic Databases	database, dynamic, price
Bug: SQL UNION fails in XP before SP 1	SQL, UNION, Windows XP, SP 1, Service Pack
Bug: SQL statements must use mm/dd/yyyy date format	SQL, database, date format, mm/dd/yyyy, dd/mm/yyyy

Data Control

Title	Keywords
HowTo: Use ADOData controls to and a DataGrid control to display master/detail data	master/detail, master, detail, ADOData control, DataGrid
HowTo: Reset a DataGrid control when the data to which it is bound changes in VB .NET	DataGrid, database, VB.NET
HowTo: Bind a ComboBox to a database lookup table in VB .NET	database, ADO.NET, VB .NET, bound controls, data binding, ComboBox, lookup table
HowTo: Bind simple controls to a database in VB .NET	database, ADO.NET, VB .NET, bound controls, data binding
HowTo: Navigate a database with bound controls in VB .NET	navigate, database, bound control, VB.NET
HowTo: Use Data controls to display master/detail data	master/detail, master, detail, data control
HowTo: Use a database with a Data control	Data control, database
HowTo: Use the Data control with a password protected Access 2000 database	Data control, Access, password, DAO

Reports

Title	Keywords
HowTo: Use IIF in a SQL SELECT statement to make a DataReport display a warning if a value is too low in VB.NET	DataReport, VB.NET, IIF, warning, CrystalReportViewer, CrystalReport, CrystalReports
HowTo: Refresh a DataReport	DataReport, refresh
HowTo: Build a DataReport using a program-created Recordset	DataReport, Recordset
HowTo: Build a hierarchical DataReport using a program-created Recordset	hierarchical DataReport, Recordset
HowTo: Write a report in PDF format	PDF, Adobe, report

DSN

Title	Keywords
HowTo: Create a DSN in code using an ActiveX DLL	DSN, database, ActiveX DLL
HowTo: Create a DSN in code	DSN, database

Misc

Title	Keywords
HowTo: Bind a collection of objects to a DataGrid in VB .NET	DataGrid, bind, data binding, collection
HowTo: Bind a collection of objects to a DataGrid and let it sort on the columns in VB .NET	DataGrid, bind, data binding, collection, sort, IEditableObject, IBindingList

Access

Title	Keywords
HowTo: Use ADOX to get and set the description of a column in an Access database	ADOX, ADO, column description, Access

ADOX

Title	Keywords
HowTo: Use ADOX to search the table columns in an Access database for a string in Visual Basic .NET	ADOX, Access, database, table, column, table columns, search columns, VB.NET
HowTo: Use ADOX to search the table columns in an Access database for a string in Visual Basic 6	ADOX, Access, database, table, column, table columns, search columns, Visual Basic 6
HowTo: Use ADOX to list the tables in an Access database and give their types in Visual Basic .NET	ADOX, Access, database, table, table type, VB.NET
HowTo: Use ADOX to list the queries in an Access database and give their command text in Visual Basic .NET	ADOX, Access, database, query, command text, VB.NET
HowTo: Use ADOX to search the queries in an Access database for a string in Visual Basic .NET	ADOX, Access, database, query, command text, search query, VB.NET
HowTo: Use ADOX to list the queries in an Access database and give their command text in Visual Basic 6	ADOX, Access, database, query, command text, Visual Basic 6
HowTo: Use ADOX to search the queries in an Access database for a string in Visual Basic 6	ADOX, Access, database, query, command text, search query, Visual Basic 6
HowTo: Use ADOX to list the tables in an Access database and give their types in Visual Basic 6	ADOX, Access, database, table, table type, Visual Basic 6