ÇóC#¶ÁдoracleÊý¾Ý¿âÖÐclobÊý¾ÝµÄ´úÂë
ÈçÌ⣬ÇóC#ÖвÙ×÷oracleÊý¾Ý¿âÖÐclobÀàÐÍÊý¾ÝµÄÏà¹Ø´úÂ룬µÚÒ»´Î½Ó´¥£¬Ò»µãÒ²²»»á°¡£¬²»ÖªµÀÈçºÎд£¬¸øµã²Î¿¼´úÂ룬лÁË
°ïÄã¶¥Ò»ÏÂ
string file_name = this.filepath1_txt.Text.ToString();//ͼƬ·¾¶
Bitmap bmp = new Bitmap(file_name);
FileInfo fi = new FileInfo(file_name);
int w = bmp.Width;//¿í
int h = bmp.Height;//¸ß
long s = fi.Length;
string conn_str = "Provider=OraOLEDB.Oracle.1;Password=123;Persist Security Info=True;User ID=123;Data Source=123;Extended Properties=";
OleDbConnection cn = new OleDbConnection(conn_str);
cn.Open();
OleDbCommand cmd;
cmd = new OleDbCommand("insert into Table_1(fphoto) values(:FPHOTO1)", cn);
cmd.Parameters.Add("FPHOTO", OleDbType.Binary);
FileStream fs = new FileStream(file_name, FileMode.OpenOrCreate, FileAccess.Read);
byte[] MyData = new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
fs.Close();
cmd.Parameters["FPHOTO"].Value = MyData;
int result = cmd.ExecuteNonQuery();
if (result >
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÎÒÓÃjqueryÎÞË¢ÐÂÉÏ´«Í¼Æ¬ºó·µ»Øjson¸ñʽµÄÊý¾Ý±¨´í
£¨Êµ¼ÊÉÏͼƬÊÇÉÏ´«³É¹¦µÄÁË£¬Ö»ÊÇ·µ»Øjson¸ñʽ×ܶÁ²»µ½£¬×ÜÊDZ¨´í£©
ÎÒµ÷ÊÔÉÏ´«µÄashxÒ³ÈçÏÂ
ÎÞ·¨ÏÔʾ XML Ò³¡£
ʹÓà Ñùʽ±íÎÞ·¨²é¿´ XML ÊäÈë¡£Çë¸ü ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......