AjaMyAjax: ASP.NET Example for MySQL ODBC Driver

* Aja · My · Ajax *

ASP.NET Example for MySQL

"* helping internet developers solve problems with JavaScript, PHP, ASP, and more..."

Other web dev examples can be viewed at AjaMyAjax...

Microsoft's .NET Framework: ASP MySQL Data Access Example...

Try this ASP.NET table listing routine with any MySQL table:

Yes, there are still a few Classic ASP/VBScript elements here...
But ODBC usually makes it easy to change your DB to MSSQL or whatever.

Tip: notice the aspx screen output is stored in one concatenated string and
displayed once. This technique will speed up your pages in general.

TESTODBC.ASPX

<!-- testodbc.aspx from http://ajamyajax.com-->
<%@ Page aspcompat=true %>
<%
Dim cn = Server.CreateObject("ADODB.Connection")
Dim rs = Server.CreateObject("ADODB.Recordset")

With cn
  .ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;" & _
     "DATABASE=yourdbhere;UID=youruidhere;PASSWORD=yourpasswordhere;"
  .Open
End With

With rs
  .ActiveConnection = cn
  .Source = "SELECT * FROM yourtablehere ORDER by 1"
  .Open
End With

If Not rs.EOF
  Dim field as Object
  Dim strOutput as String

  ' store column names
  strOutput = "<b>"
  For Each field In rs.Fields
    strOutput &= (UCase(field.Name) & " ")
  Next
  strOutput &= "</b><br/>"

  ' store table data
  While Not rs.EOF
    For Each field In rs.Fields
      strOutput &= (field.Value & " ")
    Next
    strOutput &= "<br/>"
    rs.MoveNext
  End While

  ' display output string
  Response.Write(strOutput)
End If

rs.Close
rs = Nothing
cn.Close
cn = Nothing
%>

The

MySQL ODBC driver

can be downloaded here...

See this Microsoft site for all

.NET Framework

dev tool downloads.
That's the Microsoft (MSDN) .NET Framework Developer Center.

(Also a new sample ASPX app -- with an AJAX example -- is in the

AjaMyAjax

download.
The ASPX/AJAX is WAMPServer or localhost tested; any diff config might need changes)

Plus if you use SQL Server 2008 and one of these Operating Systems....

Windows Server 2003

Windows Server 2008

Windows Vista

Windows XP

and either .NET Framework versions 2.0 or 3.x, then check out Microsoft's
Repository CLR Instances Sample File Download.

Good luck with your ASP or ASPX app development. :)