VB.NET MYSQL DataGridView 增删改查（INSERT,SELECT,UPDATE,DELETE）

最新推荐文章于 2023-02-12 08:56:52 发布

weixin_39000912

最新推荐文章于 2023-02-12 08:56:52 发布

阅读量818

点赞数 1

文章标签： mysql vb.net

本文链接：https://blog.csdn.net/weixin_39000912/article/details/113833213

版权

这篇博客介绍了如何使用VB.NET与MYSQL数据库进行交互，实现DataGridView组件的数据增删改查功能，包括INSERT、SELECT、UPDATE和DELETE操作。

摘要由CSDN通过智能技术生成

VB.NET MYSQL DataGridView 增删改查（INSERT,SELECT,UPDATE,DELETE）

留存备用。

Imports MySql.Data.MySqlClient
 
 
Public Class Form1
 
 
    ' GLOBAL DECLARATIONS
    Dim conString As String = "Server=localhost;Database=net2;Uid=root;Pwd=123456;"
    Dim con As New MySqlConnection(conString)
    Dim cmd As MySqlCommand
    Dim adapter As MySqlDataAdapter
    Dim dt As New DataTable()
 
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        'CONSTRUCT DATAGRIDVIEW
        DataGridView1.ColumnCount = 4
 
        DataGridView1.Columns(0).Name = "ID"
        DataGridView1.Columns(1).Name = "Name"
        DataGridView1.Columns(2).Name = "Position"
        DataGridView1.Columns(3).Name = "Team"
 
        DataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect
 
    End Sub
    'CLEAR TXT
    Private Sub cleartxt()
        nameTxt.Text = ""
        PosTxt.Text = ""
        TeamTxt.Text = ""
    End Sub
 
 
    'INSERT INTO DB
    Private Sub Add()
        Dim sql As String = "INSERT INTO peopletb(Name,Position,Team) VALUES(@PNAME,@POSITION,@TEAM)"
 
        cmd = New MySqlCommand