连接数据库查询表

private static void Main(string[] args)
{
var str =
"DATA SOURCE=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ip)(PORT=1521))(CONNECT_DATA=(SID=orcl)));User Id=gyaici;Password=gyaici";

var sql = @"select a.TABLE_NAME
from user_tables a,user_tab_comments b
WHERE a.TABLE_NAME=b.TABLE_NAME
order by TABLE_NAME ";
var con = new OracleConnection(str); ///连接数据库
try
{
con.Open();
Console.WriteLine(con.State.ToString());
var ds = new DataSet();

var cmd = new OracleCommand(sql, con); ///执行语句
var dap = new OracleDataAdapter(cmd);
dap.Fill(ds);
var dataTable = ds.Tables[0];

for (var j = 0; j < dataTable.Rows.Count; j++)
{
for (var i = 0; i < dataTable.Columns.Count; i++)
{
Console.Write(dataTable.Rows[j][dataTable.Columns[i].ToString()]);

}
Console.WriteLine();
}

Console.ReadKey();
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}