1 public static DataTable ConvertDataReaderToDataTable(IDataReader reader)
2 {
3 DataTable objDataTable = new DataTable();
4 int intFieldCount = reader.FieldCount;
5 for (int intCounter = 0; intCounter < intFieldCount; ++intCounter)
6 {
7 objDataTable.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter));
8 }
9
10…
Posts Categorized: ADO.NET
Enterprise .NET Community: Build a Data Access Layer with the Visual Studio 2005 DataSet Designer:
ASP.NET.4GuysFromRolla.com: Custom Paging in ASP.NET 2.0 with SQL Server 2005:
SELECT RowNum, EmployeeID, LastName, FirstName FROM (SELECT EmployeeID, LastName, FirstName ROW_NUMBER() OVER(ORDER BY EmployeeID) as RowNum FROM Employees e ) as EmployeeInfo…
Enterprise .NET Community: Build a Data Access Layer with the Visual Studio 2005 DataSet Designer:
Enterprise .NET Community: Build a Data Access Layer with the Visual Studio 2005 DataSet Designer:
…
Enhancements for ADO.NET 2.0
The following features are new in ADO.NET version 2.0:
Managed Providers
*
Server Enumeration
Provides support for enumerating active instances of Microsoft SQL Server 2000 and later.
*
Asynchronous Processing
Allows you to perform asynchronous database operations using an API …
.Net like Access(V1) – The Code Project – C# Database
リンク: .Net like Access(V1) – The Code Project – C# Database.
Introduction
Every programmer has a big dream “Programming without code”, practically a lot of database tools offer programming without code, the best 2 tools that I tried
ASP.NET.4GuysFromRolla.com: Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data with
便利です。
リンク: ASP.NET.4GuysFromRolla.com: Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data with Parameters.
A Multipart Series on ASP.NET 2.0’s Data Source Controls
ASP.NET 2.0 introduced a number of new Web controls designed for accessing and modifying data.…
Multiple Active Result Sets
理解しにくい・・・・・・
Multiple Active Result Sets, or MARS, is a new feature supported by ADO.NET that allows the implementation of multiple batches on a single connection.
MARS has the ability to have more than one pending request under a given SQL
Asynchronous Operations
新しい機能、勉強しないと・・・・・・
ADO.NET 1.1 and earlier required your data access operations to be synchronous. ADO.NET 2.0 includes new methods for the Connection and Command classes that permit you to execute asynchronous operations.
In a
Batch Updates
Batch support in ADO.NET 2.0 allows a DataAdapter to group insert/update/delete operations from a DataSet or DataTable to the server, instead of sending one operation at a time. The reduction of round trips
Data Source Configuration Wizard
ずっとClub Start KItでDataSet.Xsdの作り方を考えました、今日漸くわかりました、うれしいです。
This wizard adds a new XML Schema Definition (.xsd) and supporting files to your project. When you select a data table or stored procedure in the database,