360haven works best with JavaScript enabled
MySQL Connector/Net
Loading
Register
Login
Results 1 to 1 of 1
  1. #1
    Hoshikage


    pureIso is offline
    Join Date : Jan 2011
    Location : somewhere In Ireland
    Posts : 2,733
    Array

    MySQL Connector/Net

    Type: .NET Framework Class Library
    Usage: MySql.Data.MySqlClient.MySqlConnection
    Manufacturer: MySQL

    Standard - Default port is 3306
    Code:
    Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
    Specifying port
    Code:
    Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
    Named pipes
    Code:
    Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
    Multiple Server
    Code:
    Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
    Using encryption
    Code:
    Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encryption=true;
    or



    Code:
    Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;Encrypt=true;
    Sample Code
    Code:
    Imports MySql.Data.MySqlClient ' database
    
    Private mySqlConnection As New MySqlConnection
        Private myAdaptor As New MySqlDataAdapter
        Private command As New MySqlCommand
    
     'connection - FINISHED
        Public Sub MyySQLConnection()
    
            Try
                mySqlConnection.ConnectionString = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"
                command.Connection = mySqlConnection
                myAdaptor.SelectCommand = command
                mySqlConnection.Open()
            Catch ex As MySqlException
                MessageBoxEx.Show("No Remote or Local MySQL server connection." & Environment.NewLine & ex.Message, "Offline!", MessageBoxButtons.OK, MessageBoxIcon.Information)
            Finally
    
                mySqlConnection.Dispose()
                mySqlConnection.Close()
            End Try
    
        End Sub
    Downloads : 69 || Uploads : 22 || Rep Power : 6059 || Posts : 2,733 || Thanks : 557 || Thanked 2,972 Times in 735 Posts



    ## If you don't Contribute || Help - Why should I Contribute || Help - Leechers Should not be helped ##

  2. The Following 3 Users Say Thank You to pureIso For This Useful Post:


 

 

Similar Threads

  1. PHP Page counter and page loadtime without MYSQL/MSSQL
    By ohnoyekoms in forum Tutorials and Resources
    Replies: 5
    Last Post: 05-14-2012, 10:23 PM
  2. MySQL Connect
    By Mocha in forum Sources and Classes
    Replies: 0
    Last Post: 04-15-2011, 01:24 AM

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

About 360haven

    360haven is an Forum Devoted To Game modding Fans from all over the world.

    An Awesome Community of Xbox 360 Gamers, Modders and Developers who Create & Share Tutorials, Applications, Gfx, Trainers and Gamesaves.

    A haven for the l33t.
    A scarce paradise for modders.

Like this page

Google+