|
|
|
|
|
| | Total Hits: 248 | 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: 2526 | Today: 0 | Author: MSDN | Rating: |
| |
This step-by-step article demonstrates how to use the OleDbDataAdapter class to obtain rows from an ADO Recordset object and insert them into a DataSet object. Note that you cannot do the reverse; that is, you cannot obtain rows from a DataSet object and insert them into an ADO Recordset object.... |
| | Total Hits: 235 | Today: 0 | Author: MSDN | Rating: |
| |
This step-by-step article describes how to retrieve table and column metadata from Microsoft Excel data sources by using the GetOleDbSchemaTable method with the Microsoft OLE DB Managed Provider and the Microsoft OLE DB Provider for Jet.... |
| | Total Hits: 405 | Today: 0 | 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: 62 | Today: 0 | Author: Microsoft | 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.... |
| | Total Hits: 1022 | Today: 0 | Author: rmortega77. | Rating: |
| |
Sometimes we want to do tricks with the Crystal Reports engine, like profiting from the Exporting functions to create Word, Excel, or PDF files. What if we don't read the data from a database? This article shows the details on creating a Crystal Reports sub report, and how to fill it from code, without a database.... |
| | Total Hits: 5635 | Today: 0 | Author: MSDN | Rating: |
| |
This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass an Input parameter, to retrieve a Ref Cursor from an Oracle stored procedure, and to display the information in a DataGrid object.... |
| | Total Hits: 693 | Today: 0 | Author: MSDN | Rating: |
| |
In the MSDN Library Topic DataRelation.ChildKeyConstraint Property and in the Visual Studio Help topic "DataRelation.ChildKeyConstraint Property," the sample code is incorrect. The Help Topics describe how to obtain the ForeignKeyConstraint for the relation.... |
| | Total Hits: 1314 | Today: 0 | Author: MSDN | Rating: |
| |
This article demonstrates how you can manage quotation marks in string values when you concatenate SQL statements. The article provides a sample solution that uses the Sql managed provider (Microsoft SQL Server). This article also provides a Microsoft Access sample that uses the Microsoft OLE DB Provider and related data access classes.... |
| | Total Hits: 1047 | Today: 0 | Author: MSDN | Rating: |
| |
The SqlDataAdapter.UpdateCommand Property MSDN documentation and the "SqlDataAdapter.UpdateCommand Property" topic in the Microsoft Visual Studio .NET Help documentation describe how to get or how to set a Transact-SQL statement to update records in a data source by using the UpdateCommand property of a SqlDataAdapter object.... |
| | Total Hits: 374 | Today: 0 | Author: MSDN | Rating: |
| |
Use this step-by-step guide to implement key-based dependencies for data caching in an ASP.NET application.... |
| | Total Hits: 1695 | Today: 0 | Author: MSDN | Rating: |
| |
When large queries to a database are executed, the application may become unresponsive for a long period of time. To avoid this behavior and decrease the waiting time of the user, the query can be executed on a background thread, releasing the application for other tasks until the data is returned from the database and databinding is performed.... |
| | Total Hits: 895 | Today: 0 | Author: MSDN | Rating: |
| |
Use this step-by-step guide to copy hierarchical data into a DataSet by using the Fill method of the DataSet class.... |
| | Total Hits: 929 | Today: 0 | Author: MSDN | Rating: |
| |
This step-by-step article describes how to copy an image stored in a database directly into a PictureBox control on a Windows Form without needing to save the image to a file.... |
| | Total Hits: 978 | Today: 0 | Author: MSDN | Rating: |
| |
This step-by-step article uses a Microsoft SQL Server TimeStamp field to detect update collisions in order to reduce the amount of data sent to the server. By default, the CommandBuilder object (both SQLClient and OLEDB) builds collision detection based on all field values. By using a custom UpdateCommand, we can specify only the columns that we wish to use.... |
| | Total Hits: 1394 | Today: 0 | Author: MSDN | Rating: |
| |
This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application performance and reduce system overhead because only one row is ever in memory.... |
| | Total Hits: 1129 | Today: 0 | Author: MSDN | 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.... |
| | Total Hits: 406 | 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. Sample code is also provided.... |
| | Total Hits: 725 | Today: 0 | Author: MSDN | 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.... |
| | Total Hits: 2573 | Today: 0 | Author: MSDN | Rating: |
| |
This article contains Microsoft Visual Basic .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the database.... |
|
|
|
|
|
|
|
|
|
|
|
|
|