C#连接数据库(ADO.NET)
string ConnectionString = "Data Source=127.0.0.1/orcl;user id=scott;password=tiger;"; OracleConnection conn = new OracleConnection(ConnectionString); try { conn.Open(); OracleCommand cmd = conn.CreateCommand(); if (conn.State == ConnectionState.Open) { textBox1.Text = "连接成功"; } } catch (Exception ee) { System.Diagnostics.Debug.WriteLine(ee.Message); } finally { conn.Close(); }
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; //引用oracle存储位置命名空间 using System.Data.OracleClient; namespace demo { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { } private void button1_Click(object sender, EventArgs e) { string ConnectionString = "Data Source=127.0.0.1/orcl;user id=scott;password=tiger;"; OracleConnection conn = new OracleConnection(ConnectionString); try { conn.Open(); OracleCommand cmd = conn.CreateCommand(); if (conn.State == ConnectionState.Open) { textBox1.Text = "连接成功"; } } catch (Exception ee) { System.Diagnostics.Debug.WriteLine(ee.Message); } finally { conn.Close(); } } } }