Public
Class Form1
    Private Const CONNECTION_STRING = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=C:\BD\Cadastro.accdb"
    Private Sub Button1_Click(ByVal
sender As System.Object,
ByVal e As
System.EventArgs) Handles
Button1.Click
        Dim catalogo As New ADOX.Catalog
        Try
            catalogo.Create(CONNECTION_STRING)
            MessageBox.Show("Banco
criado com sucesso!")
        Catch ex As Exception
        End Try
    End Sub
    Private Sub Button2_Click(ByVal
sender As System.Object,
ByVal e As
System.EventArgs) Handles
Button2.Click
        Dim
conn As New
OleDb.OleDbConnection(CONNECTION_STRING)
        Dim cmd
As New OleDb.OleDbCommand("CREATE
TABLE Contato (ID int not null, Nome varchar(50))", conn)
        conn.Open()
       
cmd.ExecuteNonQuery()
        MessageBox.Show("Tabela
'Contato' criada com sucesso!")
    End Sub
    Private Sub Button3_Click(ByVal
sender As System.Object,
ByVal e As
System.EventArgs) Handles
Button3.Click
        Dim
conn As New
OleDb.OleDbConnection(CONNECTION_STRING)
        Dim cmd
As New OleDb.OleDbCommand()
        cmd.Connection = conn
        cmd.CommandType = CommandType.Text
        conn.Open()
        cmd.CommandText = "INSERT INTO Contato VALUES (1, 'Contato 1')"
        cmd.ExecuteNonQuery()
        cmd.CommandText = "INSERT INTO Contato VALUES (2, 'Contato 2')"
        cmd.ExecuteNonQuery()
        cmd.CommandText = "INSERT INTO Contato VALUES (3, 'Contato 3')"
        cmd.ExecuteNonQuery()
        MessageBox.Show("Registros
inseridos com sucesso!")
    End Sub
End Class

 
 
0 comentários:
Postar um comentário