Home » Knowledgebase » Programming » ASP.NET » How do I connect MySQL DB with MySQL .NET connector

How do I connect MySQL DB with MySQL .NET connector

Expand / Collapse
 
     

How do I connect MySQL DB with MySQL .NET connector


There is no installation required on server,  you only need to upload the Mysql.Data.dll to the site "bin" folder.
You can download the MySQL .NET connector in 'http://dev.mysql.com/downloads/connector/net/6.0.html'.
The MySQL.Data.dll locates on the "Installation path\Assemblies". Default path is "C:\Program Files\MySQL\MySQL Connector Net 6.0.3\Assemblies".

********************************************************************
[Sample .aspx]
<%@ Page Language="VB" debug="true" %>
<%@ Import Namespace = "System.Data" %>
<%@ Import Namespace = "MySql.Data.MySqlClient" %>
<script language="VB" runat="server">

Sub Page_Load(sender As Object, e As EventArgs)

    Dim myConnection  As MySqlConnection
    Dim myDataAdapter As MySqlDataAdapter
    Dim myDataSet     As DataSet

    Dim strSQL        As String
    Dim iRecordCount  As Integer

        myConnection = New MySqlConnection("Server=mysqlxxx.mysite4now.com;Database=DBname;Uid=DB_ID;Pwd=DB_pw")

        strSQL = "SELECT * From [table name];"

    myDataAdapter = New MySqlDataAdapter(strSQL, myConnection)
    myDataSet = New Dataset()
        myDataAdapter.Fill(myDataSet, "[table name]")

    MySQLDataGrid.DataSource = myDataSet
    MySQLDataGrid.DataBind()

End Sub

</script>

<html>
<head>
<title>MySQL test</title>
</head>
<body>

<form id="Form1" runat="server">

<asp:DataGrid id="MySQLDataGrid" runat="server" />

</form>

</body>
</html>
********************************************************************

In some application you require to add the following lines in web.config.
[web.config]

<system.web>
                <compilation debug="true" urlLinePragmas="true">
                        <assemblies>
                                <add assembly="MySql.Data, Version=6.0.3.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/></assemblies></compilation>
                <authentication mode="Windows"/>
                <customErrors mode="Off"/>
        </system.web>
        <system.data>
    <DbProviderFactories>
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.0.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/>
    </DbProviderFactories>
</system.data>




Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:6/24/2009 4:57 PM
Last Modified By: Mark
Type: How to do this?
Article not rated yet.
Article has been viewed 1,215 times.
Options

Powered By InstantKB.NET 2.0.4 © 2009