Connections to Oracle Databases

oracle| Data | database

String connectionstring= "user Id=ordtrc;pwd=ordtrc;data source=\" frame2db\ ";p ersist security info=false;"; /write Connection string
OracleConnection conn=new OracleConnection (ConnectionString);//Create a new connection

Try
{
Conn. Open ();
OracleCommand Cmd=conn. CreateCommand ();
cmd.commandtext= "SELECT * from Auth_busi";//write SQL statements here
OracleDataReader Odr=cmd. ExecuteReader ()//Create a Oracledatereader object
DataSet ds = new DataSet ();
while (ODR. Read ())//reading data, if the ODR. If Read () returns to false, it shows the end of the recordset
{
Response.Write (ODR. Getoraclestring (1). ToString ())//Output field 1, this number is the field index, how to use the field name is still pending research
}
Odr. Close ();
}
catch (Exception ee)
{
Response.Write (EE. message); If there is an error, output the error message
}
Finally
{
Conn. Close (); Close connection
}