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

Accessing database in the .Net environment

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.

ADO.NET 2.0 Feature Matrix

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.

An Evaluation of Stored Procedures for the .NET Developer

ADO.NET 2.0 includes a new base-class provider model, features for all providers, and changes to System.Data.SqlClient. Get an overview of these new features, examples of their use, and a chart of which features are provider-neutral and SqlClient-specific.

In this introduction to SQL Server stored procedures for .NET developers you’ll discover the pros and cons of using stored procedures, take a look at related Visual Studio .NET 2003 tools, and more.

ASP.NET Data Shaping

ASP.NET DataGrid Paging Part 2 - Custom Paging

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.

ASP.NET Letter Paging Based on Data Content

In this article Doug Seven shows you how to use the DataGrid custom paging feature. The code is in C# and it uses stored procedures in SQL Server 2000.

Auto-Generating Wrapper Classes for Stored Procedures, Part 1: Using the AutoSproc Tool

Paged table data display in DataGrid by selecting letter from a letter list which is derived from existing data.

Auto-Generating Wrapper Classes for Stored Procedures, Part 2: The Internals of the AutoSproc Tool

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.

Building a Basic Flash MX Page with ASP.NET and SQL Server

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

This how-to article describes how to create a basic Flash MX login interface that utilizes ASP.NET and SQL Server 2000.

Building a Moderated Discussion Forum in C#

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.

C#Today

In this article Juan Martinez tackles one of the most common features on a website: A discussion forum. Forums are a primary tool for building online communities and driving traffic to the website. We will step through the development of a moderated discussion forum from scratch. Analysis, design, implementation and deployment will be covered to furnish a working moderated forum in C#.

C# Photo Album Viewer

ColdStorage Advertising Service Development

This sample is a C# Windows application that uses a SQL Server 2000 database to store and retrieve images. Images are organized under albums in a treeview and displayed in a picturebox when selected. An static control is used to display a description of the album or image. Context menus on the treeview allow the user to add, rename, and delete images or albums. Descriptions can also be edited by selecting a context menu item.

ColdStorage XML Web Service Development

This article describes some of the issues faced and lessons learned in the development of the ColdStorage sample Advertising Service.

This article describes the issues encountered during the development of the ColdStorage Web Service.

Commands in ADO .NET

Coping with a New Beta - Data Server Control Templates and Editing

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.

Creating a Details Popup Window Grid in a DataGrid

The .NET Framework Beta 2 has many changes that will break applications written in Beta 1. Among these changes is the templates used in Data Server Controls, such as the DataGrid and DataList. These are simply syntax changes in how templates are used, not programmatic breaks. In this tutorial you will learn how to use Data Server Control templates. Heck, since it’s a Friday I’ll also show you how to do DataGrid editing at the same time. The downloadable sample code for this article contains files in both Vi

Creating a Details Popup Window Grid in a DataGrid

In this article, Donny walks through an example illustrating how to make a HyperLinkColumn in a DataGrid spawn events that would pop up a new window with details of the row that the user clicked on.

Creating a Parameterized Query

This articles topic came from the suggestion of a true DotNetJunkie. He originally sent an email to us asking for an example illustrating how to make a HyperLinkColumn in a DataGrid spawn events that would pop up a new window with details of the row that the user clicked on. Before we could anwser his email he had already emailed us back explaining that he had found a way to do it and suggested a tutorial of his discovery. So, here it is!

NG Code

Even though we strongly urge people to always use stored procedures there are times when you just can't. The following demonstrates how to create a parameterized query without the use of a stored procedure.

Creating a Stored Procedure for Custom Paging with the ASP.NET DataGrid Control

Creating and Saving Images to a Database in ASP.NET

The DataGrid control is the most flexible and robust data bound control offered by ASP.NET. The DataGrid control renders as an HTML table in the user’s Web browser that can contain any other combination of controls, can be dynamically manipulated using scripts and server-side code, accommodates in-row editing and updating of displayed data, sorting of columns, and built-in paging. The built-in paging supplied by the DataGrid control may either be semi-automatically managed by the control or be manually mana

Data Access and Transaction Handling Framework

While I was developing an e-commerce site, I was faced with the problem of populating a SQL database with large and thumbnail product images for each product. Uploading two different sizes of the same image for a product seemed time-consuming and not practical, so I automated this process and you'll see the code in this how-to article.