ADO and ADO.NET - Page 2

Return a boolean indicating whether the input connection string for the OLEDB managed provider points to a SQL Server DB Examples: Debug.WriteLine(IsOleDbSqlConnString("Provider=SQLOLEDB.1;Data Source=.;User ID=sa;Password=;Initial Catalog=MyDB")) ' => True Debug.WriteLine(IsOl

Retrieve the installed MDAC version Examples: Dim ver As Version = GetMdacVersion() print the full version MessageBox.Show(ver.ToString()) print the major and minor portions MessageBox.Show("Major: " & ver.Major & ", Minor: " & ver.Minor) check whether the current version is at least 2.7

Assign the same transaction to the Update/Delete/Insert commands of all the OleDb/SqlAdapters passed in input Note: all the DataAdapters must be of the same type (OleDb or Sql) Note: requires Imports System.Data.OleDb and Imports System.Data.SqlClient Example: SetCommandsTransaction(tran, ...

Execute an array of sql script files with batch statements, by using the same SqlCommand object - connString is the connection string for the destination database Example: Dim connString As String = "server=(local);Persist Security Info=False;Integrated Security=SSPI;database=TestDB" Dim ...

Returns the names of all the tables in the database identified by the input connection string Requires Imports System.Data.OleDb Example: Dim tables() As String = GetDatabaseTables("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=d:\testdb.mdb") Dim table As String For Each table In tables

Returns an array with the installed SQL Server databases The first param must be a valid connection string to the 'master' database Requires Imports System.Data.SqlClient Example: Dim databases() As String = GetSqlServerDatabases( _ "server=(local); Database=master; user id=sa; ...

Returns the names of all the columns in the specified database table. The database is identified by the input connection string Requires Imports System.Data.OleDb Example: Dim columns() As String = GetTableColumns("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=d:\testdb.mdb", "TestTable")

Returns whether a SQL Server DB with the specified name is present The first param must be a valid connection string to the 'master' database Requires Imports System.Data.SqlClient Example: Debug.WriteLine(IsSqlServerDatabasePresent( _ "server=(local); Database=master; user id=sa; ...

Execute a batch of OleDb commands. Parameters: - The list of statements separated by ; chars. Use the ? char as a placeholder for a parameter. - The array of OleParameter objects that will replace the ? chars - an optional Boolean that specifies whether the transaction will be rolled back ...

Backup the specified database. Note: requires Imports System.Data.SqlClient Example: Dim connString As String = "server=(local); user id=sa; password=; Database=master;" Try BackupDatabase(connString, "MyTestDB", "D:\MyTestDbBackup.bak") Catch ex As Exception MessageBox.Show(ex.Message)

The DataSet is a container of multiple DataTables, and it allows to create parent-child relationships between two tables, as shown below: ' create a relationship between the Categories and the Products tables, against the CatID column ds.Relations.Add(New DataRelation("CatProducts", ...

This function opens the OLEDB dialog to create an OLEDB connection string, and return the selection It requires the OLEDB Service Component 1.0 Type Library to work

Create a SQL Server database with the specified name. If the second parameter is True and a DB with the same name is already present, it is dropped before the new DB is created. Note: requires Imports System.Data.SqlClient Example: Dim connString As String = "server=(local); user id=sa; ...

Restore the specified database. Note: requires Imports System.Data.SqlClient Example: Dim connString As String = "server=(local); user id=sa; password=; Database=master;" Try RestoreDatabase(connString, "MyTestDB", "D:\MyTestDbBackup.bak") Catch ex As Exception MessageBox.Show(ex.

The DataTable class has a method, Compute, that executes SQL-like functions on the rows locally stored in the DataTable. It supports functions such as COUNT, SUM, MIN, MAX, AVG and others. Here's an example to calculate the average salary for the employees stored in the tableEmployees ...

A base data class that makes it much easier for derived classes to run a stored procedure to retrieve data or execute a SQL command. (See usage examples at the bottom)

Check if the specified OLEDB Provider is installed and registered correctly Example: check the Jet 4.0 OLEDB Provider MsgBox "The specified OLEDB provider " & _ IIf(CheckOLEDBProvider("Microsoft.Jet.OLEDB.4.0"), "does", "does not") & " exist" NOTES: Requires CheckRegistryKey and ...

Return the OleDbType that represents the specified system type This is particularly useful when you have a DataTable and want to create a OleDbParameter for onw of its columns, but don't know its type. DataColumnName.DataType returns a Type, and you can convert it to OleDbType by passing it to ...

In the .NET Framework, the DataSet's WriteXml method when used to create a DiffGram does not provide the capability to include schema information along with the data. This is more of a design choice than an objective difficulty, though. When you return a DataSet object from a Web service method ...

Many ADO.NET classes, including DataSet, DataTable, and DataColumn, use the ExtendedProperties property to enable users to add custom information. Think of the ExtendedProperties property as a kind of generic cargo variable similar to the Tag property of many ActiveX controls. You populate it ...