Forms Data Controls :: Highlight Search Keywords In Gridview?
Jul 12, 2010
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?
View 4 Replies
Similar Messages:
May 13, 2010
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]....
View 5 Replies
May 22, 2010
anyone got a sample highlight the search keyword in gridview using c# .net?
View 2 Replies
Nov 4, 2010
Is there a way to highlight key words in a datagrid from a search box?
View 8 Replies
Feb 26, 2010
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>.
View 1 Replies
Apr 29, 2010
I m retrieving a text from SQL DB based on the Search criteria i give and displaying in the Textbox in asp.net. I need to highlight the words given in the search criteria in the displayed text.
For example : If i give "need" all the word "need" in textbox that is retrieved and displayed should be highlight in yellow color.
View 1 Replies
Feb 5, 2010
I have the following code:
[Code]....
As you can see, I have two variables @total and @euclidDist, and I have declaring them and defining them using DECLARE and SET respectively. This query works in VB and MSSQL and returns the required results, however when I try to great a Gridview, and I paste the above query in the query builder, it asks me to input the values to @total and @euclidDist, ie it ignores the fact that I already defined them in the statement itself...how do I get around this?
View 1 Replies
Dec 17, 2010
i want to Search more then 2 item with one TEXTBOX field using with , Eg. item1,item2.
Result should be shown for both in one gridview i am using SP with one Parameter.
View 2 Replies
Jun 14, 2010
this is naresh.i have some query.in google search engine while typeing any letter based on letter some support keyword is getting.
View 8 Replies
Jan 20, 2010
I saw on the google when search "code project", some keywords and a text field and a button to search that google has generated for "code project" keyword also for "manchester university" in the same way.
How is it possible to show key words and text field/button for our website on google? As it shows for "code project" and "manchester university" etc.
visit google and search "manchester university" u'll see:
StudentNet Job Opportunities
PostGraduate StaffNet
etc..
and
textfield/ and a button
I want this kind of result for my site from Google!!
View 2 Replies
Feb 19, 2010
I want to create a seach textbox for users to enter a few keywords in ,..and then my sql query will display the results......( basically a little search engine for my website)Ok so im thinking of using the Containstable with ranking on how close these keywords are to eachother... so the closer the keywords are to each other... the higher their ranking will be.... but I also want to seach for these keywords in 4 columns in one Datatable how can I do this
View 7 Replies
Feb 8, 2010
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 Replies
Nov 9, 2010
I 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]....
View 7 Replies
Dec 31, 2010
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]....
View 5 Replies
Feb 11, 2010
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?
View 1 Replies
Mar 31, 2011
I was just wondering if there isa way to disable GridView rows from being highlighted with the mouse when user clicks and drags over the row.
I was thinking this may be possible by disabling the onclick atttribute but I use this as each row is a hyperlink to another page.
Just trying to think of an alternative method; is it possible to change the color to be somehow transparent on the drag?
View 5 Replies
Feb 18, 2011
The user will enter values in the textbox of the gridview in item template. A button outside the grid, when it is pressed we have to highlight the duplicate values.
Is there is any way to use validation control.
View 2 Replies
Sep 17, 2010
I have a dynamically generated Gridview wherein every tablecell within the gridview is assigned a particular class(background color) at run time.
Each cell has a linkbutton and I have a onClientClick event where, I would like to highlight the container cell when the user clicks on the linkbutton.
If the user clicks it back, I would it to get back its original class/background color that it was bound with earlier. I am trying to implement this in Javascript by passing the original className but I am unable to toggle the color back to original.
Here is a snippet of code. I could do it in c# but I would like to implement this in Javascript as it won't cause postback.
//Linkbutton databinding event
private void lb_DataBinding(Object sender, EventArgs e)
View 2 Replies
Jan 6, 2010
I have a text box in a gridview that is causing some problems with user input. The first time the user opens the page the gridview is populated with zero's in all rows textboxes. I set the focus to the first textbox in the Page_Load event but the cursor is placed to the left of the zero and when some users enter data they don't realize the zero doesn't go away so the first row ends up wrong. Once the tab or enter key is hit and the next row is selected, the zero is "selected", for lack of a better term like when the insert key is predded, and once the user starts typing only the new value remains. Is there a way to make the zero in the first row "selected" ?
View 1 Replies
Jul 22, 2010
I am trying to implement gridView multiselect using checkboxes.but i want to select the checkbox, if you click any where on row and then highlight the row as selected.
[Code]....
View 6 Replies
Aug 19, 2010
What's the best method to allow a user to search in a specific field for a record(s) containing the keywords they enter into a textbox? I am considering using the streamreader to obatin the values from textbox into an array, so I can build dynamic query using the stringbuilder. Is there a cleaner or more efficient method to approach this common search functionality?
View 1 Replies
Jan 3, 2010
is there any way how to highlight the actual number of page where I am ? .... somethink like this: < 1 2 3 4 5
6 7 8 >
View 3 Replies
Oct 19, 2010
I have the following code which sets the focus of the textbox, but I now also want th text in the textbox to be highlighted, but without the use of JavaScript. I have tried using JavaScript but cannot get it too work, is there any other way to do it?
Protected Sub
GridView1_RowEditing(ByVal sender
As
Object,
ByVal e
As System.Web.UI.WebControls.GridViewEditEventArgs)
Handles GridView1.RowEditing
GridView1.EditIndex = e.NewEditIndex
BindData()
GridView1.Rows(e.NewEditIndex).FindControl("txtTargetAmount").Focus()
View 2 Replies
Feb 9, 2011
I'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 Replies
Dec 2, 2013
I made a usercontrol consisting of an AJAX tab control, a textbox, and a gridview. The gridview is pulling data from a SQL database. When the gridview is outside of the tab control and I begin to enter text into the textbox, quicksearch begins to filter the information in the gridview. When i put the gridview and textbox inside an AJAX tab control quicksearch does not work. How do i need to structure the textbox and the gridview on an ajax update panel to get it to work?
View 1 Replies