主题:vb.net问题求助——困惑啊
[em10]
用sql server 数据库或是oracle 数据库连接运行时都出现以下提示,在dataset数据集里可以预览到数据。那位高人帮忙解决一下,十分感激!
Imports System
Imports System.Data
Imports System.Data.oledb
Public Class form2
Inherits System.Windows.Forms.Form
Dim n As Integer = 0
Dim myconnection As OleDbConnection = New OleDbConnection("server=server1;database=aaa;provider=msdaora.1;useid=sa;password=password")
Dim mydataadapter As New OleDbDataAdapter
Dim mydataset As DataSet = New DataSet
Private Sub form2_load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
mydataadapter.SelectCommand = New OleDbCommand
mydataadapter.SelectCommand.Connection = myconnection
mydataadapter.SelectCommand.CommandText = "select * from info_userlist"
mydataadapter.SelectCommand.CommandType = CommandType.Text
mydataadapter.Fill(mydataset, "info_userlist")
未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
[color=008000]mydataadapter.fill(mydataset,"info_userlist")[/color]
用sql server 数据库或是oracle 数据库连接运行时都出现以下提示,在dataset数据集里可以预览到数据。那位高人帮忙解决一下,十分感激!
Imports System
Imports System.Data
Imports System.Data.oledb
Public Class form2
Inherits System.Windows.Forms.Form
Dim n As Integer = 0
Dim myconnection As OleDbConnection = New OleDbConnection("server=server1;database=aaa;provider=msdaora.1;useid=sa;password=password")
Dim mydataadapter As New OleDbDataAdapter
Dim mydataset As DataSet = New DataSet
Private Sub form2_load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
mydataadapter.SelectCommand = New OleDbCommand
mydataadapter.SelectCommand.Connection = myconnection
mydataadapter.SelectCommand.CommandText = "select * from info_userlist"
mydataadapter.SelectCommand.CommandType = CommandType.Text
mydataadapter.Fill(mydataset, "info_userlist")
未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中。
[color=008000]mydataadapter.fill(mydataset,"info_userlist")[/color]