Advertisement
Guest User

Untitled

a guest
Oct 4th, 2011
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. at System.Data.OracleClient.Oci.OciStatementHandle.Prepare (System.String commandText) [0x00000] in <filename unknown>:0
  2. at System.Data.OracleClient.OracleCommand.PrepareStatement (System.Data.OracleClient.Oci.OciStatementHandle statement) [0x00000] in <filename unknown>:0
  3. at System.Data.OracleClient.OracleCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  4. at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  5. at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  6. at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0
  7. at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable, IDbCommand command, CommandBehavior behavior) [0x00000] in <filename unknown>:0
  8. at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable) [0x00000] in <filename unknown>:0
  9. at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Fill (System.Data.DataTable)
  10. at AktarmaSTOYS.OracleSideHandler.getData (System.String sql) [0x0001f] in /media/109b0d5b-fed9-4ca4-be7e-abccab4f083f/Source/AktarmaSTOYS/AktarmaSTOYS/AktarmaSTOYS/OracleSideHandler.cs:72
  11.  
  12. the code:
  13.  
  14. public static DataTable getData(string sql)
  15. {
  16. OracleConnection conn = new OracleConnection(_connectionString);
  17.  
  18. DataTable dt = new DataTable();
  19.  
  20. try {
  21.  
  22. conn.Open();
  23.  
  24. OracleDataAdapter da = new OracleDataAdapter(sql,conn);
  25.  
  26. da.Fill(dt);
  27.  
  28. conn.Close();
  29.  
  30. return dt;
  31.  
  32. } catch (Exception ex) {
  33. conn.Close();
  34. throw ex;
  35. }
  36. }
  37.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement