OracleDataAdapter的Fill方法 public DataSet GetDs() { DataSet ds = new DataSet();
string sql = @"select p.provincename,c.cityname,a.areaname from area a left join city c on a.cityid=c.cityid left join province p on a.provinceid=p.provinceid where rownum<11;"; string connStr = "。。。";
OracleConnection conn = new OracleConnection(connStr); conn.Open();
OracleDataAdapter da = new OracleDataAdapter(sql, conn);