Question

求助，C#查询oracle数据库返回行数的问题

如题，就是要返回table表的行数，本人不熟悉oracle的操作，请好心人帮我把下面的代码补全，只要得到行数就行。

OracleConnection conn = new OracleConnection();

conn.ConnectionString = ....
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from table";
conn.Open();

Answer 1

select count(*) from table
c#几年不看了,具体语法忘记了
大概也就是connection,然后statement 然后执行sql 然后返回一个ResultSet 再取出结果集

Answer 2

......
OracleDataAdapter adp= new OracleDataAdapter("select * from table", conn);
DataTable tbl = new DataTable();
adp.Fill(tbl);
int rowCount = tbl.Rows.Count();

Answer 3

OracleConnection conn = new OracleConnection();
conn.ConnectionString = ....
conn.Open();
OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = "select count(*) from table";
int count = cmd.ExecuteScalar();