Click here to Skip to main content
15,893,564 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Search GridView records (data) on TextBox KeyPress using ..
-----------------------------------------------------------
sourse code is
----------------
XML
<%@ 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', ''); //open the current window
    window.close(url);
 }
                }
            });
        });
    });
</script>

 <script type="text/javascript">
     function CheckNumeric(e) {

         if (window.event) // IE
         {
             if ((e.keyCode < 48 || e.keyCode > 57) & e.keyCode != 8 ) {
                 event.returnValue = false;
                 alert('Please Enter Numbers');
                 return false;

             }
         }
         else { // Fire Fox
             if ((e.which < 48 || e.which > 57) & e.which != 8) {
                 e.preventDefault();
                 alert('Please Enter Numbers');
                 return false;

             }
         }
     }
     </script>



<div class="div">
        Leave Types&nbsp;&nbsp;&nbsp;&nbsp;
        <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:&nbsp;&nbsp;"></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:&nbsp;&nbsp;"></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:&nbsp;&nbsp;"></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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 <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>&nbsp;&nbsp;&nbsp;
                </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);
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900