insert data with image into database

Hello Everyone..!

this is your friend Md Aamir

so let's point to the problem is that bfeore image option data waz being inserted but then i using image option so data is not being inserted m i doing wrong plz give solution if i m

i will be your thankfull

here you go for my cs code:

protected void btnbut_Click(object sender, EventArgs e)
{
if (imageupload.HasFile)
{
string strpath = System.IO.Path.GetExtension(imageupload.FileName);
if (strpath != ".jpg" || strpath != ".jpeg" || strpath != ".gif" || strpath != ".png" || strpath != ".PNG" || strpath != ".GIF" || strpath != ".JPEG" || strpath != ".JPG")
{
// lblimgupl.Text = "Only jpg, png, gif,jpg or caps are accepted";
// ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Only image formats ('jpg, png, gif,jpg or caps are accepted ')", true);
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand("insert2", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@category", ddlcategory.SelectedValue);
cmd.Parameters.AddWithValue("@name", txtname.Text);
cmd.Parameters.AddWithValue("@color", txtcolor.Text);
cmd.Parameters.AddWithValue("@price", txtprice.Text);
string filename = DateTime.Now.Date.ToString("ddMMyyyy") + DateTime.Now.Minute + DateTime.Now.Millisecond + Path.GetExtension(imageupload.FileName);
imageupload.SaveAs(Server.MapPath("~/Upload/") + filename);
cmd.Parameters.AddWithValue("@Image1", filename);
lblimgupl.Text = "Image successfully uploaded ";
cmd.ExecuteNonQuery();
con.Close();
fill_grd();
}
}
}

here aspx page: -

<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/admin/adminMasterPage.master" CodeFile="AddProducts.aspx.cs" Inherits="admin_AddProducts" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<asp:MultiView ID="MultiView1" runat="server">
<asp:View ID="View1" runat="server">
<div>
<asp:LinkButton ID="lbviewlist" runat="server" OnClick="lbviewlist_Click">View Product Listasp:LinkButton>
div>
<div>
Select a Category
div>
<div>
<asp:DropDownList ID="ddlcategory" runat="server">asp:DropDownList>
div>
<div>Name:div>
<div>
<asp:TextBox ID="txtname" runat="server">asp:TextBox>
div>
<div>Colordiv>
<div>
<asp:TextBox ID="txtcolor" runat="server">asp:TextBox>
div>
<div>Price:div>
<div>
<asp:TextBox ID="txtprice" runat="server">asp:TextBox>
div>
<div>
Select Image:
div>
<div>
<asp:FileUpload ID="imageupload" runat="server" />
div>
<div>
<asp:Label ID="Label1" runat="server" ForeColor="Red">asp:Label>
div>
<div>
<asp:Label ID="lblimgupl" runat="server" ForeColor="Blue">asp:Label>
div>
<div>
<asp:Button ID="btnbut" runat="server" Text="Save" OnClick="btnbut_Click" Width="72px" />
div>
asp:View>
<asp:View ID="View2" runat="server">
<div>
<asp:LinkButton ID="lbback" runat="server" OnClick="lbback_Click">Backasp:LinkButton>
div>
<asp:GridView ID="grd" runat="server" AutoGenerateColumns="false" OnRowEditing="grd_RowEditing" OnRowUpdating="grd_RowUpdating" OnRowCommand="grd_RowCommand" OnSelectedIndexChanged="grd_SelectedIndexChanged">
<Columns>
<asp:BoundField DataField="pid" HeaderText="ID" />
<asp:TemplateField HeaderText="Cetagory">
<ItemTemplate>
<%#Eval("category") %>
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<%#Eval("name") %>
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Color">
<ItemTemplate>
<%#Eval("color") %>
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Price">
<ItemTemplate>
<%#Eval("price") %>
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Click_it">
<ItemTemplate>
<asp:LinkButton ID="lnkbtndelt" runat="server" CommandName="delt" CommandArgument='<%#Eval("pid") %>' Text="Delet" />
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Click_It">
<ItemTemplate>
<asp:LinkButton ID="lnkbtnedit" runat="server" CommandName="edt" CommandArgument='<%#Eval("pid") %>' Text="Edit" OnClick="btnedit_Click" />
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Click_It">
<ItemTemplate>
<asp:LinkButton ID="lnkbtnupd" runat="server" CommandName="upd" CommandArgument='<%#Eval("pid") %>' Text="update" OnClick="lnkbtnupd_Click" />
ItemTemplate>
asp:TemplateField>
<asp:TemplateField HeaderText="Status">
<ItemTemplate>
<asp:LinkButton ID="lbtactive" runat="server" Text="Active" Visible="false" CommandName="Active" OnClick="lbtactive_Click">asp:LinkButton>
<asp:LinkButton ID="ibinactive" runat="server" Text="Inactive" CommandName="Inactive" OnClick="ibinactive_Click">asp:LinkButton>
ItemTemplate>
asp:TemplateField>
Columns>
asp:GridView>
asp:View>
<asp:View ID="View3" runat="server">
<div>ID:<asp:Label ID="lblID" runat="server" ForeColor="#CC3300" BorderColor="Red">asp:Label>div>
<div>
<asp:Label ID="lblmsg" runat="server" ForeColor="Blue">asp:Label>
div>
<div>
<asp:LinkButton ID="LinkButton1" runat="server" OnClick="lbviewlist_Click">Backasp:LinkButton>
div>
<div>
Select A Category
div>
<div>
<asp:DropDownList ID="ddlcetagory1" runat="server">asp:DropDownList>
div>
<div>Name:div>
<div>
<asp:TextBox ID="txtname1" runat="server">asp:TextBox>
div>
<div>Colordiv>
<div>
<asp:TextBox ID="txtcolor1" runat="server">asp:TextBox>
div>
<div>Price:div>
<div>
<asp:TextBox ID="txtprice1" runat="server">asp:TextBox>
div>
<div>
<asp:Button ID="BtnSave" runat="server" Text="Save" OnClick="BtnSave_Click" Width="72px" />
div>
asp:View>
asp:MultiView>
asp:Content>

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
please refer this link:
https://www.c-sharpcorner.com/uploadfile/e628d9/inserting-retrieving-images-from-sql-server-database-without-using-stored-procedures/
Mohd Aamir7y ago
store procedure:-

USE [addtocart28818]
GO
/****** Object: StoredProcedure [dbo].[insert2] Script Date: 10/29/2018 11:29:45 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[insert2]
@category varchar (60),
@name varchar (60),
@color varchar (60),
@price int,
@image1 varchar (60)
as
begin
insert into products(category,name,color,price,image1)values(@category,@name,@color,@price,@image1)
end
Sreekanth Reddy7y ago
Can you show your stored procedure "insert2" also ?