Loading
Insert image and description into database table      
  •              
  •              
  •       
  •              
  •       
  •          
  •          
  •    "button1" runat="server" text="add to cart" />      
  •   
  •  aspx.cs as  
  •   
  • protected void Button1_Click(object sender, EventArgs e)    
  • {    
  •     string Name,Price,Quantity,description,path;    
  •     foreach (RepeaterItem item in Repeater1.Items)    
  •     {  Image= (Image)item.FindControl("Image1");   
  •         Name = (Label)item.FindControl("Label1");    
  •         price=(Label)item.FindControl("Label2");    
  •         Quantity = (Label)item.FindControl("Label3");    
  •         desc=(Label)item.FindControl("Label4");    
  •         path=Image.Src;  
  •     }    
  •     
  •     using(SqlConnection con=new SqlConnection(conn))    
  •     {    
  •         SqlCommand cmd=new SqlCommand("Insert into Product values(@Name,@desc,@Price,@Quantity,Path)",con);  
  •         cmd.parameters.AddwithValue("@Name",Name);    
  •         cmd.parameters.AddwithValue("@price",price);    
  •         cmd.parameters.AddwithValue("@Quantity",Quantity);    
  •         cmd.parameters.AddwithValue("@price",price);    
  •         cmd.parameters.AddwithValue("@path",path);    
  •         con.Open();    
  •         cmd.ExecuteNonQuery();    
  •     }    
  • } 
    •  

  • Upen TPosted Oct 30, 2020, 7:32 AM

    This is cart_table in which cart details stored
     
  • Sachin Singh

    Sachin SinghPosted Oct 29, 2020, 1:30 PM

    Please use image1.ImageUrl in code behind, src is not attribute for server control , rest is fine
  • Mageshwaran R

    Mageshwaran RPosted Oct 29, 2020, 9:40 AM

    Hi Upen,
    please try this link,
    https://www.youtube.com/watch?v=5L5W-AE-sEs&list=PLaBp9t85cRP2yqWZKYY1PHBdEG3h3M-rc&index=6&t=0s
  • Rajanikant Hawaldar

    Rajanikant HawaldarPosted Oct 29, 2020, 7:51 AM

    Hello Upen refer below articles / blog at C#Corner
     
    https://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/#:~:text=As%20we%20want%20to%20insert,binary'%20for%20storing%20the%20image.&text=Design%20the%20form%20as%20above,4%20TextBoxes%20and%2011%20Buttons.
     
    https://www.c-sharpcorner.com/UploadFile/deepak.sharma00/how-to-save-images-in-mysql-database-using-C-Sharp/ 
    https://www.c-sharpcorner.com/uploadfile/17e8f6/inserting-and-reading-image-tofrom-database-in-Asp-Net-web-application-in-image-control/
    https://www.c-sharpcorner.com/UploadFile/17e8f6/crud-operation-with-image-insertion-and-retrieval-in-Asp-Net/
    https://www.c-sharpcorner.com/UploadFile/asmabegam/datagridview-crud-with-image-save-to-sql-server-using-C-Sharp/ 
    https://www.c-sharpcorner.com/blogs/crud-operations-and-upload-download-files-in-asp-net-core-20