|
|
|
|
|
| | Total Hits: 235 | Today: 0 | Author: MSDN | Rating:  |
| | 
This article demonstrates how to use the GetOleDbSchemaTable method of the OleDbConnection object in ADO.NET to retrieve database schema information. Schema information in a data source includes databases or catalogs that are available from the data source, tables, and views in a database, as well as constraints that exist and so on. Schema information in a table includes primary keys, columns, and autonumber fields.... |
| | Total Hits: 69 | Today: 0 | Author: MSDN | Rating: |
| |
Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. This article shows how to gather this information.... |
| | Total Hits: 199 | Today: 0 | Author: MSDN | Rating: |
| |
This step-by-step article demonstrates how to use the Data Link Properties dialog box to programmatically create a connection string at design time.... |
| | Total Hits: 113 | Today: 0 | Author: MSDN | Rating: |
| |
In this article, the parameters are added to the Parameters collection of the Command object. The SQL Server .NET data provider (SqlClient) supports named parameters. Therefore, when you use the SqlCommand object, you do not have add the parameters in any particular order, but the parameters must have the correct name. In this case, you must add the at sign (@) prefix to the parameter names.... |
| | Total Hits: 168 | Today: 0 | Author: MSDN | Rating: |
| |
This article demonstrates the last three methods and uses both the SqlCommand and the OleDbCommand objects. Make sure that you copy only the code for the managed provider that you are using.... |
| | Total Hits: 62 | Today: 0 | Author: MSDN | Rating:  |
| |
This article demonstrates how to persist an ADO.NET DataSet object to Extensible Markup Language (XML).... |
| | Total Hits: 116 | Today: 0 | Author: MSDN | Rating: |
| |
This article describes the ActiveX Data Objects (ADO) SHAPE command syntax that produces hierarchical recordsets and explains how to traverse hierarchical recordsets. This article also provides sample code.... |
| | Total Hits: 160 | Today: 0 | Author: MSDN | Rating: |
| |
This article demonstrates how to use the ADO.NET OLE DB managed provider to access an Oracle database.... |
| | Total Hits: 115 | Today: 0 | Author: MSDN | Rating: |
| |
This article demonstrates how to persist an ADO.NET DataSet object to Extensible Markup Language (XML).... |
| | Total Hits: 99 | Today: 0 | Author: MSDN | Rating: |
| |
This article describes how to use the Getxxx methods (such as GetChar, GetDouble, and GetInt32) to avoid the boxing penalty when you use the DataReader object.... |
| | Total Hits: 59 | Today: 0 | Author: MSDN | Rating: |
| |
The OLE DB managed provider requires that the OLE DB provider support a command syntax to select and update data. Most simple OLE DB providers meet this requirement. Because the Microsoft OLE DB Provider for Exchange only supports updates through cursors, the OLE DB managed provider does not support the OLE DB Provider for Exchange.... |
|
|
|
|
|
|
|
|
|
|
|
|
|