| 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>. |
|
| Accessing database in the .Net environment |
| The Code Project |
| An extremely flexible and easy-to-use library that retrieves data in XML format, supports simple parameterized queries, stored procedures, and transactions. It can also be used as a web service. |
|
| 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. |
|
| Building a Custom Data Provider for Use with the .NET Data Access Framework |
| MSDN |
| The System.Data.dll assembly in the .NET Framework contains namespaces whose base classes can be used to create custom data providers. These namespaces also define a number of data access interfaces and base classes that let developers create data providers that will interoperate with other custom providers. Using the ADO.NET classes Connection, Command, DataReader, and DataAdapter, writing a provider is easier than writing one for OLE DB. This article explains these classes and their implementation, and how they can be used to write a variety of different kinds of data providers. |
|
| 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. |
|
| 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. |
|
| Discussion Forum Board |
| Master C# |
| This example updates the previous forum example that I had written for beta1. A lot has changed since then, even though from outside the forum has the same looks internally a lot has changed! Due to this I have taken the trouble to elaborate this example into easy to understand pieces. |
|
| How do I add a DropDownList to EditItemTemplate, Using an Access Database (And Then Some)? |
| DotNetJunkies |
| In a recent artlicle we discussed how to populate a DropDownList box from within a DataGrid's Column while the DataGrid was in "edit mode". Well, this article builds off that example, and adds some new elements and features. First, instead of using the SQL we are going to use Access - specifically, the Northwind database. Second, when filling the DropDownList we aren't going to make a seperate call to the database to get the data - instead we are going to use a DataView and filter out the specific rows we n |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| Microsoft Support |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| How to read and write a file to or from a BLOB column by using ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317016) - This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
|
| HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual Basic .NET |
| http://www.kbalertz.com/ |
| (308049) - There are several ways to use ADO.NET to call a stored procedure and to get back return values and return parameters, including: Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the... |
|
| HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual J# .NET |
| Microsoft Support |
| (320627) - There are several ways to use ADO.NET to call a stored procedure and to get back return values and return parameters, including: Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the... |
|
| HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual J# .NET |
| http://www.kbalertz.com/ |
| (320627) - There are several ways to use ADO.NET to call a stored procedure and to get back return values and return parameters, including: Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual Basic .NET |
| http://www.kbalertz.com/ |
| (316887) - This article explains how to read and write data from BLOB (LongVarBinary) columns in a database table. NOTES : This article provides examples of both the SqlClient and the OleDb DataAdapter . The only differences, apart from class names, are the... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual C++ .NET |
| http://www.kbalertz.com/ |
| (317017) - Use this step-by-step guide to read and write data to and from BLOB (LongVarBinary) columns in a database table. NOTES This article contains examples for both the SqlClient and the OleDb DataAdapter classes. The only differences, apart from the class... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual Basic .NET |
| http://www.kbalertz.com/ |
| (317034) - This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Unlike with ADO 2.6 and later, ADO.NET does not support reading... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual C# .NET |
| http://www.kbalertz.com/ |
| (317043) - This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, you may have to retrieve a large... |
|
| HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual C++ .NET |
| http://www.kbalertz.com/ |
| (317044) - This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, sometimes you may need to retrieve... |
|
| HOW TO: Retrieve the Identity Value While Inserting Records into Access Database By Using Visual C# .NET |
| http://www.kbalertz.com/ |
| (816112) - This step-by-step article discusses how to retrieve the identity column value from an Access database. Retrieving the Identity value from a Jet database is different from that of SQL Server, because a Jet database does not support multi-statement... |
|
| HOW TO: Retrieve the Identity Value While Inserting Records into Access Database By Using Visual C# .NET |
| Microsoft Support |
| (816112) - This step-by-step article discusses how to retrieve the identity column value from an Access database. Retrieving the Identity value from a Jet database is different from that of SQL Server, because a Jet database does not support multi-statement... |
|
| Using Parameterized Query in ASP.NET |
| 4Guys from Rolla |
| One of the cool and useful things ADO.NET supports is the use of parameterized queries. Parameterized queries aren't a new feature, in fact some of you may already use them in traditional ASP programming. For those not familiar with parameterized queries they are queries that have one or more embedded parameters in the SQL statement. This method of embedding parameters into a SQL statement is, in my opinion, more straightforward and less prone to error than the method of dynamically building up a SQL string. |
|
| Working with MS Access Stored Procedures in VB.NET. Part 2 |
| devCity.NET |
| Welcome to part two of Access Stored Procedures. Part one described in detail how to create stored procedures in Access using ADO.NET and Visual Basic.NET. Part two will demonstrate how to utilize the stored procedures created in part one by assembling a Database Tier that can be modelled and used in your own applications. This article will describe in detail one implementation of a Database Tier for Visual Basic.NET.
|
|
| Writing a Messenger Application Using C# - Part 1 |
| C#Today |
| A messenger application provides users with a simple way to communicate instantly with each other. This article covers an approach to writing a sample realtime chat messenger application, much like the existing ones like MSN, Yahoo, AOL etc using C#. In this first part of this article, Saravana Kumar covers the data model, the core functionality assembly, the server, and how it is configured using .NET remoting to expose it to remote clients. The second part of the article will cover the client applications. |
|
