Tjohej!
Nu är jag igång igen och testar, har kommit en bit men det känns som att jag gör allt väldigt osmidigt så jag vill ha hjälp att komma på rätt väg.
master.master
<%@ Master %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>
<%@ Import Namespace="Microsoft.Data.Odbc" %>
<%
Dim fbooklink as string = "<a href=""http://www.facebook.com/pages/Sunday-Morning-Magazine/163709807002555"" target=""_blank"">Facebook</a>"
Dim mailto as string = "<a href=""mailto:%69%6e%66%6f%40%73%75%6e%64%61%79%6d%6f%72%6e%69%6e%67%6d%61%67%61%7a%69%6e%65%2e%73%65"">info@sundaymorningmagazine.se</a>"
%>
<script runat="server">
Dim Connection As OdbcConnection = New OdbcConnection("DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; DATABASE=smm; UID=root; PASSWORD=test; OPTION=3")
Sub Page_Load(Source as object, E as EventArgs)
If Not Page.IsPostBack Then
Dim SQL As String = "SELECT f_iid FROM tblIssues ORDER BY f_date DESC LIMIT 1,1"
Dim Odbcdataadapter As OdbcDataAdapter = New OdbcDataAdapter(SQL, Connection)
Dim ODBCdataset As DataSet = New DataSet()
ODBCdataadapter.Fill(ODBCdataset)
latest.DataSource = ODBCdataset
latest.DataBind()
Dim SQLL As String = "SELECT f_iid, f_nr, f_date FROM tblIssues ORDER BY f_date DESC LIMIT 0,5"
Dim Odbcdataadapter2 As OdbcDataAdapter = New OdbcDataAdapter(SQLL, Connection)
Dim ODBCdataset2 As DataSet = New DataSet()
ODBCdataadapter2.Fill(ODBCdataset2)
latestlist.DataSource = ODBCdataset2
latestlist.DataBind()
End If
End Sub
</script>
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title> Sunday Morning Magazine | Photographic Web Magazine </title>
<meta name="keywords" content="magazin, online magazine, web magazine, magasin, photo, photography, foto, fotografi, fototidning, sunne, broby grafiska,in between dreams, sunday morning magazine, sunday, morning, in between dreams" />
<meta name="description" content="Sunday Morning Magazine - Photographic web magazine" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="imagetoolbar" content="no" />
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="expires" content="0" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js"></script>
<script>
!window.jQuery && document.write('<script src="jquery-1.4.3.min.js"><\/script>');
</script>
<script type="text/javascript" src="./fancybox/jquery.mousewheel-3.0.4.pack.js"></script>
<script type="text/javascript" src="./fancybox/jquery.fancybox-1.3.4.pack.js"></script>
<link rel="stylesheet" type="text/css" href="./fancybox/jquery.fancybox-1.3.4.css" media="screen" />
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript">
$(document).ready(function() {
$("#readissue").fancybox({
'width' : '90%',
'height' : '90%',
'autoScale' : false,
'transitionIn' : 'none',
'transitionOut' : 'none',
'type' : 'iframe',
'overlayOpacity' : '0.9',
'overlayColor' : '#444444',
'scrolling' : 'no',
'titleShow' : false
});
});
</script>
</head>
<body>
<div id="center">
<div id="menu">
<ul>
<li><a href="about.aspx">About</a></li>
<li><a href="issues.aspx">Issues</a></li>
<li><a href="contributors.aspx">Contributors</a></li>
<li><a href="contact.aspx">Contact</a></li>
<li><a href="inbetweendreams.aspx">I.B.D</a></li>
</ul>
</div>
<div id="logo">
<a href="index.aspx">
<img src="images/logo.jpg" alt=" SUNDAY MORNING MAGAZINE " />
</a>
</div>
<div id="content">
<asp:ContentPlaceHolder id="content" runat="server">
</asp:ContentPlaceHolder>
</div>
<div id="issues">
<ul>
<asp:Repeater id="latestlist" runat="server">
<ItemTemplate>
<li><a id="readissue" href="read.aspx?id=<%#Container.DataItem("f_iid")%>">#<%#Container.DataItem("f_nr")%> <%#DataBinder.Eval(Container.DataItem,"f_date","{0:MMM yyyy}")%></a></li>
</ItemTemplate>
</asp:Repeater>
</ul>
</div>
<div id="latest">
<h2>Latest issue</h2>
<asp:Repeater id="latest" runat="server">
<ItemTemplate>
<a id="readissue" href="read.aspx?id=<%#Container.DataItem("f_iid")%>" title=" Click here to read the latest issue ">
<img src="images/latest.jpg" alt=" LATEST ISSUE " />
</a>
</ItemTemplate>
</asp:Repeater>
</div>
<div id="facebook">
<iframe src="http://www.facebook.com/plugins/likebox.php?href=http%3A%2F%2Fwww.facebook.com%2Fpages%2FSunday-Morning-Magazine%2F163709807002555&width=220&colorscheme=light&show_faces=true&border_color=%23666666&stream=false&header=false&height=202" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:220px; height:202px;" allowTransparency="true"></iframe>
</div>
<div id="footer">
<p>© Sunday Morning Magazine, all rights reserved. |
<%=mailto%></p>
</div>
</div>
</body>
</html>
issues.aspx
<%@ Page MasterPageFile="master.master" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Odbc" %>
<%@ Import Namespace="Microsoft.Data.Odbc" %>
<script runat="server">
Sub Page_Load(Source as object, e as EventArgs)
If Not Page.IsPostBack Then
Dim Connectionn As OdbcConnection = New OdbcConnection("DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; DATABASE=smm; UID=root; PASSWORD=test; OPTION=3")
Dim SQL As String = "SELECT f_iid, f_nr, f_pic, f_date FROM tblIssues"
Dim ODBCdataadapter As OdbcDataAdapter = New OdbcDataAdapter(SQL, Connectionn)
Dim ODBCdataset As DataSet = New DataSet()
ODBCdataadapter.Fill(ODBCdataset)
issueslist.DataSource = ODBCdataset
issueslist.DataBind()
End If
End Sub
</script>
<asp:Content ContentPlaceHolderId="content" runat="server">
<h1>Issues</h1>
<form runat="server">
<asp:DataList id="issueslist" class="issues_table" runat="server" RepeatColumns="3" RepeatDirection="Horizontal">
<ItemTemplate>
<h3>#<%#Container.DataItem("f_nr")%> <%#DataBinder.Eval(Container.DataItem,"f_date","{0:MMM yyyy}")%></h3>
<a href="#" title=" Click to read issue ">
<img src="images/covers/<%#Container.DataItem("f_pic")%>.jpg" class="issue_img" />
</a>
<a id="readissue" href="read.aspx?id=<%#Container.DataItem("f_iid")%>">Read</a> |
<a href="issuesinfo.aspx?id=<%#Container.DataItem("f_iid")%>">More info</a>
</ItemTemplate>
</asp:DataList>
</form>
</asp:Content>
Tycker den extra databaskopplingen känns onödig i issues.aspx samt de två repeaters som används i master, borde gå att lösa smidigare?
Tänkte även lägga koderna i separata filer men tyckte (av gammal vana förmodligen) att det var enklast att börja så här.
Har kikat lite på razor också hos W3 och det verkade ju betydligt enklare vid en första anblick iaf. Kanske skulle hoppa på det tåget så snabbt som möjligt eller? :)
