Finally i can read excel, thanks to all of you who responded. Now i though its easy as i think to extract from data table, here im searching for a specific record on excel then i need to select certain columns on that row of that record, my command statement looks like this ("Select ID, Surname, Course Where ID =" + id). Then i extract this on the datatable like this
Id = RD.GetTable().Rows.ToString(); Surname = RD.GetTable().Rows.ToString(); Course = RD.GetTable().Rows.ToString();
on the output i get "ITEMS", if you know what should i do please help me out.