如何把文件存放到数据库中

Answer 1

发给你一个上传图片并把它存入数据库的例子。1.前台<table cellpadding="0" cellspacing="0"<tr<td colspan="2"</td</tr<tr<td<asp:Label ID="Label1" runat="server" Font-Size="9pt" Text="选择文件"</asp:Label</td<td align="left"<asp:FileUpload ID="FileUpload1" runat="server" Font-Size="9pt" /</td</tr<tr<td</td<td align="left"<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="保存"/</td</tr<tr<td</td<td align="left"<asp:Label ID="Label3" runat="server" Font-Size="9pt" Width="216px"</asp:Label</td</tr</table2.后台using System.IO;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page{protected void Button1_Click(object sender, EventArgs e){try{if (this.FileUpload1.PostedFile.FileName != ""){string ImgPath = FileUpload1.PostedFile.FileName;string ImgName = ImgPath.Substring(ImgPath.LastIndexOf("\\") + 1);string ImgExtend = ImgPath.Substring(ImgPath.LastIndexOf(".") + 1);int FileLen = this.FileUpload1.PostedFile.ContentLength;Byte[] FileData = new Byte[FileLen];HttpPostedFile hp = FileUpload1.PostedFile;Stream sr = hp.InputStream;sr.Read(FileData, 0, FileLen);SqlConnection con = new SqlConnection("server=(local);user id=sa;pwd=;database=db_07");con.Open();SqlCommand com = new SqlCommand("INSERT INTO tb_08 (name) VALUES (@imgdata)", con);com.Parameters.Add("@imgdata", SqlDbType.Image);com.Parameters["@imgdata"].Value = FileData;Label3.Text = "保存成功！";}else{Label3.Text = "请选择文件！";}}catch (Exception error){Label3.Text = "处理失败！原因为：" + error.ToString();}}}