Dodawanie pól Access przez program napisany w visual basic

Question

Witam,

Mam pytanie: Jaki kod napisać "pod przyciskiem", aby do podłączonej bazy danych dodać nowe pole i je wyświetlić?

Pozdrawiam

Comments

Personalizar DataGridView - VS, C#, VB

Answer 1

VB.Net - Database Access - Scroll to Example 3 - Creating Table, Columns and Rows
Visual Basic 2017 Lesson 36: Browsing and Editing Data
Adding and Saving Records to Access Database using VB.NET
Insert, Update, Delete & Search Values in MS Access 2003 with VB.NET 2005

INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008 Part 1
INSERT, DELETE, UPDATE AND SELECT Data in MS-Access with VB 2008 Part 2

Read data from SQL Query in VB.Net

Simple Visual Basic Database Application using Data Control -Tutorial for beginners
How to Connect Access Database to VB.NET - Visual Studio 2015
VB.NET MS Access Database Tutorial 2 # Add New ,Remove ,Save Data in Database using VB.NET
VB.NET Tutorial - Insert Update Delete Data in Database from DataGridView 

Comments

Private Sub AddRow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles AddRow.Click
  
        Try
            Dim sqlConn As New OleDb.OleDbConnection
            Dim sqlQuery As New OleDb.OleDbCommand
            Dim connString As String
            connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Visual Studio 2010 Express\Projects\Invent\mdbInvent.accdb"
            sqlConn.ConnectionString = connString
            sqlQuery.Connection = sqlConn
            sqlConn.Open()
            sqlQuery.CommandText = "INSERT INTO users ([Username], [Password]) VALUES (@Username, @Password)"
            sqlQuery.Parameters.AddWithValue("@Username", txtUserName.Text)
            sqlQuery.Parameters.AddWithValue("@Password", txtPassword.Text)
            sqlQuery.ExecuteNonQuery()
            sqlConn.Close()
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
         
    End Sub