¹òÇó C#.net ODBCÔÚOracleÊý¾Ý¿âÖд´½¨±í
¸÷λ´óÏÀ£¬Ð¡ÃÃÏëÓà C#.net ODBCÁ¬½Ó ÔÚOracleÊý¾Ý¿âÖд´½¨±í£¬Çë´ó¼Ò°ïæһÏÂÌØ¼±£¡£¡
ÁíÍâÎÒÓÐдÁË´úÂë¿É×ÜÊDZ¨´í,´ó¼Ò°ïÎÒ¿´Ò»Ï£¡create±íµÄÓï¾äÔÚoracleµÄ¹¤¾ßÖÐÖ´ÐпÉÒÔ£¬µ«ÊÇÔÚÏÂÃæµÄ´úÂëÖÐÖ´Ðб¨
¡±[Microsoft][ODBC driver for Oracle][Oracle]ORA-00955: Ãû³ÆÒÑÓÉÏÖÓжÔÏóʹÓᰵĴíÎó
ÎÒÓõÄÊÇDNSÁ¬½ÓÊý¾Ý¿â
public bool ChkTable(string TableName) //¼ì²é±íÊÇ·ñ´æÔÚ
{
string sql = "";
OdbcConnection OdbcConn = new OdbcConnection(sConn);
OdbcCommand cmd = new OdbcCommand("", OdbcConn);
try
{
OdbcConn.Open();
sql = "SELECT COUNT(TABLE_NAME) * from USER_TABLES";
sql += " WHERE TABLE_NAME='" + TableName.ToUpper() + "' ";
cmd.CommandText = sql;
oResult= cmd.ExecuteNonQuery();
}
catch
&
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
txt ºÍXML ¸ñʽÏàÓ¦
²»½èÖúDataSet
µ¼Èë¶ÁÈ¡TXTÎļþ
È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.)
½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ
¹ý·ºÃºº °ï¸öæÈö^^
²»»á£¬°ïÂ¥Ö÷ ......
ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼Åжϵȶ¼ÐèÒªwinform»ù´¡
C#ÓïÑÔ
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹
Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......