How can i insert file upload control in edit template in listview then how to update the data in database
i have listview that contain many users & have products for every user
i want insert image for every product (may be every user have 3 products)
i add fileupload in listview & button that have this code to insert images based on
user id & product id
but i cant have items value from label can any one help me please
protected void Button1_Click(object sender, EventArgs e)
{
string conString =
ConfigurationManager.ConnectionStrings["dbCompaniesConnectionString1"].ConnectionString;
SqlConnection MyCon = new SqlConnection(conString);
SqlCommand SqlComm = new SqlCommand("update tbUserProducts set Product_image=@Product_image,Product_thumb=@Product_thumb where User_id=@userid AND id=@ProductId ", MyCon);
SqlComm.Parameters.AddWithValue("@userid", Request.Cookies["UserID"].Value);
ListViewItem item = ListView1.Items[4];
Label country = (Label)item.FindControl("idLabel");
SqlComm.Parameters.AddWithValue("@ProductId", country.Text.ToString());
FileUpload f2 = (FileUpload)ListView1.EditItem.FindControl("MyFileUpload");
string filename2 = Path.GetFileName(f2.FileName);
SqlComm.Parameters.AddWithValue("@Product_thumb", filename2);
FileUpload f = (FileUpload)ListView1.EditItem.FindControl("FilUpload1");
if (f.HasFile)
{
string filename = Path.GetFileName(f.FileName);
f.SaveAs(Server.MapPath("~/Images/") + filename);
MyCon.Open();
SqlComm.Parameters.AddWithValue("@Product_image", filename);
SqlComm.ExecuteNonQuery();
MyCon.Close();
}
else
{
Response.Write("errrrrrrrrrrrrrrror");
}
if (f2.HasFile)
{
f2.SaveAs(Server.MapPath("~/Images/") + filename2);
MyCon.Open();
SqlComm.ExecuteNonQuery();
MyCon.Close();
}
else
{
Response.Write("errrrrrrrrrrrrrrror");
}
}
}