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.
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.
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?
I have a gridview that shows, for example, a baseball team's statistics. It's a standard sports stats grid - the rows show statistics for each player and the columns show the specific stat for the each player.
Easy enough so far. But what I would then like to do is style (highlight or bold) the Max or Min (the team leader) of each stat column. For example, Player A may only lead in one or two categories, so we cannot style the entire row. If Player A just leads the team in strikeouts, I just want to style the number of strikeouts he had (THAT cell only).
What's the best way to handle this? Make SQL Server do all the work and in effect, rank EVERY stat of each player, effectively doubling the number of columns (e.g. col: AB, col: ABRank). Or do I let the rowdatabound event of the gridview handle this?
If I chose the latter, I think I would get the Max of every statistical category from the datatable before binding (e.g. store them in a local variable) then on rowdatabound, if they match the value, apply the style.
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 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.
Below is my function which insert textbox value into grid view .this work fine .
Now I want to compare grid view row with textbox value if already exist in grid view then it give me massage already exist with same name means duplicate data cannot insert into grid view
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" ?
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.
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()
Well the dropdownlist has an existing items. I just want the selected gridview record to be displayed in the dropdownlist. The dropdownlist has several DataTextField in string and consist of DataValueField in numeric. The gridview passes a string text to the box which has an equal or same item inside the dropdownlist. Whenever i passed a record from a gridview to be viewed in the dropdownlist it just duplicates the same item. Q: How can i simply pass a text inside the dropdown and just simply display it without adding on the list.
sample item on the dropdown: --Select-- Account Savings
after selecting on the gridview and display inside the dropdown: Account Account Savings
(you see the '--Select--' was erase and replace with the selected record)
I have a standard .NET GridView. How I can: 1. Highlight the row on mosue over (or hover),2. Activate the Select Event when you click on anywhere on the row?