PL/SQL and C# TextBox
520094Dec 14 2006 — edited Dec 15 2006Dear Friends,
I'm Just Fresh and new user of Dot Net plateform, I'm using C# as development tool.
My PL/SQL query fetch data from Oracle 9i Database.
I would be grateful if you guide me HOW CAN I SHOW DATA from executing PL/SQL code to a C# Form TextBox?
Do i need to work with Oracle procedures. Pls just little explain.
I've used all these itmes one by one. But it does'nt fullfil my requirement.
cmd.ExecuteNonQuery(query);
cmd.ExecuteReader(query);
cmd.ExecuteScaler(query);
When ShowData_Button_Pressed:
string my_query=
" Declare "+
" V_Ename Varchar2(20); "+
" V_Sal Number; "+
" Begin "+
" Select Empno,Ename,Sal "+
" Into V_Empno,V_Ename,v_Sal "+
" From Scott.Emp "+
" Where Empno=7788; "+
//Dbms_output.Put_line(v_ename ||' gets '||v_sal ||' as Salary.');
//SCOTT gets 3000 as Salary.
" End; ";
/*-------------------------------------------------------------------------------------*/
How can i show name Scott and his salary into a C# Form TextBox.
Mr.Khurram Nazir.