<script>
jQuery(document).ready( init )
function init()
{
var dbnetcombo1 = new DbNetCombo("dbnetcombo1");
with (dbnetcombo1)
{
connectionString = "SamplesDatabase"
addEmptyOption = true
emptyOptionText = "Please select a customer ...";
sql = "select CustomerID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax from customers order by companyname"
bind("onChange", displayCustomer);
initialize()
}
}
function displayCustomer(combo)
{
var ids = ["contactname","address","city","region","country","phone","fax"]
for (var i=0; i < ids.length; i++)
{
var val = "";
var opt = combo.selectedOption();
if (opt.length > 0)
if (opt[0].value != "")
val = opt[0].getAttribute(ids[i]);
jQuery("#" + ids[i]).val(val);
}
}
</script>