SqlDataReader错误

[ircfan]

编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。

编译器错误信息: BC30002: 未定义类型“SqlDataReader”。

源错误:



行 12：
行 13： Private Sub bindgrid2()
行 14： Dim myDataReader As SqlDataReader
行 15： Dim mySqlConnection As SqlConnection
行 16： Dim mySqlCommand As SqlCommand

源码:
<%@ page language="vb" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient %>

<script runat="server">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
If Not Page.IsPostBack Then
bindgrid2()
End If
End Sub

Private Sub bindgrid2()
Dim myDataReader As SqlDataReader
Dim mySqlConnection As SqlConnection
Dim mySqlCommand As SqlCommand
mySqlConnection = New SqlConnection(ConfigurationSettings.AppSettings().Item("ConnectionString"))
mySqlCommand = New SqlCommand("select id,name,address,brief from companyinfo", mySqlConnection)
mySqlConnection.Open()
myDataReader = mySqlCommand.ExecuteReader(CommandBehavior.CloseConnection)
Repeater1.DataSource = myDataReader
Repeater1.DataBind()
End Sub
</script>

这是什么问题,怎么解决?

[ircfan]

错误是第14行

[gshope]

<%@ page language="vb" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient %>

这几行也放在最开头呀！

[acewang]

若要创建 SqlDataReader，必须调用 SqlCommand 对象的 ExecuteReader 方法，而不直接使用构造函数。
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT OrderID, CustomerID FROM Orders"
Dim myConnection As New SqlConnection(myConnString)
Dim myCommand As New SqlCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()
' Always call Read before accessing data.
While myReader.Read()
Console.WriteLine((myReader.GetInt32(0) & ", " & myReader.GetString(1)))
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
myConnection.Close()
End Sub 'ReadMyData

[liq1979]

Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()