|
|
|
|
|
Total Hits: 125 | Today: 0
|
Author: Microsoft Corporation
|
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: 73 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
ADO.NET provides new flexibility in how you update your data source. This article describes how you can update a data source that is different from the original data source that you use to create the DataSet object. Earlier versions of Microsoft ActiveX Data Objects (ADO) allow you to update records in a data source other than the original data source of those records, though this is difficult to do. Because ADO.NET is a truly disconnected model and because ADO.NET introduces the DataAdapter obj...
|
|
|
|
Total Hits: 53 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article shows how to fill a DataSet object with the results of one or more database queries, and how to access that data after it is loaded into the DataSet object....
|
|
|
|
Total Hits: 35 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article shows how to fill a DataSet object with the results of one or more database queries, and how to access that data after it is loaded into the DataSet object....
|
|
|
|
Total Hits: 77 | Today: 0
|
Author: Microsoft Corporation
|
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.
1. Create a new Visual Basic .NET Windows Application project. Form1 is added to the project by default.
2. Place a Command button on Form1, and change its Name property to btnCreateDatabase and its Text property to Create Database....
|
|
|
|
Total Hits: 44 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT, or the DELETE command) by using a Visual Basic .NET console application.
The following list outlines the recommended hardware, software, network infrastructure, and service packs that are required:
• Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows 2000 Professional, Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, or Microsoft...
|
|
|
|
Total Hits: 143 | Today: 1
|
Author: Microsoft Corporation
|
Rating:
|
|
This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the stored procedure that you will create exists in the database. If the stored procedure does not exist, the code creates a stored procedure that takes one parameter to search the Authors table based on the last name and returns the matching rows and numb...
|
|
|
|
Total Hits: 32 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article demonstrates how to take a DataSet that contains data (which is loaded from a database), modify that data, and then send it back to the database to update the original source....
|
|
|
|
Total Hits: 5 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
The DataAdapter class throws generic exceptions when problems occur. This article demonstrates how to obtain a descriptive error message for each row and column that is in fault in any table in a given DataSet class. This is very useful in update scenarios when it is important to check if there are errors in any row or column....
|
|
|
|
Total Hits: 6 | 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: 10 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article shows how to fill a DataSet object with the results of one or more database queries, and how to access that data after it is loaded into the DataSet object....
|
|
|
|
Total Hits: 116 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
The GetChunk and the AppendChunk methods are not available in ADO.NET to read and write binary large object (BLOB) fields. This article describes how to use the FileStream object and a byte array to read and to write BLOB data from Microsoft SQL Server to a file....
|
|
|
|
|
|
