• Inserting/Retrieving CLOB/NCLOB Data


    private void btnGetCLOB_Click(object sender, EventArgs e)
    {
      //We first read the full contents of the file into a byte array
            string _connstring = "Data Source=localhost/NEWDB;User    
      Id=EDZEHOO;Password=PASS123;";
            try
            {
              OracleConnection _connObj = new OracleConnection(_connstring);
                    OracleDataReader _rdrObj;
                    _connObj.Open();
                    OracleCommand _cmdObj = _connObj.CreateCommand();
                    _cmdObj.CommandText = "SELECT Remarks FROM ProductFiles WHERE 
       ProductID=:ProductID";
                    _cmdObj.Parameters.Add(new OracleParameter("ProductID", txtProductID.Text));
                    _rdrObj=_cmdObj.ExecuteReader();
                    if (_rdrObj.HasRows)
                    {
                        if (_rdrObj.Read())
                        {
                            OracleClob _clobObj = 
        _rdrObj.GetOracleClob(_rdrObj.GetOrdinal("Remarks"));
                            txtRemarks.text = _clobObj.Value
                        }
                    }
                    else
                    {
                        MessageBox.Show("An item with the matching product ID was not found!");
                    }
                    _connObj.Close();
                    _connObj.Dispose();
                    _connObj = null;
     }
            catch (Exception ex)
            {
              MessageBox.Show(ex.ToString());
     }
    }

    using Oracle.DataAccess.Types;
    private void btnInsert_Click(object sender, EventArgs e)
    {
            string _connstring = "Data Source=localhost/NEWDB;User 
      Id=EDZEHOO;Password=PASS123;";
            int _recordsAffected;         try
            {
              OracleConnection _connObj = new OracleConnection(_connstring);
                    _connObj.Open();
                    OracleCommand _cmdObj = _connObj.CreateCommand();
                    _cmdObj.CommandText = "INSERT INTO ProductFiles(ProductID, Remarks) 
       VALUES(:ProductID,:Remarks)";
                    _cmdObj.Parameters.Add (new OracleParameter 
       ("ProductID",txtProductID.Text));
        OracleClob _clobObj = new OracleClob(_connObj);
      _clobObj.Write(txtRemarks.Text.ToCharArray(), 0, txtRemarks.Text.Length);
        _cmdObj.Parameters.Add (new OracleParameter("Remarks", _clobObj));
                    _recordsAffected = _cmdObj.ExecuteNonQuery();
                    if (_recordsAffected == 1) { MessageBox.Show("CLOB saved!"); }
                    _connObj.Close();
                    _connObj.Dispose();
                    _connObj = null;
            }
            catch (Exception ex)
            {
              MessageBox.Show(ex.ToString());
            }
    }

  • 相关阅读:
    python之基础知识篇
    OpenGL 着色器管理类 Shader
    OpenGL 彩色三角形
    OpenGL 你好,三角形 练习一 二 三
    OpenGL 矩阵绘画
    OpenGL 第一个三角形!!!!
    OpenGL 读取,使用 .vert .frag 着色器 文件 C++
    C++ 一定要使用strcpy_s()函数 等来操作方法c_str()返回的指针
    OpenGL 入门指南(配置GLFW ,着色语言高亮,以及一些常见问题)
    汽车加工厂
  • 原文地址:https://www.cnblogs.com/kingwangzhen/p/1796948.html
Copyright © 2020-2023  润新知