Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
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 = 
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)
string filename = Path.GetFileName(f.FileName);
f.SaveAs(Server.MapPath("~/Images/") + filename);
SqlComm.Parameters.AddWithValue("@Product_image", filename);
if (f2.HasFile)
f2.SaveAs(Server.MapPath("~/Images/") + filename2);
Posted 5-Feb-13 12:15pm
Edited 6-Feb-13 3:13am
(no name)31.4K

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 /\jmot 230
1 Zoltán Zörgő 210
2 CHill60 145
3 Peter Leow 145
4 Sergey Alexandrovich Kryukov 115
0 Sergey Alexandrovich Kryukov 9,353
1 OriginalGriff 6,881
2 Peter Leow 4,577
3 Zoltán Zörgő 4,129
4 Richard MacCutchan 2,882

Advertise | Privacy | Mobile
Web04 | 2.8.150129.1 | Last Updated 6 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100