Module Module1
Sub Main()
Dim connStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\CIM_CourseDevelopment\BillOfMaterial.accdb; Persist Security Info=False"
Dim cnn As New OleDb.OleDbConnection(connStr)
Try
cnn.Open()
Dim command As New OleDb.OleDbCommand("CREATE TABLE MyTable (ID Integer, Data varchar(50))", cnn)
command.ExecuteNonQuery()
cnn.Close()
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
End Sub
End Module
Thursday, May 7, 2020
Using SQL command to create a table in database using VB.Net Framework
Note that this required a .Net Framework Application. When Microsoft brought out .Net Core, they stop supporting OleDb
Subscribe to:
Post Comments (Atom)
Musical theory behind Bach Prelude in CMaj
Theory explained https://andrewhennington.wordpress.com/2015/10/22/j-s-bach-prelude-no-1-in-c-major-bwv-846/ Tonic cord - the root cord Su...
-
In a regular annotation note, create a stack that looks the way you like. It will take a couple of trial and error attempts since there'...
-
This example is mainly taken from : https://strokescribe.com/en/serial-port-vb-winapi.html#code . It uses WinAPI functions https ://msdn.mic...
No comments:
Post a Comment