This is a practical book that tells you how to write C# programs using some of the most common design patterns. It also serves as a quick introduction to programming in the new C# language. The pattern discussions are structured as a series of short chapters, each describing a design pattern and giving one or more complete working, visual example programs that use that pattern. Each chapter also includes UML diagrams illustrating how the classes interact. This book is not a “companion” book to the well-known Design Patterns text. by the “Gang of Four.” Instead, it is a tutorial for people who want to learn what design patterns are about and how to use them in their work. You do not have to have read Design Patterns to read this book, but when you are done here you may well want to read or reread it to gain additional insights.
Introduction to Server-Side Data
Connections, Commands, and DataSets
Accessing SQL-based Data
Binding SQL Data to a DataGrid
Performing a Parameterized Select
Inserting Data in a SQL Database
Updating Data in a SQL Database
Deleting Data in a SQL Database
Sorting Data from a SQL Database
Working with Master-Detail Relationships
Writing and Using Stored Procedures
Accessing XML-based Data
You are creating an ASP.NET application for EliteCertify’s Internet Web site. You want to create a toolbar that will be displaed at the top of each page in the Web site. The toolbar will contain only static HTML code. The toolbar will be used in only your application. You plan to create the toolbar as a reusable component for your application. You need to create the toolbar as quickly as possible. What should you do?
SQL Anywhere 10 contains a number of integration features with Microsoft Visual Studio .NET (both 2003 and 2005). These features are designed to make it easier to work with a SQL Anywhere database while developing an application using Visual Studio. This whitepaper outlines the integration features that are present with Visual Studio 2005, and contains tutorials demonstrating how the integration features can be used to ease application development while working with a database.
This lesson describes how to configure and work with data in a DataGridView control. The DataGridView is typically used to display the contents of a DataTable in a DataSet. This lesson shows how to:
- Use the DataGridView control to display and update the data.
- Bind a DataGridView control to a data source.
- Configure a DataGridView to use multiple data sources.
- Manage columns in a DataGridView control.
- Format a DataGridView control by using styles.
- Format a DataGridView control by using custom painting.
- Configure the column and cell types of a DataGridView.
- Add tables and columns to a DataGridView control.
- Delete columns in a DataGridView control.
- Respond to clicks in a DataGridView control.
- Validate input with a DataGridView control.
- Change data displayed in a DataGridView control at run time.