17,748
社区成员




Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim conn As New SqlConnection()
conn.ConnectionString = "Data Source=(local)\SQLEXPRESS;Initial Catalog=mywork;Integrated Security=True"
Dim mytable As New DataTable
Dim myadapter As New SqlDataAdapter
myadapter.InsertCommand = New SqlCommand("insert into users values(4,'test',1,1111,'bejing','True','False')", conn)
myadapter.SelectCommand = New SqlCommand("select * from users", conn)
myadapter.Update(mytable)
myadapter.Fill(mytable)
DataGridView2.DataSource = mytable
DataGridView1.Refresh()
End Sub