Friday, April 18, 2014

Like linq query example and bind gridview

Introduction: In this article today I will explain Like linq query example and bind gridview.

Like linq query

Description:


I have a table Product:
ID
int
PRODUCT_NAME
varchar(50)
DESCRIPTION
varchar(50)
PRODUCT_PRICE
int

I want to search products on product name and display the matched results in gridview.
Add a new webform to project and design the .aspx page as shown:

<fieldset style="width:420px">
    <legend>Like with Linq query Example</legend>
    <table width="100%">
    <tr><td>Enter Product Name:</td><td><asp:TextBox ID="txtsearch" runat="server"></asp:TextBox></td></tr>
    <tr><td></td><td><asp:Button ID="btnserach" runat="server" onclick="btnserach_Click" Text="Button" /></td></tr>
    <tr><td></td>
    <table>
    <tr> 
        <asp:GridView ID="GridView1" runat="server" EmptyDataText="No records Found"
            ShowHeaderWhenEmpty="True" AutoGenerateColumns="False" CellPadding="4"
            ForeColor="#333333" GridLines="None" Width="408px">
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <Columns>
                <asp:BoundField DataField="PRODUCT_NAME" HeaderText="Product Name" />
                 <asp:BoundField DataField="DESCRIPTION" HeaderText="Description" />
                <asp:BoundField DataField="PRODUCT_PRICE" HeaderText="Price" />
            </Columns>
            <EditRowStyle BackColor="#999999" />
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#E9E7E2" />
            <SortedAscendingHeaderStyle BackColor="#506C8C" />
            <SortedDescendingCellStyle BackColor="#FFFDF8" />
            <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
        </asp:GridView></tr>
    </table></tr>
    </table>
        </fieldset>

On button click write the given code on .aspx.cs page:
DataClasses1DataContext db = new DataClasses1DataContext();

protected void btnserach_Click(object sender, EventArgs e)
        {
            var product = from p in db.PRODUCTs
                          where p.PRODUCT_NAME.Contains(txtsearch.Text.Trim())
                          select p;
            GridView1.DataSource = product;
            GridView1.DataBind();
        }

OR

using System.Data.Linq.SqlClient;

protected void btnserach_Click(object sender, EventArgs e)
        {
            var product = from p in db.PRODUCTs
                          where SqlMethods.Like(p.PRODUCT_NAME, "%" + txtsearch.Text + "%")
                          select p;
            GridView1.DataSource = product;
            GridView1.DataBind();

        }

Build the project and run.

Is this article helpful for you?

If yes post your comment to appreciate my work and fell free to contact me. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.

No comments:

Post a Comment