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