#Region statement // --------------------------------------------- ------------------------ //// Modification: Li Wei (Nick.lee) /// Oracle9i connection ASP.NET method and attention point
// Time: 2005-3-18
// Boyorgril@msn.com// qq: 16503096 // Note: Please indicate the modified place, thank you // ------------------------- -------------------------------------------- # endregion
Recommended way
public void oledboracle_dataset () {string ConnectionString = "Data Source = mine; user = sys; password = sys;"; // write connection string OracleConnection conn = new OracleConnection (ConnectionString); // Create a new connection OracleCommand cmd = new OracleCommand ("Select * from fjdl.t_rights", conn); DataSet DS = New DataSet (); OracleDataAdapter oda = new oracleDataAdapter (); oda.selectcommand = cmd; oda.fill (DS); conn.close (); dataGrid1. DataSource = DS.TABLES [0] .defaultView; dataGrid1.database ();
The following is four ways to use Dataset and DataReader, OLEDB and OralceClient
public void oledboracle_datareader () {System.Data.OleDb.OleDbConnection oledb1 = new System.Data.OleDb.OleDbConnection (); string sqlText = "select * from scott.tAdmin"; System.Data.OleDb.OleDbDataReader reader;
oledb1.ConnectionString = "Provider = /" OraOLEDB.Oracle.1 / "; User ID = system; password = system; Data Source = rick;"; System.Data.OleDb.OleDbCommand Com = new System.Data.OleDb.OleDbCommand (SqlText, OLEDB1);
COM.CONNECTION.Open (); reader = com.executeReader ();
DataGrid1.datasource = Reader; DataGrid1.databind ();
//this.Response.Write(oleDbConnection1.ConnectionString); reader.Close (); Com.Connection.Close ();} public void oledboracle_dataset () {System.Data.OleDb.OleDbConnection oledb1 = new System.Data.OleDb. OLEDBCONNECTION ("provider = /" oraoledb.racle.1 / "; user ID = system; password = system; data source = rick;"); string sqltext = "select * from scott.tadmin"; system.data.dataset set1 = new dataset (); system.data.oledb.oledbdataadapter ada1 = new system.data.oledb.oledbdataadapter (Sqltext, OLEDB1); ada1.fill (set1, "data1"); this.dataGrid2.datasource = set1.tables [ "data1"] DefaultView;. this.DataGrid2.DataBind ();} public void oracle_dataset () {System.Data.OracleClient.OracleConnection oracle1 = new System.Data.OracleClient.OracleConnection ( "user = system id; data source = rick ; password = system "); string sqlText =" select * from scott.tAdmin "; System.Data.DataSet set1 = new DataSet (); System.Data.OracleClient.OracleDataAdapter Ada1 = new System.Data.OracleClient.OracleDataAdapter (sqlText Oracle1 Ada1.fill (set1, "oracle_data1");
. This.DataGrid3.DataSource = set1.Tables [ "oracle_data1"] DefaultView; this.DataGrid3.DataBind ();} public void oracle_datareader () {System.Data.OracleClient.OracleConnection oracle2 = new System.Data.OracleClient.OracleConnection ( ); String sqltext = "select * from scott.tadmin"; System.Data.OracleClient.OrcledataReader Reader;
oracle2.ConnectionString = "User ID = system; user id = system; data source = rick; password = system"; System.Data.OracleClient.OracleCommand Com = new System.Data.OracleClient.OracleCommand (sqlText, oracle2); Com. Connection.open (); reader = com.executeReader ();
DataGrid4.datasource = reader; DataGrid4.dataBind ();
//this.Response.write (oledbconnection1.connections; reader.close (); com.connection.close ();}
be careful:
If you do not set the network configuration of the remote data
ORA-00162: External DBID Length 18 is Greater Than Maximum (16)
Connection name cannot exceed 16 characters
Modification method
Configuration and Migration Tools-> Net Configuration Assistant configuration
