Visual Basic

Member 10603840 wrote:

I'm a complete beginner to Visual Basic

public module GlobalVariables
  public foo as string
end module

public shared class FooBar
 public shared SomeValue as integer =1
end class

Samoeurn wrote:

I have one using excel 2000

Samoeurn wrote:

when I add control listview, it show message "Library not registered"

Samoeurn wrote:

code is incompatible with the version,platform, or architecure

Samoeurn wrote:

anybody has idea?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

#If Win64 Then
    ' Win64=true, Win32=true, Win16= false
put your 64 bit library references here
#ElseIf Win32 Then
    ' Win32=true, Win16=false
put your 32 bit library references here
#Else
    ' Win16=true
Msgbox "You are either trying to run this from a computer " _
       "you found at a yard sale or you bought an Apple"
#End If

SPSandy wrote:

Is it possible to create a MySql view using vb2008

SPSandy wrote:

If yes can anybody provide with some tips on how to do that.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

    Public Sub CreateView()
        Using con As New MySqlConnection("your connection string here")
            Using cmd As MySqlCommand = con.CreateCommand()

                con.Open()
                cmd.CommandText = _
" CREATE VIEW view_name AS      " +
"      SELECT column_name(s)    " +
"        FROM table_name        " +
"       WHERE condition         "

                cmd.ExecuteNonQuery()
                con.Close() ' I don't close mine; the dispose handles that.

            End Using
        End Using
    End Sub

• http://www.connectionstrings.com/mysql/[^], for building your connection-string.
  
• http://www.w3schools.com/sql/sql_view.asp[^]; this is from where the "create view" command was copy/pasted.
  
• http://dev.mysql.com/doc/refman/5.0/en/create-view.html[^] - if you work with MySQL, then the manual *needs* a place in your favorites.
  
• Information on the required VB.NET code[^]

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]