当前位置:编程学习 > C#/ASP.NET >>

在vs winform 中用datagridview显示oracle中数据有问题 求助?????

   public void init()
        {
            dop.goToConnect();
            String strSql = "select * from system.管理员表";
            DataSet ds = new DataSet();
          
            ds = dop.query(strSql);
            dataGridView1.DataSource = ds.Tables[0].DefaultView;

        }

 class DataOper
    {
        private static string StrConn;
        private static OracleConnection conn = new OracleConnection();
        private static DataSet ds;
        private static OracleDataAdapter sda;
        private static OracleCommand SC;

        public void goToConnect()
        {
            StrConn = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PC-20121118GGSZ)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl))) ; Persist Security Info=True; User =SYSTEM;Password=wu__xing;Unicode=True";

            try
            {
                conn = new OracleConnection(StrConn);
            }
            catch (System.Data.OracleClient.OracleException ex)
            {
                throw new Exception(ex.Message);
            }
        }
        public DataSet query(string strSql)
        {
            ds = new DataSet();
            conn.Open();
            sda = new OracleDataAdapter(strSql, conn);
            sda.Fill(ds, "ds");
            conn.Close();
            return ds;
        }
        public int DataProcessor(string StrSql)
        {
            int Row = 0;
            conn.Open();
            SC = conn.CreateCommand();
            SC.CommandText = StrSql;
            Row = SC.ExecuteNonQuery();
            conn.Close();
            return Row;
        }
    }
}
为什么不显示呢????????
补充:.NET技术 ,  C#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,