如何从paradox表中选择一个字段

本文介绍了如何从paradox表中选择一个字段的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试从一个paradox表中选择一个特定字段。在我创建的示例应用程序中，我只能检索并将表加载到数据集中，而不仅仅是特定字段 这是我的代码

private void qButton1_Click（ object sender，EventArgs e） { OleDbConnection oledbParadoxconn = new OleDbConnection（）; { string Sqltext = @ 从Clockd.EmpNo中选择*; string oledbconnstr = Provider = Microsoft.Jet.OLEDB.4.0;数据源= c：\\Program Files \\Supertime\\db;扩展属性= 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 = 表1; }

有不同的选择方式来自悖论表的特定字段.Tlockd是表格，EmpNo是我想要使用的特定字段。 任何正确方向的帮助都将受到赞赏

解决方案

从我的评论中发布解决方案，因为OP说它有效。

字符串Sqltext = @从Clockd中选择EmpNo;

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

解决方案

Posting solution from my comment as OP has said it works.

string Sqltext = @"Select EmpNo from Clockd";