Create Oracle Database Table Using VB Programming

Create Oracle Database Table Using VB Programming:

• First, Connect with Oracle Database in Visual Studio.
• The Data Source , User Id and Password are change by  using  your Database Connection string.
• Use Following Library Function Headers in General 

Imports System.Data

Imports Oracle.DataAccess.Client 

Imports Oracle.DataAccess.Types

Example of Visual Basic Programming For Create Oracle Database Table:

Private Sub Button3_Click1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click

Dim oradb As String = "Data Source=XE;User Id=HR;Password=password;"

        Dim conn1 As New OracleConnection

        Dim cmd1 As OracleCommand

        conn1.ConnectionString = oradb

        conn1.Open()

        Dim sql = "create table table_name(column_name1 varchar2(10),column_name2 varchar2(12),column_name3 varchar2(20),column_name4 varchar2(20),column_name5 varchar2(25),column_name6 number(8))"

        cmd1 = New OracleCommand(sql, conn1)

        cmd1.CommandType = CommandType.Text

        cmd1.ExecuteNonQuery()

         MsgBox("Table is Created")
End Sub