.NET 247

.NET Anatomy - Data Concurrency in ADO.NET, Part III

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 Data Persistence: SQL Server vs. Matisse vs. FastObjects

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

An article with source code examining the development speed and performance capability of .NET, Matisse and FastObjects

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 DropDownList, EditItemTemplate, using Access, and HttpSessionState...Part 3

A DropDownList, EditItemTemplate, using Access, and HttpSessionState...Part 4

Here we are at part three of this article! In this part we will be adding one new feature to the code! Instead of making a call to the database to get the data on each request we are going to be saving the DataSet into session state. We will not only be populating the DataGrid and DropDownList controls from this DataSet, but we will also be saving all the edits done by the user. This means that after the DataSet is initially created and put into session state there will be

A First Look at ObjectSpaces in Visual Studio "Whidbey"

In this article I will demonstrate how you can save the changes made to the memory resident DataSet.

A generic loading of Data in a DropdownList using caching Mechanism

An interesting new feature in Visual Studio "Whidbey" is ObjectSpaces, an Object/Relational mapping tool fully integrated with ADO.NET. You design application features using objects, and ObjectSpaces reads and writes to data sources using SQL statements.

A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 1

This article shows you how to make use of DataAccessLayer & Caching .

A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 2

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 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 purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid

A simple string to value parser

The purpose of this document is to provide a practical guide to using Microsoft’s .NET DataTables, DataSets and DataGrid

A Truly Excel-like Grid Control

A simple string to value parser

A Tutorial for Constructing a Plug-In Viewer

The ASP.NET DataGrid control generates an HTML output that really seems to be the Web counterpart of a Microsoft Excel worksheet. In addition, the control supports features like selection and in-place editing that can only further confirm this similarity. With in-place editing, in particular, the similarities are most clear. You click on a special type of command column and the grid redraws its content using text boxes rather than static text. At the same time, the command column changes the layout, replacing the edit link with two other links—one for saving and one for canceling changes. The overall design looks nearly identical to the Excel name box command bar.

Access Database Editor in C#

Step through the process of implementing a plug-in viewer and integrating it into Analysis Services. Get stub code that enables you to quickly write a plug-in viewer into Analysis Services.

Accessing Data Using System.OleDb

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.

C# Help

This simple application demonstates several aspects of object-oriented programming in C#. It builds a simple class called "Batters" with several fields and then populates their values by retrieving data from an Access Database. In my research on how to retrieve data using System.OleDb I found that there wasn't any one help file that demonstated how to put it all together. I hope this helps.

Accessing Oracle Database

C# Corner

This source code shows you how to connect to an oracle database and do operations such as select, insert, update and delete.

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 a Blank Row to a DataGrid (Used to INSERT rather than UPDATE)

Adding Blank Rows to a DataGrid

In this article we will be illustrating one way to add a blank row to a DataGrid. Why would you want to do this? Who knows, maybe to enable a user to add a new record. This article will show you how to add a new row to a DataGrid by manipulating its DataSource - in this example a DataTable. Note that we will be simulating saving the new item back to the database.

Adding Items to a DataView and DataTable

In one application I had the requirement to add a blank row after every 10 rows in a DataGrid rather than use paging. There is no in-built way to do this with the DataGrid, but it can be easily done by modifying the DataTable that the DataGrid is bound to and by writing some code in the DataGrids ItemDataBound event. This how-to article will describe how it is done.

Adding Items to a DataView and DataTable

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