Jiangws's Blog

 
 
 
  • About

    夢を叶える為
 
将DataReader转换为DataTable的一个函数 October 24th, 2006

 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

Posted in ADO.NET || Comments Off on 将DataReader转换为DataTable的一个函数
Enterprise .NET Community: Build a Data Access Layer with the Visual Studio 2005 DataSet Designer: March 21st, 2006

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
Posted in ADO.NET, SQLSERVER || Comments Off on 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: March 21st, 2006

Enterprise .NET Community: Build a Data Access Layer with the Visual Studio 2005 DataSet Designer:

Posted in ADO.NET || Comments Off on Enterprise .NET Community: Build a Data Access Layer with the Visual Studio 2005 DataSet Designer:
Enhancements for ADO.NET 2.0 March 9th, 2006

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 …

Posted in ADO.NET || Comments Off on Enhancements for ADO.NET 2.0
.Net like Access(V1) – The Code Project – C# Database March 9th, 2006

リンク: .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

Posted in ADO.NET || Comments Off on .Net like Access(V1) – The Code Project – C# Database
ASP.NET.4GuysFromRolla.com: Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data with March 9th, 2006

便利です。

リンク: 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.…

Posted in ADO.NET || Comments Off on ASP.NET.4GuysFromRolla.com: Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data with
Multiple Active Result Sets March 9th, 2006

理解しにくい・・・・・・
 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

Posted in ADO.NET || Comments Off on Multiple Active Result Sets
Asynchronous Operations March 9th, 2006

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

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

Posted in ADO.NET || Comments Off on Asynchronous Operations
Batch Updates March 9th, 2006
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

Posted in ADO.NET || Comments Off on Batch Updates
Data Source Configuration Wizard March 9th, 2006

ずっと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,

Posted in ADO.NET || Comments Off on Data Source Configuration Wizard