Connect to the sqlserver database:
String albumname = textboxname. text. trim (); // obtain the new album name sqlconnection conn = new sqlconnection ("Server = (local); database = Electronic album; uid = sa; Pwd = zouming "); // connect to the database 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 = Electronic album; 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 ";
Connect to the fiddler database:
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();