Question

asp.net 提示说OleDbconnection未定义类型

Public Sub bind()
Dim mystr As String = _
ConfigurationManager.AppSettings("myconnstring")
Dim myspl As String = "SELECT student.学号,student.姓名," & _
"score.课程名,score.分数,student.班号 " & _
"FROM student,score " & _
"WHERE student.学号 =score.学号 " & _
"ORDER BY student.学号"
Dim myconn As New OleDbconnection()
myconn.ConnectionString = mystr
myconn.Open()
Dim myds As New Dataset()
Dim myda As New OleDbDataAdapter(mysql, myconn)
myda.Fill(myds, "student")
GridView1.DataSource = myds.Tables(0)
GridView1.DataBind()
myconn.Close()
End Sub
打得一个事件可一直提示里面OleDbconnection，Dataset未定义类型，跟书上打的一样，也不知道到底哪里错了

Answer 1

第一：有买有添加引用
system.data
system.configuration

第二： Dim myspl As String =
Dim myda As New OleDbDataAdapter(mysql, myconn)

myspl != mysql

Imports System.Configuration
Imports System.Data.OleDb

Module Module1

Sub Main()

End Sub

Public Sub bind()
Dim mystr As String = _
ConfigurationManager.AppSettings("myconnstring")
Dim mysql As String = "SELECT student.学号,student.姓名," & _
"score.课程名,score.分数,student.班号 " & _
"FROM student,score " & _
"WHERE student.学号 =score.学号 " & _
"ORDER BY student.学号"
Dim myconn As New OleDbConnection()
myconn.ConnectionString = mystr
myconn.Open()
Dim myds As New DataSet()
Dim myda As New OleDbDataAdapter(mysql, myconn)
myda.Fill(myds, "student")
GridView1.DataSource = myds.Tables(0)
GridView1.DataBind()
myconn.Close()
End Sub

End Module

Answer 2

15个积分没动力啊