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ÊÇ·ñÕýÈ·ÄØ£¿»á²»»áÊý¾Ý
Ïà¹ØÎÊ´ð£º
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈË°ïÖúÏ°¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
·þÎñÆ÷ÏÖÔÚÊÇ¡£net 2.0µÄ
ÎÒÏÖÔÚµÄÏîÄ¿¾ÍÊÇasp.net mvc + linqµÄ£¬ÏÖÔÚ·þÎñÆ÷µÄ»·¾³ÅäÖÃÓò»ÁË¡£
²»ÖªµÀÓÐÇ°±²Åöµ½¹ýÕâÑùµÄÎÊÌâû¡£
ÄѵÀ·þÎñÆ÷±ØÐëҪװ.net3.5 ºÍ asp.net mvc
ÇëÇ°±²Ö¸µã
²»×°ÄãÈÏΪÄãÒªÔõô ......