連½ÓOracle數據庫
֮ǰÎÒÒ²ÓÐ談論過.netÖÐ對²»Í¬數據庫µÄ連½Ó²Ù×÷£¬這´Î單談談Oracle£¬Æä實ÄãÒª連½Óµ½Oracle數據庫ÊÇÒªÒªÇóÓÐ個Oracle.DataAccess.dll¡£¿ÉÒÔµ½Oracle網Õ¾ÏÂ載¡£Èç¹ûÄã°²裝ÁËOracleÁË£¬Ò²會ÓÐ這個dllÁË¡£ÒýÈë¾ÍOK
Òò為ÊÇ測試£¬學習¡£ËùÒÔ´ú碼Ò²簡單¡£
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using Oracle.DataAccess.Client;
using System.Windows.Forms;
namespace OraWinApp
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.3.14)(PORT=1521)))" + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=lab)));" + "User Id=adte;Password=adte123;";
OracleConnection conn = new OracleConnection(oradb);
try
{
conn.Open();
string sql = "select * from TB_ZCTYPE";
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = CommandType.Text;
OracleDataAdapter oda = new OracleDataAdapter();
oda.SelectCommand = cmd;
DataSet ds = new DataSet();
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
catch (Exception ex) // catches any error
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
conn.Close();
}
}
}
}
Æä實ºÜ¶à¶¼ÊǸúsqlÊÇÒ»樣µÄģʽ¡£ÎÒÒ²ÊÇ學Ň
Ïà¹ØÎĵµ£º
×î½ü×ܽáÁËÒ»ÏÂoracleÖ÷¼üµÄÉèÖ÷½·¨£¬Ìùµ½Õâ±£´æÒ»Ï°ɡ£ ÓÐÁ½ÖÖ·½·¨¿ÉÒÔÉèÖÃÖ÷¼ü£¬Ò»ÖÖÊÇ×ÔÔö³¤Ö÷¼ü£¬ÁíÒ»ÖÖ¾ÍÊÇÉú³ÉΨһÐòÁС£ Ò»¡¢×ÔÔö³¤Ö÷¼ü --Ê×ÏȽ¨Ò»¸ö±íTEST
create tableTEST (
NID int PRIMARY KEY,
test1 varchar2(20),
test2 varchar2(20),
test3 ......
Oracle Spatial ¼ò½é£º
Ê×ÏÈ£¬Oracle Ö§³Ö×Ô¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬Äã¿ÉÒÔÓÃÊý×飬½á¹¹Ìå»òÕß´øÓй¹Ô캯Êý£¬¹¦Äܺ¯ÊýµÄÀàÀ´¶¨Òå×Ô¼ºµÄ¶ÔÏóÀàÐÍ¡£ÕâÑùµÄ¶ÔÏóÀàÐÍ¿ÉÒÔÓÃÓÚÊôÐÔÁеÄÊý¾ÝÀàÐÍ£¬Ò²¿ÉÒÔÓÃÀ´´´½¨¶ÔÏó±í¡£¶øOracle SpatialÒ²ÕýÊÇ»ùÓÚ´ËÖÖÌØÐÔËù¿ª·¢µÄÒ»Ì׿ռäÊý¾Ý´¦Àíϵͳ¡£
Spatial µÄ×Ô¶¨ÒåÊý¾ÝÀàÐÍÓкܶ࣬¶¼ÔÚMDSYS· ......
ÈçºÎ¼ÓËÙOracle´óÅúÁ¿Êý¾Ý´¦Àí
Ò»¡¢ Ìá¸ßDML²Ù×÷µÄ°ì·¨£º
¼òµ¥ËµÀ´£º
£±¡¢ÔÝÍ£Ë÷Òý£¬¸üкó»Ö¸´.±ÜÃâÔÚ¸üеĹý³ÌÖÐÉæ¼°µ½Ë÷ÒýµÄÖØ½¨.
£²¡¢ÅúÁ¿¸üУ¬Ã¿¸üÐÂһЩ¼Ç¼ºó¼°Ê±½øÐÐÌá½»¶¯×÷.±ÜÃâ´óÁ¿Õ¼Óûعö¶ÎºÍ»òÁÙʱ±í¿Õ¼ä.
£³¡¢´´½¨Ò»ÁÙʱµÄ´óµÄ±í¿Õ¼äÓà ......
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/chinhr/archive/2009/04/22/1440914.html
·½·¨Ò»£º
ÔÚĿǰ¾ø´ó²¿·ÖÊý¾Ý¿âÓзֲ¼Ê½²éѯµÄÐèÒª¡£ÏÂÃæ¼òµ¥µÄ½éÉÜÈçºÎÔÚoracleÖÐÅäÖÃʵÏÖ¿ç¿â·ÃÎÊ¡£
±ÈÈçÏÖÔÚÓÐ2¸öÊý¾Ý¿â·þÎñÆ÷£¬°²×°ÁË2¸öÊý¾Ý¿â¡£Êý¾Ý¿âserver AºÍB¡£ÏÖÔÚÀ´ÊµÏÖÔÚA¿âÖзÃÎÊBµÄÊý¾Ý¿â¡£
µÚÒ»²½¡¢ÅäÖÃA·þÎñÆ÷¶ËµÄtnsnam ......