|
|
|
|
|
| | Total Hits: 1039 | Today: 0 | | Rating:  |
| | 
This article shows how to create and use a typed DataSet in a small Web application. Typed DataSets , which inherit from the DataSet class, create first-class members of a DataSet 's DataTables and DataColumns , yielding the many benefits that come with the use of strong typing.
... |
| | Total Hits: 957 | Today: 0 | | Rating: |
| |
This step-by-step article describes how to create a hierarchical DataSet object that you can use as a structure for your programs. You may not have the exact data or structure that you want to use for your project. You can use the method in this article to create prototypes for your examples. It may also be easier to submit only the data that you do have to the database without using the shape command syntax to send the data to the database.... |
| | Total Hits: 59 | Today: 0 | Author: Microsoft Corporation | 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 dicusses how to obtain the underlying provider errors when using ADO.NET in Visual Basic .NET.... |
| | Total Hits: 94 | 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 dicusses how to obtain the underlying provider errors when using ADO.NET in Visual Basic .NET.... |
| | Total Hits: 156 | Today: 0 | Author: MSDN | Rating: |
| |
This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection.... |
| | Total Hits: 183 | Today: 0 | Author: MSDN | Rating: |
| |
This article provides a roadmap to learn and master ADO.NET DataAdapter objects. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers, to help you learn about a Microsoft product or technology.... |
| | Total Hits: 1752 | Today: 1 | | Rating: |
| |
Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual Basic .NET to programmatically create a Microsoft SQL Server database.... |
| | Total Hits: 79 | Today: 0 | Author: Microsoft Corporation | Rating:  |
| |
This step-by-step article describes how to programmatically retrieve data from a Microsoft Access database, and then present the data to the user. The goal of this article is not to provide every conceivable approach to the issue. It is intended to offer a simplified solution that uses ASP.NET, ADO.NET, and Visual Basic .NET as an introduction to the related technologies. The sample in this article uses the OleDbConnection, OleDbCommand, and OleDbDataReader classes. These classes are part of ADO... |
| | Total Hits: 27 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object. If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a Transaction object, a DataSet object, and a DataAdapter object to roll back any changes if an error occurs. If you use a CommandBuilder object to generate INSERT, UPDATE, and DELETE commands, you must set the Transaction property of the SELECT command of... |
| | Total Hits: 59 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
This step-by-step article demonstrates how to use a Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the returned DataSet in a DataGrid control so that you can update that data and send the updates back to the server.... |
| | Total Hits: 22 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
This article describes the ActiveX Data Objects (ADO) SHAPE command syntax that produces hierarchical recordsets and explains how to traverse hierarchical recordsets. Sample code is also provided. You can use hierarchical recordsets as an alternative to JOIN and GROUP BY syntax when you need to access parent-child and summary data. Hierarchical recordsets are used in many products: Xbase products use the SET RELATION command, Microsoft Access uses segmented virtual tables internally for reports ... |
| | Total Hits: 87 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
ADO and ADO MD have not been fully tested in a Microsoft .NET Framework environment. They may cause intermittent issues, especially in service-based applications or in multithreaded applications. The techniques that are discussed in this article should only be used as a temporary measure during migration to ADO.NET. You should only use these techniques after you have conducted complete testing to make sure that there are no compatibility issues. Any issues that are caused by using ADO or ADO MD ... |
| | Total Hits: 84 | Today: 0 | Author: MSDN | Rating: |
| |
When you try to compile the Visual Basic .NET sample code that is included in the Sample .NET Data Provider topic in the Microsoft .NET Framework Software Development Kit (SDK) documentation, you receive the following error messages:
TemplateCommand.vb(6) : error BC30149: 'DotNetDataProviderTemplate.TemplateCommand' must implement 'Overridable Overloads Function CreateParameter() As IDbDataParameter' for interface 'System.Data.IDbCommand'.... |
| | Total Hits: 235 | Today: 0 | Author: MSDN | Rating: |
| |
This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties.... |
| | Total Hits: 238 | Today: 0 | Author: MSDN | Rating: |
| |
This article describes how you can use ADO.NET to open a SQL Server database by using the SQL Server .NET data provider. ADO.NET gathers all of the classes that are required for data handling. The System.Data.SqlClient namespace describes a collection of classes that are used to programmatically access a SQL Server data source. You can access ADO classes through the System.Data.OleDb namespace to provide support for OLE DB databases.... |
| | Total Hits: 226 | 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: 363 | 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: 236 | Today: 0 | Author: MSDN | Rating: |
| |
This article demonstrates how to fill a DataSet object with the resultset from an Oracle stored procedure. The DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET. The DataSet is a memory-resident representation of data that provides a consistent, relational programming model regardless of the data source. The DataSet represents a complete set of data, including related tables, constraints, and relationships among the tables.... |
| | Total Hits: 99 | Today: 0 | Author: MSDN | Rating: |
| |
This article lists the exceptions that can be raised when you invoke the Update method of a DataAdapter object to update a DataSet object or a DataTable object. These exceptions occur if the DataSet, the DataTable, or the UpdateCommand property is Nothing or Null.... |
| | Total Hits: 54 | 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.... |
|
|
|
|
|
|
|
|
|
|
|
|
|