Oracle连接数据库

象这些类似的问题，在网上搜了也是一大串，自己整理也是为了方便日后使用：

（1）下面这段代码作用是连接数据库，并读取某个表字段，填充到comboBox控件中。
           

 string connectionString = "Data Source=ORCL_server;User Id=user;Password=***;";
 OracleConnection conn = new OracleConnection(connectionString);
 conn.Open();

 OracleCommand cmd = new OracleCommand();
 cmd.Connection = conn;
 cmd.CommandText = "select roadname from tb_road";

 OracleDataAdapter da = new OracleDataAdapter(cmd);

 DataSet ds = new DataSet();
 da.Fill(ds);

 comboBox1.DataSource = ds.Tables[0].DefaultView;
 comboBox1.DisplayMember = "roadname";

 conn.Dispose();

 

或

 string connectionString = "Data Source=ORCL_otitan-server;User Id=hfjkqgis;Password=gis;";

 OracleConnection conn = new OracleConnection(connectionString);
 conn.Open();

 OracleCommand cmd = new OracleCommand();
 cmd.Connection = conn;
 cmd.CommandText = "select roadcode,roadname from tb_roadcode";

 OracleDataReader dr = cmd.ExecuteReader();

comboBox1.Items.Clear();
 while (dr.Read())
 {
         comboBox1.Items.Add(dr["roadname"]);//通过字段名取值，看起来较清晰
         comboBox1.Items.Add(dr.GetString(1));//通过字段索引取值，作用和上一句等价
  }

 

注意：要添加System.Data.OracleClient引用。