C# 本地连接oracle数据库代码

[清风小溪]

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;
using System.Collections;
using System.Data.OleDb;
using System.Data;


string connstring = "Data Source=127.0.0.1:1521/wj123 ;user id=rr;password=wj123"; 这一句该怎么写？？？

[五更琉璃]

[圣殿骑士18]

没看明白你问的是什么 贴一个mysql的

string connString = "server=localhost;port=3306;user id=root;persistsecurityinfo=False;database=northcerp;password=xxxx;Convert Zero Datetime=True;Allow Zero Datetime=True;CharSet=utf8";
            string sql = "select * from BA_Shop";

            MySqlConnection conn = new MySqlConnection(connString);
            MySqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = sql;
            sda = new MySqlDataAdapter(cmd);
            MySqlCommandBuilder scb = new MySqlCommandBuilder(sda);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            this.dataGridView1.DataSource = dt;

[清风小溪]

C# 中连接oracle 这一段怎么写 connString = "server=localhost;port=3306;user id=root;persistsecurityinfo=False;database=northcerp;password=xxxx;Convert Zero Datetime=True;Allow Zero Datetime=True;CharSet=utf8";？？？

[圣殿骑士18]

百度。。。。。。

[钟伟海]

string connectString_ora ="Data Source = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = "+server_o+")(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = "+dbname_o+"))); Persist Security Info = True; User Id = "+username_o+"; Password = "+pass_o+"";

[zhouyi936]

来这问还不如百度来的快