ASPxGridView.GetRowValues(Int32, String[]) Method

Returns the values of the specified data source fields in the specified row.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v24.1.dll

NuGet Package: DevExpress.Web

Declaration

C#

public object GetRowValues(
    int visibleIndex,
    params string[] fieldNames
)

VB.NET

Public Function GetRowValues(
    visibleIndex As Integer,
    ParamArray fieldNames As String()
) As Object

Parameters

Name	Type	Description
visibleIndex	Int32	Identifies the data row.
fieldNames	String[]	An array of the data source field names whose values in the specified row are returned.

Returns

Type	Description
Object	An array of field values (if several field names are passed via the fieldNames parameter) or a direct field value (if a single field name is passed via the fieldNames parameter).

Remarks

The GetRowValues method returns the values of the specified data source fields in the specified grid data row.

To work correctly, the GetRowValues method needs the grid to be data bound to its data source. If you call the GetRowValues method in code behind, it returns row values. First, the grid searches for a value in Row Cache. If row data is found, data binding does not occur. If data is not found, the grid is bound with a data source. Refer to the ASPxGridView Row Cache topic for more information about general aspects of ASPxGridView Row Cache operation.

The following code snippet illustrates how to get values of several columns simultaneously.

C#

string[] fields = {"FieldName1", "FieldName2", "FieldName3", "FieldName4", "FieldName5"};
object[] values = grid.GetRowValues(3, fields) as object[];
DateTime prog1 = (DateTime)values[4];

VB.NET

Dim values As Object() = TryCast(grid.GetRowValues(index, New String() {"FieldName1", "FieldName2", "FieldName3", "FieldName4", "FieldName5"}), Object())

Note

If you call the GetRowValues method while an unbound grid control builds its hierarchy (for example, within the HtmlRowCreated, CustomButtonInitialize or ContextMenuItemVisibility event handlers), the GetRowValues method rebinds to data to reset the hierarchy. It might result in displaying the grid with empty data and losing values entered by an end user. To avoid this behavior, call the grid’s ASPxWebControl.DataBind method within the Page_Load event handler.

View Example: How to use the Rich Text Editor to edit formatted text in the Edit Form

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetRowValues(Int32, String[]) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

asp-net-web-forms-grid-lookup-access-selected-data/CS/ASPxGridLookUpSelection/ServerSide_SingleSelect.aspx.cs#L11

ASPxGridView grid = ASPxGridLookup1.GridView;
object value = grid.GetRowValues(grid.FocusedRowIndex, new string[] { "ProductName" });
ASPxListBox1.Items.Clear();

asp-net-web-forms-grid-cache-data-on-the-client-side/CS/Solution/Default.aspx.cs#L12

for (int n = startIndex; n < end; n++) {
    titleId[n - startIndex] = grid.GetRowValues(n, "title_id");
    titles[n - startIndex] = grid.GetRowValues(n, "title");

asp-net-web-forms-grid-display-barcode-in-column/CS/ASPxGridViewBarCode/Default.aspx.cs#L18

var container = (GridViewDataItemTemplateContainer)image.NamingContainer;
var value = container.Grid.GetRowValues(container.VisibleIndex, new string[] { "Text" });
if (value != null)

asp-net-web-forms-grid-use-cascading-combo-boxes-in-inline-edit-mode/CS/MultiCombo/Default.aspx.cs#L45

if(!grid.IsNewRowEditing) {
    object[] vals = (object[])grid.GetRowValues(grid.EditingRowVisibleIndex,
    new string[] { "Category2ID", "Category3ID", "Category4ID" });

asp-net-web-forms-grid-initialize-editor-conditionally/CS/WebApplication_Grid/Templates/CustomEditItemTemplate.cs#L12

GridViewEditItemTemplateContainer container = _container as GridViewEditItemTemplateContainer;
object[] values = (object[])container.Grid.GetRowValues(container.VisibleIndex, new string[] { "Type", "DataValue" });
string dataType = Convert.ToString(values[0]);

VB.NET

asp-net-web-forms-grid-lookup-access-selected-data/VB/ASPxGridLookUpSelection/ServerSide_SingleSelect.aspx.vb#L13

Dim grid As ASPxGridView = ASPxGridLookup1.GridView
Dim value As Object = grid.GetRowValues(grid.FocusedRowIndex, New String() { "ProductName" })
ASPxListBox1.Items.Clear()

asp-net-web-forms-grid-move-selected-rows-between-grid-controls/VB/E2636/Default.aspx.vb#L50

For i As Integer = 0 To SourceGrid.VisibleRowCount - 1
    rowValues.Add(SourceGrid.GetRowValues(i, fieldNames))
Next i

asp-net-web-forms-grid-cache-data-on-the-client-side/VB/Solution/Default.aspx.vb#L17

For n As Integer = startIndex To [end] - 1
    titleId(n - startIndex) = grid.GetRowValues(n, "title_id")
    titles(n - startIndex) = grid.GetRowValues(n, "title")

asp-net-web-forms-grid-display-barcode-in-column/VB/ASPxGridViewBarCode/Default.aspx.vb#L20

Dim container = CType(image.NamingContainer, GridViewDataItemTemplateContainer)
Dim value = container.Grid.GetRowValues(container.VisibleIndex, New String() { "Text" })
If value IsNot Nothing Then

asp-net-web-forms-grid-use-cascading-combo-boxes-in-inline-edit-mode/VB/MultiCombo/Default.aspx.vb#L51

If Not grid.IsNewRowEditing Then
    Dim vals() As Object = CType(grid.GetRowValues(grid.EditingRowVisibleIndex, New String() { "Category2ID", "Category3ID", "Category4ID" }), Object())
    Dim combo4 As ASPxComboBox = (CType(grid.FindEditRowCellTemplateControl(TryCast(grid.Columns("Category4ID"), GridViewDataComboBoxColumn), "Cat4"), ASPxComboBox))