Question

VB.net做一个小程序 求教

请大神帮我看看问题出在哪里?另外我如果要加Button1点击执行结果输出在DataGridView1中 应该怎么写?谢谢了,小白求教!~ Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load Dim oleDbConnection1 As OleDb.OleDbConnection Dim oledbDataAdapter As OleDb.OleDbDataAdapter Dim oledbData As DataSet = New DataSet Dim strConnect As String = "Provider= OraOLEDB.Oracle;Data Source=888;User ID=888;Password=888;" oleDbConnection1 = New System.Data.OleDb.OleDbConnection(strConnect) Dim strSql As String strSql = "select *" & " from xx" Dim oledbCommand As OleDb.OleDbCommand oledbCommand.CommandText = strSql oledbCommand.CommandType = CommandType.Text oledbCommand.Connection = oleDbConnection1 oledbDataAdapter.SelectCommand = oledbCommand oleDbConnection1.Open() oledbDataAdapter.Fill(oledbData, "gy_bingrenxx") oleDbConnection1.Close() End Sub





Answer 1

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Dim oleDbConnection1 As OleDb.OleDbConnection
Dim oledbDataAdapter As OleDb.OleDbDataAdapter
Dim oledbData As DataSet = New DataSet
Dim strConnect As String = "Provider= OraOLEDB.Oracle;Data Source=888;User ID=888;Password=888;"
oleDbConnection1 = New System.Data.OleDb.OleDbConnection(strConnect)
Dim strSql As String
strSql = "select *" & " from xx"
Dim oledbCommand As OleDb.OleDbCommand
oledbCommand.CommandText = strSql
oledbCommand.CommandType = CommandType.Text
oledbCommand.Connection = oleDbConnection1
oledbDataAdapter.SelectCommand = oledbCommand
oleDbConnection1.Open()
oledbDataAdapter.Fill(oledbData, "gy_bingrenxx")
oleDbConnection1.Close()

'在窗体上添加一个DataGridView控件,在这个位置加一句代码
DataGridView1.DataSource = oledbDataAdapter.Tables("gy_bingrenxx")

End Sub

追问

我调试了下但是还是报错

追答

你先按照我说的，直接放在 Form1_Load(）事件里，可以看到结果吗？
你那样不行的！

追问

先放在了Form1时间里面 调试报错(还没添加DataGridView控件)

添加后

老师哪里处理问题 ?