Sir i am new in this fild,so plz help me
i want to retriv two column in ListBox from oracle table,i am able to retriv one column and my coding is this but i also want to retrive second column also.
my coding is
************************************************** ******************************************
strconn = new OleDbConnection();
strconn.ConnectionString= "Provider=msdaora.1;userid=payroll;password=payrol l; data source=payroll";
strconn.Open();
strsql = "select * from Employee where BillUnit=" + DdlBillUnit.SelectedItem.ToString() + " ";
OleDbCommand cmd1 = new OleDbCommand(strsql, strconn);
OleDbDataReader reader1 = cmd1.ExecuteReader();
LbUnselectedEmp1.DataValueField = "NAME";
LbUnselectedEmp1.DataSource = reader1;
LbUnselectedEmp1.DataBind();
reader1.Close();
strconn.Close();
************************************************** ******************************************
here i display NAME but i also want to display TITLE
please help