Når jeg skriver direkte i databasen fungerer æøå fint når jeg læser den ind
i et datagrid.
Så problemet må ligge i siden der skriver til DB.
Koden er som følger:
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1"
%>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls"
Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,c
ulture=neutral" %>
<MM:Insert
runat="server"
CommandText='<%# "INSERT INTO tabel (Besked, Dato, Navn) VALUES (?, ?, ?)"
%>'
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING
_connTabel") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABA
SETYPE_connTabel") %>'
Expression='<%# Request.Form("MM_insert") = "form1" %>'
CreateDataSet="false"
SuccessURL='<%# "default.aspx" %>'
Debug="true"
>
<Parameters>
<Parameter Name="@Besked" Value='<%# IIf((Request.Form("Besked") <>
Nothing), Request.Form("Besked"), "") %>' Type="WChar" />
<Parameter Name="@Dato" Value='<%# IIf((Request.Form("Dato") <>
Nothing), Request.Form("Dato"), "") %>' Type="Date" />
<Parameter Name="@Navn" Value='<%# IIf((Request.Form("Navn") <>
Nothing), Request.Form("Navn"), "") %>' Type="WChar" />
</Parameters>
</MM:Insert>
<MM:DataSet
id="DataSet1"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING
_connTabel") %>'
DatabaseType='<%#
System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABA
SETYPE_connTabel") %>'
CommandText='<%# "SELECT * FROM tabel" %>'
Debug="true"
> </MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form method="post" name="form1" runat="server">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Besked:</td>
<td> <asp:textbox id="Besked" TextMode="SingleLine" Columns="32"
runat="server" /> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Dato:</td>
<td> <asp:textbox id="Dato" text='<%# DataSet1.FieldValue("Dato",
Container) %>' TextMode="SingleLine" Columns="32" runat="server" /> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Navn:</td>
<td> <asp:textbox id="Navn" TextMode="SingleLine" Columns="32"
runat="server" /> </td>
</tr>
<tr valign="baseline">
<td nowrap align="right"> </td>
<td><input type="submit" value="Insert Record"></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form1">
</form>
<p> </p>
</body>
</html>