急需对oracle数据库 连接，增，删，改，查操作的示例代码。请赐教

[lanyahuhu]

rt

[yuanylong]

1)定义连接
MyConn = New System.Data.OleDb.OleDbConnection("Provider=MSDAORA.1;Data Source=oracle9;User ID=test;Password=test;")
2）定义并执行命令
Me.cmdinsert = New System.Data.OleDb.OleDbCommand()
'定义并设置命令的属性。
Me.cmdinsert.CommandText = "insert into table(name,old,nation) values('" & Me.Tname.Text & "'," & "to_date('" & Me.Told.Text & "','dd/mm/yy')" & ",'" & Me.Tnation.Text & "')"
Me.cmdinsert.CommandType = CommandType.Text
Me.cmdinsert.Connection = Me.MyConn
'打开数据库连接
Me.MyConn.Open()
'调用ExecuteNonQuery命令，执行无返回值的insert命令。
Me.cmdinsert.ExecuteNonQuery()
Me.MyConn.Close()

[wzf0125]

(1)连接
string strconn = "data source=source;user=sa;password=sa;";
OracleConnection myConnection = new OracleConnection(strconn);
myConnection.Open();
(2)
string strsel = "select * from table_name";
or strsel = "insert into table(id,name) values('1','23')";
or strsel = "delete from table where id='1'";
OracleCommand mycom = new OracleCommand(strsel,myConnection);
mycom.ExecuteNonReader();
myConnection.Close();

[lanyahuhu]

行 26：string sConn = System.Configuration.ConfigurationSettings.AppSettings["DbConn"];
行 27： m_Conn=new OleDbConnection(sConn);
行 28： m_Conn.Open();
报错如下 ：

异常详细信息: System.Data.OleDb.OleDbException: 拒绝访问。

[lanyahuhu]

谁能给我一个下载类似代码的地方

[chinanewway]

我知道的，要么你的数据库不是信任连接，你就必须写上user id和password,这样才能访问数据库；或者是你的oracle数据库服务未启动。

[chinanewway]

在web.config文件中可以加入键值如下：
<appSettings>
<add key="oleDbConnection.ConnectionString" value="packet size=4096;user id=lamis;password=lamis;data source="LAMIS-SERVER";provider=SQLOLEDB;persist security info=False;initial catalog=lamis;workstation id=SOSORE" />
<add key="strConnection" value="data source=LAMIS-SERVER;initial catalog=lamis;persist security info=False;user id=lamis;password=lamis;workstation id=CXQ;packet size=4096" />
</appSettings>