showfromsql.aspx

20071024上传下载SQl

<%@ Page language="c#" Codebehind="showFromSQl.aspx.cs" AutoEventWireup="false" Inherits="WebApplication1.showFromSQl" %>
<% @Import Namespace="System.IO" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.SqlClient" %>
<form runat="server" ID="Form1">
	<asp:DataGrid id="FileList" runat="server" BorderColor="orange" BorderWidth="2" CellPadding="4"
		AutoGenerateColumns="false" ShowHeader="true" Align="center">
		<HeaderStyle BorderColor="White" BackColor="black" ForeColor="White" Font-Bold="True" Font-Size="9"
			HorizontalAlign="Center" />
		<Columns>
			<asp:TemplateColumn HeaderText="文件名字">
				<ItemTemplate>
					<b>
						<%# DataBinder.Eval(Container.DataItem, "MyFileName") %>
					</b>
				</ItemTemplate>
			</asp:TemplateColumn>
			<asp:TemplateColumn HeaderText="类型">
				<ItemTemplate>
					<b>
						<%# DataBinder.Eval(Container.DataItem, "FileType") %>
					</b>
				</ItemTemplate>
			</asp:TemplateColumn>
			<asp:TemplateColumn HeaderText="查看">
				<ItemTemplate>
					<b><a href='ShowFile.aspx?ID=<%# DataBinder.Eval(Container.DataItem, "ID") %>'>查看文件</a>
					</b>
				</ItemTemplate>
			</asp:TemplateColumn>
		</Columns>
	</asp:DataGrid>
</form>