product description inserted in database table

Question

This is product_description page: and i want to insert that detail of product into database table

Sachin Singh · Answer

First change your aspx like below "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;" > "../item_image/ product_image ") %>" alt= "" height= "150" width= "150" /> "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" /> Then aspx.cs as protected void Button1_Click( object sender, EventArgs e) { string Name,Price,Quantity,description; foreach (RepeaterItem item in Repeater1.Items) { Name = (Label)item.FindControl( "product_name" ); price=(Label)item.FindControl( "product_price" ); Quantity = (Label)item.FindControl( "product_qty" ); desc=(Label)item.FindControl( "product_description" ); } using (SqlConnection con= new SqlConnection(conn)) { SqlCommand cmd= new SqlCommand( "Insert into Product values(@Name,@desc,@Price,@Quantity,)" ,con); cmd.parameters.AddwithValue( "@Name" ,Name); cmd.parameters.AddwithValue( "@price" ,price); cmd.parameters.AddwithValue( "@Quantity" ,Quantity); cmd.parameters.AddwithValue( "@price" ,price); con.Open(); cmd.ExecuteNonQuery(); } }

Upen T · Answer

In previous example image also has to be inserted into database table...how can doit?

Mageshwaran R · Answer

Hi Upen, please refer this link, https://www.c-sharpcorner.com/UploadFile/4aae29/complete-crud-operations-in-Asp-Net/

product description inserted in database table

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)