Scilligence MolEngine Cheminformatics Toolkit (7.0)
Scilligence.MolEngine.Companion
Database Class
Database Methods
BeginTrans Method
BuildListSql Method
BuildLoadSql Method
CacheMessage Method
CancelTrans Method
Cast Method
CombineColumn Method
Commit Method
CountRows Method
Create Method
CreateFromSettings Method
CustomTables Method
DecryptString Method
Delete Method
Dispose Method
Enclose Method
EncloseKey Method
Eq Method
ExeSql Method
ExeSqlReturnID Method
FunCeil Method
FunLeft Method
FunLen Method
GetConnection Method
GetLastExecutingTime Method
GetNetworkTime Method
GetSortBy Method
GetSortDirection Method
GetUser Method
GetUserID Method
InList Method
Insert Method
InsertReturnID Method
IsAdmin Method
IsAdministrator Method
IsEnclosed Method
IsNullable Method
IsQualifiedName Method
JoinRows Method
JoinTwoTrees(T) Method
KeyMap Method
LikeClause Method
LikeClause2 Method
LikeEndWith Method
LikeEndWith2 Method
LikeStartWith Method
LikeStartWith2 Method
LoopChildrenSql Method
MakeCommand Method
MakeCommand2 Method
MakeSearchText Method
MakeTree(T) Method
NotInList Method
OrderByGivenList(T) Method
PagingSql Method
PagingSQL Method
Pivot Method
ReadColumnTypes Method
ReadRow Method
ReadRowAsXml Method
RegisterProvider Method
ResetStatistics Method
RowNum Method
Rows2CSV Method
Rows2HtmlTable Method
RunOneSqlBlock Method
RunSqlBlocks Method
SafeToken Method
SaveMapping(T) Method
ScanHeaders Method
SelectBoolValue Method
SelectDict Method
SelectFile Method
SelectFiles Method
SelectList(T) Method
SelectRow Method
SelectRowReader Method
SelectRows Method
SelectSingleObject Method
SelectSingleString Method
SelectSingleValue(T) Method
SelectSql Method
SelectUniqueValues(T) Method
SelectValues Method
SortRows Method
SqlBracket Method
SqlEscapeStr Method
SqlSafe Method
SqlSafe2 Method
StrPlus Method
Suggest Method
ToDatetimeString Method
Top Method
ToUserDB Method
UnicodeLead Method
Update Method
UpdateOrInsert Method
UseDB Method
WrapStringArray Method
WriteCsvRows Method
WriteExcelRows Method
WriteHtmlRows Method
WriteHtmlTable Method
WriteJsonArray Method
WriteJsonDict Method
WriteJsonDictArray Method
WriteJsonDictObject Method
WriteJsonRow Method
WriteJsonRows Method
WriteJsonTree(T) Method
WriteJssdfXml Method
WritePagedJsonDictArray Method
WriteRows Method
WriteRows2CSV Method
WriteRows2Excel Method
WriteRows2SDF Method
WriteSdfRows Method
WriteTableXml Method
WriteXmlRows Method
Click or drag to resize

DatabasePivot Method

Namespace:  Scilligence.MolEngine.Companion
Assembly:  Scilligence.MolEngine.Companion (in Scilligence.MolEngine.Companion.dll) Version: 1.3.0.0 (7.0.0.40031)
Syntax
C#
Copy
public static DatabaseRow[] Pivot(
	DatabaseRow[] rows,
	string id,
	string[] pivotcols,
	string key,
	string value,
	string sep,
	string none
)

Parameters

rows
Type: Scilligence.MolEngine.CompanionDatabaseRow
id
Type: SystemString
pivotcols
Type: SystemString
key
Type: SystemString
value
Type: SystemString
sep
Type: SystemString
none
Type: SystemString

Return Value

Type: DatabaseRow
See Also