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(
Ïà¹ØÎĵµ£º
Ê×ÏÈÐèÒªÔÚÏîÄ¿ÖÐÌí¼Ó(Microsoft XML, v3.0)µÄÒýÓÃ
using MSXML2;
private string VerifyNotifyURL(string URL)
{
MSXML2.XMLHTTPClass xmlhttp=new MSXML2.XMLHTTPClass();
try
{
&nbs ......
Èç¹ûÄãµÄ¼òÀúÉÏÃæÐ´“ÊìϤ/Á˽âC#”£¬ÄÇôÄã¾ÍÓ¦¸ÃÄܹ»»Ø´ðÏÂÃæµÄÕâЩ»ù´¡ÎÊÌâ¡£
´«Èëij¸öÊôÐÔµÄset·½·¨µÄÒþº¬²ÎÊýµÄÃû³ÆÊÇʲô£¿
value£¬ËüµÄÀàÐͺÍÊôÐÔËùÉùÃûµÄÀàÐÍÏàͬ¡£
ÈçºÎÔÚC#ÖÐʵÏּ̳У¿
ÔÚÀàÃûºó¼ÓÉÏÒ»¸öðºÅ£¬ÔÙ¼ÓÉÏ»ùÀàµÄÃû³Æ¡£
C#Ö§³Ö¶àÖØ¼Ì³Ðô£¿
²»Ö§³Ö¡£¿ÉÒÔÓýӿÚÀ´ÊµÏÖ¡£
±»protecte ......
private void Create_Pz(string Sourcename)
{
string OutMsg;
SqlParameter[] sortPara = { new SqlParameter("@ps_IsType", Pz ......
SqlserverÕâ¶«Î÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......
ÕâЩÌìÒòΪ¹¤×÷ÐèÒª£¬Òª½«Ò»Ð©htmlÎļþת»»ÎªchmÎļþ£¬µ±È»ÊÇÐèÒªºÍ³ÌÐò½áºÏÔÚÒ»Æð¡£
ºóÀ´ÕÒµ½NDoc£¬ÀïÍ·ÓÐÒ»¶Î´úÂëÊÇÏà¹ØµÄ£¬ÓÚÊÇ¿ªÊ¼·ÖÎö´úÂ룬дÍêÖ®ºó£¬×ܽ᣺Ö÷ÒªÊÇÀûÓÃ΢ÈíµÄhhc.exeÀ´±àÒëhtmlÎļþ£¬³ÌÐòÐèÒª½«¾ßÌåµÄÊý¾ÝдÈëhhpºÍhhcÎļþ¡£
Ö÷Òª´úÂëÈçÏ£º
¸´ÖÆC#´úÂë±£´æ´úÂëpublic void CompileProject()
{ ......