How to highlight searched words in gridview when serach performed on multiple column, i have 5 column in gridview and i perform search through text box and a button and bind gridview with searched record on all 5 column...
How to highlight searched keyword on all 5 column...
I have a pretty basic search feature on a site that queries a sqldb with a sqldarasource, and then displays the results on a page, in a panel within a Repeater. I'd like to figure out if it's possible to somehow highlight the words the user searched on as they are displayed in the search results. The code below is my repeater. Do you know of any way to manipulate the Title or Description if the words in it's body match the words searched?
<asp:Panel
ID="pnlExperience"
runat="server"
Height="500px"
ScrollBars="Auto">
[code]...
I have 1 Datalist and BTNsearch in my page below is SP
ALTER procedure [dbo].[AdminSearchP]
AS
BEGIN
SELECT * FROM House_p WHERE ID IN( SELECT DISTINCT houseP.ID FROM House_p houseP,SearchTerm WHERE [Description] LIKE '%' + SearchTerm.Name + '%')
END
this SP show in dataList data that contain some words that I define in SerachTerm table
refer
Select-records-from-one-Table-and-Search-in-other-table-in-SQL-Server/
Now I want when I click on button and it show data in datalist it highlight the words in datalist that I define in SearchTerm Table i.e in serchTerm table i define below words
Paris-India-Itally-Germany
when I click on button it search in House_p table in Description Column and if in this column be above words show it in datalist
Like below
Name
Description
Sara
She is from India
Now I want when show data in datalist it bold or Highlight the words that I define in SearchTerm table Like below
Name
Description
Sara
She is from India
How I can do it?
Is there a way to highlight key words in a datagrid from a search box?
View 8 RepliesI am trying to export a gridview that is returned from a search form. The gridview also has paging enabled. When the searched records are found in gridview it is exporting all data.instead of exporting only the searched data.
How can I only export the records from the search results, but also the make sure the records on the different pages export also?
I have a longer text and some keywords. I want to highlight these keywords in my text. That is no problem with this code:
private static string HighlightKeywords2(string keywords, string text)
{
// Swap out the ,<space> for pipes and add the braces
Regex r = new Regex(@", ?");
keywords = "(" + r.Replace(keywords, @"|") + ")";
// Get ready to replace the keywords
r = new Regex(keywords, RegexOptions.Singleline | RegexOptions.IgnoreCase);
// Do the replace
return r.Replace(text, new MatchEvaluator(MatchEval2));
}
private static string MatchEval2(Match match)
{
if (match.Groups[1].Success)
{
return "<b>" + match.ToString() + "</b>";
}
return ""; //no match
}
But when the word"tournament" is in the text and the keyword "tour" it becomes <b>tour</b>nament. I want to it to highlight the complete word: <b>tournament</b>.
I have everything working as I wanted except that when I search for the keyword and if the keyword is in an URL, it messes up the link. For instance if I search for music, the keyword in the URL is replaced by
[Code]....
so in the end the URL is like this:
[Code]....
How do I avoid replacing the keyword if the keyword is an URL? Someone mentioned using IndexOf but I'm not sure.
[Code]....
I have a list box which gets the value from a datasource as
[Code]....
Here, 'ALL' passes all the WORKSHOP_REQUEST_ID
Now, once the user enters the "Search" button on the window, the listbox shows all the searched values and also the "ALL" option. But here also , this "ALL" doesn't care of the searched values displayed on the listbox but sends all the WORKSHOP_REQUEST_ID if it is selected.
But i want to pass only the values which are searched and displayed on the listbox if the user selects "ALL" after searching some text.
I have been stuck on an issue that is driving me mad and I bet its simple. I have a Textbox with a gridview and a LINQ statement in code behind that populates the data source of the gridview at page load.
The Textbox is used as a filter for the where clause in the Linq statement. All works as expected however I want to be able to use more than one word as a filter. This is the problem. I take the textbox string and convert to an array
Dim aryTextFile() As String = SearchString.Split(",")
But I need to figure how to pass the values of the array as parameters for the Linq Statement. I need to return all rows that have either a match for LocationName AND/OR Address AND/OR City. I thought of something like this but it fails.
Dim db As New DCLocationsDataContext
Dim q = From t In db.Locations _
Where t.City AndAlso t.LocationName AndAlso t.Address Like aryTextFile _
Select t
GridView1.DataSource = q
GridView1.DataBind()
I like to use GridView because it is easy and flexible to work with. However, I found it quite frustration when it comes to display a column with a large chuck of words into the value of that particular column. Is there anyway to restrict how many words should only be display in a particular column rather than let it expands to cope up to display all the word. For example, I'm trying to display 20w and normally it would display
wwwwwwwwwwwwwwwwwww
but I would like to limit to 5 words in a line so it's going to be
wwwww
wwwww
wwwww
wwwww
I want to calculate Quntity*Rate into Total column in Gridview.
calulate the Gross Total of Total Column in Gridview Footer.
Text format of amount in Gross Total into Label Text. with AddNewRow,Remove Options.
How i can calulate the Gross Total and text in Gross Total in gridview?
Highlight the gridview if exceeds the required number and if the user will going to remove the specific row the highlight per row should follow, just like the image [URL] .....
View 1 RepliesI'd like to make some words of a cell in gridview Bold. For example - "MRN No.: SI0021848 Name: Cherry" like my attachment. I could query this field value from database but don't know how to make some words Bold. How to do it?
View 2 RepliesI found this usefull code in this website but i was wondering a way to select a multiple names in textbox inside GridView. I have seen one exampe on this website but the example is not in GridView. Here is my code that works fine now but it does not let me select multiple names:
<script type="text/javascript">
$(document).ready(function () {
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequestHandler);
Sys.WebForms.PageRequestManager.getInstance().beginAsyncPostBack();
function EndRequestHandler(sender, args) {
$("[id*=txt_UID]").autocomplete({
[code]....
I havewrite the edit button code as
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
BindData();
}
in bindata i am doing this
GridView1.DataSource = ta.GetData();
GridView1.DataBind();
Now i want that when i click on Edit command button of GridView then that row remain highlighted till the next edit button is clicked in anothe row..
I have an ASP.net gridview on a webform where user's can select a row. When they select it, the row is highlighted yellow. The problem is that when I sort the table, it sorts properly but the highlight stays on the same line. The data all moves, but the highlight stays put.
how I can make the highlight stay with the data?
I have a textbox and a gridview which is bound to a table what I want to achieve is a solution where lets say there are two records - e.g. "1. Book and 2. Red", i want a user to type in those words and the gridview shows the results as followed;
1. Book
2. Red
I have set up the sql data source and everything and my like operator is this.
LIKE '%' + @record + '%'
how can I solve this problem?
When my user clicks on the "select" button on a row in a gridview, is there any way for me to 'highlight' the data that is displayed in the selected row? Can I change the color of the text in just the selected row? Or change the background color for the selected row?
View 5 RepliesI haveissue with gridview
I use gridview inupdate panel like this
[Code]....
I use<asp:ButtonField Text="DoubleClick" CommandName="DoubleClick" Visible="false" /> for double click handeling on row
I need when click on row it be highlighted so I use the following
[code]....
I am using a gridview with 1 Template Field. I want to make that field hilighted when some one MOUSEOVER that any row. i used
[Code]....
I use the code below with gridview with command field to select specified row according to "name" from textbox and search button but it doesn't work
private void SelectRow(int rowindex)
{
GridView1.Rows[rowindex].BackColor = ColorTranslator.FromHtml("#009999");
GridView1.Rows[rowindex].ForeColor = ColorTranslator.FromHtml("#CCFF99");
for (int i = 0; i < GridView1.Rows.Count; i++)
[CODE]..
I want to higlight the background color based on condition
E.g. I have a column like
name rate
rafi 100
ravi 0
karthick 300
Here rafi and karthick should display the background color
ravi should display the whitecolor
While uploading excel sheet to datatable and bind it to gridview it will check the repeat data and null data in excel sheet and when it will bind to gridview, the row in which error present that row will be in red background color and the correct row will occur in normal back color.
View 1 RepliesI build a serach function just using SelectCommand and SelectParameters, i.e.
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:mprojectConnectionString %>"
SelectCommand="SELECT * FROM [publication] WHERE ((([character] LIKE '%' + @character + '%') AND ([type] = @type))
OR(([f11623] LIKE '%' + @f11623 + '%') AND ([type] = @type))
OR (([f1character] LIKE '%' + @f1character + '%') AND ([type] = @type))
OR(([nortonoxfordnumber] LIKE '%' + @nortonoxfordnumber + '%') AND ([type] = @type))
OR (([nortonoxfordtext] LIKE '%' + @nortonoxfordtext + '%') AND ([type] = @type)))">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="character" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="f11623" PropertyName="Text"
Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="f1character"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="nortonoxfordnumber"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="TextBox1" Name="nortonoxfordtext"
PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="type"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
I am also using a dropdown box and a textbox for people to search within a particular area from the dropdown list.
Now, I would like to be able to highlight the keywords in my gridview table. I searched around on the Internet and found a lot of samples, but they are all related to the Gridview <templates>, however, I am using <BoundField> and sqlDataSource.
I just cound not figure out how can I add this highlight function to my current search function?
I have a Gridview with two columns name and email.
Now if the employee does not have an email address then I would like to highlight that row.
How can i achieve that?