fx:
du skal placere filen:
Microsoft.Data.Odbc.dll
i dit en mappe der hedder bin (i dit root dir)
fx. c:\inetpub\wwwroot\bin\Microsoft.Data.Odbc.dll
<%@ Page Language="C#" Debug="true" Description="MainPage" %>
<%@ Import Namespace= "System.Data" %>
<%@ Import namespace = "Microsoft.Data.Odbc"%>
<script language="C#" runat="server">
void Page_Load(Object sender, EventArgs e) {
string sConn = "DRIVER={MySQL};SERVER=<dinserver>;DATABASE=<dindb>;UID=<user>;PWD=<pasord>";
string query = "SELECT feltnavn, feltnavn2 FROM tabel WHERE something = 'Aktiv' ORDER BY ID DESC LIMIT 10";
OdbcConnection myConnection = new OdbcConnection(sConn);
OdbcDataAdapter myCommand = new OdbcDataAdapter(query, myConnection);
DataSet ds = new DataSet();
try {
myCommand.Fill(ds, "ds");
}
catch (Exception ) {
}
MyRepeater.DataSource = ds;
MyRepeater.DataBind();
}
</script>
<table>
<ASP:Repeater id="MyRepeater" runat="server">
<HeaderTemplate>
<Table width="640">
<tr class="top">
<td>Dato</td>
<td>Kort beskrivelse</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr class="txt">
<td><%# DataBinder.Eval(Container.DataItem, "sbdato") %></td>
<td><%# DataBinder.Eval(Container.DataItem,"skbesk") %></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</Table>
</FooterTemplate>
</ASP:Repeater></table>
