C#连接Oracle数据库，连接字符串怎么写？

Question

C#连接Oracle数据库，连接字符串怎么写？需要带用户名密码，局域网访问；

Answer 1

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            OracleConnection conn = new OracleConnection("data source=orcl;user=system;password=manager");
            conn.Open();
            OracleDataAdapter oda = new OracleDataAdapter();
            OracleCommand cmd = new OracleCommand();
            cmd.CommandText = "select * from t";
            cmd.Connection = conn;
            DataTable dt = new DataTable();
            oda.SelectCommand = cmd;
            oda.Fill(dt);            conn.Close();
            this.GridView1.DataSource = dt;
            this.DataBind();            
        }    }

Answer 2

1、Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
2、Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;Integrated Security=Yes;Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
3、Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;
4、Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;
另外还有一个olaceconnection的组件，详细连接字符串可参考：
www.connectionstrings.com

Answer 3

string Conn="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;"+
"User ID="+User+";Password="+Password+";Data Source="+DataSource;

Answer 4

connectionString="Server=ORACLEDB_192.168.0.61;User Id=用户;password=密码;"server指向你本地tns中的配置