asp.net C# oracle ²åÈëÊý¾Ý²»³É¹¦
racleDataBaseÊÇ×Ô¼º¶¨ÒåµÄÒ»¸ö²Ù×÷Êý¾Ý¿âµÄÀ࣬NoReturnSqlÊÇÖ´Ðмòµ¥µÄsqlÓï¾äµÄ·½·¨
public void NoReturnSql(string Sql)
{
Open();
Cm = new OracleCommand(Sql, Cn);
Cm.ExecuteNonQuery();
Close();
}
ʹÓÃNoReturnSql·½·¨Ö´Ðвéѯ¿ÉÒÔ·µ»Ø¼Ç¼£¬Ö´ÐвåÈëÓï¾äÈ´²»³É¹¦£¬²»ÖªÎªºÎ¡£ÈçÏÂ
OracleDataBase OraHelper = new OracleDataBase();
string strSql = "insert into bank (key,bank_id,bank_name,a_len) values(999,'12345678','Öйú½¨ÉèÒøÐÐ',18)";
OraHelper.NoReturnSql(strSql);
¿ÒÇë´Í½Ì£¡
public void NoReturnSql(string Sql)
{
Open();
Cm = new OracleCommand(Sql, Cn);
Cm.ExecuteNonQuery();
Close();
}
ÄãÈ·¶¨Õâ¸ö·½·¨Ã»ÓÐÎÊÌ⣿
¼ì²éÏÂ×Ö¶ÎÀàÐͺÍ×ֶδóС°É¡£
ÎÒÕâ¸ö²åÈëÓï¾äÔÚtoadÖ´ÐйýÊÇ¿ÉÒÔµÄ
NoReturnSqlÖ´ÐÐSelectµÄsqlÓï¾äÊÇ¿ÉÒÔ·µ»Ø¼Ç¼µÄ
ÄǾͼì²éÏÂ×Ö¶ÎÀàÐÍ£¬±ÈÈçbank_idÊÇstring?
xiang zi zi
Ìáʾʲô´íÎó£¬×Ö¶ÎÀàÐÍÊÇ·ñÒ»ÖÂ
Open();
Cm = new OracleCommand(Sql, Cn);
openºÍcnÊÇ·ñÕýÈ·ÄØ£¿»á²»»áÊý¾Ý
Ïà¹ØÎÊ´ð£º
Imports System.ComponentModel
Imports System.Web.UI
Imports System.Web.UI.Design
Imports System.Web.UI.WebControls
Namespace CBDAspNet.WebControls.HTML
''' <summary>
'' ......
×î½üÔÚ×ö¸öÍøÉÏÉ̳ǣ¬¹ºÎﳵģ¿é£¬Ã»ÓÐ×ö¹ý£¬Âé·³¸÷λ°ïæ˵Ï´óÖÂ˵ÏÂ˼·£¬ÄÜ·¢Ò»·ÝÔ´Âë¸üºÃ¡£Ð¡µÜÏÈл¹ý¸÷λÁË£»
QQ£º413763818£»
eamil:swebook@126.com
ÍøÉÏÒ»´ó¶Ñ£¡
www.51aspx.com
ȥϠ......
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......
ASP.NETÈçºÎÓÃÒ»¸ö°´Å¥ÊµÏÖÑ¡ÔñÎļþ¼Ð·¾¶µ½Îı¾¿òÖУ¿£¨×¢ÒâÊÇÎļþ¼Ð·¾¶£¬²»ÊÇÎļþ·¾¶£©
http://blog.csdn.net/xianfajushi/archive/2008/10/18/3094474.aspx
Õâ²»ÊÇÎÒÒªµÄЧ¹û£¬ÎÒÒªÓõÄÊÇÀàËÆÓÚÎļþÉÏ´«¿ÉÒ ......
·þÎñÆ÷ÏÖÔÚÊÇ¡£net 2.0µÄ
ÎÒÏÖÔÚµÄÏîÄ¿¾ÍÊÇasp.net mvc + linqµÄ£¬ÏÖÔÚ·þÎñÆ÷µÄ»·¾³ÅäÖÃÓò»ÁË¡£
²»ÖªµÀÓÐǰ±²Åöµ½¹ýÕâÑùµÄÎÊÌâû¡£
ÄѵÀ·þÎñÆ÷±ØÐëҪװ.net3.5 ºÍ asp.net mvc
Çëǰ±²Ö¸µã
²»×°ÄãÈÏΪÄãÒªÔõô ......