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 11:15am
radals490
Edited 6-Feb-13 2:13am
28.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 OriginalGriff 210
1 Richard MacCutchan 100
2 kbrandwijk 90
3 ChauhanAjay 80
4 ProgramFOX 80
0 Sergey Alexandrovich Kryukov 9,050
1 OriginalGriff 8,151
2 CPallini 2,613
3 Richard MacCutchan 2,221
4 Abhinav S 1,928


Advertise | Privacy | Mobile
Web03 | 2.8.140827.1 | Last Updated 6 Feb 2013
Copyright © CodeProject, 1999-2014
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