Imports MySql.Data.MySqlClient
Imports System.Data
 
Public Class Form1
    'Dim conn As MySqlConnection
    Private ConnectionString As String = "Integrated Security=SSPI;" + "Initial" & _
      "Catalog=;" + "Data Source=localhost;"
    Private reader As MySqlDataReader = Nothing
    Private conn As MySqlConnection = Nothing
    Private cmd As MySqlCommand = Nothing
    Private AlterTableBtn As System.Windows.Forms.Button
    Private sql As String = Nothing
    Private CreateOthersBtn As System.Windows.Forms.Button
 
    Private Sub ExecuteSQLStmt(ByVal sql As String)
        ' Open the connection
        If conn.State = ConnectionState.Open Then
            conn.Close()
        End If
        ConnectionString = "Integrated Security=SSPI;" + "Initial" & _
          "Catalog=mydb;" + "Data Source=localhost;"
        conn.ConnectionString = ConnectionString
        conn.Open()
        cmd = New MySqlCommand(sql, conn)
        Try
            cmd.ExecuteNonQuery()
        Catch ae As MySqlException
            MessageBox.Show(ae.Message.ToString())
        End Try
    End Sub 'ExecuteSQLStmt
 
    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As _
      System.EventArgs) Handles Button2.Click
        ' Create a connection
        conn = New MySqlConnection(ConnectionString)
        ' Open the connection
        If conn.State <> ConnectionState.Open Then
            conn.Open()
        End If
        Dim sql As String = "CREATE DATABASE mydb" ' ON PRIMARY" + "( _
          Name=test_data, filename = 'C:\mysql\mydb_data.mdf', size=3," +" & _
          ""maxsize=5, filegrowth=10%)log on" + "(name=mydbb_log, _
          filename='C:\mysql\mydb_log.ldf',size=3," + "maxsize=20,filegrowth=1)"
        ExecuteSQLStmt(sql)
    End Sub
End Class

        ConnectionString = "Integrated Security=SSPI;" + "Initial" & _
          "Catalog=mydb;" + "Data Source=localhost;"

Keyword not supported. Parametername: integrated security

wintoolz.KeyLocker - Programm zum sicheren Verwalten von Passw?rten
wintoolz.Filmdatenbank - Verwaltungssoftware f?r Filme
wintoolz.CodeGallery - Programm zum speichern von Codeschnipseln