C#连接各种数据库

 

Connection   (SQLSERVER)

            SqlConnection conn = new SqlConnection("Server=(local);DataBase=test;User=sa;Pwd=sa");

            SqlDataAdapter da = new SqlDataAdapter("select * from test", conn);

            DataSet ds = new DataSet();

            da.Fill(ds);

            dataGridView1.DataSource = ds.Tables[0];

 

Connection    (ORACLE)

OracleConnection Con = new OracleConnection("server=TRMESPP;user id=DIV_APP;password=DIV12APP;");

Con.Open();

OracleDataAdapter dr = new OracleDataAdapter("Select YYYYMMDD,LOT_ID,model_code,suffix_code,lot_qty  From tb_ref_bcrprintinfo where yyyymmdd>to_char(sysdate,'yyyymmdd')", Con);

DataSet dt = new DataSet();

dr.Fill(dt);

dataGridView1.DataSource = dt.Tables[0];

 

Connection   (ACCESS)

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\" + "MES_LOCAL.MDB";