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(
Ïà¹ØÎĵµ£º
public void SetWindowRegion()
{
System.Drawing.Drawing2D.GraphicsPath FormPath;
FormPath =
new System.Drawing.Drawing2D.GraphicsPath();
Rectangle
rect=ne ......
֮ǰ²»Ì«Ï²»¶C#£¬ÎÞÒâÖз¢ÏÖlinq,ÓÃÀ´ÊµÏÖÅÅÐòÊÇÈç´Ë¼òµ¥£¬ËùÒÔÓÖÓÃC#дÁË±é·¢ÅÆ³ÌÐò
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace ConsoleApplication1
{
class Program
{
&nb ......
SqlserverÕâ¶«Î÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......
ÕâЩÌìÒòΪ¹¤×÷ÐèÒª£¬Òª½«Ò»Ð©htmlÎļþת»»ÎªchmÎļþ£¬µ±È»ÊÇÐèÒªºÍ³ÌÐò½áºÏÔÚÒ»Æð¡£
ºóÀ´ÕÒµ½NDoc£¬ÀïÍ·ÓÐÒ»¶Î´úÂëÊÇÏà¹ØµÄ£¬ÓÚÊÇ¿ªÊ¼·ÖÎö´úÂ룬дÍêÖ®ºó£¬×ܽ᣺Ö÷ÒªÊÇÀûÓÃ΢ÈíµÄhhc.exeÀ´±àÒëhtmlÎļþ£¬³ÌÐòÐèÒª½«¾ßÌåµÄÊý¾ÝдÈëhhpºÍhhcÎļþ¡£
Ö÷Òª´úÂëÈçÏ£º
¸´ÖÆC#´úÂë±£´æ´úÂëpublic void CompileProject()
{ ......