downformsql.aspx

20071024上传下载SQl

<%@ Page language="c#" Codebehind="DownFormSQL.aspx.cs" AutoEventWireup="false" Inherits="WebApplication1.DownFormSQL" %>
<% @Import Namespace="System.IO" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
public void UploadBtn_Click (Object sender, EventArgs e){

//得到提交的文件
Stream fileDataStream = MyFile.PostedFile.InputStream;

//得到文件大小
int fileLength = MyFile.PostedFile.ContentLength;

//创建数组
byte[] fileData = new byte[fileLength];

//把文件流填充到数组
fileDataStream.Read(fileData,0,fileLength);

//得到文件名字
string fileTitle = MyFileName.Value;

//得到文件类型
string fileType = MyFile.PostedFile.ContentType;

//构建数据库连接，SQL语句，创建参数
SqlConnection connection = new SqlConnection("Server=.;uid=sa;pwd=;Database=TestUploadFile");
SqlCommand command = new SqlCommand ("INSERT INTO TestFiles (MyFileName,MyFile,FileType)" + 
"VALUES (@MyFileName,@MyFile,@FileType)", connection);

SqlParameter paramTitle = new SqlParameter ("@MyFileName", SqlDbType.VarChar,35); 
paramTitle.Value = fileTitle;
command.Parameters.Add(paramTitle);

SqlParameter paramData = new SqlParameter ("@MyFile", SqlDbType.Image);
paramData.Value = fileData;
command.Parameters.Add(paramData);

SqlParameter paramType = new SqlParameter ("@FileType", SqlDbType.VarChar,25); 
paramType.Value = fileType;
command.Parameters.Add(paramType);

//打开连接，执行查询
connection.Open();
command.ExecuteNonQuery();
connection.Close();

Message.Text="你的文件已经成功上载";
MyFileName.Value = "";
}
</script>
<hr>
<asp:label id="Message" Text="选择文件和文件名字：" runat="server" />
<hr>
<form method="post" enctype="multipart/form-data" runat="server" ID="Form1">
	<b>文件名字：</b><input id="MyFileName" type="text" runat="server" NAME="MyFileName">
	<P>
		<b>文件：</b><input id="MyFile" type="file" runat="server" NAME="MyFile">
		<br>
		<br>
		<input type="submit" value="开始上传" OnServerclick="UploadBtn_Click" runat="server" ID="Submit1"
			NAME="Submit1">
		<asp:Button id="Button1" runat="server" Text="查看上传文件"></asp:Button>
</form>
</P>