|
|
|
|
|
| |
|
|
| |
|
| Title |
Keywords |
|
| 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 |
|
| Title |
Keywords |
|
| 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 |
|
| 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 |
|
| Title |
Keywords |
|
| 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:
Build an Access database and a table with records using
DAO |
build database, DB, DAO, make table, Access |
|
| HowTo:
Join tables in two different databases using linked
tables |
DAO, ADO, join, two databases, multiple databases |
|
| Title |
Keywords |
|
| 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 |
|
| HowTo:
Display query results in a bound grid control |
database, bound controls, grid |
|
| Bug:
SQL statements must use mm/dd/yyyy date format |
SQL, database, date format, mm/dd/yyyy,
dd/mm/yyyy |
|
| 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 |
|
| | |
bravenet.com
