vb.net DGV不覆盖数据

最新推荐文章于 2025-06-22 11:45:57 发布

原创最新推荐文章于 2025-06-22 11:45:57 发布 · 418 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#vb.net

vb.net 专栏收录该内容

11 篇文章

订阅专栏

本文介绍了一种使用VB.NET从MySQL数据库填充DataGridView的方法。通过创建一个全局变量DataTable并使用MySqlConnection和MySqlDataAdapter，可以有效地从数据库中检索数据并显示在DataGridView控件上，确保数据不会被重复覆盖。

      Private DataTable1 As New DataTable   '设成全局变量'''''''''''''''''
      Dim connstr As String = String.Format("server={0};user id={1}; password={2};port={3}; database=test; pooling=true", "ip地址", "root", "123456", "3307")
      Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim MySqlConn As MySqlConnection
        If Not MySqlConn Is Nothing Then MySqlConn.Close()
        Try
            MySqlConn = New MySqlConnection(connstr)
            MySqlConn.Open()
            Dim Adp1 As New MySqlDataAdapter("select * from ....;", MySqlConn)  
            Adp1.Fill(DataTable1)
            Me.DataGridView1.DataSource = DataTable1
            MySqlConn.Close()
            MySqlConn.Dispose()
        Catch ex As Exception
            MessageBox.Show(ex.ToString)
        End Try
      End Sub

可实现DGV不覆盖数据