| .NET Anatomy - Data Concurrency in ADO.NET, Part I |
| DotNetJunkies |
| This article is the beginning of a multi-part article that discusses data concurrency in ADO.NET and reviews how the ADO.NET model supports multi-user scenarios where data may be updated at the server while an ADO.NET client is using that data. |
|
| .NET Anatomy - Data Concurrency in ADO.NET, Part III |
| DotNetJunkies |
| In the two previous articles on this subject we have looked at how the ADO.NET DataSet object contains built-in support for concurrency operations. This functionality helps the developer to build applications that keep users from overwriting each other’s data accidentally. The implementation is open and flexible and so what I will be showing you here can be tailored to your own requirements |
|
| A C# Web Spider written as a Web Service |
| C#Today |
| A Web Spider is a program that is used to navigate sites, follow links and collect various information. It is sometimes called a Web Robot. In this article. ST Tan & Aldy Karna discuss the subject, and show how a Web Spider can be written in C#. |
|
| A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 2 |
| The Code Project |
| The purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid |
|
| A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 3 |
| The Code Project |
| The purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid |
|
| A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 4 |
| The Code Project |
| The purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid |
|
| Access Database Editor in C# |
| The Code Project |
| This project presents an Access Database Editor written in C#. The solution consists of two projects One of which the GenericOLEDB dll provides the access to the database through using the Ole Db classes available in C#. As the title suggests the dll code is completely generic and all the main database code that is specific to Access is contained in the project files that call the code. The main project and the consumer of the GenericOLEDB project contains two files the main file takes care of the specific creation and opening of the database as well as the database operations where there is no further information required, and the second file presents and editor that allows the editing of a row of data for insertions or deletions. |
|
| Accessing Oracle 9i Stored Procedures Using ADO.NET |
| MSDN |
| Use the .NET Oracle Provider in the Microsoft .NET Framework version 1.1 to access Oracle stored procedures and functions. |
|
| Accessing Schemas |
| C# Corner |
| OleDb data provider's connection class (OleDbConnection) provides a method GetOleDbSchemaTable that returns a database schema. |
|
| Accessing Web Services from Windows Client |
| C#Today |
| Over the last several years, we have seen the Internet evolve from delivering static and simple HTML pages, into using dynamic, programmable and reusable web components. Microsoft's .NET framework introduces Web Services and SOAP that take the Internet a step further, by allowing the web applications to be more distributable, reusable and resourceful. In this article, Ravi Venkatarajalu look at how to combine the features of Web Services, SOAP and the .NET framework with Microsoft Excel 2000. We will also see how to serialize a Dataset and send it as part of a HTTP Request to a Web Service. |
|
| Adding Items to a DataView and DataTable |
| DotNetJunkies |
| In this article we'll be demonstrating how to add a new row to both a DataTable and a DataView. In the first part of this article we will briefly discuss the differences between a DataView and DataTable, then we'll give a code example and analysis of how to add a new item to each. The code will demonstrate how effecting one, has a direct effect on the other. |
|
| Adding Items to a DataView and DataTable |
| DotNetJunkies |
| In this article we'll be demonstrating how to add a new row to both a DataTable and a DataView. In the first part of this article we will briefly discuss the differences between a DataView and DataTable, then we'll give a code example and analysis of how to add a new item to each. The code will demonstrate how effecting one, has a direct effect on the other. |
|
| ADO .NET for the ADO Programmer |
| MSDN |
| ADO .NET is the latest in a long line of database access technologies that began with the Open Database Connectivity (ODBC) application programming interface (API) several years ago. Along the way, a number of interesting things happened. For example, COM landed at the database territory and started a colonization process that culminated with OLE DB. Next, ActiveX® Data Objects (ADO)—roughly an automation version of OLE DB—has been elected to govern the Visual Basic® and ASP community of Windows®-based database developers. |
|
| ADO.NET DataSet vs. ADO RecordSet Speed Tests |
| Egg Head Cafe |
| Comparitive performance tests between "old school" ADO RecordSets and new ADO.NET DataSets. |
|
| ADO.NET Overview |
| GotDotNet |
| GotDotNet presents an overview of accomplishing common data access tasks. Extract: "ADO.NET is an evolution of the ADO data access model that directly addresses user requirements for developing scalable applications. It was designed specifically for the web with scalability, statelessness, and XML in mind" |
|
| An ADO.NET multi-tier solution |
| The Code Project |
| A view of how ado.net can be used in a multi-tier environment. |
|
| An Easy-To-Use CacheManager |
| The Code Project |
| Using Cache is easy. Basically, you only need to use Insert to store data and use Get to access data. But you have to decide if the data is already in the cache, which in turn requires that you have a scheme to build a key. So you still have to do some work. The CacheManager serves to shield you from the details of managing the cache key. |
|
| ASP.NET Data Shaping |
| MSDN |
| Is it possible to port this model to Web Forms and get automatic synchronization between two DataGrid server controls? This is the question I will try to answer in this month's column. |
|
| BUG: XML Serialization Incorrectly Processes MaxOccurs="0" (Q319922) |
| http://www.kbalertz.com/ |
| You can use the XML Schema Definition Tool (Xsd.exe) to generate the common language runtime classes from an XML schema. When you do so, elements that have the |
|
| Building a Generic Database Tool Using .NET and Three Tier Architecture |
| DotNetJunkies |
| In this article, Sun shows how easy it is to develop a n–tiered Web application to create a generic database tool using ASP.NET and the .NET Framework. The system is quite simple and is able to handle the management of any simple table in any database. It provides an excellent starting point for providing a generic database tool. |
|
| Building a Master/Detail DataGrid for Database Inserts |
| DotNetJunkies |
| We are going to build an example Web Form that you can extend in your application. We will have two tables - OrderMaster and OrderDetails. As the names suggest the former is a master table where as the later is detail table. We want to add one record in the master table and several others in the detail table. We will not display any existing rows on the screen to maintain a clean page. |
|
| Building a Master/Detail DataGrid for Database Inserts |
| DotNetJunkies |
| In this article, Bipin explains how to build a Web Form where the requirement is inserting many rows of data against one row of master data. He builds an example Web Form that you can extend in your application with two tables - OrderMaster and OrderDetails. |
|
| Building a Moderated Discussion Forum in C# |
| C#Today |
| In this article Juan Martinez tackles one of the most common features on a website: A discussion forum. Forums are a primary tool for building online communities and driving traffic to the website. We will step through the development of a moderated discussion forum from scratch. Analysis, design, implementation and deployment will be covered to furnish a working moderated forum in C#. |
|
| Building a Web Service to Provide Real-Time Stock Quotes |
| DotNetJunkies |
| There are many benefits to using a Web Service, including the versatility of the client that consumes the Web Service and the reusability of the code. This article provides an example of a useful Web Service that provides real-time stock quotes through information scraped from public Web sites. |
|
| C++ Q&A |
| MSDN |
| Performance Optimization, Controls versus Components |
|