Search Records In GridView Footer And Highlight Results using ajax in asp.net, In this example i am populating Gridview by creating Sqlconnection and SqlCommand.
I've put a textbox in FooterTemplate of gridview for text to search, and the search results are highlighted using regular expression, i m using AJAX for partial postback and update progress template to show search progress
1: <style type="text/css">
2: .highlight {text-decoration:none; font-weight:bold;
3: color:black; background:yellow;}
4: </style>
5: </head>
6: <body>
7: <form id="form1" runat="server">
8: <asp:ScriptManager ID="ScriptManager1" runat="server"/>
9: <asp:UpdatePanel ID="UpdatePanel1" runat="server">
10: <ContentTemplate>
11: <div>
12: <asp:GridView ID="grdSearch" runat="server"
13: ShowFooter="True"
14: OnRowCommand="grdSearch_RowCommand"
15: AutoGenerateColumns="False">
16:
17: <Columns>
18: <asp:TemplateField HeaderText="FirstName">
19: <ItemTemplate>
20: <asp:Label ID="lblFIrstName" runat="server"
21: Text='<%# Highlight(Eval("FirstName").ToString()) %>'/>
22: </ItemTemplate>
23:
24: <FooterTemplate>
25: <asp:TextBox ID="txtSearch" runat="server"/>
26: <asp:Button ID="btnSearch" CommandName="Search"
27: runat="server" Text="Search"/>
28: </FooterTemplate>
29: </asp:TemplateField>
30:
31: <asp:BoundField DataField="LastName" HeaderText="LastName"/>
32: </Columns>
33: </asp:GridView>
34: </div>
35: </ContentTemplate>
36: </asp:UpdatePanel>
37:
38: <asp:UpdateProgress ID="UpdateProgress1" runat="server">
39: <ProgressTemplate>
40: <br />
41: <img src="Images/ajax.gif" alt="Searchig"/>
42: </ProgressTemplate>
43: </asp:UpdateProgress>
44: </form>
45: </body>
Populate GridView by making SqlConnection and SqlCommand to fetch data from database, then bind the data to Grid in Page_Load event.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGrid();
}
}
private DataTable GetRecords()
{
SqlConnection conn = new SqlConnection(strConnection);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select * from Employees";
SqlDataAdapter dAdapter = new SqlDataAdapter();
dAdapter.SelectCommand = cmd;
DataSet objDs = new DataSet();
dAdapter.Fill(objDs);
return objDs.Tables[0];
}
private void BindGrid()
{
DataTable dt = GetRecords();
if (dt.Rows.Count > 0)
{
grdSearch.DataSource = dt;
grdSearch.DataBind();
}
}
Now i've written a method to search GridView rows or records for the text entered in footer textbox by user
private void SearchText(string strSearchText)
{
DataTable dt = GetRecords();
DataView dv = new DataView(dt);
string SearchExpression = null;
if (!String.IsNullOrEmpty(strSearchText))
{
SearchExpression =
string.Format("{0} '%{1}%'",
grdSearch.SortExpression, strSearchText);
}
dv.RowFilter = "FirstName like" + SearchExpression;
grdSearch.DataSource = dv;
grdSearch.DataBind();
}
Next step is to check the command in RowCommand event of gridview,if it is what u've defined in while creating the button in footer of grid by assigning the commandname property, if yes than get the text entered by user in textbox placed in footer of gridview by using findcontrol method and pass this text to the search method written earlier by making a call to that method
protected void grdSearch_RowCommand(object sender, GridViewCommandEventArgs e)
{
System.Threading.Thread.Sleep(2000);
if (e.CommandName == "Search")
{
TextBox txtGrid =
(TextBox)grdSearch.FooterRow.FindControl("txtSearch");
SearchText(txtGrid.Text);
}
}
To highlight search results use regular expression and replace the the words found with highlighted in yellow color
public string Highlight(string InputTxt)
{
GridViewRow gvr = grdSearch.FooterRow;
if (gvr != null)
{
TextBox txtExample =
(TextBox)grdSearch.FooterRow.FindControl("txtSearch");
if (txtExample.Text != null)
{
string strSearch = txtExample.Text;
Regex RegExp =
new Regex(strSearch.Replace(" ", "|").Trim(),
RegexOptions.IgnoreCase);
return
RegExp.Replace(InputTxt, new MatchEvaluator(ReplaceKeyWords));
RegExp = null;
}
else
return InputTxt;
}
else
{
return InputTxt;
}
}
public string ReplaceKeyWords(Match m)
{
return "" + m.Value + "";
}
Showing posts with label Progress Template. Show all posts
Showing posts with label Progress Template. Show all posts
13
ASP.NET Search Records In GridView Footer And Highlight Results
Posted by
Unknown
Subscribe to:
Posts (Atom)
