This article will show you how you can search record preset
in a gridview. In this user will add text in a TextBox and on click of button
gridview data will get filtered using c#.net and asp.net.
Some of my previous articles are as follows: GridView
Validation Of TextBox Using RequiredFieldValidator Control Asp.Net Using C#.Net,
Resizable
Gridview Using jQuery in Asp.Net, Draggable
GridView Using jQuery in Asp.Net, GridView
Bind By Using AccessDataSource in Asp.Net, Gridview
Row Highlighting in Condition Bases in Asp.net Using C#.Net, GridView
Find Control Value on RowDataBound In Asp.Net Using C#.Net and VB.Net.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="ProjectDemo_Asp.et.Default"
%>
<!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>Search
GridView Record on Button Click By Using C#.Net in Asp.Net</title>
</head>
<body>
<form id="form1" runat="server">
Search By Title : <asp:TextBox ID="txtsearch"
runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click"
Text="Search" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" EmptyDataText="There are no data records to display."
Width="500px" BorderStyle="Solid" ShowFooter="True">
<Columns>
<asp:BoundField DataField="author_name" HeaderText="NAME" />
<asp:BoundField DataField="publisher_name" HeaderText="PUB. NAME" />
<asp:BoundField DataField="title" HeaderText="TITLE" />
<asp:BoundField DataField="publication_year" HeaderText="PUB.
YEAR" />
</Columns>
<HeaderStyle BackColor="#66CCFF" />
</asp:GridView>
</form>
</body>
</html>
|
Now just check the code on your .cs page.
using System;
using System.Data;
using System.Data.OleDb;
namespace ProjectDemo_Asp.et
{
public partial class Default : System.Web.UI.Page
{
public
string connectionstring = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=|DataDirectory|\\bookstore.mdb;Persist Security Info=False;";
protected
void Page_Load(object
sender, EventArgs e)
{
if
(!IsPostBack)
{
DataTable
_objdt = new DataTable();
_objdt = GetDataFromDataBase("");
if
(_objdt.Rows.Count > 0)
{
GridView1.DataSource =
_objdt;
GridView1.DataBind();
}
}
}
///
/// Function for binding retribing the data from database
/// In this i have used Access DB you can use SQL DB to bind
the data
///
public DataTable GetDataFromDataBase(string searchtext)
{
DataTable _objdt = new DataTable();
string querystring = "";
querystring = "select * from Books";
if (querystring != "")
{
querystring += " where title like '%" + txtsearch.Text + "%';";
}
OleDbConnection _objcon = new OleDbConnection(connectionstring);
OleDbDataAdapter _objda = new OleDbDataAdapter(querystring, _objcon);
_objcon.Open();
_objda.Fill(_objdt);
return _objdt;
}
protected void Button1_Click(object sender, EventArgs e)
{
DataTable _objdt = new DataTable();
_objdt = GetDataFromDataBase(txtsearch.Text);
if (_objdt.Rows.Count > 0)
{
GridView1.DataSource = _objdt;
GridView1.DataBind();
}
}
}
}
|
In above code I have create a function in which in which I have
passed the search string as parameter. If the passed value if blank on that case
I have fetched all the records other wise I have applied like query to search
the record.
No we have some just run the page and check the output.
Now add some text and click on search button.
DOWNLOAD
About the Author
Thank you, I just needed something like this. Using vb.net it took some changing but I got it working. Nice
ReplyDeleteThanks for your valuable comment. keep visiting.
DeleteThanku u sir, I just needed something like this.
ReplyDelete