Click here to Skip to main content
15,923,557 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Datagrid in VB6 Pin
Anonymous10-Mar-04 21:37
Anonymous10-Mar-04 21:37 
GeneralRe: Datagrid in VB6 Pin
hxxbin11-Mar-04 3:57
hxxbin11-Mar-04 3:57 
GeneralRe: Datagrid in VB6 Pin
Member 84306415-Jun-04 4:34
Member 84306415-Jun-04 4:34 
GeneralControls at runtime Pin
Member 84306410-Mar-04 6:45
Member 84306410-Mar-04 6:45 
GeneralDesign ideas needed for static data access class Pin
Jim Taylor10-Mar-04 5:56
Jim Taylor10-Mar-04 5:56 
GeneralRe: Design ideas needed for static data access class Pin
Mike Ellison10-Mar-04 6:20
Mike Ellison10-Mar-04 6:20 
GeneralRe: Design ideas needed for static data access class Pin
Jim Taylor10-Mar-04 22:57
Jim Taylor10-Mar-04 22:57 
GeneralRe: create table in oracle using vb.net Pin
Mike Ellison10-Mar-04 6:09
Mike Ellison10-Mar-04 6:09 
If you're using an OleDbConnection for Oracle, I think you could probably use the OleDbCommand's ExecuteNonQuery() method, issuing a "Create Table ..." statement. Here's an example of a VB.NET console application doing it this way:
VB
Imports System.Data.OleDb

Module Module1

    Sub Main()
        Const kConnectionString = _
"Provider=MSDAORA.1;User ID=myUser; Password=myPass;Data Source=myServer;"
        Dim conn As OleDbConnection
        Dim cmd As OleDbCommand
        Dim strSql As String

        Try
            conn = New OleDbConnection(kConnectionString)
            conn.Open()
            strSql = "Create Table test1(field1 varchar(10))"
            cmd = New OleDbCommand(strSql, conn)
            cmd.ExecuteNonQuery()
            Console.WriteLine("Statement executed.")

        Catch ex As Exception
            Console.WriteLine(ex.Message)

        Finally
            cmd.Dispose()
            conn.Dispose()

        End Try

        Console.WriteLine("Press Enter...")
        Dim strWait As String = Console.ReadLine()

    End Sub

End Module


If you're using a different provider (like the OracleClient for example) you'll want to review that provider's documentation for the proper methods to create a table.
GeneralE-Mail problems with SMTP Pin
KreativeKai10-Mar-04 3:13
professionalKreativeKai10-Mar-04 3:13 
GeneralRe: E-Mail problems with SMTP Pin
Mike Ellison10-Mar-04 6:25
Mike Ellison10-Mar-04 6:25 
GeneralRe: E-Mail problems with SMTP Pin
KreativeKai15-Mar-04 6:25
professionalKreativeKai15-Mar-04 6:25 
GeneralExchange server 5.5 Pin
pushpi10-Mar-04 1:03
pushpi10-Mar-04 1:03 
QuestionRaise a number to a power? Pin
Roger Allen10-Mar-04 0:57
Roger Allen10-Mar-04 0:57 
AnswerRe: Raise a number to a power? Pin
Dave Kreskowiak10-Mar-04 1:10
mveDave Kreskowiak10-Mar-04 1:10 
GeneralRe: Raise a number to a power? Pin
Roger Allen10-Mar-04 2:01
Roger Allen10-Mar-04 2:01 
GeneralWinmp (2.9) & Visual Basic 6.0 Pin
erikkloeze9-Mar-04 23:41
erikkloeze9-Mar-04 23:41 
GeneralListview ColumnHeader Height Pin
Member 9365629-Mar-04 13:32
Member 9365629-Mar-04 13:32 
GeneralGetting CD name and file list in VB.net Pin
Julien Burgaud9-Mar-04 13:22
Julien Burgaud9-Mar-04 13:22 
GeneralRe: Getting CD name and file list in VB.net Pin
Mike Ellison10-Mar-04 6:39
Mike Ellison10-Mar-04 6:39 
GeneralRe: Getting CD name and file list in VB.net Pin
Julien Burgaud11-Mar-04 5:09
Julien Burgaud11-Mar-04 5:09 
GeneralExecute DOS commands on client Pin
toboyle9-Mar-04 12:15
toboyle9-Mar-04 12:15 
GeneralRe: Execute DOS commands on client Pin
Dave Kreskowiak10-Mar-04 1:16
mveDave Kreskowiak10-Mar-04 1:16 
GeneralRe: Execute DOS commands on client Pin
toboyle10-Mar-04 5:57
toboyle10-Mar-04 5:57 
GeneralRe: Execute DOS commands on client Pin
toboyle10-Mar-04 6:10
toboyle10-Mar-04 6:10 
GeneralBootstrapper Settings Button Disabled Pin
vister729-Mar-04 10:45
vister729-Mar-04 10:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.