Step 1: Download ziped Bin folder and
copy it to your Bin folder
Step 2: Add dll to your toolbox and
drag it to your web page.
Step 3: Follow following steps
Aspx Page
<%@
Page Language="C#"
AutoEventWireup="true"
CodeFile="Default.aspx.cs"
Inherits="_Default"
%>
<%@
Register assembly="SamApp.WebControls.SearchGridView"
namespace="SamApp.WebControls"
tagprefix="cc1"
%>
<!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
id="Head1"
runat="server">
<title></title>
</head>
<body>
<p>
<br
/>
</p>
<form id="form1"
runat="server">
<div style="height:
100px">
<asp:HiddenField
ID="hfSearchText"
runat="server"
/>
<asp:HiddenField
ID="hfSort"
runat="server"
/>
</div>
<div>
<cc1:SearchGridView
ID="SearchGridView1"
runat="server"
BackColor="White"
BorderColor="#999999"
BorderStyle="Solid"
BorderWidth="1px"
CellPadding="3"
EnableModelValidation="True"
onpageindexchanging="SearchGridView1_PageIndexChanging"
onsearchgrid="SearchGridView1_SearchGrid"
ShowFooter="True"
AllowPaging="True"
AllowSorting="True"
AutoGenerateColumns="False"
onsorting="SearchGridView1_Sorting"
ForeColor="Black"
GridLines="Vertical">
<SearchFilters>
<asp:ListItem>Username</asp:ListItem>
<asp:ListItem
Value="User_Pass">Password</asp:ListItem>
<asp:ListItem
Value="F_Name">First
Name</asp:ListItem>
<asp:ListItem
Value="L_Name">Last
Name</asp:ListItem>
<asp:ListItem
Value="City">City</asp:ListItem>
</SearchFilters>
<AlternatingRowStyle
BackColor="#CCCCCC"
/>
<Columns>
<asp:BoundField
DataField="Username"
HeaderText="Username"
SortExpression="Username"
/>
<asp:BoundField
DataField="User_Pass"
HeaderText="Password"
SortExpression="User_Pass"
/>
<asp:BoundField
DataField="F_Name"
HeaderText="First Name"
SortExpression="F_Name"
/>
<asp:BoundField
DataField="L_Name"
HeaderText="Last Name"
SortExpression="L_Name"
/>
<asp:BoundField
DataField="City"
HeaderText="City"
SortExpression="City"
/>
</Columns>
<FooterStyle
BackColor="#CCCCCC"
/>
<HeaderStyle
BackColor="#333399"
Font-Bold="True"
ForeColor="Silver"
/>
<PagerStyle
BackColor="#999999"
ForeColor="Black"
HorizontalAlign="Center"
/>
<SelectedRowStyle
BackColor="#000099"
Font-Bold="True"
ForeColor="White"
/>
</cc1:SearchGridView>
<br
/>
<br
/>
</div>
<div>
</div>
</form>
</body>
</html>
Step 4: Cs Code...
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;
public
partial class
_Default : System.Web.UI.Page
{
public static
SqlConnection conn = new
SqlConnection(@"Your
connection String!!!");
protected void Page_Load(object
sender, EventArgs e)
{
if (!Page.IsPostBack)
{
bind();
}
}
public void bind()
{
SearchGridView1.DataSource = GetTable();
SearchGridView1.DataBind();
}
public DataView GetTable()
{
SqlDataSource ds =
new SqlDataSource();
ds.ConnectionString =
@"server=IT-WSPC-F10\SQL;User Id=sa;Password=inveera@123;Initial
Catalog=pankaj";
ds.SelectCommand =
"select * from User_Login";
if (hfSearchText.Value !=
"")
ds.SelectCommand
+= " where " + hfSearchText.Value;
DataView dv = (DataView)ds.Select(new
DataSourceSelectArguments());
if (hfSort.Value !=
"")
dv.Sort =
hfSort.Value;
return dv;
}
protected void
SearchGridView1_PageIndexChanging(object sender,
GridViewPageEventArgs e)
{
SearchGridView1.PageIndex = e.NewPageIndex;
bind();
}
protected void
SearchGridView1_SearchGrid(string _strSearch)
{
hfSearchText.Value =
_strSearch;
bind();
}
protected void SearchGridView1_Sorting(object
sender, GridViewSortEventArgs e)
{
if (hfSort.Value == e.SortExpression)
hfSort.Value =
e.SortExpression + " Desc";
else
hfSort.Value =
e.SortExpression;
bind();
}
}