| .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 |
|
| .NET Data Access Performance Comparison |
| http://aspalliance.com/ |
| This article attempts to compare several different data access techniques through the use of a stress testing tool. DataTables and DataReaders are compared with a number of different variables, and recommendations for best practices are provided. |
|
| 10 Things You Shouldn't Do with SQL Server (Data Access Developer "Don'ts") |
| DotNetJunkies |
| In this article Doug Seven will walk through 10 of the more common mistakes made by data access developers using SQL Server. |
|
| 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 Data Access Layer to Persist Business Objects Using Attributes and Reflection |
| The Code Project |
| 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 DetailsView Control for ASP.NET 1.x |
| MSDN |
| Dino Esposito builds an ASP.NET 1.x custom control that mimics the behavior and the programming interface of the ASP.NET 2.0 DetailsView control. |
|
| A DropDownList, EditItemTemplate, using Access, and HttpSessionState...Part 3 |
| DotNetJunkies |
| 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 <b>DataSet</b> into session state. We will not only be populating the <b>DataGrid</b> and <b>DropDownList</b> controls from this <b>DataSet</b>, but we will also be saving all the edits done by the user. This means that after the <b>DataSet</b> is initially created and put into session state there will be |
|
| A DropDownList, EditItemTemplate, using Access, and HttpSessionState...Part 4 |
| DotNetJunkies |
| In this article I will demonstrate how you
can save the changes made to the memory resident <b>DataSet</B>. |
|
| A generic loading of Data in a DropdownList using caching Mechanism |
| The Code Project |
| This article shows you how to make use of DataAccessLayer & Caching . |
|
| A Grouping and Subtotaling Repeater for ASP.NET |
| DotNetJunkies |
| 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 Modified C# Implementation of Tony Selkes TextFieldParser |
| The Code Project |
| A C# implementation of the TextFieldParser class submitted by Tony Selkes that includes the ability to put the schema in an XML file and load the data directly into a DataTable. |
|
| A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 1 |
| 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 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 |
|
| A Truly Excel-like Grid Control |
| MSDN |
| 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. |
|
| A Tutorial for Constructing a Plug-In Viewer |
| MSDN |
| 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 |
| MSDN |
| 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.
|
|
| 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 Data Using System.OleDb |
| 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 |
| MSDN |
| Use the .NET Oracle Provider in the Microsoft .NET Framework version 1.1 to access Oracle stored procedures and functions. |
|
| 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. |
|
| Adding a Blank Row to a DataGrid (Used to INSERT rather than UPDATE) |
| DotNetJunkies |
| 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. |
|
