def num(s):
"""num(s)
num(3),num(3.7)-->3
num('3')-->3, num('3.7')-->3.7
num('3,700')-->ValueError
num('3a'),num('a3'),-->ValueError
num('3e4') --> 30000.0
"""
try:
return int(s)
except ValueError:
try:
return float(s)
except ValueError:
raise ValueError('argument is not a string of number')
Зачем вы вызываете функцию load_table и load_table2 в событии нажатия кнопки? попробуйте удалить вызов функции, поскольку событие нажатия кнопки уже запрашивает базу данных.
Private Sub Button3_Click(sender As System.Object, e As System.EventArgs) Handles Button3.Click
"'load_table2()<<-----"
sConnection = New MySqlConnection
sConnection.ConnectionString = "server=localhost;userid=root;password=;database=cph;Convert Zero Datetime=True"
Dim SDAX As New MySqlDataAdapter
Dim sqlCommand As New MySqlCommand
Dim bSource As New BindingSource
Try
sConnection.Open()
Dim Query As String
Query = "select emp_no, emp_firstnm, emp_midnm, emp_lastnm, schedtype from employee_table"
sqlCommand = New MySqlCommand(Query, sConnection)
SDAX.SelectCommand = sqlCommand
SDAX.Fill(dbDataSet2)
bSource.DataSource = dbDataSet2
DataGridView2.DataSource = bSource
SDAX.Update(dbDataSet2)
sConnection.Close()
Catch ex As MySqlException
MessageBox.Show(ex.Message)
Finally
sConnection.Dispose()
End Try
End Sub
UPDATE
ИЛИ как это
Private Sub Button3_Click(sender As System.Object, e As System.EventArgs) Handles Button3.Click
load_table2()
End Sub