C# ͨ¹ýado.net ·ÃÎÊoracle
1.°²×°ODP£¨oracle data provider£©
2.È»ºóÔÚÏîÄ¿ÖÐÒýÓà Oracle.DataAccess³ÌÐò¼¯
3.½Ó×Å
using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
4.È»ºó±àд³ÌÐòºÍado.net·½Î»sqlserver ²î±ð²»´óÁË£¬¾ÍÊÇÀûÓÃÏÂÃæµÄ¶ÔÏó½øÐбà³Ì£¬µ±È»£¬ÒòΪoracleºÍsqlserverÓÐºÜ¶àµØ·½²»Ò»Ñù£¬ËùÒÔϸ½Ú´æÔںܴó²îÒì¡£
OracleConnection
OracleCommand
OracleParameter
OracleDataReader
OracleDataAdapter
5. ʵÀý
Àý1£º ¸ù¾Ý²¿ÃÅID »ñÈ¡²¿ÃÅÃû³Æ
string oradb = "Data Source=TESTASM;User Id=hr;Password=hr;";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
OracleParameter param = new OracleParameter();
param.OracleDbType = OracleDbType.Decimal;
param.Value = textBox1.Text;
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.Parameters.Add(param);
cmd.CommandText = "select department_name from departments where department_id = :1";
if(dr.Read())
{
textBox1.Text = dr.GetString(
Ïà¹ØÎĵµ£º
Èç¹ûÄãµÄ¼òÀúÉÏÃæÐ´“ÊìϤ/Á˽âC#”£¬ÄÇôÄã¾ÍÓ¦¸ÃÄܹ»»Ø´ðÏÂÃæµÄÕâЩ»ù´¡ÎÊÌâ¡£
´«Èëij¸öÊôÐÔµÄset·½·¨µÄÒþº¬²ÎÊýµÄÃû³ÆÊÇʲô£¿
value£¬ËüµÄÀàÐͺÍÊôÐÔËùÉùÃûµÄÀàÐÍÏàͬ¡£
ÈçºÎÔÚC#ÖÐʵÏּ̳У¿
ÔÚÀàÃûºó¼ÓÉÏÒ»¸öðºÅ£¬ÔÙ¼ÓÉÏ»ùÀàµÄÃû³Æ¡£
C#Ö§³Ö¶àÖØ¼Ì³Ðô£¿
²»Ö§³Ö¡£¿ÉÒÔÓýӿÚÀ´ÊµÏÖ¡£
±»protecte ......
1¡¢Ð½¨Ò»¸öÀà¿âÏîÄ¿
2¡¢½«Class1.cs¸ÄΪÎÒÃÇÏëÒªµÄÃû×Ö
ÎÊÊÇ·ñͬʱ¸øÀà¸ÄÃû£¬È·¶¨
3¡¢ÐÞ¸ÄPropertiesĿ¼ÏÂÃæµÄAssemblyInfo.cs
ComVisibleÊôÐÔÉèÖÃΪTrue
4¡¢ÏîÄ¿²Ëµ¥->MyLibÊôÐÔ
ÕÒµ½“Éú³É”Ñ¡Ï
ÍùÏ¿´£¬ÕÒµ½“Ϊ COM Interop ×¢²á”¹´ÉÏ
5¡¢¼ÌÐøÍùÏ£¬ÕÒµ½“Ç©Ãû&rdqu ......
1¡¢C/C++³ÌÐòÔ±Çë×¢Ò⣬²»ÄÜÔÚcaseÓï¾ä²»Îª¿Õʱ“ÏòÏÂÖ´ÐД¡£
¡¡¡¡2¡¢ÖµÀàÐͺÍÒýÓÃÀàÐÍÖ®¼äµÄÇø±ð£ºC#µÄ»ù±¾ÀàÐÍ(int£¬charµÈ)¶¼ÊÇÖµÀàÐÍ£¬ÊÇÔÚÕ»Öд´½¨µÄ¡£¶ø¶ÔÏóÊÇÒýÓÃÀàÐÍ£¬´´½¨ÓÚ¶ÑÖУ¬ÐèҪʹÓùؼü×Önew¡£
¡¡¡¡3¡¢ÔÚC#ÖÐͨ¹ýʵÀý·ÃÎʾ²Ì¬·½·¨»ò³ÉÔ±±äÁ¿ÊDz»ºÏ·¨µÄ£¬»áÉú³É±àÒëÆ÷´íÎó¡£µ«ÊÇÎÒÃÇ¿ÉÒÔͨ¹ýÉù ......
½üÀ´ORM±äµÃÔ½À´Ô½ÆÕ±é£¬Õâ¶¼¹éÓÚÒ»Öֺܾß˵·þÁ¦µÄÔÒò£»Ëü¿ÉÒÔʹ¿ª·¢Êý¾Ý¿âÇý¶¯µÄÓ¦ÓóÌÐò±äµÃ¸ü¿ì¡¢¸üÊ¡Á¦¡£µ«ÊÇORM¿ò¼Ü¶¼Óе㓹ÌÖ´¼º¼û”£¬ËûÃÇÆÚÍû¿ª·¢Õß×ñ´ÓÌØ¶¨µÄ¹æÔò£¬µ±¹æÔò±»´òÆÆµÄʱºò¾Í·Ç³£ÄÑÒÔʹÓá£×îͨ³£µÄ¹æÔòÖ®Ò»¾ÍÊÇ£¬´æ´¢¹ý³Ì±ØÐë×ÜÊÇ·µ»Øµ¥¶ÀµÄ½á¹û¼¯£¬ÆäÖд ......