|
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> |