Entries Tagged 'ADO.NET' ↓

将DataReader转换为DataTable的一个函数

 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

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

新しい機能、勉強しないと・・・・・・

New Features of ADO.NET 2.0
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

New Features of ADO.NET 2.0
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の作り方を考えました、今日漸くわかりました、うれしいです。

Visual Studio 2005 Wizards and Designers
Data Source Configuration Wizard
Wizards and Designers

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,