DbNetSuite Sample

Example

Source

Menu

|

|

Run as

Documents and images can be maintained by uploading them to the file system and storing the path in the database or by uploading the file directly into a database column capable of storing binary data. The samples demostrate the storing of images and documents in both the file system and the database as a BLOB. When storing a file in the file system you specify the uploadRootFolder property to identify the location. The types of files that can be uploaded is restricted using the uploadExtFilter property. For images the maximum size of thumbnail images can be controlled via the column maxThumbnailHeight property.

Storing images in the file system	Storing documents in the file system
Storing images in the database	Storing documents in the database

Include the client JavaScript & CSS libraries

	<link rel="stylesheet" type="text/css" href="dbnetsuite.css.ashx" />
	<script language="JavaScript" src="dbnetsuite.js.ashx"></script>

Client-side configuration script

	<script>
	jQuery(document).ready( init )

	function init()
	{
		var dbnetgrid1 = new DbNetGrid("dbnetgrid1");
		with (dbnetgrid1)
		{
			connectionString = "SamplesDatabase"
			fromPart = "Documents"
			setColumnExpressions("DocumentID","DocumentDescription","FilePath")
			setColumnLabels("Document ID","Description","Image")
			setColumnProperty("FilePath",{uploadRootFolder:"~/samples/Files",uploadExtFilter:"png,jpg,gif"})
			setColumnProperty("FilePath","uploadOverwrite",true)

			fixedFilterSql = "FilePath like '%.png' or FilePath like '%.jpg' or FilePath like '%.gif'";
			initialize()
		}

		var dbnetgrid2 = new DbNetGrid("dbnetgrid2");
		with (dbnetgrid2)
		{
			connectionString = "SamplesDatabase"
			fromPart = "Employees"
			setColumnExpressions("EmployeeID","FirstName","LastName","Photo");
			setColumnProperty("Photo",{uploadExtFilter:"png,jpg,gif", maxThumbnailHeight:100});
			setColumnProperty("EmployeeID","primaryKey", true);
			pageSize = 2
			initialize()
		}

		var dbnetgrid3 = new DbNetGrid("dbnetgrid3");
		with (dbnetgrid3)
		{
			connectionString = "SamplesDatabase"
			fromPart = "Documents"
			setColumnExpressions("DocumentID","DocumentDescription","FilePath")
			setColumnLabels("Document ID","Description","PDF")
			setColumnProperty("FilePath",{uploadRootFolder:"~/samples/Files",uploadExtFilter:"pdf"})
			setColumnProperty("FilePath","uploadOverwrite",true)
			fixedFilterSql = "FilePath like '%.pdf'";

			initialize()
		}

		var dbnetgrid4 = new DbNetGrid("dbnetgrid4");
		with (dbnetgrid4)
		{
			connectionString = "SamplesDatabase"
			fromPart = "Documents"
			setColumnExpressions("DocumentID","DocumentDescription","Blob")
			setColumnLabels("Document ID","Description","PDF")
			setColumnProperty("Blob","uploadExtFilter","pdf");
			setColumnProperty("DocumentID","primaryKey", true);
			fixedFilterSql = "FilePath is null";
			initialize()
		}
	}
	</script>

HTML markup

<table>
	<tr>
		<td style="vertical-align:top">
			<fieldset>
			<legend>Storing images in the file system</legend>
				<div id="dbnetgrid1"></div>
			</fieldset>
		</td>
		<td style="vertical-align:top">
			<fieldset>
			<legend>Storing documents in the file system</legend>
				<div id="dbnetgrid3"></div>
			</fieldset>
		</td>
	</tr>
	<tr>
		<td style="vertical-align:top">
			<fieldset>
			<legend>Storing images in the database</legend>
				<div id="dbnetgrid2"></div>
			</fieldset>
		</td>
		<td style="vertical-align:top">
			<fieldset>
			<legend>Storing documents in the database</legend>
				<div id="dbnetgrid4"></div>
			</fieldset>
		</td>
	</tr>
</table>