Purvi's Blog

Code To Insert, Update, Delete Record In Sql Server DataBase Using Asp.net (or) Perform Insert, Update,Delete Using Asp.net In C#

Now for this new article first create a new asp.net web application, and add a new page in it and add a gridview control. Here is your .aspx code.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="BindGridView.WebForm1" %>

<!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>How To Import Excelsheet Data Into SQL Server Using Asp.Net In c#</title>
    <script language="javascript">
        function ConfirmMessage() {
            var answer = confirm("Are you sure. do you want to delete record.");
            if (answer) {
                return true;
            } else {
                return false;
            }
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>

               Name :<asp:TextBox ID="TextBox1" runat="server"
            Width="200px"></asp:TextBox>
        <br />
        <br />
    Address:<asp:TextBox ID="TextBox2" runat="server" Width="200px"></asp:TextBox>
        <br />
        <br />
        ContactNo :<asp:TextBox ID="TextBox3" runat="server" Width="200px"></asp:TextBox>
        <br />
        <br />

        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Save"
            Width="93px" />
                  <asp:Button ID="Button2" runat="server" Text="Update"
            Width="93px" onclick="Button2_Click" />
        <br />
        <br />
        <asp:Label ID="lblmessage" runat="server"
            style="font-weight: 700; color: #FFFFFF; background-color: #FF0000"
            Text=""></asp:Label>
        <br />
        <br />
        <asp:GridView runat="server" AutoGenerateColumns="False" ID="griddemo"
            Width="540px" onrowcommand="griddemo_RowCommand">
            <Columns>
                <asp:BoundField DataField="Name" HeaderText="Name" />
                <asp:BoundField DataField="Address" HeaderText="Address" />
                <asp:BoundField DataField="ContactNo" HeaderText="Contact No" />
                <asp:TemplateField HeaderText="Edit">
                    <ItemTemplate>
                        <a href="WebForm1.aspx?ID=<%#Eval("Id") %>">Update</a>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Delete">
                    <ItemTemplate>
                        <asp:LinkButton ID="Delete" CommandName="Delete" runat="server" OnClientClick="javascript:return ConfirmMessage();">Delete</asp:LinkButton>
                        <asp:Label runat="server" Text=`<%#Eval("Id") %>` ID="lblid"></asp:Label>
                    </ItemTemplate>

                </asp:TemplateField>
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

Now add the below code in your .cs page.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.IO;
using System.Data.OleDb;

namespace BindGridView
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        SqlConnection objcon = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.QueryString["ID"] == null)
            {
                Button1.Visible = true;
                Button2.Visible = false;
            }
            else
            {
                Button2.Visible = true;
                Button1.Visible = false;
                if (!IsPostBack)
                {
                    GetDataById(Request.QueryString["ID"].ToString());
                }
            }
            if (!IsPostBack)
            {
                BindGrid();
            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            try
            {
                string query = "Insert into student([Name],[Address],[ContactNo]) values(`" + TextBox1.Text + "`,`" + TextBox2.Text + "`,`" + TextBox3.Text + "`);SELECT @@IDENTITY as Pkvalue;";
                SqlDataAdapter objda = new SqlDataAdapter(query, objcon);
                objcon.Open();
                objda.SelectCommand.ExecuteNonQuery();
                objcon.Close();
                lblmessage.Text = "Data saved successfully.";
                BindGrid();
            }
            catch
            {
                lblmessage.Text = "Error while saving the record.";
            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            try
            {
                DataTable objdt = new DataTable();
                string query = "update student set [Name]=`" + TextBox1.Text + "`,[Address]=`" + TextBox2.Text + "`,[ContactNo]=`" + TextBox3.Text + "` where Id=" + Request.QueryString["ID"].ToString() + ";";
                SqlDataAdapter objda = new SqlDataAdapter(query, objcon);
                objcon.Open();
                objda.SelectCommand.ExecuteNonQuery();
                objcon.Close();
                lblmessage.Text = "Data updated successfully.";
                BindGrid();
            }
            catch
            {
                lblmessage.Text = "Error while saving the record.";
            }
        }
        private void GetDataById(string id)
        {
            try
            {
                DataTable objdt = new DataTable();
                string query = "select * from student where Id=`" + id + "`;";
                SqlDataAdapter objda = new SqlDataAdapter(query, objcon);
                objcon.Open();
                objda.Fill(objdt);
                objcon.Close();
                if (objdt.Rows.Count > 0)
                {
                    TextBox1.Text = objdt.Rows[0]["Name"].ToString();
                    TextBox2.Text = objdt.Rows[0]["Address"].ToString();
                    TextBox3.Text = objdt.Rows[0]["ContactNo"].ToString();
                }
            }
            catch
            {
                // lblmessage.Text = "Error while getting the record.";
            }
        }
        private void BindGrid()
        {
            try
            {
                DataTable objdt = new DataTable();
                string query = "select * from student;";
                SqlDataAdapter objda = new SqlDataAdapter(query, objcon);
                objcon.Open();
                objda.Fill(objdt);
                objcon.Close();
                if (objdt.Rows.Count > 0)
                {
                    griddemo.DataSource = objdt;
                    griddemo.DataBind();
                }
            }
            catch
            {
                lblmessage.Text = "Error while getting the record.";
            }
        }
        protected void DeleteRecord(string DeleteID)
        {
            try
            {
                DataTable objdt = new DataTable();
                string query = "delete from student where Id=`" + DeleteID + "`";
                SqlDataAdapter objda = new SqlDataAdapter(query, objcon);
                objcon.Open();
                objda.SelectCommand.ExecuteNonQuery();
                objcon.Close();
                Response.Redirect("WebForm1.aspx");
            }
            catch
            {
                lblmessage.Text = "Error while saving the record.";
            }
        }

        protected void griddemo_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName.Equals("Delete"))
            {
                GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
                Label lblid = (Label)griddemo.Rows[row.RowIndex].FindControl("lblid");
                DeleteRecord(lblid.Text);
            }
        }

    }
}

Now run the application.

manage data