[ Team LiB ] Recipe 7.10 Creating Custom Columns in a Windows Forms DataGrid Problem You need to create a DataGrid having columns with custom formatting and attributes. Solution Use the DataGridTableStyle class. The sample code contains two event handlers
[ Team LiB ] Recipe 2.16 Mapping Table and Column Names Between the Data Source and DataSet Problem You want to control the names assigned to tables and columns when you fill a DataSet using a DataAdapter.
[ Team LiB ] Recipe 6.8 Creating Constraints, PrimaryKeys, Relationships Based on Multiple Columns Problem You need to create a constraint, primary key, or a relationship between two tables in a DataSet using more than one column. Solution Use the System.Data.
[ Team LiB ] Recipe 8.9 Formatting Column Values When Outputting Data as XML Problem You need to save some of the columns in a DataTable as attributes instead of elements when you write out the data as XML. Solution Use the ColumnMapping property.
[ Team LiB ] Recipe 3.2 Using Expression Columns to Display Calculated Values Problem You need to display a calculated value for each row in a DataTable and to filter and sort the table on this value. Solution Add an expression column to the table and display it.
[ Team LiB ] Recipe 2.17 Displaying Columns from a Related DataTable Problem You want to add a column to a DataTable that displays a value from a row in a related table in the DataSet. Solution Use expression columns to retrieve lookup values based on DataRelation objects.
[ Team LiB ] Recipe 10.4 Determining the Length of Columns in a SQL Server Table Problem The FillSchema( ) method of the DataAdapter returns the correct length in the MaxLength property for string columns in a SQL Server database, but it returns -1 for the length of all other fields.
Bases Round Tapered Round Non-Tapered Square Non-Tapered
Pacific Columns products are esteemed throughout the world for possessing the quintessential blend of Authenticity, Elegance, and Durability. With the richest line of designs, styles, and materials, Pacific Columns offers the most extensive series of columns and capitals in the industry. With extensive product knowledge, abundant capacity, and a history of excellence, Pacific Columns is qualified to effectively handle your order; whether you're working on a small weekend project or large development....
[ Team LiB ] Recipe 9.7 Improving DataReader Performance with Column Ordinals Problem You want to use column ordinals rather than column names to retrieve data from a DataReader to improve application performance and without hard-coding
[ Team LiB ] Recipe 6.7 Enforcing Business Rules with Column Expressions Problem You need to enforce a business rule based on multiple columns in a table at the user interface tier. Solution Use expression-based columns to enforce business rules at the user interface tier.
[ Tam LiB ] Recipe 10.3 Retrieving Column Default Values from SQL Server Problem The DataColumn object exposes a Default property. While the FillSchema( ) method of the DataAdapter returns schema information, it does not include the default values for columns.
[ Team LiB ] Recipe 4.1 Using Auto-Incrementing Columns Without Causing Conflicts Problem You want to use an AutoIncrement column in a table without producing values that may be duplicated in records added by other users. Solution Use the AutoIncrementSeed and AutoIncrementStep properties of the AutoIncrement column.
[ Team LiB ] Recipe 3.7 Using Expression Columns to Display Aggregate Values Problem You want to add summary information such as averages, sums, and counts to a table based on related child rows. Solution Use expression columns to perform aggregate calculations based on child rows.