I am using MS Access Database.
Design in MSAccess as follows;
Faculty_Name Text
My Code as follows in Load button;
when i click the Load button faculty_Name to be retrieved from the DB and displayed in the List box.
string connstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= E:\\Projects\\Faculty Schedule\\Faculty Schedule\\Data\\HIMTTESTing.mdb;";
OleDbConnection OleDbCon = new OleDbConnection(connstring);
OleDbCon.Open();
string sql1 = "select Faculty_Name from Tb_SCH_Faculty_Details ";
OleDbCommand cmd = new OleDbCommand(sql1, OleDbCon);
OleDbDataReader reader = cmd.ExecuteReader();
{
Lb_Faculty_Name.Items.Add(reader);
}
OleDbCon.Close();
when i run in the List box the Faculty_Name is not displaying.
from my above code what is the mistake.how can i do.please help me.
[Edit]Code block added by Jibesh[/Edit]