Hi Guys.
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[0][0].ToString();
              Surname = RD.GetTable().Rows[0][2].ToString();
              Course = RD.GetTable().Rows[0][3].ToString();

on the output i get "ITEMS", if you know what should i do please help me out.

After few minutes i found it dont mind this, Thanks to Daniweb team

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.