and cmd=conn.CreateCommand();
cmd.CommandText="select * from MyTable";//在这儿写
sql语句
OracleDataReader odr=cmd.ExecuteReader();//创建一个OracleDateReader对象
while(odr.Read())//读取数据,如果odr.Read()返回为false的话,就说明到记录集的尾部了
{
Response.Write(odr.GetOracleString(1).ToString());//输出字段1,这个数是字段索引,具体怎么使用字段名还有待研究
}
odr.Close();
}
catch(Exception ee)
{
Response.Write(ee.Message); //如果有错误,输出错误信息
}
finally
{
conn.Close(); //关闭连接
}
}
=====================================
oracle9i连接asp.net方法及注意点
推荐方式
public void oledboracle_dataset()
{
string ConnectionString="Data Source=mine;user=sys;password=sys;"; //写连接串
OracleConnection conn=new OracleConnection(ConnectionString); //创建一个新连接
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.DataBind();
}
以下为用dataset和datareader,oledb和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.Oracle.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 id=system;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.OracleDat