Insert image and description into database table

Question

I want to insert that Image into database table

Sachin Singh · Answer

Instead of saving image into database save image path to database Your full code should like "r1" runat= "server" > "height:300px; width:600px; border-style:solid; border-width:1px;" > "height:300px; width:200px; float:left; border-style:solid; border-width:1px;" > "Image1" src= "../item_image/ product_image ") %>" alt= "" height= "150" width= "150" runat= "server" > "height:300px; width:395px; float:left; border-style:solid; border-width:1px;" > product name= "Label1" runat= "server" Text= ' ' > product desc= "Label2" runat= "server" Text= "product_desc" ) %>' product price= "Label3" runat= "server" Text= "product_price" ) %>'> product qnatity= "Label4" runat= "server" Text= ' ' > "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(); } }

Sachin Singh · Answer

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

Upen T · Answer

This is cart_table in which cart details stored

Mageshwaran R · Answer

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

Rajanikant Hawaldar · Answer

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

Insert image and description into database table

Answers (5)