Connect to mySQL
5 svar · 298 visningar · startad av icaaq
Tanka MyOLEDB från https://www.mysql.com och sen typ
"Provider=MySQLProv;Data Source=databasnamn;"
Typ så här kan det se ut:
<%@ Page Language="VB" Trace="True" %>
<%@ import Namespace="Microsoft.Data.Odbc" %>
<script runat="server">
Public Sub Page_Load(Sender As Object, E As EventArgs)
Dim ldsn As String = "driver=mysql;server=localhost;database=db-namn;uid=anvandarnamn;pwd=losenord"
Dim query As String = "SELECT * FROM Statistics"
Dim cnnS As New OdbcConnection(ldsn)
Dim cmdS As New OdbcCommand(query, cnnS)
cnnS.Open()
Dim drS As OdbcDataReader = cmdS.ExecuteReader()
DataGrid1.DataSource = drS
DataGrid1.dataBind()
drS.Close()
cnnS.Close()
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>
</form>
</body>
</html>
cya,
PatrikB
Har du version 1.1 så finns Odbc i System.Data.Odbc tror jag
TAck