我的代码没有错误并且运行良好,但如果表单运行,它会弹出一条注释,指出"表单在构造期间从默认实例引用自身,导致无限递归。在窗体的构造函数中,使用 ME' 引用窗体。我知道注释是什么意思,但我的代码来自一个类,我怎么能写我。类中的 DataGridView1。
这是代码:
Public Function billing_member_data_grid_radiobutton4_checkchanged()
MysqlConn.ConnectionString = ServerString
Dim dbDataSet As New DataTable
Dim SDA As New MySqlDataAdapter
Dim bSource As New BindingSource
Try
MysqlConn.Open()
Dim query As String
query = "SELECT user_memberid as 'Member ID',user_firstname as 'First Name',user_middlename as 'Middle Name',user_lastname as 'Last Name',user_birthday as 'Birthday',user_age as 'Age',user_address as 'Address',user_contact as 'Contact Number',user_gender as 'Gender' FROM gym.user"
COMMAND = New MySqlCommand(query, MysqlConn)
SDA.SelectCommand = COMMAND
SDA.Fill(dbDataSet)
bSource.DataSource = dbDataSet
Billing_Member_Data_Grid.DataGridView1.DataSource = bSource
SDA.Update(dbDataSet)
MysqlConn.Close()
Catch ex As Exception
MsgBox(ex.Message)
Finally
MysqlConn.Dispose()
End Try
Return True
End Function
你需要调用 READER。阅读完后关闭((。