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

C# ¶ÁÈ¡ºÍдÈëoracleµÄblob×ֶεķ½·¨

 //ÏòÊý¾Ý¿âÖÐдÈë
        private void button1_Click(object sender, EventArgs e)
        {
            oracleConnection1.Open();
          
            OracleCommand cmd = new OracleCommand("UPDATE TEST SET F2 =:blob where F1=:sn ", oracleConnection1);
           
            cmd.Parameters.Add(new OracleParameter("blob",OracleType.Blob));
              cmd.Parameters.Add(new OracleParameter("sn",OracleType.Int32));
             FileInfo fi = new FileInfo("c:\\dos.doc");
             FileStream fs = fi.OpenRead();
             byte[] MyData = new byte[fs.Length];
             fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
             fs.Close();
            cmd.Parameters["blob"].Value = MyData;
            cmd.Parameters["sn"].Value = 1;
            try
            {
                int result = cmd.ExecuteNonQuery();
                if (result < 1)
    


Ïà¹ØÎĵµ£º

C#¶ÁÈ¡sqlserver ¶¯»­flash swf Îļþµ½±¾µØÓ²ÅÌ

 using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlC ......

³õʶoracleÖеÄË÷Òý×éÖ¯±í

 Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊǰ´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
ÈçÏÂͼËùʾ£¬ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°üÀ¨<Ö÷¼üÁÐÖµ£¬·ÇÖ÷¼üÁÐÖµ>¶ø ......

ORACLE ÏëÇå³þÁËÔÙ×ö£¬Òª½÷É÷Щ¡¡ÐÖµÜ

 ÐÇÆÚÒ» ·¢ÏÖÒ»¸ö±íÓкܶàÖØ¸´Êý¾Ý Ëæ»úʹÓÃɾ³ýÖØ¸´Êý¾ÝµÄÓï¾ä¡£
ÐÇÆÚ¶þ ·¢ÏÖ ÕâÓï¾äÅÜÁ˺ܾö¼Ã»ÅÜÍ꣬13¸öСʱÁË£¡Ö»²»¹ýɾ³ý10¸öÔµÄÊý¾Ý¶øÒÑ
ÒÀÈ»¶ÏÁËËü£¬¿ÉËü»Ø¹ö»¨ÁË4¸öСʱ£¬ÉÏÎçÓ°ÏìÁËÊý¾Ý¿âµÄ·þÎñËÙ¶ÈÁË¡£
È»ºóÒ»¸öÔÂÒ»¸öÔ¼ì²éÖØ¸´Êý¾ÝµÄ·¶Î§£¬×îºó¶¨Î»µ½9Ôµ½10Ô¡£É¾³ýËü£¬ÓÃÄÇÌõÓï¾äºÜÂý£¬Ò»¸öСʱºó ......

oracleµÄnvlº¯ÊýµÄÓ÷¨

oracleµÄnvlº¯ÊýµÄÓ÷¨ ͨ¹ý²éѯ»ñµÃij¸ö×ֶεĺϼÆÖµ£¬Èç¹ûÕâ¸öֵλnull½«¸ø³öÒ»¸öÔ¤ÉèµÄĬÈÏÖµ
select nvl(sum(t.dwxhl),1) from tb_jhde t where zydm=-1ÕâÀï¹ØÐĵÄnvlµÄÓ÷¨£¬nvl£¨arg,value£©´ú±íÈç¹ûÇ°ÃæµÄargµÄֵΪnullÄÇô·µ»ØµÄֵΪºóÃæµÄvalue
Èç: NVL(a,b)¾ÍÊÇÅжÏaÊÇ·ñÊÇNULL,Èç¹û²»ÊÇ·µ»ØaµÄÖµ£¬Èç¹ ......

OracleδÌṩÏàÓ¦Çý¶¯

  ±¾»úµçÄÔÉÏÓа²×°ORACLE10GµÄ¿Í»§¶Ë£¬ºóÀ´ÓÉÓÚÐèÒªÍæÁËÒ»ÏÂODAC£¬ºóÀ´ÓÖÐ¶ÔØµôÁË¡£½á¹û£¬Ê¹ÓÃC#½øÐÐÁ¬½ÓµÄʱºò±¨£º
        δÔÚ±¾µØ¼ÆËã»ú×¢²á“OraOLEDB.Oracle.1”Ìṩ³ÌÐò
  È»ºó£¬Ð½¨Ò»¸öUDL½øÐвâÊÔ£¬·¢ÏÖOracle   Provider & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ