.NET连接ORACLE数据库简单实例

夏末丶拾忆

于 2014-05-28 09:59:12 发布

阅读量817

点赞数

分类专栏： ASP.Net 文章标签： .net

本文链接：https://blog.youkuaiyun.com/cq_xiaoma/article/details/27310653

版权

ASP.Net 专栏收录该内容

1 篇文章

订阅专栏

using System.Data.OracleClient;

string ConnectionString = "Data Source=net_test;user=sa;password=123456;";
            OracleConnection conn = new OracleConnection(ConnectionString);
            try
            {
                conn.Open();
                OracleCommand comm = conn.CreateCommand();

                comm.CommandText = "select sysdate from dual";
                object obj;
                obj = comm.ExecuteOracleScalar();
                this.label1.Text = Convert.ToString(obj);
                
            }
            catch (Exception error)
            {

                MessageBox.Show(error.Message, "信息提示");
            }
            finally {
                conn.Close();
            }