How do I select a field from paradox table

See more:

C#

I am trying to select a specific field from a paradox table.In my sample app I created I can only retrieve and load the table into a dataset and not just a specific field

This my code

private void qButton1_Click(object sender, EventArgs e)
        {
            OleDbConnection oledbParadoxconn = new OleDbConnection();



            {
                string Sqltext = @"Select * from Clockd.EmpNo";



             

                string oledbconnstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Program Files\\Supertime\\db;Extended Properties=Paradox 5.x;";
                                
                oledbParadoxconn.ConnectionString = oledbconnstr;

                oledbParadoxconn.Open();

                OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(Sqltext, oledbParadoxconn);
                
                DataSet dtgetdata = new DataSet();

                myDataAdapter.Fill(dtgetdata, "table1");

                this.metroGrid1.DataSource = dtgetdata;

                this.metroGrid1.DataMember = "table1";


        }

Is there a different way to select a specific field from a paradox table.The Clockd is the table and the EmpNo is the specific field I want to use.
Any help in the right direction would be appreciated