José Perez
asked on
C# / ORACLE/ODP query Select * from v$version
Hi,
after a succesful connection to the database I want to run the query "Select * from v$version where banner like '%Oracle'"
how can I display the result in a multiline Textbox? (This is the part I am having the issue, it displays nothing)
This the code I have:
after a succesful connection to the database I want to run the query "Select * from v$version where banner like '%Oracle'"
how can I display the result in a multiline Textbox? (This is the part I am having the issue, it displays nothing)
This the code I have:
conn.Open();
string strSQL = "select * from v$version WHERE banner LIKE '%Oracle'";
OracleCommand cmd = new OracleCommand(strSQL, conn);
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
reader.GetString(0);
txtQuery.Text = reader;
}
conn.Close();
conn.Dispose();
conn = null;
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER