Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

ÔÚasp.netÀïÃæ½Å±¾³ö´í - .NET¼¼Êõ / ASP.NET

function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;

var div1=document.getElementById("divPwd");

if (pwd.value=="")
{
......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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

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

asp.net Ò³ÃæÏÞʱÌá½» ÈçºÎʵÏÖ - .NET¼¼Êõ / ASP.NET

1.asp.net×öµÄÒ»¸ö´ðÌâÒ³Ãæ£¬ÈçºÎʵʱÏÞʱºó×Ô¶¯Ìá½»£¬Çë´ó¼Ò¸øµã˼·
ÏÞʱµÄʱ¼äÐÅÏ¢´æ·ÅÔÚÊý¾Ý¿âÖÐ
2.Èç¹û´ðÌâʱ¼äÉèÖõĽϳ¤£¬ÈçºÎ·½Ê½session³¬Ê±ºóÒ³ÃæÎÞЧ
лл
ÓÃjs·½·¨À´¿ØÖÆ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË¡£¡£

js ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ