I spent the day working on this, but I have my widget working. If anyone wants to use it, here is the code:
<%@ Page Language="C#" AutoEventWireup="true" Inherits="LS.BaseControl" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="LS" %>
<% Response.CacheControl = "no-cache";%>
<% Response.AddHeader("Pragma", "no-cache"); %>
<% Response.Expires = -1; %>
<% LS.User.Current().CheckWebsiteAccess(); %>
<%var dsAssets = DB.ExecuteDataset("SELECT Top 10 tblAssets.AssetID, tblAssets.AssetName, tblAssets.Firstseen FROM tblAssets ORDER BY tblAssets.Firstseen Desc");
{%>
<font size="1">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<% foreach (DataRow myrow in dsAssets.Rows)
{%>
<tr>
<td align="left" ><a href="<%=ResolveUrl("~/")%>Asset.aspx?AssetID=<%:myrow["AssetID"]%>"><%: myrow["AssetName"] %></a></td>
<td align="right" valign="top">
<%:myrow["Firstseen"]%>
</td>
</tr>
<% }%>
</table>
</font>
<%=AutoRefresh(10) %>
<%if (LS.User.Current().IsInRole(WebRole.EditConfiguration)){%><% } %>
</div>
<%}%>
<script type="text/javascript">
$('#WTitle<%=TabControlID %>', window.top.document).text("Newest Assets");
</script>