asp连接oracle实例,asp.net连接oracle实例

[TestMethod]

public void LinkOracle()

{

OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

try

{

conn.Open();

OracleCommand cmd = conn.CreateCommand();

cmd.CommandText = "select * from newtable";

OracleDataReader odr = cmd.ExecuteReader();

while (odr.Read())

{

Console.Write(odr[0].ToString());

}

odr.Close();

}

catch (Exception ee)

{

Console.WriteLine("link error!/r/n" + ee.ToString());

}

finally

{

conn.Close();

}

}