How to create Search in ASP.NET

-

Introduction
The seach is important in the web site. When you are create a new website you have to implement in the search  features as well. So in this article I will explain how to search record from database using  gridview.
Implementation
Create page named search.aspx . Palce a textbox.linkbutton,label,gridview at  this page. You can see it in the HTML code.here I’m using templatefields for bimd the gridview.

HTML  code for search.aspx page

<body>
    <form id="form1" runat="server">
     <div>
   
        <table class="style1">
            <tr>
                <td class="style3">
                                        Search Employee:                </td>
                <td class="style2">
                    &nbsp;<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                    &nbsp;</td>
                <td>
                    <asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click">Go</asp:LinkButton>
                </td>
            </tr>
            <tr>
                <td class="style3">
                                                                                                <h3>
                                    <i><b                                    <span class="style4">The Detail Of Employee&nbsp;</span></b></i></h3>
                            </td>
                <td class="style2">
                   
                    <asp:Label ID="Label1" runat="server"></asp:Label>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style3">
                                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
                                    BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
                                    CellPadding="3" CellSpacing="2" Height="90px" Width="260px">
                                    <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
                                    <Columns>
                                        <asp:TemplateField HeaderText="Name">
                                         <ItemTemplate>
                                          <%#Eval("ename") %>
                                          </ItemTemplate>
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="Address">
                                         <ItemTemplate>
                                        <%#Eval("eadd") %>
                                        </ItemTemplate>
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="Email">
                                        <ItemTemplate>
                                          <%#Eval("email") %>
                                          </ItemTemplate>
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="username">
                                        <ItemTemplate>
                                          <%#Eval("uname") %>
                                          </ItemTemplate>
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="Password">
                                        <ItemTemplate>
                                          <%#Eval("pwd") %>
                                          </ItemTemplate>
                                        </asp:TemplateField>
                                      
                                    </Columns>
                                    <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
                                    <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
                                    <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
                                    <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
                                </asp:GridView>
                                <h5>
                                    &nbsp;</h5>
                            </td>
                <td class="style2">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
        </table>
   
    </div>
    </form>
</body>
 
C# code for search.aspx page
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class search : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection();
    string b = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        con.ConnectionString = ConfigurationManager.ConnectionStrings["cn"].ConnectionString;
        if (con.State == ConnectionState.Closed)
        {
            con.Open();
        }
    }

    private void user_chk()
    {
        string a;
        a = TextBox1.Text;
        // SqlConnection con = new SqlConnection();

        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "select ename  from tbemp where ename like'" + a + "%'";

        cmd.Connection = con;

        SqlDataReader dr;
        dr = cmd.ExecuteReader();
        if (dr.HasRows)
        {
            dr.Read();
            rep_bind();
            GridView1.Visible = true;

            TextBox1.Text = "";
            Label1.Text = "";
        }
        else
        {

            GridView1.Visible = false;
            b = TextBox1.Text + " &nbsp;Is Not Available in the List.";
            Label1.Text = b;
            TextBox1.Text = "";
        }



    }
    private void rep_bind()
    {
        string a;
        a = TextBox1.Text;
        SqlDataAdapter adp = new SqlDataAdapter("select * from tbemp where ename like'" + a + "%'", ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
        DataSet ds = new DataSet();
        adp.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();

    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
       // here i'm calling function named    user_chk() at this button click
        user_chk();
    }
}
Conclusion
Through this article, you have learned how we can create search using gridview.

Database Script

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbemp]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[tbemp](
      [id] [int] IDENTITY(1,1) NOT NULL,
      [ename] [varchar](100) NULL,
      [eadd] [varchar](500) NULL,
      [email] [varchar](100) NULL,
      [uname] [varchar](50) NULL,
      [pwd] [varchar](50) NULL,
 CONSTRAINT [PK_tbemp] PRIMARY KEY CLUSTERED
(
      [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
END

Output of the program






Comments

Post a Comment

Popular posts from this blog

Sending reset password link for one time use only in asp.net

-
Introduction: Hello developers, in this article i will explain that how we can create and send reset password link that will use onle one time in asp.net,after one time use this link will dispose and say that this link is wrong. This is very helpful article for every .net developer Implementation: Create two pages named forgetpassword.aspx and reset.aspx. Paste the code that below am giving, separately inside the both pages. This is a sample program you can change it accoring to your requirement. Inside your table there will be a colimn named code is necessary. Code for forgetpassword.aspx page: < head runat ="server">     < title > Forget Password </ title >     < style type ="text/css">         .style1         {             width : 100% ;  ...
Read more

add delete update inside gridview using store procedure in ASP.NET

-
Image
Introduction: Hello friends, in this article i will explain that how we can insert,delete,update the data in the gridview. Here i am using the store procedure to insert,delete and update the record. With the help of the store procedure the execution of the sql  query make fast. And less  the code of the aspx.cs page. So we can say  the use of the store procedure in the sql server is very important and also very helpful. Implementation: create a new website abb a page named gallery.aspx. Drag and drop the two textboxes, a fileuploader and a button from the toolbox named txt_album_name, txt_caption, fileuploader1 and btn_insert respectively. Here i am giving the complete code for the html page.  Code for .aspx page: < table class ="style1">         < tr >             < td class ="style2">      ...
Read more

Change password using asp.net

-
Image
Introduction : Hello friends, in this article i will explain that how we can change the password after login, in asp.net.This article is very useful for the all the .net developer. Implementation : create a new website add a page. Drag and drop three textboxes and two buttons   from the toolbox inside the   < body > body tag at the .aspx page.   Below   i am giving the complete code for the html page and .cs page.  Code for default.aspx page < div >     < table style =" width : 91% ; height : 97px ; " class ="tbl_reg_form">         < tr >             < td >                 Old Password </ td >             < td >        ...
Read more