Question

C#执行select语句

string sqltext = (@"select x from A where y = 'Z');

把这句语句执行后在text里显示出来怎么写？

Answer 1

在看你放在哪里了，比如说datatable里，那就是lbltext.text=dt.rows[0][0].tostring();

Answer 2

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + file);
conn.Open();
DataTable dtList = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter("select x from A where y = 'Z'", conn);
da.Fill(dtList);
int len = dtList.Rows.Count;
StringBuilder sb = new StringBuilder();
for (int i = 0; i < len; i++)
{
sb.AppendLine(dtList.Rows[i].ItemArray[0]);
}
MessageBox.Show("读取的数据为\r\n" + sb.ToString());

Answer 3

楼上的可以试下