DBCombo Replacement

Sam Heller

Currently in the process of updating a project from V.1.1 to V.2. Previous project implemented a Drop down combo box which included auto complete. This drop down no longer works in V.2 and support is poor and no updates are available. We attempted using the Ajax extender control but the issue with this is it can only retrieve a single column of data. For most of the scenarios we are using it in we require a unique id to be retrieved too. Due to the original control being a drop down list it had a text and value attribute so could store this informaiton. Does anyone know of a new third party control or other solution that would fix this issue? Thanks

Dr_X

I had it working with Ajax beta 1. I think it was beta 1 or an earlier version. Project is on hold for now. Anyway, take a look below. Might be helpful as it did work. It also had add-on-the-fly option. aspx's javascript

function lfV()
{
//onkeydown="blur();"
  try {
    ListData.GetVesselID(document.getElementById('<%= Vessel.ClientID %>').value, vesselIDReturn);
 } catch(e) { alert(e.message); }
}

function vesselIDReturn(vesselID)
{
  if (vesselID==0)
  {
    //alert("vesselIDReturn");
    if (!(document.getElementById('<%= butSave.ClientID %>')==null))
    {
      if (document.getElementById('<%= Vessel.ClientID %>').value.length > 3) {
        if (confirm("The vessel, '" + document.getElementById('<%= Vessel.ClientID %>').value 
            + "' does not exist. Please confirm it is spelled correctly with out abbreviations before adding. \\n"
            + "Would you like to add the new vessel, '" + document.getElementById('<%= Vessel.ClientID %>').value + "'?")) 
        {
          //alert(uid);
          ListData.AddVessel(document.getElementById('<%= Vessel.ClientID %>').value, uid, AddVesselIDReturn);
        }
      }
    }
  }
  else
  {
    document.getElementById('<%= VesselID.ClientID %>').value=vesselID;
    document.getElementById('<%= butRefreshList.ClientID %>').click();
  }
}

function AddVesselIDReturn(vesselID)
{
  try
  {
    if (vesselID==0)
    {
      alert("Failed to add new vessel.");
    }
    else
    {
      document.getElementById('<%= VesselID.ClientID %>').value=vesselID;
    }  
  } catch(e) { alert(e.message); }
}

aspx's html