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--");
Replies
Know the answer? Post it — somebody with the same question will find it here.