How to delete Gridview row?

Hi Sharmanuj, As I have used gridview to display datas.In that i m using Dropdownlist. I want answer when I select dropdownlist, I want to delete the whoole row. For eg: In dropdownlist I m using Poor and Good. when i select poor, the row itself should be deleted.

This is the code m using Please say me in coding....


<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="username"
DataSourceID="SqlDataSource1" onrowcommand="GridView1_RowCommand">
<columns> <asp:TemplateField HeaderText="Username" SortExpression="username">
<edititemtemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("username") %>'>

<itemtemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("username") %>'>


<asp:TemplateField HeaderText="Status" SortExpression="status">
<edititemtemplate>
<asp:DropDownList ID="DropDownlist1" runat="server" Text='<%# Bind("status") %>'>
<asp:ListItem>Active
<asp:ListItem>Inactive


<itemtemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("status") %>'>


<asp:TemplateField HeaderText="Operations">
<edititemtemplate>
<asp:LinkButton ID="LinkButton1" runat="server"
CommandName="Update" Text="Update">
 <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False"
CommandName="Cancel" Text="Cancel">

<itemtemplate>

<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"
CommandName="Edit" Text="Edit">
<span önclick="return confirm('Are you sure to Delete this record)')">
 <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False"
CommandName="Delete" Text="Delete">

</span>



<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SUJAYConnectionString %>"
DeleteCommand="DELETE FROM [admin] WHERE [username] = @username "
InsertCommand="INSERT INTO [admin] ([username], [status]) VALUES (@username, @status)"
SelectCommand="SELECT [username], [status] FROM [admin]"
UpdateCommand="UPDATE [admin] SET [status] = @status WHERE [username] = @username">
<deleteparameters>
<asp:Parameter Name="username" Type="String" />

<insertparameters>
<asp:Parameter Name="username" Type="String" />
<asp:Parameter Name="status" Type="String" />

<updateparameters>
<asp:Parameter Name="status" Type="String" />
<asp:Parameter Name="username" Type="String" />