Ændre en sti i databasen
Jeg prøver at gøre det muligt at ændre en sites design via et CMS system. Scriptet ser således ud:<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="true" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script runat="server">
void DesignCommand(Object sender, System.Web.UI.WebControls.CommandEventArgs e) {
string strDatabase = Server.MapPath("database.mdb");
OleDbConnection objConnection = null;
OleDbCommand objCmd = null;
string DesignID = e.CommandArgument.ToString();
Response.Write(DesignID);
string strConnection, strSQL;
OleDbDataReader objDataReader;
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConnection += @"Data Source=" + strDatabase;
objConnection = new OleDbConnection(strConnection);
strSQL = "Update Design Set Banner = @Banner Where DesignID = " + DesignID;
// strSQL = "Update Indhold Set Navn = @Navn, Tekst = @Tekst Where Varenummer = " + Varenummer;
objCmd = new OleDbCommand(strSQL, objConnection);
objCmd.Parameters.Add("@Banner", OleDbType.VarChar, 255).Value = ("<img src=Design/" + rbBanner + " width='800' height='200'>");
objConnection.Open();
objCmd.ExecuteNonQuery();
//Response.Write(strSQL);
objConnection.Close();
//LoadData();
}
</script>
</head>
<body>
<form enctype="multipart/form-data" runat="server">
<asp:RadioButtonList ID="rbBanner" RepeatDirection="horizontal" runat="server"><asp:ListItem Selected="true" Value="Top_fall.jpg">Efterår</asp:ListItem><asp:ListItem Value="Top_winter.jpg">Vinter</asp:ListItem><asp:ListItem Value="Top_spring.jpg">Forår</asp:ListItem><asp:ListItem Value="Top_summer.jpg">Sommer</asp:ListItem></asp:RadioButtonList>
<asp:Button runat="server" Text="Skift" OnCommand="DesignCommand" CommandArgument="DesignID" />
</form>
</body>
</html>
men i stedet for at ændre stien udfra radioknappernes værdi sætter den følgende sti ind i stedet for:
<img src=Design/System.Web.UI.WebControls.RadioButtonList width='800' height='200'>