MBR IT/.NET 247 : System.Data.DataTable Class [Articles]

A C# Web Spider written as a Web Service

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

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 Data Access Layer to Persist Business Objects Using Attributes and Reflection

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

Then I came up with the idea of creating classes that would say how they should be persisted in the database. I would use attributes to say what database table my object should be persisted to, as well as other attributes to say what are the properties that should be mapped to table columns. From now on to update my code after a change in the solution I would only change the business object class.

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 Grouping and Subtotaling Repeater for ASP.NET

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

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

A recent project had a user interface requirement where data could be displayed two ways: either in chronological order or grouped by family member. I solved the "not so easy" grouping by family member requirement by modifying the Repeater control, as you'll see in this article.

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 Truly Excel-like Grid Control

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

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.

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.

Abstracting ADO .NET

Access Database Editor in C#

With the release of Microsoft® .NET just around the corner, developers are gearing up to take advantage ot the many features, increased interoperability, and better data integration that the new framework promotes. While COM and Visual Basic® 6.0 are still widely used and will likely live on for years to come, I've met many developers who are anxious to get moving with the .NET components. Some of the questions I am asked most often regarding .NET are how developing with ActiveX Data Objects (ADO) 2.x will change under ADO .NET and how can you still abstract ADO into a data service component. So, in this month's Data Points column, I'll try to tackle these issues.

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 9i Stored Procedures Using ADO.NET

Accessing Oracle Database

Use the .NET Oracle Provider in the Microsoft .NET Framework version 1.1 to access Oracle stored procedures and functions.

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.

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

ADO.NET – Get Notification Events from Managed Providers

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.