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));

}

Hari Krishna · Answer

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(NameCommentsDateTime) 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(); } }