Devexpress Gridview Select Row By Cell Value

Transforms distinct values in columns into new column. Ask Question. Here is an example: Sub Exercise() Rows. All the rows are converted into tr element and values placed in different td. These are displayed to the screen. So for your scenario, I am afraid there is no a efficient DAX expression to achieve your requirement. NET Grid to eliminate this tradeoff. Get cell value: 7. Highlight the row and column of the selected cell. Re: Selecting Rows based on cell criteria Hi, I don't want to strip out anything from this particular worksheet I just want to select those rows that meet the criteria of having "G" in column A and so that my next set of instructions will be copying them and pasting into another worksheet, which I can handle that part, it's just getting to the point of selecting those rows. [GridControl - WinForms]. The range would still expand by one row (A2:A11), but since we left one blank cell in-between our previous data and the new value, that blank cell now becomes part of the range. Use row and column index to reference cell: 4. Users can update data with Cell Editing. We want to offset this entire range by one row and one column. #2 go to HOME tab, click Conditional Formatting command under Styles group. Move cells. Collections. To swap values between rows and columns, select an entire row or column, and then hold down Shift before dragging your cursor out to the row or column you want to swap its values with. GetRowCellValue method. VBA code to hide or unhide rows based on a cell value. User will select one row in grid and click on button to open popup. A lambda expression indicating the selected value. This is a great tip for anyone who is auditing or reviewing a spreadsheet and wants to quickly find any abnormalities in the formulas or values that are being used for calculations. Select How to Select a Range of Cells Offset from a Specified Range. NET Grid View (ASPxGridView) provides the capability to allow end-users to select rows using checkboxes. To avoid any confusion, first off, let's agree on what we call unique values in Excel. Select the first cell and then use Shift+click to include a contiguous group of cells. Move a cell row to another worksheet based on cell value If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above. If you need to count the total number of cells in a rectangular range, you can do so with the ROWS and COLUMNS functions. in data grid. To programmatically select all rows of a worksheet, call the Select method on the Rows collection. Cells(Rows. Last Reply on Feb 16,. Once with the value in the cell and then the next alert just shows undefined (almost like something's looping, but I only have one alert and no loops). Cells(7, 3). In the above example, this should be the row with the names of the months. Demo Can you please take a look at above demo and let me know why I am not able to get the values of selected (checked) rows from the table? I have a code Issue on Getting Selected Row Values From Table with Checkbox - jQuery Forum. To retrieve the row number which corresponds with a matched value in a lookup, we use the MAX function, along with the IF and ROW functions in Microsoft Excel 2010. How to remove rows based on cell value in Excel? To quickly delete or remove multiple rows based on cell value in Excel, you may need to select those entire rows containing specific cell value first, and then go to remove them. I'll cover the. Retrieving the Row Number that Corresponds with a Matched Value in a Look Up in Excel 2010. Appearance of the Focused Row can be specified using the Styles. * Returns an empty text value for all others. e: Range(B1). What do you do? Display the Paste Special dialog box and select Formulas and number formats. AddNewRows() method. merge two rows in excel worksheet where one cell has same content but other cells have different content. index 0) in the selected row of a DataGridView. Does your data preparation process include deleting the same rows based on a condition? If so, you can use a macro to instantly delete any rows that have a particular value, date, or even blank cells. NET Grid View (ASPxGridView) provides the capability to allow end-users to select rows using checkboxes. How to select a row in gridview The GridView control is used to display the values of a data source in a table. It works fine if the cell is text, but need to evaluate a cell that is a number and would like to. MS Excel 2010: Automatically highlight highest and lowest values in a range of cells This Excel tutorial explains how to use conditional formatting to automatically highlight the highest and lowest values in a range of cells in Excel 2010 (with screenshots and step-by-step instructions). We want to offset this entire range by one row and one column. However, I'm having an issue getting he value of the FIRST Cell in that Row that is selected to a string value. Selecting a row will remove previous selection unless you hold down ctrl while clicking. how to get gridview row index value in javascript hi. Select the cell you want to copy. A common scenario is to switch grid cells in edit mode by simply clicking them (an easy and intuitive approach), update the data on the client and then process all changes on the server with a single batch update. Firstly I bind the dataset to gridview in code-behind. SelectedRow. Try // get the values of selected row from a Gridview and display the values in textboxes using C# code. The sample code below shows how to use the RowProperties. You can then perform various operations on selected rows (copy to the Clipboard (as text), delete, drag, etc. empty array [] No: selrow: string: This option is readonly. Rows: In dataGridView1_RowEnter, we access the Rows property, and then loop over all the rows and then the cells. NET GridView Cell Value when it is clicked, using jQuery. GetRowCellValue method. Conditional Formatting: Values in ANOTHER cell in same row to display a color (works cell-by-cell otherwise it doesn't) When using conditional formatting for a specific cell things work fine. GetValue method. When I do this, i. SelectedIndex value to point to the selected row. Now in new row i need to get the 3rd cell/column value of previous row and perform some calculation and set in new row. i am trying to see if you can help. If new cell values do not pass validation, end-users are kept on the current row to either correct all errors, or press Esc and undo the changes. The column will display check boxes within its cells. Select Note: because we placed our command button on the first worksheet. Assiging a value to this property. I don't have any example code for this handy, maybe someone else can supply you with some, but essentialy what you do is capture your GridViewRow from the e parameter. How to Hide/show rows depending on a cell value? details to that particular service should appear on my sheet i. Firstly I bind the dataset to gridview in code-behind. Cells(StartNumber, StartNumber). You can then perform various operations on selected rows (copy to the Clipboard (as text), delete, drag, etc. I've found a few forums that showed how to select full rows or all visible cells in a filtered table, but very little for a single cell in a filtered column. Select the cells to move. You may also want to paste values that were previously copied to the clipboard from another application. and Add three Textboxes to display a data in Textboxes when the GridviewRow is Selected. You may want to shade the rows in different colors based on the cell value in the Qty. To access the values of the selected rows in a grid, you must access the SelectedRows collection. And here's touch working:. How to get cell value of gridview using JQUERY Categories ASP. And saving the bigger value and eliminate the smaller one. Column Row = activecell. Now I will explain how to get row values from a GridView when the checkbox is selected using ASP. One of the key advantages of the GridView control over other data-bound controls is its ability to automatically take advantage of data source capabilities. I have a 3d array, precip= :,:, 8760. Extract data frame cell value While working with tables you need to be able to select a specific data value from any row or column. So for your scenario, I am afraid there is no a efficient DAX expression to achieve your requirement. With the cell selected, hover on the lower right corner of the cell then (a) grab the "+" handle and drag with your mouse to extend the calculation to other worksheet columns or (b) double-click on the "+" handle to extend the formula to every row cell to the right of the original formula cell. 9 percent to $518 million. These properties and methods are listed in the table below:. Here you can get values from other fields within the same row using the e. To identify a row currently being focused, use the GetFocusedRowIndex client method. Check out our five minute lessons on Excel, Microsoft Word, and Google Analytics. Learn more about jQuery Bootgrid. Try // get the values of selected row from a Gridview and display the values in textboxes using C# code. AllowSelectByRowClick property to true. To set the focus on a particular record of a DevExpress GridView we have to set theFocusedRowHandle property. From the Home tab, select Paste. To avoid any confusion, first off, let's agree on what we call unique values in Excel. RadGridView provides a variety of visual cells (all inheriting from GridCellElement) with different functionality and purpose – header cells, indent cells, command cells, summary cells, group content cells, data cells, etc. Questions: Does anyone know how to get the cells value of the selected row of JQGrid ? i m using mvc with JQGrid, i want to access the value of the hidden column of the selected row ? Answers: First you can get the rowid of the selected row with respect of getGridParam method and. This little code snippet will help us to find the data keys assocciated with a row in. The cell or range of cells for which you want the row number. This demo displays contact names selected in the Grid View within the 'Selected values' list box. -**- In datagridview cell click event - get the index of the selected datagridview row - show data from the selected row to textboxes Get Selected Row Values From DataGridView Into TextBox In. It then gets the title of the book in the row to be selected and locates the corresponding record in the Recordset that is providing data for the DataGrid. To select all cells of a series of rows, select those rows as seen in Lesson 3 and notice that all cells on the right side of the selected rows are highlighted; To select cells in the same region using the mouse only, click and hold your mouse on one cell, then drag down or up, left or right, to the last cell in the range. Return only rows that match a condition. formId=formId;this. Under Format cells that are not between, enter a lower value and an upper value. and Add three Textboxes to display a data in Textboxes when the GridviewRow is Selected. The reason is if I tried to paste my swapped columns and rows into cell A1, I got an. This is a great tip for anyone who is auditing or reviewing a spreadsheet and wants to quickly find any abnormalities in the formulas or values that are being used for calculations. how to get selected row value in aspx gridview function OnIbtnComments() { key = gvProjectData. I'm trying Offset within specialcells, but it's bugging out at the Offset. Here now we read all the data of a given HTML table. User will select one row in grid and click on button to open popup. To do this, add a command column to the ASPxGridView and set its ShowSelectCheckBox property to ‘true’. #1 select the range of cells that you want to highlight the highest values in each row. This options is readonly. In the GridView Template I using Button in Column[6]. Or, if the Search window is closed, select Edit > Search > Replace. How can this be done?I want to do this at the form level and not on the datasource level. In this demo I have used Northwind database to bind GridView. This topic explains how to use the API for selecting and deselecting rows and cells in igHierarchicalGrid™. Want to insert a line so select row 2 or any cell on row 2 such as D2. Also, the original value in the hidden cell will be replaced with the new value or formula that you type into the cell. Using a macro to insrt rows below the active cell and retain formulas from the copied row. Hey guys I have been closely watching your threads regarding searching a record in a datagrid as I have the same problem as Geetajilo. Find: Get Real Last Cell: 7. * Returns an empty text value for all others. If the Grid is in edit mode, saves the edit cell’s value, closes its editor, selects the left cell and opens its editor. " Recall that the Model for this view is the ProductGridModel class, which has a CategoryId property that is assigned the value of the categoryId input parameter passed into the Filterable action. To allow row selection, add a command column to the Grid View and set its ShowSelectCheckBox property to true. getSelections: none: Return all selected rows, when no record selected, an empty array. What rows are selected and how the selector actually operates is controlled by this row-selector data type. If you wish to get data from selected rows, you can call the GridView. this is useful only in relatively small samples. Use the AutoFill function by specifying the. CONTAINS ( 'Error', 'Error'[ColumnName], ), LOOKUPVALUE ( [ We cannot use dynamic column name or table name in DAX currently. I am calling a java script function on button click. Note: If you make changes in one row and then edit cells in another row, the changes in the first row are automatically saved. To select cells from asp. I have an ASP. To respond to a change in row focus, handle the FocusedRowChanged event. How to access the row cells value of gridview on Select button click in Gridview Hi Friends I am trying to getting the Row cells value on the Select command click. Returns 0 if the cell is not locked. You may also want to paste values that were previously copied to the clipboard from another application. Here Mudassar Ahmed Khan has explained with an example, how to get Cell value of GridView on LinkButton Click in ASP. You will notice that the selection is cut up to skip the hidden rows and columns. To select a row: Use the Select row entry in the Tools/Edit table submenu (Ctrl-t Ctrl-r). Working With Visible And Hidden Cells. Either way, you’ll select a range of rows. Value property to access cell values. The way the grid column value is stored is based on the type of the associated dictionary item (for example, math numeric, string, character), and it is distinct from the screen representation of the. CellAddress is a new object, which will helps you identify the cell address and contains three elements: Sheet Column Row. For extracting the value of the TemplateField Cell, first the Label control is referenced and then the value is extracted. Hello, i like the value from a cell in a selected row, but it doesn't work. WinForms DataGrid Control VIBlend DataGridView for WinForms is a top of the line data grid control loaded with hundreds of powerful features. This can be easily done using Excel Conditional Formatting. How to get the values of cells gridview row? Dec 05, 2007 03. In other words, we want the user to be able to type Europe into a cell and the PivotTable updates to show the value for Europe, just as if the user had used the filter dropdown to select Europe. Selecting a row and then holding down shift while clicking a second row will select the range. So if the number is 2, I need the row shown 2 times. In this Article you can learn how to get the values of selected row from a Gridview and display the values in textBoxes using C# code. Select the column where you will find out cells if contain specific text or value. I m trying to target some cells values only in selected row or rows. GetRowCellValue method. Continuing to hold down your mouse button, drag your cursor across all the rows you want to select. Use Rows to access all the strings for a single row, along with their associated objects. In this short article, I will show using Excel how you can get data from another worksheet based on a cell value. Select makes DataTables act like small databases. How to Select a Cell Relative to Another (Not the Active) Cell. Change the background color of selected cells using "Format Cells" dialog. By setting the focused row and column, you can select a cell you want. This value can be positive, negative, or set to zero. Collections. However, I'm having an issue getting he value of the FIRST Cell in that Row that is selected to a string value. formId=formId;this. Cells(Rows. I've added a button to display on each row of a GridView control. The code repeats this step to compare the cells in the second collection to those in the first. Copy row based on a cell value I have a spreadsheet that contains office names (Brookside, Blairsville, New Castle, etc) in Column A. IsSelected property is set to true , and the cell is added to the SelectedCells collection. How to: Provide. Consider the following picture I get the selected row values in the three textboxes shown in the figure when i click a cell using following code. Format : Cells(Row,Column) Excel is represented in a grid format, tabular form in rows and columns, so to reach to particular cell you need tell to compiler the cell is located in which row and which column in that particular row. Row lCols = lastcell. The column will display check boxes within its cells. You selected and copied worksheet data containing formulas. However it is simple to adjust if you just want to select a Cell. Here are instructions on how to copy and paste visible cells only (please see the video above for details): Select the entire range you want to copy. For example, if the value in cell B2 is 5 I'd like 4 additional rows inserted beneath it with the exact same content in that row. Now first create the Emp table in the database. Cells(7, 3). Here is a sample code snippet:. To enable this selection mode, set the SettingsBehavior. First you can get the rowid of the selected row with respect of getGridParam method and 'selrow' as the parameter and then you can use getCell to get the cell value from the corresponding column:. This method takes two parameters: a row object and the UniqueName of a column. By default, selected rows are painted using the same appearance settings as for the focused row, although it is possible to use different appearance settings to paint selected and focused rows. You can then perform various operations on selected rows (copy to the Clipboard (as text), delete, drag, etc. js MVC Security codingbat design pattern python reflection signalr wcf 4. I have a 3d array, precip= :,:, 8760. To be able to select more than one cell, you could use a variation of the SelectCellByIndex method above that takes a list of row and cell combinations as a parameter in the form of a System. Check out our five minute lessons on Excel, Microsoft Word, and Google Analytics. Until 11g, Oracle SQL did not have a direct mechanism for allowing multiple values from the same column to be displayed in the same row of output. NET developers joined together with a common goal: to learn, teach, and have fun programming. I need to select all the rows in sheet 1 where a cell is equal to or less than a certain value and then show all those rows in sheet 2. Sort Lists options. The new range of cells in the line of code above will be B2 to D4. Text = GridView1. If new cell values do not pass validation, end-users are kept on the current row to either correct all errors, or press Esc and undo the changes. Let's say you want to change color of GridView's cell depending of value. Then, run through this collection and get a cell value using the GridView. Here now we read all the data of a given HTML table. One of the key advantages of the GridView control over other data-bound controls is its ability to automatically take advantage of data source capabilities. Demo Can you please take a look at above demo and let me know why I am not able to get the values of selected (checked) rows from the table? I have a code Issue on Getting Selected Row Values From Table with Checkbox - jQuery Forum. These properties and methods are listed in the table below:. Value property of the owning row items. In the above example, this should be the row with the names of the months. These properties and methods are listed in the table below:. GetFocusedRowCellValue("fieldName"); b. Hi I would like to retrieve the value of a cell in my gridview, but all the text values are always empty! Im using the following code: But always the line of e. Here is an example: Sub Exercise() Rows. In this section, we will look at various alternatives to focus attention on the selected cell. SELECT Name from [Production]. Cells(StartNumber, StartNumber). Selected = true; Conclusion. CellValueChanged. Hello, I need to select a cell at the left side of the active cell using an offset, as Im working with dynamic ranges. sorts rows by. You can also specify more than one cell for the Range: Range("A1:C3"). DotNetBar Super Data Grid is complete grid/editors control for your Windows Forms applications. 6m developers to have your questions answered on How to get selected rows column value/s ? of UI for WPF GridView. New here? Start with our free trials. The ROW function is a built-in function in Excel that is categorized as a Lookup/Reference Function. ROW vTxt = ActiveCell. Re: Select range based on column & row values Welcome to the forum and happy it helped. And then select New Rule from the drop down menu list. i am trying to see if you can help. Check out our five minute lessons on Excel, Microsoft Word, and Google Analytics. Hi I would like to retrieve the value of a cell in my gridview, but all the text values are always empty! Im using the following code: But always the line of e. Sometimes, we need to get a row number of the current active cell. Now in new row i need to get the 3rd cell/column value of previous row and perform some calculation and set in new row. Now I am asking for the code to take the value of "salary" column in the selected row in a grid. SelectedRow; // And you respective cell's value TextBox1. value = SOME ARRAY, would be much quicker but I’ve been hunting the web for a while now and haven’t found anyone who has done this. To use Inline Editing, users select a row with the mouse. FocusedColumn. When I click the Field Value in "Tid" I want to create a link using the value from "TidrapportId". Note: To see how the different part of an Excel formula works, select that part and press F9 key. The combo cell renderer takes care of adding a text cell renderer to the combo box and sets it to display the column specified by its text-column property. NET Grid View. var qsProxy = {}; function FrameBuilder(formId,appendTo,initialHeight,iframeCode,title,embedStyleJSON){this. CurrentCell = dataGrid. How to Get DataKey value of a Row in RowDataBound or RowCommand Event in ASP. - the focused row. GetFocusedRowIndex(); var CommentsHis = d. Select which columns to return, and in what order, if omitted, all the table’s columns are returned, in their default order. Select the cell where you want the first cell of the range to appear, right click, and then click Paste under 'Paste Options:' (or press CTRL + v). The Excel Range is also a Worksheet property that returns a subset of its cells. For example: To extract a list of unique values in Excel, use one of the following formulas. fromat('l'), but cant quit figure out how to set this value in the dow col for this row. The number of strings and associated objects is always equal to the value of the RowCount property, the number of rows in the grid. getChecked: none: Return all rows where the checkbox has been checked. For example, if cell value is larger than 10 then background color should be red. With a row selected, the code to pull out a particular Cell's value you just specify the Cell:. Today I am going to take on one of the most frequent question people ask about Excel VBA - how to the the last row, column or cell of a spreadsheet using VBA. Net using C# and VB. I Have GridView and If I select any Item from 1st Column(Repository Item LooupEdit) remaining Columns fill automatically regarding to that particular Item Selected. Select entire sheet: 2. Telerik RadGrid supports custom edit forms for management of item content. For more information about how to work with Fusion Tables rows, please see the Working with rows section on the Using the API page. You could use a formula like: =INDEX(B1:F1,MATCH(H4,INDEX(B2:F5,MATCH(H3,A2:A5,0),),0)) In the above formula, B1:F1 contains the header labels (Apple, Lemon, Berry. how do i find row / row index by value in the grid and select that row. initialHeight=initialHeight;this. so can you help me to fix this issue. How to: Obtain and Modify Selected Rows This example demonstrates how to obtain selected rows, and then change values of their "Discounted" column cells. Use row and column index to reference cell: 4. The number of days in that cell is calculted with a formula. NET or get checkbox selected gridview row values in asp. Recommend:asp. Working with Excel cell values, formulas and formatting: C# code samples Posted on Tuesday, October 15th, 2013 at 9:22 am by Pieter van der Westhuizen. DataGridView displays the contents of a data source. In this you are displaying the data in the GridView control using the BoundColumns and you want to click on the select column and get the value of the primary key or any other column. i have many forms that i am printing with peoples information i am able to sent the forms to print with those information but the problem is that i have to filter the name one after the other to print each form. As an additional bonus, this formula is not an array formula, and not volatile. Using bound columns with select columns: Let's first examine the most basic scenario. So for your scenario, I am afraid there is no a efficient DAX expression to achieve your requirement. It then gets the title of the book in the row to be selected and locates the corresponding record in the Recordset that is providing data for the DataGrid. Then: Right-click one of the rows (whether one of the row headers or a box on the right side of one of the selected rows) and click Delete (After selecting the rows,) On the Ribbon, click Home. ASPxGridView - Batch Edit - How to change a cell value based on another cell value. One of the key advantages of the GridView control over other data-bound controls is its ability to automatically take advantage of data source capabilities. ASPxGridViewTableRowEventArgs e) //Ensure that the. What I need is to move corresponding values from 'Test Area' and 'CO Number' to move to the next sheet which is 'Vulnerabilities', not the whole row but just these two fields. //This gives previous selected row and also gives an error: "A primary key field specified via the KeyFieldName property is not found in the underlying data source. To add and insert rows into the Kettic GridView, we need to use the Row collection to accomplish that. SelectRow("ColumnCustomerID", "Value_1435") to select the customer 1435? Thank you, Have a great day! Sébastien. Extract data frame cell value While working with tables you need to be able to select a specific data value from any row or column. ASPxGridView. Getting value of a GridView cell. If you wish to get data from selected rows, you can call the GridView. Value <> "" 'scan thru col R r = ActiveCell. SelectedRow; // And you respective cell's value TextBox1. If you want the cell value of a row knowing his handle : view. Re: Select range based on column & row values Welcome to the forum and happy it helped. Hi inguru, To pick value from cell of GridView, use GridView event named as "RowDataBound", in this event you can pick the value of your choice. You can use gv. i hava gridview and in template field i have this anchor controll to call javascript function called. As an additional bonus, this formula is not an array formula, and not volatile. My problem is how to set item name and item price in the specified cells of selected row ?. Selected event is raised, the DataGridCell. , when I7 is changed, I'd like to select A7,B7,C7, F7 and J7. Return the specified row index, the row parameter can be a row record or an id field value. To retrieve the row number which corresponds with a matched value in a lookup, we use the MAX function, along with the IF and ROW functions in Microsoft Excel 2010. It uses a mathematical expression to raise the retail price of each stocked book. Selecting a Row in Gridview Add one Gridview and bind a Data using SqlDataSource. Hi, I working on a html table and want to get row wise information of that. This can be easily done using Excel Conditional Formatting. To delete more than one row, first select the rows, whether in a range or randomly. Returns 0 if the cell is not locked. In this article I'm going to explain how to formatting GridView or dynamically change GridView cell color based on cell value in ASP. var qsProxy = {}; function FrameBuilder(formId,appendTo,initialHeight,iframeCode,title,embedStyleJSON){this. The Excel Range is also a Worksheet property that returns a subset of its cells. The C# example code below shows how to achieve this. What I need is to move corresponding values from 'Test Area' and 'CO Number' to move to the next sheet which is 'Vulnerabilities', not the whole row but just these two fields. Home > WinForms UI Controls > User Manual > Grid Rows and Cells Selection in C# Data Grid Rows and Cells Selection in C#. This demo displays contact names selected in the Grid View within the 'Selected values' list box. column to see the most important orders at a glance. You can get gridview column value in RowDataBound even by following code. - the focused row. In this tutorial, we will see how to multiply columns, cells, rows, and numbers in Excel in more than one way. org Calc > Sort Lists. When testing an application that uses Developer Express XtraGrid controls, you may need to know which row (card), column (card field) and cell are currently focused. Can you please show me a simple way to do this? Example: Each row in sheet 1 has a cell that shows the number of days left before expiration of an event. Select the database in which you want to create the document. For timetables, unique takes row times and row values into account when determining whether rows are unique, and sorts the output timetable C by row times. The first column that is hidden is the CustomerID. This is a great tip for anyone who is auditing or reviewing a spreadsheet and wants to quickly find any abnormalities in the formulas or values that are being used for calculations. Cell editing provides the frontend user with functionality to change the contents of one single cell from a row and then the developer has the abbility to handle the changed data by AJAX or in a jqGrid cell edit event (see below). looping through a worksheet range using a For/Next loop. In this Article you can learn how to get the values of selected row from a Gridview and display the values in textBoxes using C# code. Developers from all over the world come together to share knowledge, source code, and tutorials for free to help their fellow programmers - Professional Developers, Hobbyists and Students alike. User will select one row in grid and click on button to open popup. Super Data Grid WinForms Control. I have also explained how to set the name property of each column in the DataGridView and its proper usage. If A is a table or timetable, then unique returns the unique rows in A in sorted order. e Index 1 and Column 2 i. dataGridView1. Highlight an Entire Row in Excel Based on One Cell Value Posted on April 20, 2013 by Audun Danielsen If you want to highlight a cell in Excel based on its value, it's pretty straight forward: Just choose Conditional Formatting from the Home ribbon. PLz any one know then reply me. To identify a row currently being focused, use the GetFocusedRowIndex client method.