This application shows how you can integrate DbNetGrid and DbNetFile to create simple document management system that creates and associates a folder using the customer code. Documents can then be uploaded into this folder to be associated with the customer. In addition DbNetFile also allows you to search through the documents including the content (subject to Indexing Server being enabled). Select a customer using DbNetGrid and the contensts of the customer's document folder will be displayed automatically using DbNetfile.

Customers

Documents

Include the Javascript library file

Client-side script

window.onload = initialise

var dbnetfile1, dbnetgrid1

//////////////////////////////////////////////////////////////////////////////////////////////
function initialise()
//////////////////////////////////////////////////////////////////////////////////////////////
{
	dbnetfile1 = new DbNetFile( "dbnetfile1" )
	with (dbnetfile1)
	{
		smallButtons = true
		createRootFolder = true
		columns = ['name', 'size', 'type', 'dateCreated']
	}

dbnetgrid1 = new DbNetGrid( "dbnetgrid1" )
	with ( dbnetgrid1 )
	{
		connectionString = "suite"
		fromPart = "customers"
		view = true
		selectPart = ["CustomerId", "CompanyName", "ContactName"]
		headings = ["Account Code", "Company", "Contact"]
		primaryKeyColumn = "customerid"

print = false
		config = false
		columnPicker = false
		copy = false
		help = false
		save = false
		sort = false
		editRow = false

onRowSelected = customerSelected

loadData()
	}
}

//////////////////////////////////////////////////////////////////////////////////////////////
function customerSelected(grid)
//////////////////////////////////////////////////////////////////////////////////////////////
{
	with (dbnetfile1)
	{
		rootFolder = '/data/customer_docs/' + grid.currentRow.id
		rootFolderAlias = grid.currentRow.cells[1].innerHTML
		initialise()
	}
}