using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OracleClient;namespace TOracleConnection { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { OracleConnection conn = new OracleConnection(); conn.ConnectionString = "data source=<服务名>;user id=<用户名>;password=<密码>"; conn.Open(); } } }
using System.Data.OracleClient;strConn = "Data Source=**;Password=***;Persist Security Info=True;User ID=**;Unicode=True"; //链接字符串,可以在伺服器总管属性里面找到oConn = new OracleConnection(strConn); oConn.Open();strOracle = "你的SQL语句 "; OracleCommand Cmd = new OracleCommand(strOracle, oConn);OracleDataReader read = Cmd.ExecuteReader(); while (read.Read()) { //读取从数据库中找到的数据; }
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OracleClient;namespace WindowsApplication3 { class Class1 {
public static DataSet dataSet(string sqlstr) { DataSet ds = new DataSet(); try { OracleConnection conn; conn = new OracleConnection("Data Source=数据库服务名;User ID=用户名;Password=密码"); conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = sqlstr; cmd.Connection = conn; OracleDataAdapter da = new OracleDataAdapter(cmd); da.Fill(ds); } catch { MessageBox.Show("数据库连接错误!"); } finally { } return ds; }//返回指定sql语句的dataset } }
<connectionStrings >
<add name="connectionString" connectionString="server=oracle9i;user id=qc;password=zhangjie;"
providerName="System.Data.OracleClient" />
<add name="connectionString1" connectionString="server=ora9qc;user id=qc;password=zhangjie;"
providerName="System.Data.OracleClient" />
</connectionStrings>然后程序中使用:
public static string connstring = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
来获得连接字符串!然后connection,command之类的和sql一样!
当然前提是本机装有oracle client!配置一下服务名为连接串中的server!
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;namespace TOracleConnection
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void button1_Click(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection();
conn.ConnectionString = "data source=<服务名>;user id=<用户名>;password=<密码>";
conn.Open();
}
}
}
http://www.oracle86.com/doc_9i/win.920/a95896/o4c00035.htm
http://www.oracle86.com/doc_9i/win.920/a95896/o4c00047.htm
string constrfororacle = "Data Source=jxorcl; user=scott; password=oracle;";
//查找方法
public string QueryLNO(string lguid, string lsguid)
{
string conn = constrfororacle;
string str = "SELECT SLNO FROM staticstopinfo where LGUID = '" + lguid + "' and SGUID = '" + lsguid + "'";
OracleDataAdapter da = new OracleDataAdapter(str, conn);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
string slno = dt.Rows[0][0].ToString();
return slno;
}
//增删改方法,其他的换个sql语句就可以了
public void InserUpdateDeleteMethod(参数自己加)
{
oracleconn = new OracleConnection(constrfororacle);
string Sql = "insert into updatearrivaltime values (/*自己加*/)";
OracleCommand cmd = new OracleCommand(Sql, oracleconn);
try
{
if (oracleconn.State == ConnectionState.Closed)
{
oracleconn.Open();
}
cmd.ExecuteNonQuery();
}
catch
{ }
finally
{
oracleconn.Close();
}
}
你得有oracle客户端,那个datasource得在客户端配好
看这个也行
using System.Data.OracleClient;strConn = "Data Source=**;Password=***;Persist Security Info=True;User ID=**;Unicode=True"; //链接字符串,可以在伺服器总管属性里面找到oConn = new OracleConnection(strConn);
oConn.Open();strOracle = "你的SQL语句 ";
OracleCommand Cmd = new OracleCommand(strOracle, oConn);OracleDataReader read = Cmd.ExecuteReader();
while (read.Read())
{
//读取从数据库中找到的数据;
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OracleClient;namespace WindowsApplication3
{
class Class1
{
public static DataSet dataSet(string sqlstr)
{
DataSet ds = new DataSet(); try
{
OracleConnection conn;
conn = new OracleConnection("Data Source=数据库服务名;User ID=用户名;Password=密码");
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = sqlstr;
cmd.Connection = conn;
OracleDataAdapter da = new OracleDataAdapter(cmd);
da.Fill(ds); }
catch
{
MessageBox.Show("数据库连接错误!");
}
finally
{
}
return ds;
}//返回指定sql语句的dataset }
}
webconfig里配置好连接字符。就可以直接用
类里面啥方法都有!简单,方便,又实用。