Click here to Skip to main content
15,913,939 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to save the file path in Database using fileuploder control ...
and retrieve the image from database.
Posted

Try this:
C#
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();

For more please refer this article:Save Files to SQL Server Database using FileUpload Control[^]
 
Share this answer
 
v2
XML
<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>




C#
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;



C#
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();
       }
}
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900