ole-db provider
Jeg skal oprette en forbindelse til en MySQL db, jeg bruger ASP.NET og har brugt ODBC førhen, men vil nu bruge ole-db.Men hvad hedder koden for dette?
Her er koden for ODBCén.
<%@ Page Language="VB" Debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<%@ Import Namespace="Microsoft.Data.ODBC" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Imaging" %>
<html>
<head>
<script runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim strConn As String = "driver=MySQL;Server=localhost;DB=wtdb;UID=brugernavn;Pwd=pass;"
Dim objConn As New ODBCConnection(strConn)
If Not Page.IsPostBack Then
Dim objCmd As New ODBCCommand
Dim objDA As New ODBCDataAdapter
Dim dvw As DataView
Dim ds As New DataSet
dim strSQL = "SELECT * FROM T2 order by tidspunkt desc"
objDA = New ODBCDataAdapter(strSQL, objConn)
objDA.Fill(ds, "T2")
dvw = ds.Tables("T2").DefaultView
ctrlRepeater.DataSource = dvw
ctrlrepeater.DataBind()
End If
End Sub
</script>
