Mega Code Archive
Deletion using SqlDataSource Control
<![CDATA[
<%@ Page Language="C#" %>
<script runat="server">
void deptSource_Deleted(object sender,SqlDataSourceStatusEventArgs e)
{
if (e.Exception == null)
{
if (e.AffectedRows == 1)
{
lblResult.Text = "Record deleted successfully.";
}
else
{
lblResult.Text = "An error occurred during the delete operation.";
}
}
else
{
lblResult.Text = "An error occurred while attempting to delete the row." + e.Exception.Message;
e.ExceptionHandled = true;
}
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Deletion using SqlDataSource Control</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="deptSource" runat="server"
ProviderName="System.Data.SqlClient"
ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"
SelectCommand="Select DepartmentID, Name, GroupName, ModifiedDate from HumanResources.Department"
DeleteCommand="Delete from HumanResources.Department Where DepartmentID=@original_DepartmentID"
OldValuesParameterFormatString="original_{0}" OnDeleted="deptSource_Deleted">
<DeleteParameters>
<asp:Parameter Type="Int32" Name="DepartmentID"></asp:Parameter>
</DeleteParameters>
</asp:SqlDataSource>
<asp:GridView ID="deptView"
AutoGenerateColumns="False"
runat="server"
DataSourceID="deptSource"
HeaderStyle-HorizontalAlign="Center"
HeaderStyle-Font-Bold="True"
HeaderStyle-BackColor="blue"
HeaderStyle-ForeColor="White"
DataKeyNames="DepartmentID">
<Columns>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:Button ID="btnDelete" Text="Delete" runat="server"
OnClientClick="return confirm('Are you sure you want to delete this record?');"
CommandName="Delete" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="DepartmentID" DataField="DepartmentID" />
<asp:BoundField HeaderText="Department Name" DataField="Name" />
<asp:BoundField HeaderText="Group Name" DataField="GroupName" />
<asp:BoundField HeaderText="Last Modified Date" DataField="ModifiedDate" />
</Columns>
</asp:GridView>
<asp:Label ID="lblResult" runat="server" ForeColor="DarkRed"/>
</div>
</form>
</body>
</html>
]]>