`
qimo601
  • 浏览: 3415910 次
  • 性别: Icon_minigender_1
  • 来自: 苏州
社区版块
存档分类
最新评论

DataReader 读取Oracle数据库

阅读更多
OracleConnection oc = new OracleConnection();
            oc.ConnectionString = @"Data Source=gxmis;Persist Security Info=True;User ID=system;Password=admin";
            try
            {
                oc.Open();
                OracleCommand thisCommand = oc.CreateCommand();
                thisCommand.CommandText = @"SELECT * FROM STUDENT";
                OracleDataReader thisReader = thisCommand.ExecuteReader();
                while (thisReader.Read())
                {
                    Console.WriteLine("\t{0} \t{1}", thisReader["student_id"], thisReader["student_name"]);
                }
                thisReader.Close();
                oc.Close();
            }
            catch (OracleException oe)
            {
                Console.WriteLine("数据库连接失败");
                Console.WriteLine(oe.Message);
            }

 

0
0
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics