System.Data.OracleClient.dll方式操作oracle数据库
发布时间:2020-12-12 13:46:23 所属栏目:百科 来源:网络整理
导读:System.Data.OracleClient.dll方式操作oracle数据库 一.查询语句: using (OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings[ " local_Orcl " ].ConnectionString)) { conn.Open(); using (Oracl
System.Data.OracleClient.dll方式操作oracle数据库 一.查询语句: using (OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["local_Orcl"].ConnectionString)) { conn.Open(); using (OracleCommand cmd = conn.CreateCommand()) { try { cmd.CommandText = "select * from HLB_HIS_REQUISITION"; DataTable dt = null; OracleDataAdapter adapter = new OracleDataAdapter(); adapter.SelectCommand = cmd; dt = new DataTable(); adapter.Fill(dt); cmd.Parameters.Clear(); dataGridView1.DataSource = dt; } catch (Exception ee) { MessageBox.Show(ee.Message.ToString() + "rn" + ee.StackTrace.ToString()); cmd.Dispose(); conn.Close(); conn.Dispose(); } } } ? 二.插入语句: using (OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["local_Orcl"].ConnectionString)) { conn.Open(); using (OracleCommand cmd = conn.CreateCommand()) { try { cmd.CommandText = "insert into hlb_his_requisition(requisition_id,patient_name,patient_sex,patient_age,patient_bed,charge_name,sample_class,requisition_state)values(1,‘张三‘,1,1)"; cmd.ExecuteNonQuery(); } catch (Exception ee) { MessageBox.Show(ee.Message.ToString() + "rn" + ee.StackTrace.ToString()); cmd.Dispose(); conn.Close(); conn.Dispose(); } } } ? 三.连接字符串: <add name="local_Orcl" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.31.11)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));User ID=scott;Password=123"/> ? 四.是否乱码: ? 五.是否需要安装客户端: (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |