asp oracle9i 链接oracle,asp.net 2.0 连接oracle 9i

protected void btnOK_Click(object sender, EventArgs e)

{

string strconnection = "Data Source=div_app;User id=System;Password=div12app";

OracleConnection conn = new OracleConnection(strconnection);

conn.Open();

Response.Write(conn.State);

OracleCommand comm = new OracleCommand("select * from help", conn);

OracleDataAdapter myda = new OracleDataAdapter(comm);

DataSet myds = new DataSet();

myda.Fill(myds);

if (myds.Tables[0].Rows.Count> 0)

{

GridView1.DataSource = myds;

GridView1.DataBind();

}

else

{

Response.Write("有错误产生");

}

myds.Dispose();

myds.Dispose();

conn.Dispose();

}

本文来源于网络：查看 >https://www.cnblogs.com/baohaiqi/archive/2010/08/29/1811771.html