How to delete row from gridview in asp.net with c# with database

Deleted event in SqlDataSource for deleting records.

aspx:


<%@ Page Language="C#" AutoEventWireup="true" %>
<%@ Import Namespace="System.Drawing" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
    void SqlDataSource1_Deleted(object sender, SqlDataSourceStatusEventArgs e)
    {
        if (e.Exception == null)
        {
            if (e.AffectedRows == 1)
            {
                Label1.Text = "One Record deleted successfully!";
                Label1.ForeColor = Color.Green;
            }
            else
            {
                Label1.Text = "An error occured!";
                Label1.ForeColor = Color.Red;
            }
        }
        else
        {
            Label1.Text = "Error Details: " + e.Exception.Message;
        }
    }
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>How to use OnDeleted event in SqlDataSource for deleting records</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h2 style="color:Navy; font-style:italic;">SqlDataSource Example: Using OnDeleted Events</h2>
        <!-- Remove relation between Products and OrderDetails tables for test this example -->
        <asp:SqlDataSource 
            ID="SqlDataSource1"
            runat="server"
            ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            SelectCommand="Select ProductID, ProductName, QuantityPerUnit, UnitPrice From products"
            SelectCommandType="Text"
            DeleteCommand="Delete From Products Where ProductID=@original_ProductID"
            OldValuesParameterFormatString="original_{0}"
            OnDeleted="SqlDataSource1_Deleted"
            >
            <SelectParameters>
                <asp:Parameter Direction="Output" Name="Count" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:Label 
            ID="Label1" 
            runat="server"
            Font-Bold="true"
            Font-Italic="true"
            Font-Size="Large"
            ForeColor="SeaGreen"
            >
        </asp:Label>
        <br /><br />
        <asp:GridView 
            ID="GridView1"
            runat="server"
            DataSourceID="SqlDataSource1"
            AutoGenerateColumns="false"
            DataKeyNames="ProductID"
            AllowPaging="true"
            PageSize="8"
            BorderColor="Salmon"
            AutoGenerateDeleteButton="true"
            Font-Names="Comic Sans MS"
            Width="850"
            >
            <HeaderStyle BackColor="Crimson" ForeColor="Snow" Height="45"/>
            <RowStyle BackColor="OrangeRed" ForeColor="Snow" Font-Italic="true" />
            <PagerStyle 
                Height="45" 
                HorizontalAlign="Right" 
                BackColor="BurlyWood"
                Font-Bold="true"
                Font-Size="X-Large"
                ForeColor="Snow"
                />
            <PagerSettings Mode="Numeric" />
            <Columns>
                <asp:BoundField HeaderText="Product ID" DataField="ProductID" />
                <asp:BoundField HeaderText="Product Name" DataField="ProductName" />
                <asp:BoundField HeaderText="Quantity Per Unit" DataField="QuantityPerUnit" />
                <asp:BoundField HeaderText="Unit Price" DataField="UnitPrice"/>
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

<%@ Page Language="C#" AutoEventWireup="true" %>

<%@ Import Namespace="System.Drawing" %>

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

void SqlDataSource1_Deleted(object sender, SqlDataSourceStatusEventArgs e)

{

if (e.Exception == null)

{

if (e.AffectedRows == 1)

{

Label1.Text = "One Record deleted successfully!";

Label1.ForeColor = Color.Green;

}

else

{

Label1.Text = "An error occured!";

Label1.ForeColor = Color.Red;

}

else

{

Label1.Text = "Error Details: " + e.Exception.Message;

}

</script>

<title>How to use OnDeleted event in SqlDataSource for deleting records</title>

</head>

<body>

<div>

<h2 style="color:Navy; font-style:italic;">SqlDataSource Example: Using OnDeleted Events</h2>

<asp:SqlDataSource

ID="SqlDataSource1"

runat="server"

ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"

SelectCommand="Select ProductID, ProductName, QuantityPerUnit, UnitPrice From products"

SelectCommandType="Text"

DeleteCommand="Delete From Products Where ProductID=@original_ProductID"

OldValuesParameterFormatString="original_{0}"

OnDeleted="SqlDataSource1_Deleted"

<asp:Parameter Direction="Output" Name="Count" Type="Int32" />

</SelectParameters>

</asp:SqlDataSource>

<asp:Label

ID="Label1"

runat="server"

Font-Bold="true"

Font-Italic="true"

Font-Size="Large"

ForeColor="SeaGreen"

</asp:Label>

<asp:GridView

ID="GridView1"

runat="server"

DataSourceID="SqlDataSource1"

AutoGenerateColumns="false"

DataKeyNames="ProductID"

AllowPaging="true"

PageSize="8"

BorderColor="Salmon"

AutoGenerateDeleteButton="true"

Font-Names="Comic Sans MS"

Width="850"

<PagerStyle

Height="45"

HorizontalAlign="Right"

BackColor="BurlyWood"

Font-Bold="true"

Font-Size="X-Large"

ForeColor="Snow"

<asp:BoundField HeaderText="Product ID" DataField="ProductID" />

<asp:BoundField HeaderText="Product Name" DataField="ProductName" />

<asp:BoundField HeaderText="Quantity Per Unit" DataField="QuantityPerUnit" />

<asp:BoundField HeaderText="Unit Price" DataField="UnitPrice"/>

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

Output:

How to delete row from gridview in asp.net with c# with database2 min read

Leave a Comment X

You may also like

Leave a Comment X