使用文件上载器将图像保存在数据库中 [英] save the image in Database using file uploder

问题描述

如何使用fileuploder控件在数据库中保存文件路径...
并从数据库中检索图像.

how to save the file path in Database using fileuploder control ...
and retrieve the image from database.

推荐答案

尝试以下操作:

Try this:

string filename = FileUpload1.FileName;
          
            FileUpload1.PostedFile.SaveAs(Server.MapPath("~\\Uploadform\\" + filename.Trim()));
            
          string path = "~\\Uploadform\\" + filename.Trim();
           
            SqlConnection con = new SqlConnection(str);
            cmd = new SqlCommand("Insert into tableName(date,ctype,title,type,url1) values('"+txtdate.Text+"','" + TextBox1.Text + "','" + txttitle.Text + "','" + txttype.Text + "','" + path + "' )", con);
            lblinfo.Text = " Upload Success";
            cmd.CommandType = CommandType.Text;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();

有关更多信息，请参见本文:将文件保存到SQL Server使用FileUpload Control的数据库 [

For more please refer this article:Save Files to SQL Server Database using FileUpload Control[^]

请参阅以下内容:

http://techiecocktail.blogspot.in/2009/05/store- and-retrieve-image-from-sql.html [ ^ ]

http://www.2ndbrain.com/devToolbox/showArticle.aspx?aID=114 [ ^ ]

Refer these:

http://techiecocktail.blogspot.in/2009/05/store-and-retrieve-image-from-sql.html[^]

http://www.2ndbrain.com/devToolbox/showArticle.aspx?aID=114[^]

<asp:GridView ID="GridView1" runat="server" Width="245px" AutoGenerateColumns="False"

                       DataKeyNames="id" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting"

                       OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"

                       onrowdatabound="GridView1_RowDataBound">
                       <Columns>
                           <asp:BoundField DataField="name" HeaderText="name" NullDisplayText="no data" SortExpression="name" />
                           <asp:TemplateField HeaderText="name">
                               <%--  <ItemTemplate>
                                   <asp:Label ID="Label2" runat="server" Text='<%# Eval("name") %>'></asp:Label>
                               </ItemTemplate>--%>
                               <EditItemTemplate>
                                   <asp:TextBox ID="TextBox4" runat="server" Text='<%# Eval("name") %>'></asp:TextBox>
                               </EditItemTemplate>
                           </asp:TemplateField>
                           <asp:TemplateField HeaderText="age">
                               <ItemTemplate>
                                   <asp:Label ID="Label3" runat="server" Text='<%# Eval("age") %>'></asp:Label>
                               </ItemTemplate>
                               <EditItemTemplate>
                                   <asp:TextBox ID="TextBox5" runat="server" Text='<%# Eval("age") %>'></asp:TextBox>
                               </EditItemTemplate>
                           </asp:TemplateField>
                           <asp:TemplateField HeaderText="img">
                               <ItemTemplate>
                                   <asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("iname") %>' Width="30" />
                               </ItemTemplate>
                               <EditItemTemplate>
                                   <asp:FileUpload ID="FileUpload2" ImageUrl='<%# Eval("iname") %>' runat="server" />
                               </EditItemTemplate>
                           </asp:TemplateField>
                           <asp:TemplateField HeaderText="edit">
                               <ItemTemplate>
                                   <asp:LinkButton ID="LinkButton1" runat="server" CommandName="Edit">Edit</asp:LinkButton>
                               </ItemTemplate>
                               <EditItemTemplate>
                                   <asp:LinkButton ID="LinkButton2" runat="server" CommandName="update">update</asp:LinkButton>
                                   <asp:LinkButton ID="LinkButton3" runat="server" CommandName="cancel">cancel</asp:LinkButton>
                               </EditItemTemplate>
                           </asp:TemplateField>
                       </Columns>
                   </asp:GridView>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.IO;
using System.Drawing;
using Image = System.Drawing.Image;
using System.Drawing.Drawing2D;

protected void Button1_Click(object sender, EventArgs e)
    {
SqlCommand cmd = new SqlCommand("tblname", con);
       cmd.CommandType = CommandType.StoredProcedure;
       cmd.Parameters.AddWithValue("@id", "");
       cmd.Parameters.AddWithValue("@name", TextBox1.Text);
       cmd.Parameters.AddWithValue("@age", TextBox2.Text);

       string username = TextBox1.Text;
       string fp = Path.GetFullPath(FileUpload1.PostedFile.FileName);//Get File Path
       string extension = Path.GetExtension(fp);//Get File extension
       string result = Path.ChangeExtension(extension, ".jpeg");
       FileUpload1.SaveAs(Server.MapPath("~/uplodes/") + username + result);
       //  E:/examples/db/uplodes
       string urlname = "/db/uplodes/" + username + ".jpeg";
       cmd.Parameters.AddWithValue("@iname", urlname);
       cmd.Connection = con;
       try
       {
           con.Open();
           cmd.ExecuteNonQuery();
       }
       catch (Exception ex)
       {
           Response.Write("this error is " + ex.Message);
       }
       finally
       {
           con.Close();
       }
}

这篇关于使用文件上载器将图像保存在数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！