L使用(rdr as mysqldatareader = cmd.executereader())rdr在此行上出现此错误 [英] L get this an error on this line using (rdr as mysqldatareader = cmd.executereader()) rdr
问题描述
当我运行此代码时,我得到错误
(rdr As MySqlDataReader = cmd.ExecuteReader())rdr未声明,它可能无法访问它的保护水平。请帮帮忙!
我的尝试:
私人FPList As新列表(AppData)
Private Sub Me_Load(ByVal sender As System.Object,ByVal e AsSystem.EventArgs)
处理MyBase。加载
初始化()
StartCapture()
Dim sql As String =SELECT * FROM new_case_file
使用conn作为新的MySqlConnection(****),_
cmd作为新的MySqlCommand(sql,conn)
conn.Open()
使用(rdr As MySqlDataReader = cmd.ExecuteReader())
FPList.Clear()
while(rdr.Read())
Dim tmpObj As New AppData
tmpObj.No = rdr(No)。ToString()
Dim fpBytes As Byte()= rdr(FingerPrint)
使用MemStream As New IO.MemoryStream(fpBytes)
Dim templa8 As New DPFP.Template()
templa8.DeSerialize(MemStream)
tmpObj.Template = templa8
结束使用
FPList.Add(tmpObj)
结束时
rdr.Close()
结束使用
结束使用
End Sub
When l run this code l get the error
(rdr As MySqlDataReader = cmd.ExecuteReader()) rdr is not declared, it may be inaccessible due to its protection level. Please help!
What I have tried:
Private FPList As New List(Of AppData)
Private Sub Me_Load(ByVal sender As System.Object, ByVal e AsSystem.EventArgs)
Handles MyBase.Load
Init()
StartCapture()
Dim sql As String = "SELECT * FROM new_case_file"
Using conn As New MySqlConnection("**** "), _
cmd As New MySqlCommand(sql, conn)
conn.Open()
Using (rdr As MySqlDataReader = cmd.ExecuteReader())
FPList.Clear()
While (rdr.Read())
Dim tmpObj As New AppData
tmpObj.No = rdr("No").ToString()
Dim fpBytes As Byte() = rdr("FingerPrint")
Using MemStream As New IO.MemoryStream(fpBytes)
Dim templa8 As New DPFP.Template()
templa8.DeSerialize(MemStream)
tmpObj.Template = templa8
End Using
FPList.Add(tmpObj)
End While
rdr.Close()
End Using
End Using
End Sub
推荐答案
删除括号:
Remove the brackets:
Using (rdr As MySqlDataReader = cmd.ExecuteReader())
成为
Becomes
Using rdr As MySqlDataReader = cmd.ExecuteReader()
从语句中删除外括号,因此:
Remove the outer parenthesis fron the statement, thus:
Using rdr As MySqlDataReader = cmd.ExecuteReader()
参见使用声明(Visual Basic)| Microsoft Docs [ ^ ]。
这篇关于L使用(rdr as mysqldatareader = cmd.executereader())rdr在此行上出现此错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!