Introduction
Getting Started
Adding DbNetSuite to Visual Studio
Configuration Settings
ConnectionStrings
DbNetSuiteTinyMCELocation
DbNetSuiteCultureSource
DbNetSuiteLicenseId
DbNetSuiteLicenseKey
DbNetSuitejQueryNoInclude
DbNetSuitejQueryNoConflict
DbNetSuiteAntiXSS
Implementing DbNetSuite in your own application
Implementing DbNetSuite as a client-side object
Implementing DbNetSuite as a server-control
Database Connectivity
Databases
SQL Server
Access
Access 2007
Oracle
MySql
DB2
Visual FoxPro
VistaDB
dBASE
Pervasive
Firebird
Postgresql
ADO.NET Data Providers
SqlClient
OleDb
OracleClient
MySql
DB2
VistaDB
Pervasive
Firebird
Odbc
Npgsql(PostgreSql)
Creating a custom database connection
Customising the look & feel
Version History
Upgrading from 3.x
DbNetGrid
Client-side implementation
Server control implementation
DbNetEdit
Client-side implementation
Server-control implementation
Client-side programming
jQuery
DbNetLink.Util
dateToString
stringToDate
sizeWindowToContent
webMethod
Date Format Specifiers
Interfacing with server-side code
Server-side programming
DbNetLink.DbNetData
DbNetGrid
Client API Reference
Properties
Basic Properties
connectionString
fromPart
Additional Properties
advancedSearch
advancedSearchDialog
autoRowSelect
caption
chartConfig
chartSerialize
columnPickerDialog
commandTimeout
customProfileProperties
customSave
dbNetSpell
dragAndDrop
editControl
editDialog
editDialogHeight
filterColumnMode
fixedFilterSql
fixedFilterParams
fixedOrderBy
groupBy
height
mailMergeDocuments
multiRowSelect
multiRowSelectLocation
optimizeForLargeDataSet
orderBy
outputCurrentPage
outputPageSize
pageSize
parentFilterSql
parentFilterParams
procedureName
procedureParameters
profileUser
searchDialog
searchDialogHeight
searchDialogMode
searchFilter
searchFilterSql
searchFilterParams
searchFilterText
selectModifier
simpleSearch
simpleSearchDialog
spellCheck
standardSearch
table
totalRows
updateMode
width
Toolbar Properties
chart
columnPicker
config
copy
deleteRow
insertRow
mailMerge
navigation
outputPageSelect
pageInfo
print
quickSearch
rowInfo
save
search
sort
toolbarLocation
updateRow
userProfile
userProfileSelect
Column Properties
Basic Properties
columnExpression
label
primaryKey
Additional Properties
aggregate
autoIncrement
baseTableName
booleanDisplayMode
bulkInsert
display
edit
editControlType
editControlProperties
editDisplay
editFormat
editLookup
editMaxThumbnailHeight
editStyle
filter
filterMode
foreignKey
format
inlineEdit
initialValue
insertReadOnly
isBoolean
lookup
lookupSearchMode
maxThumbnailHeight
readOnly
required
search
searchLookup
sequenceName
simpleSearch
spellCheck
style
totalBreak
toolTip
updateReadOnly
unique
uploadExtFilter
uploadMaxFileSize
uploadOverwrite
uploadRootFolder
width
Methods
addLinkedControl
addNestedGrid
bind
buildChart
columnValue
executeSingletonQuery
getInputControl
initialize
loadData
refreshListOptions
refreshRow
rowPrimaryKey
selectedRows
setColumnExpressions
setColumnLabels
setColumnProperty
toolbarElement
toolButtonText
Events
onBeforeBulkInsert
onBeforeEditInitialized
onBeforeInitialized
onBeforeMailMerge
onBeforeOutput
onBeforeRecordDeleted
onBeforeRecordValidated
onCellTransform
onColumnSort
onColumnValidate
onDependentListLoaded
onEditDialogInitialized
onFieldValueChanged
onFilterColumnChange
onOutput
onHeaderCellTransform
onInitialized
onPageLoaded
onParentFilterAssigned
onRecordDeleteError
onRecordDeleted
onRecordInsertError
onRecordInserted
onRecordSelected
onRecordUpdateError
onRecordUpdated
onRecordValidate
onRowSelected
onRowTransform
onSearchDialogApply
onUniqueConstraintViolated
onValidationFailed
Server API Reference
Basic Properties
ConnectionString
FromPart
GridColumns
Additional Properties
AdvancedSearch
AutoRowSelect
Caption
ChartConfig
ChartSerialize
CommandTimeout
CustomProfileProperties
CustomSave
DbNetSpell
DragAndDrop
EditDialogHeight
FilterColumnMode
FixedFilterSql
FixedFilterParams
FixedOrderBy
GridClientEvents
GroupBy
Height
LinkedControls
MailMergeDocuments
MultiRowSelect
MultiRowSelectLocation
NestedGrid
OptimizeForLargeDataSet
OrderBy
OutputCurrentPage
OutputPageSize
PageSize
ProcedureName
ProcedureParameters
ProfileUser
SearchDialogHeight
SearchDialogMode
SelectModifier
SimpleSearch
SpellCheck
StandardSearch
ToolbarLocation
UpdateMode
Toolbar Properties
Chart
ColumnPicker
Config
Copy
DeleteRow
InsertRow
MailMerge
Navigation
OutputPageSelect
PageInfo
Print
QuickSearch
RowInfo
Save
Search
Sort
UpdateRow
UserProfile
UserProfileSelect
Grid Column Properties
Basic Properties
ColumnExpression
Label
PrimaryKey
Additional Properties
Aggregate
AutoIncrement
BaseTableName
BooleanDisplayMode
BulkInsert
Display
Edit
EditControlType
EditFormat
EditLookup
EditMaxThumbnailHeight
EditStyle
Filter
FilterMode
ForeignKey
Format
InlineEdit
InitialValue
InsertReadOnly
IsBoolean
Lookup
LookupSearchMode
MaxThumbnailHeight
ReadOnly
Required
Search
SearchLookup
SequenceName
SimpleSearch
SpellCheck
Style
TotalBreak
ToolTip
Unique
UpdateReadOnly
UploadExtFilter
UploadMaxFileSize
UploadOverwrite
UploadRootFolder
Width
Dialogs
Edit Dialog
Properties
closeOnApply
editControl
Search Dialogs
Standard Search Dialog
Simple Search Dialog
Advanced Search Dialog
Column Picker Dialog
Configuration Dialog
PDF Settings Dialog
Column Sort Selection Dialog
User Profiles Dialog
Charting
Chart Configuration Dialog
Pre-configuring the grid to display a chart
Manually assigning the configuration object
Custom Attributes
DbNetEdit
Client API Reference
Properties
Basic Properties
connectionString
fromPart
Additional Properties
advancedSearch
advancedSearchDialog
browseDialogHeight
browseDialogWidth
commandTimeout
customProfileProperties
dbNetSpell
fixedFilterSql
fixedFilterParams
insertOnly
orderBy
parentFilterSql
parentFilterParams
primaryKey
profileUser
searchDialog
searchDialogHeight
searchDialogMode
searchFilter
searchFilterSql
searchFilterParams
searchFilterText
simpleSearch
simpleSearchDialog
spellCheck
standardSearch
totalRows
Toolbar Properties
deleteRow
insertRow
navigation
quickSearch
search
sort
toolbarLocation
userProfile
userProfileSelect
Column Properties
Basic Properties
columnExpression
label
primaryKey
Additional Properties
autoIncrement
browse
display
editControlType
editControlProperties
foreignKey
format
initialValue
insertReadOnly
isBoolean
lookup
lookupSearchMode
maxThumbnailHeight
readOnly
required
search
searchLookup
sequenceName
simpleSearch
spellCheck
style
toolTip
unique
updateReadOnly
uploadExtFilter
uploadMaxFileSize
uploadOverwrite
uploadRootFolder
width
Methods
addInputControlButton
addLinkedControl
addToolbarButton
bind
columnValue
executeSingletonQuery
getInputControl
initialize
initializeInsert
refreshListOptions
selectRecord
setColumnExpressions
setColumnLabels
setColumnProperty
setInputControlValue
toolbarElement
Events
onBeforeInitialized
onBeforeRecordDeleted
onBeforeRecordValidated
onBeforeTinyMceInit
onColumnValidate
onDependentListLoaded
onEditDialogInitialized
onFieldValueChanged
onInsertInitialize
onInitialized
onPageLoaded
onParentFilterAssigned
onRecordDeleteError
onRecordDeleted
onRecordInsertError
onRecordInserted
onRecordSelected
onRecordUpdateError
onRecordUpdated
onRecordValidate
onSearchDialogApply
onUniqueConstraintViolated
onValidationFailed
Server API Reference
Basic Properties
ConnectionString
FromPart
EditColumns
FormTemplate
Additional Properties
AdvancedSearch
BrowseDialogHeight
BrowseDialogWidth
CommandTimeout
CustomProfileProperties
DbNetSpell
EditClientEvents
FixedFilterSql
FixedFilterParams
InsertOnly
LinkedControls
OrderBy
ProfileUser
SearchDialogHeight
SearchDialogMode
SimpleSearch
SpellCheck
StandardSearch
Toolbar Properties
DeleteRow
InsertRow
Navigation
PageInfo
QuickSearch
Search
Sort
Edit Column Properties
Basic Properties
ColumnExpression
Label
PrimaryKey
Additional Properties
AutoIncrement
Browse
Display
EditControlType
ForeignKey
Format
InitialValue
InsertReadOnly
IsBoolean
Lookup
LookupSearchMode
MaxThumbnailHeight
ReadOnly
Required
Search
SearchLookup
SequenceName
SimpleSearch
SpellCheck
Style
ToolTip
Unique
UpdateReadOnly
UploadExtFilter
UploadMaxFileSize
UploadOverwrite
UploadRootFolder
Width
Dialogs
Search Dialogs
Standard Search Dialog
Simple Search Dialog
Advanced Search Dialog
Column Sort Selection Dialog
User Profiles Dialog
DbNetFile
Client API Reference
Properties
Basic Properties
rootFolder
rootFolderAlias
Additional Properties
allowFolderDeletion
autoSelectFolder
browseMode
createFolder
customMimeTypes
displayStyle
displayWindowFeatures
fileInfoList
fileSelectionAction
folderPathLocation
headerRow
height
indexingServiceCatalog
maxSearchMatches
orderBy
pageSize
previewDialogHeight
previewDialogWidth
searchDialog
searchMode
selectableFileTypes
selectionMode
thumbnailHeight
thumbnailPercent
thumbnailWidth
toolbarLocation
uploadFileTypes
uploadOverwrite
uploadMaxFileSizeKb
visibleFileTypes
width
Toolbar Propeties
deleteRow
newFolder
search
upload
Column Properties
Basic Properties
columnType
label
Additional Properties
browseDisplay
format
search
searchDisplay
selectable
Methods
addLinkedControl
addToolbarButton
bind
initialize
setColumnLabels
setColumnProperty
setColumnTypes
toolbarElement
Events
onBeforeDocumentDisplayed
onBeforeFileDeleted
onBeforeFileSelected
onBeforeInitialized
onCellTransform
onFolderSelected
onInitialized
onPageLoaded
onRowSelected
Appendix
FileInfo object
Column Types
File System Column Types
Windows Search Column Types
System
Audio
Document
Image
Media
Music
Photo
Search
Video
Indexing Service Column Types
Server API Reference
Basic Properties
RootFolder
RootFolderAlias
FileColumns
Additional Properties
AllowFolderDeletion
AutoSelectFolder
BrowseMode
CreateFolder
CustomMimeTypes
DisplayStyle
FileClientEvents
FileSelectionAction
FolderPathLocation
HeaderRow
IndexingServiceCatalog
LinkedControls
MaxSearchMatches
OrderBy
PageSize
PreviewDialogHeight
PreviewDialogWidth
SearchMode
SelectableFileTypes
SelectionMode
ThumbnailHeight
ThumbnailPercent
ThumbnailWidth
ToolbarLocation
UploadFileTypes
UploadMaxFileSizeKb
UploadOverwrite
VisibleFileTypes
Width
WindowsSearchConnectionString
Toolbar Properties
DeleteRow
NewFolder
Search
Upload
File Column Properties
Basic Properties
ColumnType
Label
Additional Properties
BrowseDisplay
Format
IndexingServiceColumnType
Search
SearchDisplay
Selectable
WindowsSearchColumnType
Dialogs
File Search Dialog
File Search Results Dialog
File Preview Dialog
File Upload Dialog
DbNetSpell
Client API Reference
Properties
connectionString
createButton
dictionaryTableName
Methods
checkSpelling
registerElement
Events
onElementSpellCheckCompleted
onInitialized
onSpellCheckCompleted
Server API Reference
Properties
ConnectionString
CreateButton
DictionaryTableName
SpellCheckElements
SpellClientEvents
DbNetCombo
Client API Reference
Properties
connectionString
addEmptyOption
emptyOptionText
parameters
sql
Methods
addLinkedControl
clear
initialize
load
selectedOption
Events
onBeforeItemsLoaded
onChange
onInitialized
onItemsCleared
onItemsLoaded
Server API Reference
AddEmptyOption
ConnectionString
ComboClientEvents
EmptyOptionText
LinkedControls
Sql
DbNetList
DbNetList Client Reference
Properties
connectionString
headerRow
parameters
rowSelection
sql
treeImageUrl
Column Properties
display
format
label
selectable
Methods
addNestedList
initialize
columnValue
getCell
load
setColumnProperty
Events
onBeforeItemsLoaded
onInitialized
onItemsLoaded
onLinkSelected
onRowSelected
onRowTransform
DbNetList Server Reference
Properties
ConnectionString
HeaderRow
ListClientEvents
ListColumns
NestedList
Parameters
RowSelection
Sql
TreeImageUrl
Column Properties
ColumnExpression
Display
Format
Label
Selectable

© 2010 DbNetLink Limited