在数据库中保存和获取各种文件

今天药忘吃喽~ 2022-01-06 04:15 193阅读 0赞

[http://www.aspsnippets.com/Articles/How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx][http_www.aspsnippets.com_Articles_How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx]

1.创建数据库--各字段如下图所示

![171624194821552.png][]

注：Name：文件名

ContentType:文件的类型 （.doc .txt）

Data:以二进制的存储的数据

2.添加文件上传控件和上传按钮

<asp:FileUpload ID="FileUpload1" runat="server" />
        <asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" /><br />
        <asp:Label ID="lblMessage" runat="server" Text="" Font-Names = "Arial"></asp:Label>

3.添加上传文件事件

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

protected void btnUpload_Click(object sender, EventArgs e)
            {
                //获取上传的文件
                string filePath = FileUpload1.PostedFile.FileName;
                //获取上传文件名
                string filename = Path.GetFileName(filePath);
                //获取文件按的后缀名
                string ext = Path.GetExtension(filename);  
                string contenttype = String.Empty;
    
                //根据后缀名设置文件类型
                switch (ext)
                {
                    case ".doc":
                        contenttype = "application/vnd.ms-word";
                        break;
                    case ".docx":
                        contenttype = "application/vnd.ms-word";
                        break;
                    case ".xls":
                        contenttype = "application/vnd.ms-excel";
                        break;
                    case ".xlsx":
                        contenttype = "application/vnd.ms-excel";
                        break;
                    case ".jpg":
                        contenttype = "image/jpg";
                        break;
                    case ".png":
                        contenttype = "image/png";
                        break;
                    case ".gif":
                        contenttype = "image/gif";
                        break;
                    case ".pdf":
                        contenttype = "application/pdf";
                        break;
                }
    
                if (contenttype != String.Empty)
                {
                    Stream fs = FileUpload1.PostedFile.InputStream;
                    BinaryReader br = new BinaryReader(fs);
                    Byte[] bytes = br.ReadBytes((Int32)fs.Length);
                    //insert the file into database
    
                    string strQuery = "insert into FileSaves(Name, ContentType, Data)" +"values (@Name, @ContentType, @Data)";
                    SqlCommand cmd = new SqlCommand(strQuery);
                    cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = filename;
                    cmd.Parameters.Add("@ContentType", SqlDbType.VarChar).Value
                      = contenttype;
                    cmd.Parameters.Add("@Data", SqlDbType.Binary).Value = bytes;
                    InsertUpdateData(cmd);
                    lblMessage.ForeColor = System.Drawing.Color.Green;
                    lblMessage.Text = "File Uploaded Successfully";
                }
                else
                {
                    lblMessage.ForeColor = System.Drawing.Color.Red;
                    lblMessage.Text = "File format not recognised." +" Upload Image/Word/PDF/Excel formats";
                }
            }

4.根据查询字符串判断文件是否上传成功

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

private Boolean InsertUpdateData(SqlCommand cmd)
            {
                String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["DemosDatabaseConnectionString"].ConnectionString;
                SqlConnection con = new SqlConnection(strConnString);
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;
                try
                {
                    con.Open();
                    cmd.ExecuteNonQuery();
                    return true;
                }
                catch (Exception ex)
                {
                    Response.Write(ex.Message);
                    return false;
                }
                finally
                {
                    con.Close();
                    con.Dispose();
                }
            }

转载于:https://www.cnblogs.com/songxia/p/4031502.html

[http_www.aspsnippets.com_Articles_How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx]: http://www.aspsnippets.com/Articles/How-to-save-insert-Image-in-Database-in-ASPNet-using-C-and-VBNet.aspx
[171624194821552.png]: /images/20211228/cef571db41a148f8a716460af50d63fa.png
[ContractedBlock.gif]: https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211228/25e55e27ace14de7a29a47f4aeeeaf19.png