16,555
社区成员
发帖
与我相关
我的任务
分享
Imports System.Data
Imports System.Data.SqlClient
Public Class CustomerDetails
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim myConn = New SqlConnection("Data Source = .\SQLEXPRESS; AttachDbFilename = |DataDirectory|\Travel.mdf; Integrated Security=True;Connect Timeout=30;User Instance=True")
Dim myQuery = "SELECT * FROM Customer "
Dim myCommand As New SqlCommand(myQuery, myConn)
myConn.Open()
Dim myAdpt As New SqlDataAdapter(myCommand)
Dim myDT As New DataTable()
myAdpt.Fill(myDT)
DataGridView1.DataSource = myDT
myConn.Close()
End Sub
Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click
'在这里怎么写 才能 保存对 DataGridView1 表格的编写 到 数据库里呢
End Sub
End class