Dear Team unable Search as type text in textboxDesign of Webform using master page ltdiv class34shoppingcarttable 34gt ltdiv class34tableresponsive34gt lttable class34table34gt lttheadgt lttrgt ltth class34headingtitle34gt Order History

Hi pratikshirRefer below sampleHTMLMasterPagemasterlt Master Language34C34 AutoEventWireup34true34 CodeFile34MasterPagemastercs34 Inherits34MasterPage34 gtltDOCTYPE html PUBLIC 34W3CDTD XHTML 10 TransitionalEN34 34httpwwww3orgTRxhtml1DTDxhtml1transitionaldtd34gtlthtml xmlns34httpwwww3org1999xhtml34gtlthead runat34server34gt lttitlegtlttitlegt ltscript type34textjavascript34 src34httpajaxgoogleapiscomajaxlibsjquery191jqueryminjs34gtltscriptgt ltscript type34textjavascript34 src34httpmaxcdnbootstrapcdncombootstrap332jsbootstrapminjs34gtltscriptgt ltlink rel34stylesheet34 href34httpmaxcdnbootstrapcdncombootstrap332cssbootstrapmincss34 gt ltaspContentPlaceHolder ID34head34 runat34server34gt ltaspContentPlaceHoldergtltheadgt

Filter GridView on TextBox OnTextChanged event in master page using C# in ASP.Net

pratiksh...

SOLVED CLOSED ACTIVE ANSWERED
User: pratikshir
Posted: on Oct 30, 2017 12:35 AM
Forum: Data Controls
Answer: 1
Views: 5068
Sample Code: Download

Dear Team ,

unable Search as type text in textbox

Design of Webform using master page

  <div class="shopping-cart-table ">
                        <div class="table-responsive">
                             <table class="table">
                                <thead>
                                    <tr>
                                        <th class="heading-title">
                                            Order History
                                        </th>
                                    </tr>
                                </thead>
                            <asp:Label ID="lblMaxIdForOrder" runat="server" Text=""></asp:Label>
                            <%--<asp:TextBox ID="txtSearch" runat="server" placeholder="Enter Order No. for Search"></asp:TextBox>--%>
                            <asp:TextBox ID="TextBox1" runat="server" placeholder="Enter Order No. for Search" OnTextChanged="TextBox1_OnTextChanged" AutoPostBack="true"></asp:TextBox>
                            <asp:UpdatePanel ID="UpdatePanel2" runat="server">
                                <ContentTemplate>
                                    <asp:GridView ID="GvOrderHistory" runat="server" AllowPaging="true"
                                        CssClass="Grid" AutoGenerateColumns="false" DataKeyNames="order_id" OnRowCommand="GvOrderHistory_RowCommand">
                                        <Columns>
                                            <asp:TemplateField HeaderText="Sr. No.">
                                                <ItemTemplate>
                                                    <%# Container.DataItemIndex + 1 %>
                                                </ItemTemplate>
                                            </asp:TemplateField>
                                            <asp:BoundField DataField="order_id" HeaderText="Order No." />
                                            <asp:BoundField DataField="BillingAmount" HeaderText="BillingAmount" />
                                            <asp:BoundField DataField="status" HeaderText="Order Status" />
                                            <asp:BoundField DataField="OrderDate" HeaderText="Order Date" />
                                            <asp:ButtonField CommandName="detail" ControlStyle-CssClass="btn btn-info" ButtonType="Button"
                                                Text="Detail" HeaderText="Detailed View">
                                                <ControlStyle CssClass="btn btn-info"></ControlStyle>
                                            </asp:ButtonField>
                                        </Columns>
                                    </asp:GridView>
                                </ContentTemplate>
                                <Triggers>
                                </Triggers>
                            </asp:UpdatePanel>
                            </table>
                            <!-- Trigger the modal with a button -->
                            <!-- Modal -->
                            <div id="myModal" class="modal fade" role="dialog" aria-labelledby="myModalLabel"
                                aria-hidden="true">
                                <div class="modal-dialog">
                                    <!-- Modal content-->
                                    <asp:UpdatePanel ID="UpdatePanel1" runat="server" ChildrenAsTriggers="false" UpdateMode="Conditional">
                                        <ContentTemplate>
                                            <div class="modal-content">
                                                <div class="modal-header">
                                                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">
                                                        x</button>
                                                    <h4 class="modal-title">
                                                        Modal Header</h4>
                                                </div>
                                                <asp:GridView ID="gvDialog" runat="server" AutoGenerateColumns="false" HorizontalAlign="Center"
                                                    AllowPaging="true"  DataKeyNames="order_id" CssClass="table table-bordered table-hover"
                                                   >
                                                    <Columns>
                                                        <asp:BoundField DataField="CustomerName" HeaderText="CustomerName" />
                                                        <asp:BoundField DataField="order_id" HeaderText="order_id" />
                                                        <asp:BoundField DataField="ProudctName" HeaderText="ProudctName" />
                                                        <asp:BoundField DataField="qty" HeaderText="qty" />
                                                        <asp:BoundField DataField="price" HeaderText="price" />
                                                        <asp:BoundField DataField="total" HeaderText="total" />
                                                        <asp:BoundField DataField="status" HeaderText="status" />
                                                    </Columns>
                                                </asp:GridView>
                                                <div class="modal-footer">
                                                    <button class="btn btn-default" data-dismiss="modal" aria-hidden="true">
                                                        Close</button>
                                                </div>
                                            </div>
                                        </ContentTemplate>
                                        <Triggers>
                                            <asp:AsyncPostBackTrigger ControlID="GvOrderHistory" EventName="RowCommand" />
                                            <asp:AsyncPostBackTrigger ControlID="gvDialog" EventName="PageIndexChanging" />
                                        </Triggers>
                                    </asp:UpdatePanel>
                                    <%--</table>--%>
                                </div>
                            </div>
                        </div>
                    </div>

Code Behind .CS code

 protected void TextBox1_OnTextChanged(object sender, EventArgs e)
        {
            obj_ord.order_id = TextBox1.Text;
            ds = obj_ord.SP_SearchByOrderID();
            if (ds.Tables[0].Rows.Count > 0)
            {
                GvOrderHistory.DataSource = ds;
                GvOrderHistory.DataBind();
            }
        }

In Class file

 public DataSet SP_SearchByOrderID()
        {
            DataSet ds = new DataSet();
            cmd = new SqlCommand("SP_SearchByOrderID", obj_con.Obj_ConLink);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@order_id", order_id);
            da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            return ds;
        }

Store Procedure

alter proc SP_SearchByOrderID
(
  @order_id varchar(20)  
)

as
select order_id,Sum(total) As BillingAmount, status,cast(OrderDate as date)as OrderDate from Tbl_Order
WHERE 
order_id like '%'+@order_id+'%'
group by 
order_id,status,cast(OrderDate as date)
return

exec SP_SearchByOrderID 'DMVORDER1048'

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Oct 30, 2017 01:35 AM
Report

Hi pratikshir,

Refer below sample.

HTML

MasterPage.master

<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
    <script type="text/javascript" src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/js/bootstrap.min.js"></script>
    <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css" />
    <asp:ContentPlaceHolder ID="head" runat="server">
    </asp:ContentPlaceHolder>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
        </asp:ContentPlaceHolder>
    </div>
    </form>
</body>
</html>

CS.aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="CS.aspx.cs" Inherits="CS" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <div class="shopping-cart-table ">
        <div class="table-responsive">
            <table class="table">
                <thead>
                    <tr>
                        <th class="heading-title">
                            Order History
                        </th>
                    </tr>
                </thead>
                <asp:Label ID="lblMaxIdForOrder" runat="server" Text=""></asp:Label>
                <asp:TextBox ID="TextBox1" runat="server" placeholder="Enter Order No. for Search"
                    OnTextChanged="TextBox1_OnTextChanged" AutoPostBack="true"></asp:TextBox>
                <asp:UpdatePanel ID="UpdatePanel2" runat="server">
                    <ContentTemplate>
                        <asp:GridView ID="GvOrderHistory" runat="server" AllowPaging="true" CssClass="Grid"
                            AutoGenerateColumns="false" DataKeyNames="order_id">
                            <Columns>
                                <asp:TemplateField HeaderText="Sr. No.">
                                    <ItemTemplate>
                                        <%# Container.DataItemIndex + 1 %>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:BoundField DataField="order_id" HeaderText="Order No." />
                                <asp:BoundField DataField="BillingAmount" HeaderText="BillingAmount" />
                                <asp:BoundField DataField="status" HeaderText="Order Status" />
                                <asp:BoundField DataField="OrderDate" HeaderText="Order Date" />
                                <asp:ButtonField CommandName="detail" ControlStyle-CssClass="btn btn-info" ButtonType="Button"
                                    Text="Detail" HeaderText="Detailed View">
                                    <ControlStyle CssClass="btn btn-info"></ControlStyle>
                                </asp:ButtonField>
                            </Columns>
                        </asp:GridView>
                    </ContentTemplate>
                    <Triggers>
                    </Triggers>
                </asp:UpdatePanel>
            </table>
        </div>
    </div>
</asp:Content>

protected void TextBox1_OnTextChanged(object sender, EventArgs e)
{
    string order_id = TextBox1.Text.Trim();
    DataSet ds = SP_SearchByOrderID(order_id);
    if (ds.Tables[0].Rows.Count > 0)
    {
        GvOrderHistory.DataSource = ds;
        GvOrderHistory.DataBind();
    }
}

public DataSet SP_SearchByOrderID(string searchText)
{
    DataSet ds = new DataSet();
    DataTable dt = Data().Select("order_id LIKE '%" + searchText + "%'").CopyToDataTable();
    ds.Tables.Add(dt);
    return ds;
}

public DataTable Data()
{
    DataTable dt = new DataTable();
    dt.Columns.AddRange(
        new DataColumn[4]   
        { 
            new DataColumn("order_id", typeof(string)),
            new DataColumn("BillingAmount", typeof(string)),
            new DataColumn("status",typeof(string)),
            new DataColumn("OrderDate",typeof(DateTime))                                
        });
    dt.Rows.Add("101", "500", "Ok", "10/30/2017");
    dt.Rows.Add("102", "600", "Ok", "10/29/2017");
    dt.Rows.Add("103", "700", "Defective", "10/28/2017");
    dt.Rows.Add("104", "800", "Ok", "10/27/2017");
    return dt;
}

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Filter GridView on TextBox OnTextChanged event in master page using C# in ASP.Net

Company

Explore

Follow us

Contact Us