16,556
社区成员
发帖
与我相关
我的任务
分享
Using dt As New DataTable
dt.Columns.Add("STKID")
For i = 0 To ListBox1.Items.Count - 1
IpAddress = ListBox1.Items(i)
Try
Dim cn As New MySqlConnection("server=" & IpAddress & ";uid=***;pwd=***;database=***;")
cn.Open()
Dim sql As String = "Select ************** From************* Where ***********"
cm = New MySqlCommand(sql, cn)
dr = cm.ExecuteReader()
dt.Load(dr)
For Each row As DataRow In dt.Rows
row.Item("STKID") = IpAddress
Next
Catch ex As Exception
MsgBox("错误")
End Try
Next
DataGridView2.DataSource = dt
DataGridView2.AllowUserToAddRows = False
End Using