16,721
社区成员
发帖
与我相关
我的任务
分享请问在vb.net中如何连接Oracle数据库阿？
请问在vb.net中如何连接Oracle数据库阿？相对来说哪种方法更好一些阿？
...全文
请发表友善的回复…
发表回复
liangzai6640459 2004-08-30
- 打赏
- 举报
自己顶一下!
liangzai6640459 2004-08-30
- 打赏
- 举报
大家可不可以给贴个例子阿！我试了几个方法都连不上啊·！大家看看这个行不？
Dim myConnString As String = _
"Data Source=ORACLE8i;User Id=kon;Password=kon;Integrated Security=no;"
Dim myConnection As New System.Data.OracleClient.OracleConnection(myConnString)
Dim myDataAdapter As New OracleDataAdapter
Dim myDataSet As DataSet
myDataAdapter.SelectCommand = New OracleCommand
myDataAdapter.SelectCommand.Connection = myConnection
myDataAdapter.SelectCommand.CommandText = _
"SELECT * " & _
"FROM ST_USER"
myDataAdapter.SelectCommand.CommandType = CommandType.Text
myConnection.Open()
myDataAdapter.SelectCommand.ExecuteNonQuery()
myDataAdapter.Fill(myDataSet, "ST_USER")
myConnection.Close()
grdUser.DataSource = myDataSet
grdUser.DataMember = "ST_USER"
Dim myConnString As String = _
"Data Source=ORACLE8i;User Id=kon;Password=kon;Integrated Security=no;"
Dim myConnection As New System.Data.OracleClient.OracleConnection(myConnString)
Dim myDataAdapter As New OracleDataAdapter
Dim myDataSet As DataSet
myDataAdapter.SelectCommand = New OracleCommand
myDataAdapter.SelectCommand.Connection = myConnection
myDataAdapter.SelectCommand.CommandText = _
"SELECT * " & _
"FROM ST_USER"
myDataAdapter.SelectCommand.CommandType = CommandType.Text
myConnection.Open()
myDataAdapter.SelectCommand.ExecuteNonQuery()
myDataAdapter.Fill(myDataSet, "ST_USER")
myConnection.Close()
grdUser.DataSource = myDataSet
grdUser.DataMember = "ST_USER"
抬头望天边一只雁 2004-08-27
- 打赏
- 举报
在这里搜索一下应该有很多啦。
蓝海狙机 2004-08-27
- 打赏
- 举报
dataset
plmmdem 2004-08-27
- 打赏
- 举报
弄错了，查看msdn帮助吧
plmmdem 2004-08-27
- 打赏
- 举报
http://dev.csdn.net/develop/article/18/18623.shtm
这上面有好方法，可以借鉴！
这上面有好方法，可以借鉴！
ghost225 2004-08-27
- 打赏
- 举报
http://www.connectionstrings.com/
都有了
都有了
