Today, I saw the method of connecting the ASP.NET to connect the Oracle database, I got the following code. This code opened myTable table and listed the operator's name. The field type is ORACLESTRING. When reading is a field number, I don't know how to use the field name to read the contents of a certain field. Below is the code: // First add two references use system.data.racleClient; use system.data;
// Add a button on the form, called Button1, double-click Button1, enter the following code private void button1_click (object sender, system.eventargs e) {string connectionString = "data source = sky; user = system; password = manager;" ; // Write the connection string OracleConnection conn = new oracleConnection (Connectionstring); // Create a new connection try {conn.open (); OracleCommand cmd = conn.createCommand ();
cmd.comMandtext = "Select * from myTable"; // Write SQL statement OracleDataRead Odr = cmd.executeReader (); // Create an OracleDateReader object while (Odr.Read ()) // read data if ODR. Read () returns to false, explains the end of the recordset {response.write (odr.getroraclestring (1) .tostring ()); // Output field 1, this number is the field index, how to use the field name Still need to be studied} Odr.close ();} catch (exception ee) {response.write (Ee.Message); // If there is an error, output error message} finally {conn.close (); // Close connection}}
The entire program is not very complicated, but it is also enough for me to study for a long time. After all, the ASP.NET and ASP have VB differences. Slowly learn
