连接SQLServer，Oracle数据库语句。。。

连接SQLserver数据库：　

string albumName = TextBoxName.Text.Trim();//获取新建相册的名字
        SqlConnection conn = new SqlConnection("Server=(local);database=电子相册;uid=sa;pwd=zouming");//连接数据库
        conn.Open();
        string sql = "insert into Table_Name (name)values('" + albumName + "')";
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.ExecuteNonQuery();
        conn.Close();


  SqlConnection conn = new SqlConnection("Server=(local);database=电子相册;uid=sa;pwd=zouming");
            conn.Open();
            string sql = "select name from Table_Name";
            SqlCommand cmd = new SqlCommand(sql, conn);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            DropDownList1.DataSource = ds.Tables[0];
            DropDownList1.DataTextField = "name";　　

 

　

连接Oracler数据库：　

using System.Data.OracleClient;

OracleConnection con = new OracleConnection("Data Source=myOracle;user id=xxx;password=xxx;");
OracleCommand cmd = new OracleCommand("select * from table", con);
con.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
GridView1.DataSource = dr;
GridView1.DataBind();
dr.Close();