Forms Data Controls :: Highlight Key Words In A Datagrid From A Search Box?
Nov 4, 2010Is there a way to highlight key words in a datagrid from a search box?
View 8 RepliesIs there a way to highlight key words in a datagrid from a search box?
View 8 RepliesI 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 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]....
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...
anyone got a sample highlight the search keyword in gridview using c# .net?
View 2 RepliesI 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?
I 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 the following code in the .aspx page:
<asp:TemplateField
HeaderText="Summary"
SortExpression="INTERPRETATION_SUMMARY"><ItemTemplate>
<asp:Label
ID="lblSummaryView"
runat="server"
Text='<%# HighlightText(Eval("INTERPRETATION_SUMMARY")) %>'></asp:Label
[Code]....
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 need to implement a stored procedure for search with 1 fileldkeywords(jobtitle,skills,company name....etc) everything is in different tables?how i will query this?any samples using dynamic query or temporary tables
View 3 RepliesI don't know how to keep in sync the filtered elements of a DataGrid after the user applies a filter. The problem is when she/he tries to edit one filtered elements.... it is not the correct item!
[Code]....
How to update the index for the elements returned by the filter process?
I need to search some words or text in word document through programming.
View 1 Repliesi want to search the words and nearby words from the xml file.I dont know how to start this with asp.net. I have a xml file i want to serialize it using xmlelement and xmlatrribute.but i don't know how to define it. and use it. I also want to use hash table that contain this xml file but how do i define keys and values with the xmlelement and attribute. I am new to this.
View 2 RepliesI've an aspx page with a couple of textboxes, one of which is populated with text from a sqlserver, is it possible to highlight certain words within the text box that match a search critrea? I've opted for textbox to display the text as that seems to be the only control that will format the text correctly. Incidently I'm using vb.net as my code behind
View 6 Repliesseveral words in my textbox.How do I do?
View 7 RepliesI have <span> tags in the cells of my datagrid which determine which background color to use. I also want the user to be able to click any cell and highlight the entire row. This works anywhere there's not a span tag. The span tag is somehow canceling this out. What would you do so that fields inside a span tag act like regular fields where you can click on them and the entire row is highlighted?
View 10 RepliesI have a table in SQL Server with structure:
Students
(
StudentId bigint,
FullName nvarchar(100),
DegreeId smallint,
Articel nvarchar(max)
)
i have created a full text index and enabled it for "students" table.
in my asp.net page ,users type words and i call a stored proc filter students using these words.
Create Procedure GetStudents(@Article nvarchar(200)=typed words)
AS
BEGIN
SET NOCOUNT ON
SELECT StudentId,FullName,DegreeId,Article
FROM Students
WHERE WHERE FREETEXT(Article,'''+ @Article+''')
END
The search works fine ,now i need to highlight(yellow background)the "articles" of returned stuents in my asp.net page(by jquery,or asp.net).
I have 2 grids gvParent & gvChild I would like to filter gvChild when a row is selected in gvParent the linking fields are contractNo
I added a column for selecting:
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"
OnClick="LinkButton1_Click" Text="Select"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
I know how to handle the filtering of the grid (create a criteria and set to rowfilter of the dataview) But, I dont know how to get the value of the column of the selected row.
I have Datagrid , i want to clcik on row and get data in textbox , but my textbox is FreeTextBox control,i tried to use javascript but work for asp.net control not working for freetext box control, how i can capture this code is sample code but it work for asp.net control but not working for my freetextbox
[Code]....
Simply put... I want to duplicate the example found at this link, in VB.net rather than C#.
[URL]
I would like the selectedvalue of the dropdown to display additional data base on its selection in multiple text boxes.
I have tried using the DropDownList OnSelectedIndexChanged property, within a DataGrid EditiItemTemplate, but I cannot retrieve data from the selection. (AutoPostBack is "True"). I can however use a button onclick event to fire a "prre-defined" selection value.
i have in my asp.net page a textarea where users type an article="long text" to be saved in the database. In another page i display these articles(textarea) in a :
<p class="p-article">
the text of the article goes here.
</p>
I'd like to filter these articles by search keywords .for example when a user search for "Startup Marketing".
I want to apply the keywords as a filter and get articles and bring those that contain "Startup" or "Marketing" or "Startup Marketinbg".And this in client side by jquery if possible.
I have 2 datagrid (using .net 1.1). I need to access column of second grid ( i need to make a column of second grid as disabled) when i click "Cancel" link button in First Grid. How can this be done?
View 7 RepliesI´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:
1. Save a byte array from SQL server to word document as a temp file in a server side?
2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?
how to Add Search Control for Detailsview for search page... simple solution required.?
and is it possible to give field names to each page numbering?
how to do a search using a Full Text Search Catalog. I would also like to have the results on the page highlighted?
View 1 Replies