Annu

Annu

  • NA
  • 1
  • 1.4k

Multiple selection problem in listbox

May 31 2012 1:48 AM

i have two feild building and unit.i want to populate unit value in one list box1.and finaly as per selection  unit value from listbox1 that unit and building value populate into two other list box..(insert building in listbox2 and insert unit in listbox3)

my code:
populate building and unit in listbox1

dtVacant =


OraDaVacant =

Library.objOracleConnection.Open();

OraDaVacant.Fill(dtVacant);

new DataTable();string strSelectVacant ="SELECT TEMC_BUILDING, TEMC_UNIT FROM TTCM_ESTATE_MASTER where TEMC_VAC_IND ='Y' order by 1";new OracleDataAdapter(strSelectVacant,Library.objOracleConnection);

lstVancantList.DataTextField = "TEMC_UNIT".Trim();

lstVancantList.DataValueField ="TEMC_BUILDING".Trim();

lstVancantList.DataBind();

lstVancantList.Items.Insert(0,"--Select Vacant List--");