Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

C#´¦Àíoracle lobµÄÀý×Ó

  protected void BindData1()
    {
        OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        orcn.Open();
        string MyData = "";
        StreamReader rs = new StreamReader(@"c:\1.txt");
        MyData = rs.ReadToEnd();
        rs.Close();
        //OracleConnection orcn = new OracleConnection("User ID=wesoftwcp; Password=wesoft; Data Source=oradb");
        //orcn.Open();
        OracleType lobtype = OracleType.Clob; //Èç¹ûÊÇblobÕâÀï¸Ä³ÉOracleType.blob
        string CreateTempBlob = "DECLARE A " + lobtype + "; " +
            "BEGIN " +
            "DBMS_LOB.CREATETEMPORARY(A, FALSE); " +
            ":LOC := A; " +
            "END;";
        OracleTransaction transaction = orcn.BeginTransaction();
        OracleParameter[] param = new OracleParameter[1];
        param[0] = new OracleParameter("LOC", OracleType.Clob);
        //OracleHelper.CacheParameter(CreateTempBlob,param);
        OracleCommand cmdTemp = new OracleCommand(CreateTempBlob, orcn);
        param[0].Direction = ParameterDirection.Output;
        //OracleHelper.ExecuteNonQuery(transaction


Ïà¹ØÎĵµ£º

ÔÚFedora 10Éϰ²×°Oracle£¨10.2.0£©[³­Ï®]

ÔÚFedora 10Éϰ²×°Oracle£¨10.2.0£©
ĬÈϵÄϵͳ²ÎÊýÏ£¬ÔÚFedora 10ÉÏÎÞ·¨°²×°Oracle£¬ÐèÒª½øÐÐÏÂÁÐÈô¸É´¦Àí£º
   1. Ñé֤ϵͳҪÇó
    ÒªÑé֤ϵͳÊÇ·ñÂú×ã Oracle 10g Êý¾Ý¿âµÄ×îµÍÒªÇó£¬ÒÔ root Óû§Éí·ÝµÇ¼²¢ÔËÐÐÒÔÏÂÃüÁî¡£
    Òª²é¿´¿ÉÓà RAM ºÍ½»»»¿Õ¼ä´óС£¬ÔËÐÐÒÔÏÂà ......

C#Á¬½ÓmysqlÊý¾Ý¿â

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql ......

´ó¼ÒÒ»ÆðÀ´ÌÖÂÛOracle±í¿Õ¼äµÄ´´½¨

ÔÚÏîĿʵÏÖʱ£¬´ó¼ÒÒ»°ãÓбíµÄÉè¼Æ¡£ÓëÒ»°ãÊý¾Ý¿â²»Í¬£¬Oracle±í¿Õ¼äµÄ˵·¨¡£±í¿Õ¼äÒâΪ´æ·Å±íµÄ¿Õ¼ä¡£ÔÚ½¨Á¢±íµÄʱºòΪÁËÓëԭʼOracle±í¿Õ¼äÓÐÇø±ð£¬ÎÒÃÇ¿ÉÒÔ´´½¨Ðµıí¿Õ¼ä´æ·Å±í¡£Ò»°ãµÄ½¨ÒéÊǽ¨Á¢Á½¸ö±í¿Õ¼äÒ»¸ö´æ·ÅÊý¾Ý£¬Ò»¸ö´æ·ÅË÷Òý¡£
´´½¨Oracle±í¿Õ¼äµÄ·½·¨ÈçÏ£º
1.¿ÉÒÔͨ¹ýOracle×Ô´øµÄͼÐÎÓû§½çÃæÊµÏÖ¡£¾ßÌå ......

Oracle±í¿Õ¼ä»Ö¸´ÈÃÄã²»ÔÙµ£ÐÄÊý¾Ý¿â³öÏÖ´íÎó

ѧϰOracleʱ£¬Äã¿ÉÄÜ»áÓöµ½oracle±í¿Õ¼ä»Ö¸´ÎÊÌ⣬ÕâÀォ½éÉÜOracle±í¿Õ¼ä»Ö¸´ÎÊÌâµÄ½â¾ö·½·¨£¬ÔÚÕâÀïÄóöÀ´ºÍ´ó¼Ò·ÖÏíһϡ£
Oracle±í¿Õ¼ä»Ö¸´·½°¸
Ò».Óû§±í¿Õ¼ä
´íÎó:
ÔÚÆô¶¯Êý¾Ý¿âʱ³öÏÖora-01157,ora-01110»ò²Ù×÷ϵͳ¼¶´íÎóÀýÈçora-07360, ÔڹرÕÊý¾Ý¿â(ʹÓÃshutdown normal»òshutdown immediate) ʱ½«µ¼Ö´íÎó ......

½«Í¼Æ¬µÈÎļþ±£´æµ½sqliteÖУ¨c#£©

 SqLite.netµÄdllΪSystem.Data.SQLite.dll£¬ÕâÖÖdll·ÖΪ32λ¡¢64λºÍÊÊÓÃÓÚcompactframeworkÈýÖÖ£¬ÔÚÒýÓÃʱҪעÒ⣬ѡÔñÕýÈ·µÄdll¡£
½«Òª±£´æÍ¼Æ¬µÄ×Ö¶ÎÀàÐÍÉèΪblob¡£´úÂëÈçÏ£º
private void savePicture£¨£©
{
using (SQLiteConnection cnn = new SQLiteConnection(dbPath))
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ