default.aspx.cs:
---
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Data.OleDb;
namespace Stardeveloper.UploadAccess
{
public class DefaultForm : GenericPage
{
protected const string CmdText = "SELECT ID, FileName, FileSize, ContentType, Dato FROM Files ORDER BY DATO DESC";
protected HtmlGenericControl allFiles;
private void Page_Load(object sender, System.EventArgs e)
{
allFiles.InnerHtml = GetFilesFromAccessDb();
}
private string GetFilesFromAccessDb()
{
StringBuilder buffer = new StringBuilder(1024);
buffer.Append("<table align=\"center\" width=\"100%\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">");
buffer.Append("<tr><td width=\"45%\"><span class=\"dimColor\">Filnavn</span></td>");
buffer.Append("<td width=\"15%\" align=\"center\"><span class=\"dimColor\">Filstørrelse</span></td>");
buffer.Append("<td width=\"15%\" align=\"center\"><span class=\"dimColor\">Type</span></td>");
buffer.Append("<td width=\"25%\" align=\"center\"><span class=\"dimColor\">Dato</span></td></tr>");
using(OleDbConnection con = new OleDbConnection(ConnectionString))
using(OleDbCommand cmd = new OleDbCommand(CmdText, con))
{
con.Open();
OleDbDataReader rd = cmd.ExecuteReader(CommandBehavior.SingleResult | CommandBehavior.CloseConnection);
while(rd.Read())
{
int fileId;
string fileName;
int fileLength;
string contentType;
DateTime dato;
fileId = rd.GetInt32(0);
fileName = rd.GetString(1);
fileLength = rd.GetInt32(2);
contentType = rd.GetString(3);
dato = rd.GetDateTime(4);
buffer.Append("<tr><td><a href=\"file.aspx?file_id=");
buffer.Append(fileId);
buffer.Append("&mode=view\">");
buffer.Append(fileName);
buffer.Append("</a> | <a " onclick=\"return confirm('Er du sikker på at du ønsker at slette ?');\" href=\"file.aspx?file_id=");
buffer.Append(fileId);
buffer.Append("&mode=delete\">Slet</a> •");
buffer.Append(" <a href=\"file.aspx?file_id=");
buffer.Append(fileId);
buffer.Append("&mode=download\">Download</a> ");
buffer.Append("</td><td align=\"center\">");
buffer.Append(fileLength);
buffer.Append("</td><td align=\"center\">");
buffer.Append(contentType);
buffer.Append("</td><td align=\"center\">");
buffer.Append(dato);
buffer.Append("</td></tr>");
}
rd.Close();
buffer.Append("</table>");
}
return buffer.ToString();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}
