| 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. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| 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. |
|
| Binding a DataGrid to an ADO Recordset |
| DotNetJunkies |
| Sooner or later you're going to need to bind a control to an ADO Recordset. The most likely reason is that you need to leverage a control written in COM that returns a recordset. As you will see, this is actually a very easy thing to do. |
|
| 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. |
|
| 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 Mass Emailer for Newsletters |
| DotNetJunkies |
| The article explains how to send out hundreds of thousands of personalized emails, from a dataset, using a 100% .NET managed application. Dave shows you how easy it is to build a mass mailer, called RapidMailer. |
|
| 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 an N-Tier Application in .NET |
| MSDN |
| After reviewing the types of n-tier applications, you'll learn how to create a typed dataset that can return data from a Web service and consume a Web service from a Windows application. |
|
| 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. |
|
| CodeSnip: Fill a DataGrid From an Access Database |
| http://aspalliance.com/ |
| This code demonstrates how to connect to and query a Microsoft Access database then bind those results to an ASP.Net datagrid for display as an HTML table. |
|
| Commands in ADO .NET |
| MSDN |
| In ADO there are three possible ways to update a data source. One is through direct SQL commands, like INSERT, DELETE and UPDATE, or more complex and sophisticated stored procedures. Another is through batch update, where you submit a new image of a certain table to the server all at once. The third way is through direct fields update using server cursors. |
|
| Common .NET Libraries for Developers |
| MSDN |
| Identifies and defines many of common namespaces that you will use when developing .NET applications, and provides examples of the most common classes and methods in those namespaces. |
|
| Coping with a New Beta - DataSetCommand to DataAdapter |
| DotNetJunkies |
| In ASP.NET Beta 1 we all got very used to using the DataSetCommand (SQLDataSetCommand or ADODataSetCommand). With the release of Beta 2 we have a little relearning to do. In this tutorial you will learn how to use the DataAdapter, the Beta 2 equivalent of the DataSetCommand. The downloadable sample code is in both C# and Visual Basic.NET |
|
| Data Access and Transaction Handling Framework |
| The Code Project |
| Generic data access component for different datasources, sprocs/sql, implicitly propagated transactions, explicitly managed transaction contexts etc. |
|
| Data Access with ADO.NET - Part 3 |
| ASP 101 |
| We now know how to access data and put it into a simple, readable form in our ASP .Net web pages, but there's so much more! In this article I am going to explain several more key objects that allow us to efficiently access our data in .Net. I will be using the OleDb flavor of ADO .Net classes for those of you who are not working with SQL Server, but just remember that if you are a SQL Server user, the difference is only in the naming of the classes you use and the connection string (refer to Part I of this series if you're not sure what I'm talking about). So let's get to work. |
|
