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:

Forms Data Controls :: Highlight A Search Field In A Gridview

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

Forms Data Controls :: Highlight Search Keyword In C#.net?

May 22, 2010

anyone got a sample highlight the search keyword in gridview using c# .net?

View 2 Replies

Forms Data Controls :: Highlight Key Words In A Datagrid From A Search Box?

Nov 4, 2010

Is there a way to highlight key words in a datagrid from a search box?

View 8 Replies

C# - How To Highlight Complete Words With Keywords With Regexp

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

Need To Automatically Highlight The Keywords In The Text Box Using Code Behind C#?

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

Forms Data Controls :: Declare And Set Keywords In Gridview?

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

Search More Then 2 Keywords In C#.net?

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

Search Engine Support Keywords?

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

How To Show Keywords And A Search Box Under Site's Google Results

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

To Create A Search Textbox For Users To Enter A Few Keywords In?

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

Forms Data Controls :: How Can Highlight A Selected Row In A Gridview

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

Forms Data Controls :: Cannot Highlight Gridview Row Onclick

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

Forms Data Controls :: GridView Highlight Row On Mouse Over?

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

Forms Data Controls :: How To Highlight A Gridview Row Based On Column Value

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

Forms Data Controls :: Disabling Mouse Over Highlight On GridView?

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

Forms Data Controls :: Highlight Duplicate Values In Gridview?

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

Forms Data Controls :: Gridview Cell Highlight With Toggling?

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

Forms Data Controls :: How To Set Focus In Gridview Textbox And Highlight The Text If It Is Zero

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

Forms Data Controls :: Gridview Multiselect Row Highlight-not Working On Firefox?

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

SQL Server :: Method To Allow A User To Search In A Specific Field For A Records Containing The Keywords They Enter Into A Textbox?

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

Forms Data Controls :: GridView Paging / Highlight The Actual Number Of Page?

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

Forms Data Controls :: Highlight Text In A Dynamic Textbox Within A Gridview Without Using JavaScript

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

Web Forms :: Highlight Search Term In A Textbox?

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

Data Controls :: Search In GridView Using JQuery Quick Search Inside AJAX TabContainer

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







Copyrights 2005-15 www.BigResource.com, All rights reserved