How to Delete Data from Database Using ASP.NET

-






This is the Source Code

ShowData.aspx

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Show Data</title>
    <link href="Content/bootstrap.min.css" rel="stylesheet" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h4>Student's Table Data</h4>
        <hr />
        <asp:Table ID="Table1" runat="server" CssClass="table table-bordered">
            <asp:TableHeaderRow>
                <asp:TableHeaderCell>ID:</asp:TableHeaderCell>
                <asp:TableHeaderCell>Name:</asp:TableHeaderCell>
                <asp:TableHeaderCell>City:</asp:TableHeaderCell>
                <asp:TableHeaderCell>Options</asp:TableHeaderCell>
            </asp:TableHeaderRow>

        </asp:Table>
    </div>
    </form>
</body>
</html>

Show Data

Student's Table Data

ID: Name: City: Options


Show Data

Student's Table Data

ID: Name: City: Options

ShowData.aspx.cs

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

namespace MyFirstProgram
{
    public partial class ShowData : System.Web.UI.Page
    {
        string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(cs);

            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "Select * from student";
            cmd.Connection = con;

            con.Open();

            SqlDataReader rd = cmd.ExecuteReader();

            while(rd.Read())
            {
                TableRow tr = new TableRow();

                TableCell id = new TableCell();
                TableCell name = new TableCell();
                TableCell city = new TableCell();
                TableCell opt = new TableCell();

                id.Text = rd[0].ToString();
                name.Text = rd[1].ToString();
                city.Text = rd[2].ToString();
                opt.Text = "<a href='Edit.aspx?id="+rd[0]+"' class='btn btn-primary'>Edit</a>";
                opt.Text +="  " +"<a href='delete.aspx?id=" + rd[0] + "' class='btn btn-danger'>Delete</a>";

                tr.Cells.Add(id);
                tr.Cells.Add(name);
                tr.Cells.Add(city);
                tr.Cells.Add(opt);

                Table1.Rows.Add(tr);
            }
            con.Close();
        }
    }
}

 Delete.aspx.cs

namespace MyFirstProgram
{
    public partial class Delete : System.Web.UI.Page
    {
        string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(cs);
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "delete from student where id=@id";
            cmd.Connection = con;

            con.Open();

            cmd.Parameters.AddWithValue("@id", Request.QueryString["id"]);

            if(cmd.ExecuteNonQuery() > 0)
            {
                Response.Redirect("ShowData.aspx");
            }
            else
            {
                Response.Write("Data not Deleted");
            }



        }
    }
} 

Comments

Post a Comment