ASP.NET Example for MySQL ODBC Driver from AjaMyAjax

Latest:

ASP.NET Example for MySQL

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.
 <%@ 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 %>