Hi Selvi,

Refer

http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/add-details-of-an-employee-with-image-and-display-it-into-a/

Stored procedure

CREATE PROCEDURE insert_employee

(

@name varchar(50),

@address varchar(50),

@image varchar(50)

)

Insert into employee values (@name,@address,@image)

CREATE PROCEDURE update_employee

(

@id int,

@name varchar(50),

@address varchar(50)

)

Update employee set name=@name, address=@address where id=@id

CREATE PROCEDURE delete_employee

(@id int)

Delete from employee where id=@id

Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Add_update_delete_gridview._Default" %>

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Pagetitle>

head>

<body>

<div>

<table>

<tr>

<td>

Nametd>

<td>

<asp:TextBox ID="txt_name" runat="server">asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"

ControlToValidate="txt_name" ErrorMessage="Please enter the name">asp:RequiredFieldValidator>

td>

tr>

<tr>

<td>

Addresstd>

<td>

<asp:TextBox ID="txt_address" runat="server">asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"

ControlToValidate="txt_address" ErrorMessage="Please enter the address">asp:RequiredFieldValidator>

td>

tr>

<tr>

<td>

Imagetd>

<td>

<asp:FileUpload ID="FileUpload1" runat="server" />

<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"

ControlToValidate="FileUpload1" ErrorMessage="Please browse the image">asp:RequiredFieldValidator>

td>

tr>

<tr>

<td>

td>

<td>

<asp:Button ID="btn_insert" runat="server" onclick="btn_insert_Click"

Text="Insert" />

td>

tr>

<tr>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

onrowcancelingedit="GridView1_RowCancelingEdit"

onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"

onrowupdating="GridView1_RowUpdating"

onselectedindexchanging="GridView1_SelectedIndexChanging"

BackColor="#CC3300" ForeColor="Black">

<asp:TemplateField HeaderText="Name">

<asp:TextBox ID="txt_name" runat="server"

Text='<%# Eval("name") %>'>asp:TextBox>

<asp:Label ID="Label4" runat="server" Text='<%# Eval("id") %>' Visible="False">asp:Label>

EditItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Eval("name") %>'>asp:Label>

<asp:Label ID="Label2" runat="server" Text='<%# Eval("id") %>' Visible="False">asp:Label>

ItemTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="Address">

<asp:TextBox ID="txt_address" runat="server" Text='<%# Eval("address") %>'>asp:TextBox>

EditItemTemplate>

<asp:Label ID="Label3" runat="server" Text='<%# Eval("address") %>'>asp:Label>

ItemTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="Image">

<img alt ="" src ='images/<%#Eval("image") %>' height="50px" width="50px"/>

ItemTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="Edit">

<asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False"

CommandName="Update">Updateasp:LinkButton>

<asp:LinkButton ID="LinkButton4" runat="server" CausesValidation="False"

CommandName="Cancel">Cancelasp:LinkButton>

EditItemTemplate>

<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False"

CommandName="Edit">Editasp:LinkButton>

ItemTemplate>

asp:TemplateField>

<asp:TemplateField HeaderText="Delete">

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"

CommandName="Delete"

onclientclick="return confirm('Are you sure you want to delete this record')">Deleteasp:LinkButton>

ItemTemplate>

asp:TemplateField>

Columns>

asp:GridView>

td>

tr>

table>

div>

form>

body>

html>

Default.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

using System.IO;

namespace Add_update_delete_gridview

{

public partial class _Default : System.Web.UI.Page

{

string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

string s1;

string path;

SqlConnection cnn = new SqlConnection();

SqlCommand com = new SqlCommand();

SqlDataAdapter sqlda;

DataTable dt;

int id;

string name;

string address;

string image;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}

protected void btn_insert_Click(object sender, EventArgs e)

{

if (FileUpload1.PostedFile.ContentLength > 0)

{

s1 = Path.GetFileName(FileUpload1.FileName);

path = Server.MapPath("images") + "/" + s1;

FileUpload1.SaveAs(path);

}

SqlConnection con = new SqlConnection(strConnString);

con.Open();

SqlCommand com = new SqlCommand("insert_employee", con);

com.CommandType = CommandType.StoredProcedure;

com.Connection = con;

com.Parameters.AddWithValue("@name", txt_name.Text);

com.Parameters.AddWithValue("@address", txt_address.Text);

com.Parameters.AddWithValue("@image", s1);

com.ExecuteNonQuery();

com.Dispose();

bindgrid();

con.Close();

clear();

}

private void clear()

{

txt_name.Text = "";

txt_address.Text = "";

}

private void bindgrid()

{

SqlConnection con = new SqlConnection(strConnString);

con.Open();

sqlda = new SqlDataAdapter("SELECT * FROM employee ", con);

dt = new DataTable();

sqlda.Fill(dt);

sqlda.Dispose();

GridView1.DataSource = dt;

GridView1.DataBind();

con.Close();

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

SqlConnection con = new SqlConnection(strConnString);

con.Open();

try

{

id = Convert.ToInt32(((Label)(GridView1.Rows[e.RowIndex].FindControl("label2"))).Text);

SqlCommand com = new SqlCommand("delete_employee", con);

com.CommandType = CommandType.StoredProcedure;

com.Connection = con;

com.Parameters.Add("@id", SqlDbType.Int).Value = id;

SqlDataAdapter sqlda = new SqlDataAdapter("select * from employee where id=@id", con);

sqlda.SelectCommand.Parameters.Add("@id", SqlDbType.Int).Value = id;

DataSet ds = new DataSet();

sqlda.Fill(ds);

try

{

image = Convert.ToString(ds.Tables[0].Rows[0]["image"]);

File.Delete(Server.MapPath("images") + "\\" + image);

}

catch (Exception)

{

}

com.ExecuteNonQuery();

com.Dispose();

bindgrid();

}

catch(Exception)

{

}

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

bindgrid();

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

bindgrid();

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

SqlConnection con = new SqlConnection(strConnString);

con.Open();

id = Convert.ToInt32(((Label)(GridView1.Rows[e.RowIndex].FindControl("label4"))).Text);

name = (((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_name"))).Text);

address = (((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_address"))).Text);

SqlCommand com = new SqlCommand("update_employee", con);

com.CommandType = CommandType.StoredProcedure;

com.Connection = con;

com.Parameters.Add("@id", SqlDbType.Int).Value = id;

com.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = name;

com.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = address;

com.ExecuteNonQuery();

com.Dispose();

con.Close();

GridView1.EditIndex = -1;

bindgrid();

}

protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)

{

GridView1.PageIndex = e.NewSelectedIndex;

bindgrid();

}

Thanks
If this post helps you mark it as answer

2 Replies

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

Senthilkumar14y ago
Hi,

If you only looking to upload files in asp.net then you have the control called file upload.

This is control which allows you to select the file in your computer to see all the drives, directories and files.

After selecting the files and click on another button something called "Upload", you need to write the server side code.

protected void btnUpload_click(object sender, EventArgs e)
{
FileInfo fileInfo = new FileInfo( fileUpload.PostedFile.FileName);
if(fileUpload.HasFile)
{
fileUpload.PostedFile.SaveAs(Server.MapPath( fileInfo.FileName));
}
}

The above will be saved into your application folder.
Satyapriya Nayak14y ago
Hi Selvi,

Refer

http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/add-details-of-an-employee-with-image-and-display-it-into-a/

Stored procedure

CREATE PROCEDURE insert_employee
(

@name varchar(50),
@address varchar(50),
@image varchar(50)
)

AS

Insert into employee values (@name,@address,@image)

CREATE PROCEDURE update_employee
(

@id int,
@name varchar(50),
@address varchar(50)
)

AS

Update employee set name=@name, address=@address where id=@id

CREATE PROCEDURE delete_employee
(@id int)
AS

Delete from employee where id=@id

Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Add_update_delete_gridview._Default" %>

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>Untitled Pagetitle>

head>

<body>

    <form id="form1" runat="server">

    <div>

    <table>

        <tr>

            <td>

                 Nametd>

            <td>

                <asp:TextBox ID="txt_name" runat="server">asp:TextBox>

                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"

                    ControlToValidate="txt_name" ErrorMessage="Please enter the name">asp:RequiredFieldValidator>

            td>

        tr>

        <tr>

            <td>

                Addresstd>

            <td>

                <asp:TextBox ID="txt_address" runat="server">asp:TextBox>

                <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"

                    ControlToValidate="txt_address" ErrorMessage="Please enter the address">asp:RequiredFieldValidator>

            td>

        tr>

        <tr>

            <td>

                Imagetd>

            <td>

                <asp:FileUpload ID="FileUpload1" runat="server" />

                <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"

                    ControlToValidate="FileUpload1" ErrorMessage="Please browse the image">asp:RequiredFieldValidator>

            td>

        tr>

        <tr>

            <td>

                td>

            <td>

                <asp:Button ID="btn_insert" runat="server" onclick="btn_insert_Click"

                    Text="Insert" />

            td>

        tr>

        <tr>

            <td colspan="2">

                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

                    onrowcancelingedit="GridView1_RowCancelingEdit"

                    onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"

                    onrowupdating="GridView1_RowUpdating"

                    onselectedindexchanging="GridView1_SelectedIndexChanging"

                    BackColor="#CC3300" ForeColor="Black">



                    <Columns>



                        <asp:TemplateField HeaderText="Name">

                            <EditItemTemplate>



                                <asp:TextBox ID="txt_name" runat="server"

                                    Text='<%# Eval("name") %>'>asp:TextBox>

                                <asp:Label ID="Label4" runat="server" Text='<%# Eval("id") %>' Visible="False">asp:Label>

                            EditItemTemplate>

                            <ItemTemplate>

                                <asp:Label ID="Label1" runat="server" Text='<%# Eval("name") %>'>asp:Label>

                                <asp:Label ID="Label2" runat="server" Text='<%# Eval("id") %>' Visible="False">asp:Label>

                            ItemTemplate>

                        asp:TemplateField>

                        <asp:TemplateField HeaderText="Address">

                            <EditItemTemplate>

                                <asp:TextBox ID="txt_address" runat="server" Text='<%# Eval("address") %>'>asp:TextBox>

                            EditItemTemplate>

                            <ItemTemplate>

                                <asp:Label ID="Label3" runat="server" Text='<%# Eval("address") %>'>asp:Label>

                            ItemTemplate>

                        asp:TemplateField>

                        <asp:TemplateField HeaderText="Image">

                        <ItemTemplate>



                        <img alt ="" src ='images/<%#Eval("image") %>' height="50px" width="50px"/>

                        ItemTemplate>

                        asp:TemplateField>





                         <asp:TemplateField HeaderText="Edit">

                            <EditItemTemplate>



                                <asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False"

                                    CommandName="Update">Updateasp:LinkButton>

                                <asp:LinkButton ID="LinkButton4" runat="server" CausesValidation="False"

                                    CommandName="Cancel">Cancelasp:LinkButton>

                            EditItemTemplate>

                            <ItemTemplate>



                                <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False"

                                    CommandName="Edit">Editasp:LinkButton>

                            ItemTemplate>

                        asp:TemplateField>



                        <asp:TemplateField HeaderText="Delete">



                            <ItemTemplate>

                               <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"

                                    CommandName="Delete"

                                    onclientclick="return confirm('Are you sure you want to delete this record')">Deleteasp:LinkButton>

                            ItemTemplate>

                        asp:TemplateField>



                    Columns>

                    <HeaderStyle BackColor="#FF9933" />

                    <AlternatingRowStyle BackColor="#FFCC00" />

                asp:GridView>

            td>

        tr>

        table>

    div>

    form>

body>

html>

Default.aspx.cs

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

using System.IO;

namespace Add_update_delete_gridview

{

    public partial class _Default : System.Web.UI.Page

    {

    string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    string s1;

    string path;

    SqlConnection cnn = new SqlConnection();

    SqlCommand com = new SqlCommand();

    SqlDataAdapter sqlda;

    DataTable dt;

    int id;

    string name;

    string address;

    string image;

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                bindgrid();

            }

        }

        protected void btn_insert_Click(object sender, EventArgs e)

        {



            if (FileUpload1.PostedFile.ContentLength > 0)

            {

                s1 = Path.GetFileName(FileUpload1.FileName);

                path = Server.MapPath("images") + "/" + s1;

                FileUpload1.SaveAs(path);

            }



            SqlConnection con = new SqlConnection(strConnString);

            con.Open();

            SqlCommand com = new SqlCommand("insert_employee", con);

            com.CommandType = CommandType.StoredProcedure;

            com.Connection = con;

            com.Parameters.AddWithValue("@name", txt_name.Text);
            com.Parameters.AddWithValue("@address", txt_address.Text);
            com.Parameters.AddWithValue("@image", s1);
            com.ExecuteNonQuery();

            com.Dispose();

            bindgrid();

            con.Close();

            clear();

        }

      private void clear()

        {

            txt_name.Text = "";

            txt_address.Text = "";

        }

        private void bindgrid()

        {

            SqlConnection con = new SqlConnection(strConnString);

            con.Open();

            sqlda = new SqlDataAdapter("SELECT * FROM employee ", con);

            dt = new DataTable();

            sqlda.Fill(dt);

            sqlda.Dispose();

            GridView1.DataSource = dt;

            GridView1.DataBind();

            con.Close();

        }

        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

        {

            SqlConnection con = new SqlConnection(strConnString);

            con.Open();

            try

            {



                id = Convert.ToInt32(((Label)(GridView1.Rows[e.RowIndex].FindControl("label2"))).Text);

                SqlCommand com = new SqlCommand("delete_employee", con);

                com.CommandType = CommandType.StoredProcedure;

                com.Connection = con;

                com.Parameters.Add("@id", SqlDbType.Int).Value = id;

                SqlDataAdapter sqlda = new SqlDataAdapter("select * from employee where id=@id", con);


                sqlda.SelectCommand.Parameters.Add("@id", SqlDbType.Int).Value = id;
                DataSet ds = new DataSet();

                sqlda.Fill(ds);

                try

                {

                    image = Convert.ToString(ds.Tables[0].Rows[0]["image"]);

                    File.Delete(Server.MapPath("images") + "\\" + image);

                }

                catch (Exception)

                {



                }

                com.ExecuteNonQuery();

                com.Dispose();

                bindgrid();

            }

            catch(Exception)

            {



            }

        }

        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

        {

            GridView1.EditIndex = -1;

            bindgrid();

        }

        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

        {

            GridView1.EditIndex = e.NewEditIndex;

            bindgrid();

        }

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

        {

            SqlConnection con = new SqlConnection(strConnString);

            con.Open();



            id = Convert.ToInt32(((Label)(GridView1.Rows[e.RowIndex].FindControl("label4"))).Text);

            name = (((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_name"))).Text);

            address = (((TextBox)(GridView1.Rows[e.RowIndex].FindControl("txt_address"))).Text);

            SqlCommand com = new SqlCommand("update_employee", con);

            com.CommandType = CommandType.StoredProcedure;

            com.Connection = con;

            com.Parameters.Add("@id", SqlDbType.Int).Value = id;

            com.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = name;

            com.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = address;

            com.ExecuteNonQuery();

            com.Dispose();

            con.Close();

            GridView1.EditIndex = -1;

            bindgrid();

        }

        protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)

        {

            GridView1.PageIndex = e.NewSelectedIndex;

            bindgrid();

        }

    }

}

Thanks
If this post helps you mark it as answer

I need to upload a image in asp.net using C#

Stored procedure

Default.aspx

Default.aspx.cs