|
|
|
|
|
Total Hits: 157 | 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....
|
|
|
|
Total Hits: 89 | 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: 231 | 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: 794 | 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: 2435 | 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: 338 | Today: 1
|
Author: MSDN
|
Rating:
|
|
Use this step-by-step guide to implement key-based dependencies for data caching in an ASP.NET application....
|
|
|
|
Total Hits: 1596 | 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: 839 | Today: 1
|
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: 847 | Today: 1
|
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: 1244 | Today: 1
|
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: 2856 | Today: 1
|
|
Rating:
|
|
This article provides step-by-step samples that show you how to automate Microsoft Access from Visual Basic .NET. The topics and the sample code show you how to do the following:- Open a database in Access
- Print or preview an Access report
- Show and edit an Access form
- Avoid dialog boxes when you open a password-protected database or when user-level security is turned on
- Automate the Access Runtime
back to the topAutomation vs. ADO.NETA developer can work ..Read More..
|
|
|
|
Total Hits: 3580 | Today: 1
|
|
Rating:
|
|
This article describes how to use ActiveX Data Objects (ADO) .NET to connect to a database and run a command (such as UPDATE, INSERT and DELETE) by using a Visual Basic .NET console application....
|
|
|
|
Total Hits: 122 | 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: 892 | Today: 0
|
Author: Microsoft
|
Rating:
|
|
This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this article provides the information that you need so that you can use the Jet OLE DB provider when Excel is the target data source....
|
|
|
|
Total Hits: 5257 | Today: 1
|
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: 655 | 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: 1271 | 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: 1008 | Today: 1
|
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: 857 | 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: 1059 | 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....
|
|
|
|
|
|
