how to upload default image into database

Question

i have to insert default image into databse..when no image is selected from fileupload control..

code...not working for inserting  default image...

if (FileUpload1.HasFile)
{
string FileName = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(Server.MapPath("~/UPLOADEDFILES/" + FileName));
feedBack.Attachments.Add(new Attachment(FileUpload1.PostedFile.InputStream, FileName));
}

else
{
string filename="~/images/"+ "sun.gif";
filename.pPropertyImage = filename;
FileUpload1.SaveAs(MapPath(filename));



}

Answer 1

Hi,

    The following code for default image stored into database when Fileupload doesn't have file. This code may help to u.

.aspx.cs
-----------------

public partial class _Default : System.Web.UI.Page

{

    SqlConnection con;

    SqlCommand cmd;

    SqlDataAdapter da;

    DataSet ds;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

            loadComments();

    }

    protected void BtnInsert_Click(object sender, EventArgs e)

    {

        try

        {

            con=new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnectionstring"].ConnectionString);

            

            string imagename="~/Images/"+FileUpload1.FileName;

            //string query="Insert into Comments values('"+TxtName.Text+"','"+TxtComments.Text+"','"+imagename+"','"+DateTime.Now.ToString()+"')";

            

            string path = Server.MapPath("~/Images/" + FileUpload1.FileName);

            if (FileUpload1.HasFile)

            {

                FileUpload1.SaveAs(path);

                string query1 = "Insert into Comments values('" + TxtName.Text + "','" + TxtComments.Text + "','~/Images/" + FileUpload1.FileName + "','" + DateTime.Now.ToString() + "')";

                ExecuteCommand(query1);

            }

            else

            {

                //string query = "Insert into Comments(Name,Comments,DateTime) values('" + TxtName.Text + "','" + TxtComments.Text + "','" + DateTime.Now.ToString() + "')";

                // Logic for inserting default image into database when file is not selected from FileIpload control
                string query = "Insert into Comments values('" + TxtName.Text + "','" + TxtComments.Text + "','~/Images/noAvator.jpg','" + DateTime.Now.ToString() + "')";

                ExecuteCommand(query);

            }

            

        }

        catch (Exception ex)

        { 

        

        }

    }

    private void ExecuteCommand(string query)

    {

        con = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnectionstring"].ConnectionString);

        cmd = new SqlCommand(query, con);

        cmd.CommandText = query;

        con.Open();

        cmd.ExecuteNonQuery();

        con.Close();

        TxtName.Text = "";

        TxtComments.Text = "";

        loadComments();

    }

    private void loadComments()

    {

        con = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnectionstring"].ConnectionString);

        da = new SqlDataAdapter("Select * from Comments order by DateTime desc", con);

        ds = new DataSet();

        da.Fill(ds);

        DataList1.DataSource = ds;

        DataList1.DataBind();

    }

}