// 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);
Hari KrishnaPosted May 9, 2013, 8:43 AM
The following code for default image stored into database when Fileupload doesn't have file. This code may help to u.
.aspx.cs
-----------------
string query = "Insert into Comments values('" + TxtName.Text + "','" + TxtComments.Text + "','~/Images/noAvator.jpg','" + DateTime.Now.ToString() + "')";