oracleÓë.netʱºò±¨´í
ÎÒÈ·¶¨£¬ÎÒoracleÀïÃæµÄÅäÖö¼ÊÇÕýÈ·µÄ£¨ÒòΪÎÒÓÃpb£¬plsql¶¼¿ÉÒÔÁ¬½ÓoracleÊý¾Ý¿â£©
µ«ÊÇÎÒÏë.netÀïÃæÁ¬½ÓoracleÊý¾Ý¿âµÄʱºò¾ÍÊDZ¨´í
ÎÒµÄÁ¬½ÓÎļþÊÇÕâÑùдÁ˵ģºProvider=OraOLEDB.Oracle;User ID=hwuser;Password=hw2001;Data Source=ora8;
ÎÒÊÇÕâÑùЩµÄ·ÃÎÊÊý¾Ý¿â·½·¨
static string oraConStr = ConfigurationSettings.AppSettings["oreConnection"];
/**
* Êý¾Ý¿âÖвéѯÓï¾äÖ´ÐÐ
*/
public DataSet QueryInfo(string sql)
{
DataSet ds = new DataSet ();
OleDbConnection olecon = new OleDbConnection(oraConStr);
OleDbDataAdapter oledba = new OleDbDataAdapter(sql, olecon);
oledba.Fill(ds);
return ds;
}
µ«ÊÇÔÚÎÒÖ´ÐÐ oledba.Fill(ds);µÄʱºò¾Í±¨´í:Óû§´úÂëδ´¦Àí£ºInvalidOperationException¡°Î´ÔÚ±¾µØ¼ÆËã»úÉÏ×¢²á¡°OraOLEDB.Oracle¡±Ìṩ³ÌÐò¡£¡±
Çë¸ßÊÖ°ïÖúÒ»ÏÂÈü£¬Ð»ÁË£¡£¡£¡
oracle¿Í»§¶Ë×°ÁËû£¿»¹ÓÐtnsname.oraÓÐûÓÐÕýÈ·µÄ·ÅÖÃÔÚÖ¸¶¨µÄλÖã¿
Data Source = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP)(HOST =·þÎñÆ÷Ãû)(PORT = ¶Ë¿ÚºÅ)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = Êý¾Ý¿âÃû))); User Id = Óû§Ãû; &nbs
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
Õâ¸öSQLÓï¾äÔõôд?
ÏÖÔÚÓÐÒ»¸ö±íT,ÀïÃæ¾Í3¸ö×Ö¶Î
ѧÉúID(sid)¿Î³Ì(cName)³É¼¨(score)
1 1 75
2 2 90
3 2 60
4 3 89
5 3 80
6 3 70
ÎÒÏÖÔÚÏëÖªµÀµÃµ½µÄ½á¹ûÊÇ:ÿÃſγÌÅÅÔÚǰÁ½ÃûµÄѧÉúµÄID,Ó¦¸ÃÔõÃ´Ð´ÄØ?
......