|Total Hits: 130 | 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: 174 | Today: 0||Author: MSDN|| Rating: |
This article contains a generic function that you can use to process multiple recordsets and other messages that are returned from stored procedures or the execution of batch SQL statements....
|Total Hits: 366 | Today: 0||Author: MSDN|| Rating: |
This step-by-step article provides guidelines about how to implement paging. This article provides a few examples of paging and describes the advantage of each method....
|Total Hits: 376 | Today: 0||Author: MSDN|| Rating: |
In ADO.NET, you can use the DataView.RowFilter property and the DataTable.Select method to filter a subset of records. However, the expressions that you can use have limitations. This article demonstrates three techniques to work around the limitations of the filter expressions....
|Total Hits: 157 | Today: 0||Author: MSDN|| Rating: |
If the Tag property of a Windows Forms control is bound to a read-only field in a DataSet object, you cannot move the focus away from the control, and you cannot close the form....
|Total Hits: 392 | Today: 0|| 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....
|Total Hits: 707 | Today: 0|| Rating: |
When you test code to identify performance bottlenecks, it is best to use the highest resolution timer that the system has to offer. This step-by-step article describes how to use the QueryPerformanceCounter function to time application code.
|Total Hits: 1291 | Today: 0|| Rating: |
This article describes how to retrieve a DataView object from a Windows Forms bound control.To bind a data source to a Windows Forms control, you can code it yourself or use design-time binding. When the binding occurs at design time, you may need to access the DataView that the bound control uses. However, the DataView is not exposed by default in design-time binding....
|Total Hits: 10520 | Today: 0|| Rating: |
This step-by-step article demonstrates how to display data from an Excel worksheet through an ASP.NET (.aspx) page by using Visual C# .NET....
|Total Hits: 1966 | Today: 0|| Rating: |
This step-by-step article describes how to retrieve the identity value when you add a record into a SQL Server table with an identity field.
|Total Hits: 3295 | Today: 0|| 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: 1774 | Today: 0|| 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: 2947 | Today: 0|| 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:
back to the top
- 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
Automation vs. ADO.NETA developer can work ..Read More..
|Total Hits: 3722 | Today: 0|| 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: 621 | Today: 0|| Rating: |
This article demonstrates how to persist an ADO.NET DataSet object to XML....
|Total Hits: 2258 | Today: 0|| Rating: |
This article explains how to read and write data from BLOB (LongVarBinary) columns in a database table....
|Total Hits: 1480 | Today: 0|| Rating: |
This article explains how to create a small console application that uses COM Interop to create an earlier version ( legacy ) ADO RecordSet, convert it to an ADO.NET DataSet, and then display the record count. You will see how easy it is to use COM components from within Microsoft Visual Studio .NET....
|Total Hits: 4586 | Today: 0|| 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: 1059 | 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: 977 | 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....