Searching Records From a DataBase and Displaying In a Gridview Using ASP.Net C#

Download Files:

• SearchRecords.zip

 

Background

There is often a need to search the records in a database for those that satisfy a specific condition and display them in a GridView. So in consideration of that requirement I decided to write this article. So let us proceed toward that with step-by-step instructions.

Now before creating the application, let us create a table named emp in a database to store the records in a database table having the fields shown in the following image:
 

In the preceding table I have created four columns, they are id for the unique identity, Name for the emp name, address for emp address and email to store the email address of the emp.

Now insert some records into the table as you wish, such as:

insert into emp values ('vithal','Navi Mumbai','abc@gmail.com') 
insert into emp  values  ('Shivanand','Mumbai','xyz@yahoo.com')
insert into emp  values  ('Shivanand','Mumbai','xyz@yahoo.com')
insert into emp  values   ('Sudhir','Latur','ac12@gmail.com.com')
I hope you have created the same type of table.

Now let us start to create an application to search the records, step-by-step.

Now create the project  as:

1. "Start" - "All Programs" - "Microsoft Visual Studio 2010".
2. "File" -> "New" -> "Project..." -> "C#" -> "Empty Project" (to avoid adding a master page).
3. Give the project a name, such as "SearchRecords" or another as you wish and specify the location.
4. Then right-click on Solution Explorer and select  "Add New Item" then create a "Default.aspx" page. 
5. Add a button, a label and a GridView in the Default.aspx page.

Then the <form> section of the Default aspx page will look as in the following:
 

 <form id="form1" runat="server">

    <div>  

   <table>

    <tr>

    <td> 

       Search

        </td>

        <td>

        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

        </td>

        <td> 

        <asp:Button ID="Button1" runat="server" Text="Go" onclick="Button1_Click" />

        </td>

        

        </tr> 

</table>

<table><tr><td><p><asp:Label ID="Label2" runat="server" Text="label"></asp:Label>  </p></td></tr></table>

<asp:GridView ID="GridView1" runat="server" >

    </asp:GridView> 

    </div>

 </form>

Now switch to design mode and use the following code.

To bind the grid, create the following method:

 Then double-click on the "Go" button and use the following code:
 

 

Now run the application, it will look as in the following:

 

 

Now enter some characters in the TextBox that do not match the specified table's records (that we inserted into the table); that will produce the following message:
 

Now do not enter a value into the TextBox and click on the "Go" button, that will display all the records as in the following:
 

Now enter the specific name and click on the "Go" button to search the records specific to name as follows:

 

 

In the all  preceding examples, we learned how to search the records.