从Oracle数据库表中填充DataTable - C#

Question

当数据库是Access时，我已经成功构建了连接字符串并能够填充表格数据：

DataTable results = new DataTable();
using (OleDbConnection thisConnection = new OleDbConnection(connectionname))
            {
                OleDbCommand cmd = new OleDbCommand("SELECT * from TABLE_A", thisConnection);  //EDIT : change table name for Oracle
                thisConnection.Open();
                OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
                adapter.Fill(results);
            }

虽然我是新手，但我想知道如何修改上述代码以适应Oracle数据库？

- user7157732

---

是的，但怎么做？@ChrisCruz - user7157732

Answer 1

你可以尝试这个方法；

OracleConnection conn = new OracleConnection("Your Connection string");

//Open the connection to the database
conn.Open();

DataSet dataSet = new DataSet();

OracleCommand cmd = new OracleCommand("your select query");

cmd.CommandType = CommandType.Text;

cmd.Connection = conn;

using (OracleDataAdapter dataAdapter = new OracleDataAdapter())
{
  dataAdapter.SelectCommand = cmd;
  dataAdapter.Fill(dataSet);
}

- Caner Tezcan