oracleDataAdapter & Parameters
-
Hi to all, sorry me for my Inglish. I have a Problem: I want to select rows from my Oracle table which named "Table1" and I want to do it with oracleDataAdapter. It's OK when I use OleDbDataAdapter: ............ command.CommandText="select name from Table1 where num = ?"; Ole.OleDbDataAdapter ada=new Ole.OleDbDataAdapter(); ada.SelectCommand=com; command.Parameters.Add("@num",Ole.OleDbType.Numeric,3); command.Parameters[0].Value=1; ............ Can you give me this code with using the oracleDataAdapter and with parameters of oracleConnection. I had not find the using of oracle parameters in MSDN.At last can you give me Internet resource with the using of oracle in C#. Thanks. Gerder
-
Hi to all, sorry me for my Inglish. I have a Problem: I want to select rows from my Oracle table which named "Table1" and I want to do it with oracleDataAdapter. It's OK when I use OleDbDataAdapter: ............ command.CommandText="select name from Table1 where num = ?"; Ole.OleDbDataAdapter ada=new Ole.OleDbDataAdapter(); ada.SelectCommand=com; command.Parameters.Add("@num",Ole.OleDbType.Numeric,3); command.Parameters[0].Value=1; ............ Can you give me this code with using the oracleDataAdapter and with parameters of oracleConnection. I had not find the using of oracle parameters in MSDN.At last can you give me Internet resource with the using of oracle in C#. Thanks. Gerder