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)
Creating a LAMP stack on AWS Free Tier
https://shawn-shi.medium.com/how-to-host-a-lamp-web-application-server-on-aws-ec2-for-free-8f6fc61463ed#:~:text=Its%20free%20tier%20allows...
-
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'...
-
Modifying profile of footing so that the notch shows up between the footing and the base of the foundation wall. https://youtu.be/0MPkykiWu0o
No comments:
Post a Comment