How can i insert file upload control in edit template in listview then how to update the data in database

See more:

C#

ASP.NET

SQL-Server

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

//the problem here how i can have more values Row of label of listview based on ids come from lable
//this code work but for specific Row as have index 4
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)
{
//1
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");
}

}
}