连接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();