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

asp.netÖ´ÐÐoracleµÄ´æ´¢¹ý³ÌÎÊÌ⣡

ÎÒÓÃodbcÁ¬½ÓÊý¾Ý¿â£¬
´æ´¢¹ý³ÌÒ²¶¼Ð´ºÃÁË£¡plsqlÖ´ÐÐûÎÊÌ⣡
ÓÃasp.netÖ´Ðоͳö´íÁË£¡
˵ÎÞЧsqlÓï¾ä£¡
ÇëÎÊÊÇÔõô»ØÊ£¿
»òÕßË­ÓÐÀý×Ó£¡¸ø·¢Ò»¸ö£¡²Î¿¼²Î¿¼£¡
ERROR [42000] [Oracle][ODBC][Ora]ORA-00900: ÎÞЧ SQL Óï¾ä

ÄãÈ·ÐÅASP.NET ÒѾ­Á¬ÉÏÁËORACLE?

public void ccgc(string Cname, string is_time)
  {
  try
  {

  OdbcCommand ocom = new OdbcCommand();
  ocom.CommandText = Cname;
  ocom.CommandType = CommandType.StoredProcedure;
  ocom.Connection = DBlink();

  OdbcParameter op = new OdbcParameter("is_time", OdbcType.VarChar, 100);
  op.Value = is_time;
  ocom.Parameters.Add(op);
  ocom.Parameters["is_time"].Direction = ParameterDirection.Input;

   
  ocom.ExecuteNonQuery();

  }
  catch (OdbcException ee)
  {
  throw new Exception(ee.Message);
  }
  finally { oc.Dispose(); }
  }


Õâ¸öÊÇÄãµÄ´úÂ룿£¿£¿

¸øÄãÒ»¸ö²Î¿¼£º
http://m.cnblogs.com/44564/1299037.html

DataSet ds= new DataSet();
using(OracleConnection conn = new OracleConnection(""))
{
OracleCommand cmd = n


Ïà¹ØÎÊ´ð£º

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

asp.net³ÌÐòÔ±ÇóÖ° - .NET¼¼Êõ / ·Ç¼¼ÊõÇø

±¾È˹¤×÷¾­ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp.net
ÊìϤjavascript
ÊìϤCss
ÊìϤajax
ÊìϤsqlserver2005
ÓÐÒ»ÄêµÄÏîÄ¿¾­Ñé
¾ßÌåÏîÄ¿ºÍÆäËûµÄ¾Í²»ÔÚÕâдÁË
ÓÐÒâÕßÁªÏµ£º
QQ:359233910
ÒýÓÃ
±¾È˹¤×÷¾­ÑéÒ»ÄêÒÔÉÏ
ÊìϤasp ......

ÇóÖú£ºÕÒASP.NETÍøÒ³ÖÆ×÷¸ßÊÖ£¬Óб¨³ê¡£

±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»Æ­ÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......

wapÍøÕ¾¿ª·¢µÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

ÎÒÓÃ.net¿ª·¢wapÍøÕ¾
1£¬ÎÒ´Ó¹¤¾ßÏäÀïÍÏÁËÁ½¸ölink£¬ÕâÁ½¸ölink»áÏÔʾÔÚÁ½ÐУ¬Èç¹ûÈÃÕâÁ½¸ölink´¦ÓÚͬһÐС£
2£¬ÈçºÎÏÔʾÁ½¸ö¿Ø¼þÖ®¼äµÄ¿Õ¸ñÎÊÌâ¡£
¸úwapÓйØÂ𣿲»Ì«Ã÷°×

ÓÑÇé°ï¶¥¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

¾Í ......

ÇóÖúasp.netͼƬÉÏ´« - .NET¼¼Êõ / ASP.NET

¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£

ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ