No Data.. urgent

  • Thread starter Thread starter sandy
  • Start date Start date
S

sandy

Dear all, i am using the following code to get data from
Oracle Database. My query returns say 400 records.
Sometime the datase dows not return any records, but if i
reduce the number of columns in the query, i can get all
tthe records.. any idea?


DataSet dsTmp = new DataSet();
OracleDataAdapter daOracle = new OracleDataAdapter();
string strOracle = OracleSqlManager.GetParsedSql
(SqlNumber, hsTmp);
OracleCommand cmdSelect = new OracleCommand(strOracle);
cmdSelect.Connection = this.OraCon;
daOracle.SelectCommand = cmdSelect;
daOracle.Fill(dsTmp);
 
Sometime the datase dows not return any records, but if i
reduce the number of columns in the query, i can get all
tthe records.. any idea?
Click to expand...

So, what's the query?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
http://www.takempis.com
Big Things are made up of
Lots of Little Things.
 
Back
Top