datagridvew简单使用

在窗体上用VB.net对datagridview进行简单的增删改查

刚刚学两天，主要是做个记录

界面设计如下

运行结果如下

代码如下

Public Class Form1
Dim myconnect As New SqlClient.SqlConnection
'Dim mytable As New DataTable()
Dim SDA As SqlClient.SqlDataAdapter
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles  MyBase.Load
    'TODO: 这行代码将数据加载到表“MasterDataSet.test”中。您可以根据需要移 动或删除它。
    'Me.TestTableAdapter.Fill(Me.MasterDataSet.test)
    load()
End Sub

Public Sub load()
    start()
    SDA = New SqlClient.SqlDataAdapter("select * from test", myconnect)
    close1()
End Sub

Public Sub start()
    myconnect.ConnectionString = "server=127.0.0.1;database=master;integrated security=true;uid=c