Search GridView records (data) on TextBox KeyPress using ..
-----------------------------------------------------------
sourse code is
----------------
<%@ Page Language="C#" MasterPageFile="~/Main.Master" AutoEventWireup="true" CodeBehind="LeaveTypes.aspx.cs" Inherits="vpayroll.LeaveTypes" Title="Untitled Page" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" ></script>
<script type="text/javascript">
function close_window(url){
var newWindow = window.open('', '_self', '');
window.close(url);
}
}
});
});
});
</script>
<script type="text/javascript">
function CheckNumeric(e) {
if (window.event)
{
if ((e.keyCode < 48 || e.keyCode > 57) & e.keyCode != 8 ) {
event.returnValue = false;
alert('Please Enter Numbers');
return false;
}
}
else {
if ((e.which < 48 || e.which > 57) & e.which != 8) {
e.preventDefault();
alert('Please Enter Numbers');
return false;
}
}
}
</script>
<div class="div">
Leave Types
<span style="color: #FFFFFF; font-style: normal; font-weight: normal">Search:</span>
<asp:DropDownList ID="Srch_Type" runat="server" Width="9%" />
<asp:TextBox ID="Srch_Text" runat="server" Width="7%"></asp:TextBox>
<asp:ImageButton ID="Srch_Btn" runat="server" ImageAlign="Baseline" ImageUrl="Images/Search_Icon_16x16.png" />
<div style="vertical-align: middle; float: right; text-align: right;">
<asp:ImageButton ID="btnNew" runat="server" ImageUrl="~/Images/Add.png" Width="7%"
Height="16px" onclick="btnNew_Click" />
<asp:LinkButton ID="lkbSave" runat="server" Font-Bold="True" Text="New Leave Type"
Font-Underline="False" ForeColor="White" CssClass="LinkButton" onclick="lkbSave_Click">
</asp:LinkButton>
</div>
</div>
<div>
<asp:GridView ID="gvLeaveTypes" runat="server" AllowPaging="true"
AllowSorting="true" AutoGenerateColumns="False" ForeColor="#333333" Width="100%"
Height="50%" onrowediting="gvLeaveTypes_RowEditing"
PageSize="10" CellPadding="4" CellSpacing="3" GridLines="None" onrowdeleting="gvLeaveTypes_RowDeleting"
onpageindexchanging="gvLeaveTypes_PageIndexChanging" OnDataBound="gvLeaveTypes_DataBound" >
<Columns>
<asp:TemplateField HeaderText="LeaveCode" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<ItemTemplate>
<asp:Label ID="lblLeaveCode" runat="server" Text='<%#Eval("lv_type_code") %>'></asp:Label>
<asp:Label ID="lbllv_type_id" runat="server" Text='<%#Eval("lv_type_id") %>' Visible="false"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText ="Leave Type" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<ItemTemplate>
<asp:Label ID="lblLeaveType" runat="server" Text='<%#Eval("lv_type_name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Days" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" >
<ItemTemplate>
<asp:Label ID="lblDays" runat="server" Text='<%#Eval("lv_type_days") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/Edit.png"
ToolTip="Edit" Height="25px" Width="25px" CommandArgument='<%#Eval("lv_type_id") %>' />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Delete" runat="server"
ImageUrl="~/Images/Delete.png" ToolTip="Delete" Height="25px" Width="25px" CommandArgument='<%#Eval("lv_type_id") %>' OnClientClick="return ConfirmOnDelete('');"/>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="Aqua" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#ff99ff" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</div>
<div>
</div>
<asp:ModalPopupExtender ID="mdpLeaveTypes" runat="server" TargetControlID="hdnLeaveTypes"
PopupControlID="pnlLeaveTypes" BackgroundCssClass="modalBackground">
</asp:ModalPopupExtender>
<asp:HiddenField runat="server" ID="hdnLeaveTypes" />
<asp:Panel ID="pnlLeaveTypes" runat="server" Height="28%" Width="31%" CssClass="PopupPanel">
<div class="divPopUp" style="height:11%">
LeaveTypes<asp:ImageButton ImageUrl="~/Images/close.png" runat="server" Height="15px" Width="3%" ImageAlign="Right"
ID="btnClose" OnClick="btnClose_Click" />
</div>
<div align="center">
<table style="margin-left:1%; margin-top:6%">
<tr>
<td align="right">
<asp:Label ID="lblCode" runat="server" Text="Code: "></asp:Label>
</td>
<td align="left" >
<asp:TextBox ID="txtCode" runat="server" Width="300px" ValidationGroup="vchk" ></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtCode" ErrorMessage="*"
ValidationGroup="vchk"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="lblLeaveType" runat="server" Text="Leave Type: "></asp:Label>
</td>
<td align="left" >
<asp:TextBox ID="txtLeaveType" runat="server" Width="300px" ValidationGroup="vchk" ></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtLeaveType" ErrorMessage="*"
ValidationGroup="vchk"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right">
<asp:Label ID="lblNoOfDays" runat="server" Text="No.Of Days: "></asp:Label>
</td>
<td align="left" >
<asp:TextBox ID="txtNoOfDays" runat="server" Width="300px" ValidationGroup="vchk"
onkeypress="CheckNumeric(event);" ></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="txtNoOfDays" ErrorMessage="*"
ValidationGroup="vchk"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td colspan="2" align="right">
<asp:Button ID="btnSave" runat="server" CssClass="button" Text="Save"
Height="24px" Width="55px" OnClick="btnSave_Click" ValidationGroup="vchk"></asp:Button>
<asp:Button ID="btnCancel" runat="server" CssClass="button" Text="Cancel"
Height="24px" Width="55px" onclick="btnCancel_Click"></asp:Button>
</td>
</tr>
</table>
</div>
</asp:Panel>
</asp:Content>
-----------------------------------------------------------------------------------------------------
protected void gvLeaveTypes_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
int index = e.NewEditIndex;
Label lblLeaveCode = (Label)gvLeaveTypes.Rows[index].FindControl("lblLeaveCode");
Label lbllv_type_id = (Label)gvLeaveTypes.Rows[index].FindControl("lbllv_type_id");
Label lblLeaveType = (Label)gvLeaveTypes.Rows[index].FindControl("lblLeaveType");
Label lblDays = (Label)gvLeaveTypes.Rows[index].FindControl("lblDays");
mdpLeaveTypes.Show();
txtCode.Text = lblLeaveCode.Text;
txtLeaveType.Text = lblLeaveType.Text;
txtNoOfDays.Text = lblDays.Text;
btnSave.Text = "Update";
Session["lv_type_id"] = lbllv_type_id.Text;
}
catch (Exception ex) { }
}
-----------------------------------------------------------------------------------------------------------------
protected void gvLeaveTypes_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = e.RowIndex;
Label lbllv_type_id = (Label)gvLeaveTypes.Rows[index].FindControl("lbllv_type_id");
Label lblLeaveCode = (Label)gvLeaveTypes.Rows[index].FindControl("lbllv_type_id");
BBEL.lv_type_id = Convert.ToInt32(lbllv_type_id.Text);
BBEL.comp_id = Convert.ToInt16(Session["comp_id"]);
if (BBLL.DeleteLeaveTypes(BBEL) == true)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "LeaveTypes", "alert('LeaveTypes details deleted successfully');", true);
}
GridFill();
}
--------------------------------------------------------------------------------------------------------------------
protected void gvLeaveTypes_DataBound(object sender, EventArgs e)
{
GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
for (int i = 0; i < gvLeaveTypes.Columns.Count - 2; i++)
{
TableHeaderCell cell = new TableHeaderCell();
TextBox txtSearch = new TextBox();
txtSearch.Attributes["placeholder"] = gvLeaveTypes.Columns[i].HeaderText;
txtSearch.CssClass = "search_textbox";
cell.Controls.Add(txtSearch);
row.Controls.Add(cell);
}
gvLeaveTypes.HeaderRow.Parent.Controls.AddAt(1, row);