DbNetList

Top  Previous  Next

DbNetList is a browser based list component that can be populated from the database. It can be implemented as either a client-side object or a server-control.

 

 

Example client-side implementation code

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

	function init()
	{
		var dbnetlist1 = new DbNetList("dbnetlist1");

		with (dbnetlist1)
		{
			connectionString = "SamplesDatabase"
			sql = "select LastName, FirstName, BirthDate, HireDate from employees order by 1"
			setColumnProperty("BirthDate","format","D")
			setColumnProperty("HireDate","format","MMMM yyyy")
			headerRow = true
			rowSelection = true
			initialize()
		}

	}
	</script>

 

Example server-side implementation code

<DNL:DbNetList 
	id="DbNetList1" 
	runat="server" 
	ConnectionString = "SamplesDatabase"
	Sql = "select LastName, FirstName, BirthDate, HireDate from employees order by 1"
	HeaderRow = "true"
	RowSelection = "true"
	Style="border:1pt solid silver"
	>
	<ListColumns>
		<DNL:ListColumn ColumnExpression="BirthDate" Format="D"/>
		<DNL:ListColumn ColumnExpression="HireDate" Format="MMMM yyyy"/>
	</ListColumns>
</DNL:DbNetList>