O’reilly related

[ 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.

3p luvpro 04-08-2010 100 4   Download

[ Team LiB ] Recipe 2.1 Retrieving Hierarchical Data into a DataSet Problem You want to fill a DataSet with parent and related child data, even if the DataSet already has a schema that includes the relationship. Solution There are several techniques you can use to load parent and child data into a DataSet.

4p luvpro 04-08-2010 78 6   Download

[ Team LiB ] Recipe 2.20 Retrieving Data from an Oracle Package Problem Given an Oracle package that returns multiple result sets for related tables as REF CURSOR data types, you want to access this data using a DataReader and load the data into a DataSet. Solution Use the data type OracleType.Cursor .

5p luvpro 04-08-2010 91 7   Download

[ Team LiB ] Recipe 9.9 Improving Performance While Filling a DataSet Problem Given a DataSet containing many related tables that takes a long time to fill

6p luvpro 04-08-2010 93 6   Download

[ Team LiB ] Recipe 4.5 Adding Parent/Child Rows with Auto-Incrementing Keys Problem You want to insert related parent/child rows into a DataSet where the primary key of the parent table is an automatically incrementing value.

4p luvpro 04-08-2010 105 6   Download

[ Team LiB ] Recipe 4.6 Adding Records with a GUID Primary Key Problem You want to add records to a DataTable that uses a GUID as its primary key and has related child records. Solution Use the DataTable.RowChanging event handler.

4p luvpro 04-08-2010 86 5   Download

Introduction The DataSet is a disconnected, in-memory relational database that provides sophisticated navigational capabilities. It acts as a container for other objects including DataTable, DataColumn, DataRow, and DataRelation.

7p luvpro 04-08-2010 75 4   Download

[ 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.

4p luvpro 04-08-2010 71 6   Download

[ Team LiB ] Recipe 2.2 Building a DataSet Programmatically Problem You want to build a DataSet programmatically—including adding tables, columns, primary keys, and relations—from a schema that you have designed.

4p luvpro 04-08-2010 73 5   Download

B.5. Startup Problems Not every problem you encounter is related to running applications. Sometimes trouble strikes before you even get that far. The following are examples.

4p daisuphu 28-07-2010 71 5   Download