Click here to Skip to main content
15,867,777 members
Home / Discussions / C#
   

C#

 
GeneralRe: Displaying lines of code as a program runs Pin
Roger Alsing30-Apr-08 21:48
Roger Alsing30-Apr-08 21:48 
QuestionFile Structure Serialization Pin
Ian Uy30-Apr-08 20:05
Ian Uy30-Apr-08 20:05 
AnswerRe: File Structure Serialization Pin
carbon_golem1-May-08 2:59
carbon_golem1-May-08 2:59 
GeneralRe: File Structure Serialization Pin
Ian Uy1-May-08 3:05
Ian Uy1-May-08 3:05 
GeneralRe: File Structure Serialization Pin
carbon_golem1-May-08 3:41
carbon_golem1-May-08 3:41 
GeneralRe: File Structure Serialization Pin
Ian Uy1-May-08 3:49
Ian Uy1-May-08 3:49 
GeneralRe: File Structure Serialization Pin
carbon_golem1-May-08 3:57
carbon_golem1-May-08 3:57 
QuestionPlease Help !Query executing in oracle but not executing through code Pin
ravindradonkada30-Apr-08 19:46
ravindradonkada30-Apr-08 19:46 
<>Hi,

This is ravindra ,I created the following function and able to execute the followed query
successfully in sql plus but when i try to execute the same query through code,getting error like



Unspecified error
Oracle error occurred, but error message could not be retrieved from Oracle.
Data type is not supported.







Create or Replace Function convert_time(datetime in timestamp, tz1 in varchar2, tz2
in varchar2)
Return timestamp with time zone
as
retval timestamp with time zone;
Begin
retval := from_tz(datetime, tz1) at time zone tz2;
return retval;
End;


select convert_time(to_timestamp('01/01/2006 23:45','mm/dd/yyyy
hh24:mi'),'US/Eastern','Turkey') from dual;




the .net code as follows


string conn = "Provider=MSDAORA.1;Password=;User ID=;Data Source=naradaon;Extended
Properties=Server=naradaon";

OleDbConnection con = new OleDbConnection(conn);

con.Open();

DataSet ds = new DataSet();

OleDbDataAdapter da = new OleDbDataAdapter("select from_tz(to_timestamp('01/01/2006
23:45','mm/dd/yyyy hh24:mi'),'-05:00') as hio from dual", con);


da.Fill(ds);


Please help me



thank you


<>
AnswerRe: Please Help !Query executing in oracle but not executing through code Pin
Christian Graus30-Apr-08 20:18
protectorChristian Graus30-Apr-08 20:18 
AnswerRe: Please Help !Query executing in oracle but not executing through code [modified] Pin
Mircea Puiu1-May-08 4:46
Mircea Puiu1-May-08 4:46 
QuestionDetect Shift when Menu Opens Pin
Chris_McGrath30-Apr-08 19:28
Chris_McGrath30-Apr-08 19:28 
AnswerRe: Detect Shift when Menu Opens Pin
Chris_McGrath30-Apr-08 19:45
Chris_McGrath30-Apr-08 19:45 
QuestionHOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
syamooo30-Apr-08 18:55
syamooo30-Apr-08 18:55 
AnswerRe: HOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
Christian Graus30-Apr-08 19:18
protectorChristian Graus30-Apr-08 19:18 
GeneralRe: HOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
syamooo30-Apr-08 19:38
syamooo30-Apr-08 19:38 
GeneralRe: HOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
Christian Graus30-Apr-08 19:53
protectorChristian Graus30-Apr-08 19:53 
GeneralRe: HOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
Zoltan Balazs30-Apr-08 20:00
Zoltan Balazs30-Apr-08 20:00 
GeneralRe: HOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
Christian Graus30-Apr-08 20:13
protectorChristian Graus30-Apr-08 20:13 
GeneralRe: HOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
Zoltan Balazs30-Apr-08 20:30
Zoltan Balazs30-Apr-08 20:30 
GeneralRe: HOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
Christian Graus30-Apr-08 20:39
protectorChristian Graus30-Apr-08 20:39 
GeneralRe: HOW TO CREATE AN INSTANCE OF INTERNET EXPLORER AND HOW TO USE IT? Pin
Anthony Mushrow1-May-08 1:38
professionalAnthony Mushrow1-May-08 1:38 
QuestionHow to Intercept WebBrowser Control default download with my custom downloader? Pin
Anindya Chatterjee30-Apr-08 18:10
Anindya Chatterjee30-Apr-08 18:10 
AnswerRe: How to Intercept WebBrowser Control default download with my custom downloader? Pin
Anthony Mushrow1-May-08 1:47
professionalAnthony Mushrow1-May-08 1:47 
GeneralRe: How to Intercept WebBrowser Control default download with my custom downloader? Pin
Spacix One1-May-08 8:50
Spacix One1-May-08 8:50 
GeneralRe: How to Intercept WebBrowser Control default download with my custom downloader? Pin
Anthony Mushrow1-May-08 11:36
professionalAnthony Mushrow1-May-08 11:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.