Hi dears,
How can i edit,update,delete and filters in asp.net gridview like excel worksheet, please guide me how to interlink with c# code
<asp:UpdatePanel ID="upnlOutstanding" runat="server" ChildrenAsTriggers="true" UpdateMode="Conditional">
<ContentTemplate>
<h4>
Outstanding Orders</h4>
<br />
<asp:LinkButton ID="lbRemoveFilterOutstanding" runat="server" Text="Remove Filter"
OnClick="lbRemoveFilterOutstanding_Click"></asp:LinkButton>
<asp:GridView ID="grdViewOutstanding" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#999999" BorderStyle="Solid" CellPadding="5" ForeColor="Black"
GridLines="Both" AllowPaging="True" CellSpacing="1" EmptyDataText="No outstanding orders found"
CssClass="Grid" PageSize="10" AllowSorting="true" OnPageIndexChanging="grdViewOutstanding_PageIndexChanging"
OnRowDataBound="grdViewOutstanding_RowDataBound" OnSorting="grdViewOutstanding_Sorting">
<FooterStyle BackColor="#CCCCCC" />
<Columns>
<asp:TemplateField SortExpression="Item">
<HeaderTemplate>
<asp:LinkButton ID="lbItem" runat="server" Text="Item" CommandName="Sort" CommandArgument="Item"></asp:LinkButton>
<br />
<asp:TextBox runat="server" ID="txtItem" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"></asp:TextBox>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Item") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="Order">
<HeaderTemplate>
<asp:LinkButton ID="lbOrder" runat="server" Text="Order" CommandName="Sort" CommandArgument="Order"></asp:LinkButton>
<br />
<asp:TextBox runat="server" ID="txtOrder" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"></asp:TextBox>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Order") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="Line" ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Right">
<HeaderTemplate>
<asp:LinkButton ID="lbLine" runat="server" Text="Line" CommandName="Sort" CommandArgument="Line"
CssClass="RightAlign"></asp:LinkButton>
<br />
<table>
<tr>
<td>
<asp:DropDownList runat="server" ID="ddlFilterTypeLine" CssClass="upperCaseText">
<asp:ListItem Text="=" Value="=" Selected="True"></asp:ListItem>
<asp:ListItem Text=">" Value=">"></asp:ListItem>
<asp:ListItem Text=">=" Value=">="></asp:ListItem>
<asp:ListItem Text="<" Value="<"></asp:ListItem>
<asp:ListItem Text="<=" Value="<="></asp:ListItem>
</asp:DropDownList>
</td>
<td>
<asp:TextBox runat="server" ID="txtLine" Width="50" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"
CssClass="upperCaseText"></asp:TextBox>
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Line","{0:0}")%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="Status" ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Right">
<HeaderTemplate>
<asp:LinkButton ID="lbStatus" runat="server" Text="Status" CommandName="Sort" CommandArgument="Status"
CssClass="RightAlign"></asp:LinkButton>
<br />
<table>
<tr>
<td>
<asp:DropDownList runat="server" ID="ddlFilterTypeStatus" CssClass="upperCaseText">
<asp:ListItem Text="=" Value="=" Selected="True"></asp:ListItem>
<asp:ListItem Text=">" Value=">"></asp:ListItem>
<asp:ListItem Text=">=" Value=">="></asp:ListItem>
<asp:ListItem Text="<" Value="<"></asp:ListItem>
<asp:ListItem Text="<=" Value="<="></asp:ListItem>
</asp:DropDownList>
</td>
<td>
<asp:TextBox runat="server" ID="txtStatus" Width="50" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"
CssClass="upperCaseText"></asp:TextBox>
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Status","{0:0}")%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="ToLocation">
<HeaderTemplate>
<asp:LinkButton ID="lbToLocation" runat="server" Text="ToLocation" CommandName="Sort"
CommandArgument="ToLocation"></asp:LinkButton>
<br />
<asp:TextBox runat="server" ID="txtToLocation" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"></asp:TextBox>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("ToLocation") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="Qty" ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Right">
<HeaderTemplate>
<asp:LinkButton ID="lbQty" runat="server" Text="Qty" CommandName="Sort" CommandArgument="Qty"
CssClass="RightAlign"></asp:LinkButton>
<br />
<table>
<tr>
<td>
<asp:DropDownList runat="server" ID="ddlFilterTypeQty" CssClass="upperCaseText">
<asp:ListItem Text="=" Value="=" Selected="True"></asp:ListItem>
<asp:ListItem Text=">" Value=">"></asp:ListItem>
<asp:ListItem Text=">=" Value=">="></asp:ListItem>
<asp:ListItem Text="<" Value="<"></asp:ListItem>
<asp:ListItem Text="<=" Value="<="></asp:ListItem>
</asp:DropDownList>
</td>
<td>
<asp:TextBox runat="server" ID="txtQty" Width="50" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"
CssClass="upperCaseText"></asp:TextBox>
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Qty","{0:0}")%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="RegDate" ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Right">
<HeaderTemplate>
<asp:LinkButton ID="lbRegDate" runat="server" Text="RegDate" CommandName="Sort" CommandArgument="RegDate"
CssClass="RightAlign"></asp:LinkButton>
<br />
<table>
<tr>
<td>
<asp:DropDownList runat="server" ID="ddlFilterTypeRegDate" CssClass="upperCaseText">
<asp:ListItem Text="=" Value="=" Selected="True"></asp:ListItem>
<asp:ListItem Text=">" Value=">"></asp:ListItem>
<asp:ListItem Text=">=" Value=">="></asp:ListItem>
<asp:ListItem Text="<" Value="<"></asp:ListItem>
<asp:ListItem Text="<=" Value="<="></asp:ListItem>
</asp:DropDownList>
</td>
<td>
<asp:TextBox runat="server" ID="txtRegDate" Width="80" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"
CssClass="upperCaseText"></asp:TextBox>
<ajaxToolkit:CalendarExtender runat="server" ID="calExtender" TargetControlID="txtRegDate"
Format="dd/MM/yyyy">
</ajaxToolkit:CalendarExtender>
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("RegDate","{0:dd/MM/yyyy}")%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="Location">
<HeaderTemplate>
<asp:LinkButton ID="lbLocation" runat="server" Text="Location" CommandName="Sort"
CommandArgument="Location"></asp:LinkButton>
<br />
<asp:TextBox runat="server" ID="txtLocation" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"></asp:TextBox>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("Location") %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="AllocQty" ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Right">
<HeaderTemplate>
<asp:LinkButton ID="lbAllocQty" runat="server" Text="AllocQty" CommandName="Sort"
CommandArgument="AllocQty" CssClass="RightAlign"></asp:LinkButton>
<br />
<table>
<tr>
<td>
<asp:DropDownList runat="server" ID="ddlFilterTypeAllocQty" CssClass="upperCaseText">
<asp:ListItem Text="=" Value="=" Selected="True"></asp:ListItem>
<asp:ListItem Text=">" Value=">"></asp:ListItem>
<asp:ListItem Text=">=" Value=">="></asp:ListItem>
<asp:ListItem Text="<" Value="<"></asp:ListItem>
<asp:ListItem Text="<=" Value="<="></asp:ListItem>
</asp:DropDownList>
</td>
<td>
<asp:TextBox runat="server" ID="txtAllocQty" Width="50" AutoPostBack="true" OnTextChanged="txtItem_TextChanged"
CssClass="upperCaseText"></asp:TextBox>
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<%#Eval("AllocQty","{0:0}")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerStyle HorizontalAlign="Center" CssClass="pgr" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<%--<HeaderStyle Font-Bold="True" ForeColor="Black" Font-Size="10"/>--%>
<%-- <AlternatingRowStyle BackColor="#CCCCCC" />--%>
</asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>
