Click here to Skip to main content
Rate this: bad
good
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 = 
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");
}
 
}
}
Posted 5-Feb-13 12:15pm
radals501
Edited 6-Feb-13 3:13am
(no name)31.4K
v3

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