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();
}
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();
}