将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 … Read More
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… Read More
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:… Read More
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 that is modeled after the asynchronous model used by the .NET Framework. * Multiple Active… Read More
.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 are, Microsoft Access and PowerBuilder. if you developed applications using Microsoft Access, you will understand that developing… Read More
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. These controls allow page developers to declaratively access and modify data without writing any code to… Read More
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 Server connection. In most cases, it allows you to have more than one default result… Read More
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 multithreaded middle code the key factor for increasing throughput is doing more than one thing… Read More
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 to the server usually results in major performance gains. Batch updates are supported for the… Read More
Data Source Configuration Wizard ずっとClub Start KIｔでDataSet.Xsdの作り方を考えました、今日漸くわかりました、うれしいです。 Visual Studio 2005 Wizards and Designers Data Source Configuration Wizard 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, the wizard derives a corresponding DataTable object within the data source for the table. The wizard does… Read More