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
Gray_code_element
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)
SVG: Two arrows with text on the ends
Example of Two arrows with text at the head of the arrow: Arrow with Text SVG Using Markers and Text tags In this tutoria...
-
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...
-
Getting into Equation Mode use <alt> and = to get into the equation editor. Radicals : $\sum_{i=0}^n i^2 = \frac{(n^2+n)(2n+1)}{6}$ ...
No comments:
Post a Comment