converts a data reader with serialized fields into a typed data set

Namespace: DotNetNuke.Common
Assembly: DotNetNuke (in DotNetNuke.dll)

Syntax

C#
public static DataSet BuildCrossTabDataSet(
	string DataSetName,
	IDataReader result,
	string FixedColumns,
	string VariableColumns,
	string KeyColumn,
	string FieldColumn,
	string FieldTypeColumn,
	string StringValueColumn,
	string NumericValueColumn,
	CultureInfo Culture
)
Visual Basic
Public Shared Function BuildCrossTabDataSet ( 
	DataSetName As String,
	result As IDataReader,
	FixedColumns As String,
	VariableColumns As String,
	KeyColumn As String,
	FieldColumn As String,
	FieldTypeColumn As String,
	StringValueColumn As String,
	NumericValueColumn As String,
	Culture As CultureInfo
) As DataSet

Parameters

DataSetName
Type: System..::..String
Name of the dataset to be created
result
Type: System.Data..::..IDataReader
Data reader that contains all field values serialized
FixedColumns
Type: System..::..String
List of fixed columns, delimited by commas. Columns must be contained in DataReader
VariableColumns
Type: System..::..String
List of variable columns, delimited by commas. Columns must be contained in DataReader
KeyColumn
Type: System..::..String
Name of the column, that contains the row ID. Column must be contained in DataReader
FieldColumn
Type: System..::..String
Name of the column, that contains the field name. Column must be contained in DataReader
FieldTypeColumn
Type: System..::..String
Name of the column, that contains the field type name. Column must be contained in DataReader
StringValueColumn
Type: System..::..String
Name of the column, that contains the field value, if stored as string. Column must be contained in DataReader
NumericValueColumn
Type: System..::..String
Name of the column, that contains the field value, if stored as number. Column must be contained in DataReader
Culture
Type: System.Globalization..::..CultureInfo
culture of the field values in data reader's string value column

Return Value

The generated DataSet

See Also