请各位高手看下,这个过程有什么问题????
我现在遇到的问题是:
选择第一次时可以在文本框出现,但选择第二次时不能用,并且提出出错。请高手们指点。
Dim SQLString As String = "SELECT * FROM grade WHERE gradeid='" & lvgrade.SelectedItems(0).Text & "'"
MyConnection.Open()
MyCommand = New OleDbCommand(SQLString, MyConnection)
MyReader = MyCommand.ExecuteReader()
While MyReader.Read
Me.combogradeid.Text = MyReader("gradeid").ToString
Me.txtgrade.Text = MyReader("grade").ToString
End While
MyConnection.Close()
MyReader.Close()
MyCommand.Dispose()
我现在遇到的问题是:
选择第一次时可以在文本框出现,但选择第二次时不能用,并且提出出错。请高手们指点。
Dim SQLString As String = "SELECT * FROM grade WHERE gradeid='" & lvgrade.SelectedItems(0).Text & "'"
MyConnection.Open()
MyCommand = New OleDbCommand(SQLString, MyConnection)
MyReader = MyCommand.ExecuteReader()
While MyReader.Read
Me.combogradeid.Text = MyReader("gradeid").ToString
Me.txtgrade.Text = MyReader("grade").ToString
End While
MyConnection.Close()
MyReader.Close()
MyCommand.Dispose()