| .NET Anatomy - ADO.NET in Beta2 : Part 1 |
| DotNetJunkies |
| This article reviews the ADO.NET object model found in Microsoft’s .NET Framework Beta2. The information presented here will be useful both to programmers who worked with Beta1 and also, to those just starting with the framework. |
|
| A Database Admin Tool in 20 Lines of C# Code |
| ASP Alliance |
| This example illustrates how to create a one page database administration tool with only 20 lines of C# code. Using this example, you can enter almost any Sql statement into a text box and execute the statement against any tables in your database. You can view the results of a SELECT in a DataGrid or the see the affects of UPDATE, INSERT and DELETE statements. |
|
| 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 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. |
|
| 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 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. |
|
| Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET |
| MSDN |
| Discover how to generate XML from a dataset, format the XML using a Stylesheet, and then use code to open the transformed XML. |
|
| Authenticate Web Service |
| C# Corner |
| In this example we will build a web service that authenticates userid and password from an a very simple MS Access database. This web service exposes only one method to the client. This method takes input username and password, checks the values in the table, and if found returns the remaining fields from the table. |
|
| Auto-Generating Wrapper Classes for Stored Procedures, Part 1: Using the AutoSproc Tool |
| MSDN |
| Get an overview of the AutoSproc code generation tool and how it works. The AutoSproc tool (based on classes exposed from the System.Reflection.Emit namespace) saves you time by using reflection to auto-generate wrapper classes for stored procedure calls. |
|
| Auto-Generating Wrapper Classes for Stored Procedures, Part 2: The Internals of the AutoSproc Tool |
| MSDN |
| Review the AutoSproc tool, which uses a code generation technique using classes from the System.Reflection.Emit namespace. It is assumed that the reader is fully conversant with the System.Reflection namespace, but not System.Reflection.Emit or CIL. |
|
| Basic Content Management System with ASP.NET and MS Access |
| The Code Project |
| A very basic web-based content management system using ASP.NET and MS Access |
|
| BETA-HOWTO: Transfer XML Data to Microsoft Excel 2002 Using Visual C# .NET (Q307029) |
| Microsoft Support |
| Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 by using either the user interface or code. With Visual C# .NET, you can take advantage of Excel's XML functionality to seamlessly transfer data to a workbook to present the data with formatting and an arrangement of your choice. This article demonstrates how to accomplish this task. |
|
| BETA-PRB: No Method in DataReader Closes Its Underlying Connection (Q310369) |
| Microsoft Support |
| The DataReader object does not include a property to retrieve its underlying connection. Although you can close DataReader and then close the OleDbConnection or SqlConnection object on which DataReader was opened, DataReader does not have a built-in connection. Thus, if you retrieve a DataReader from a component method, you cannot close the underlying connection. That is, if you retrieve a DataReader object from a component, the DataReader stays connected, and there is no way to disconnect it.
|
|
| BookStock v2- Samples to Show Simple OleDb.NET Connectivity |
| Master C# |
| The bookstock example I had previously created for .NET SDK beta1 consisted of 3 samples to show how to perform basic ADO.NET connectivity with a Ms Access 2000 Database and how to Add, View , Edit , Delete records from it. It also demonstrates how to DataBind Textboxes to a DataSet object. |
|
| BUG: The Scale Value for Oracle Numeric Parameter Is Ignored (Q317528) |
| http://www.kbalertz.com/ |
| When you set the scale for a parameter of type NUMBER, it does not affect the value of the parameter that is passed to the database. |
|
| Build a Universal DAL Component |
| DotNetJunkies |
| Think about the possibilities of a component in the data access layer (DAL) of your application that didn't care what .NET Data Provider you were using. It could work just as easily with the SQL Server Data Provider or the OleDb Data Provider, or any other potential .NET Data Providers that could surface in the future. A DAL component that you could use against an Access 2000 database in development, and against a SQL Server database in production. In this tutorial, Doug shows how to build a universal data |
|
| 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 Redirector to Binary Files |
| DotNetJunkies |
| In this How-To Doug Seven shows you how to build a Web Form to handle redirects to binary files, such as MP3's or images, when the path information is stored in an Access database. |
|
| Building a Universal DAL Component |
| DotNetJunkies |
| Think about the possibilities of a component in the data access layer (DAL) of your application that didn't care what .NET Data Provider you were using. It could work just as easily with the SQL Server Data Provider or the OleDb Data Provider, or any other potential .NET Data Providers that could surface in the future. A DAL component that you could use against an Access 2000 database in development, and against a SQL Server database in production. |
|
| Building Windows Forms on-the-fly with XML and C# |
| C#Today |
| In this article, Ashiwn Kamanna takes the concept of an XML driven Form builder a step further than the basics as he discusses how to eliminate the requirement for Form development, not only in an ASP based web application, but also in any potential client of an application. He discusses how to build a Form dynamically in a C# based windows application, and also discusses some object oriented patterns as he walks us through an example. |
|
| C# / Oracle Example |
| C# Help |
| This is a GUI based data entry application which shows how to add, modify and delete records using Oracle Database. This also shows how to use the ErrorProvider for validations. |
|
| C# DB Connection With Beta 2 |
| C# Help |
|
|
