在Asp.net下连接Oracle的方法

OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr_oracle"].ConnectionString);//读web.config中的数据库连接参数
        try
        {
            conn.Open();
            OracleCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select dept_name from dept_dict where dept_code='"+TextBox1.Text.Trim()+"'";
            OracleDataReader odr = cmd.ExecuteReader();            
            while (odr.Read())
            {
                TextBox1.Text = odr.GetOracleString(0).ToString();
            }
            odr.Close();
        }
        catch (Exception ee)
        {
           Button1.Text=ee.Message;
        }
        finally
        {
            conn.Close();
        }