ASPxGridView.GetRowValuesByKeyValue(Object, String[]) Method

Returns the specified row’s values displayed within the specified columns (fields).

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v19.1.dll

Declaration

C#

public object GetRowValuesByKeyValue(
    object keyValue,
    params string[] fieldNames
)

VB.NET

Public Function GetRowValuesByKeyValue(
    keyValue As Object,
    ParamArray fieldNames As String()
) As Object

Parameters

Name	Type	Description
keyValue	Object	An object that uniquely identifies the row.
fieldNames	String[]	The names of data source fields whose values are returned.

Returns

Type	Description
Object	An object that contains the row values displayed within the specified columns (fields).

Example

The code sample below demonstrates how you can prohibit a user from editing data rows containing information unrelated to the Sales department.

C#

string UserDepartment = "Sales";
...
protected void MyGridView_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e) {
     if (MyGridView.GetRowValuesByKeyValue(e.EditingKeyValue, "Department").ToString() != UserDepartment) {
          e.Cancel = true;
     }
}

VB.NET

Dim UserDepartment As String = "Sales"
...
Protected Sub MyGridView_StartRowEditing(sender As Object, e As DevExpress.Web.Data.ASPxStartRowEditingEventArgs)
    If MyGridView.GetRowValuesByKeyValue(e.EditingKeyValue, "Department").ToString() <> UserDepartment Then
        e.Cancel = True
    End If
End Sub

ASPX

<dx:ASPxGridView ID="MyGridView" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource1"
KeyFieldName="ID" OnStartRowEditing="MyGridView_StartRowEditing">
          <Columns>
          <dx:GridViewCommandColumn VisibleIndex="0">
                    <EditButton Visible="True">
                    </EditButton>
          </dx:GridViewCommandColumn>
          <dx:GridViewDataTextColumn FieldName="Department" ReadOnly="True" VisibleIndex="0">
          </dx:GridViewDataTextColumn>
          ...
          </Columns>
</dx:ASPxGridView>

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetRowValuesByKeyValue(Object, 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#

how-to-conditionally-display-one-or-another-detail-grid-e1054/CS/ConditionalDetailRowTemplate/Default.aspx.cs#L71

protected bool IsGridProductVisible(object categoryID) {
    object categoryName = gridMaster.GetRowValuesByKeyValue(categoryID, "Category");
    return "Product".Equals(categoryName);

aspxgridview-how-to-initialize-an-edit-form-editor-based-on-the-value-of-another-column-e4835/CS/WebApplication_GridTest/CustomEditItem.aspx.cs#L14

ASPxGridView grid = (ASPxGridView)sender;
DataType dataType = (DataType)grid.GetRowValuesByKeyValue(e.Keys[0], "Type");

custom-callback-based-implementation-of-cascading-comboboxes-in-inline-mode-e1362/CS/MultiCombo/Default.aspx.cs#L33

if (!grid.IsNewRowEditing) {
    object val = grid.GetRowValuesByKeyValue(e.KeyValue, parentComboName);
    id = (val == null || val == DBNull.Value) ? null : val.ToString();

how-to-edit-hierarchical-data-using-cascading-comboboxes-e1346/CS/MultiCombo/Default.aspx.cs#L76

{
    object[] vals = (object[]) ASPxGridView1.GetRowValuesByKeyValue(e.EditingKeyValue,
        new string[] {"Category1ID", "Category2ID", "Category3ID" });

how-to-use-cascading-comboboxes-in-an-inline-edit-mode-e1358/CS/MultiCombo/Default.aspx.cs#L82

{
    object[] vals = (object[]) grid.GetRowValuesByKeyValue(e.EditingKeyValue,
        new string[] {"Category1ID", "Category2ID", "Category3ID" });

VB.NET

how-to-conditionally-display-one-or-another-detail-grid-e1054/VB/ConditionalDetailRowTemplate/Default.aspx.vb#L75

Protected Function IsGridProductVisible(ByVal categoryID As Object) As Boolean
    Dim categoryName As Object = gridMaster.GetRowValuesByKeyValue(categoryID, "Category")
    Return "Product".Equals(categoryName)

aspxgridview-how-to-initialize-an-edit-form-editor-based-on-the-value-of-another-column-e4835/VB/WebApplication_GridTest/CustomEditItem.aspx.vb#L16

Dim grid As ASPxGridView = CType(sender, ASPxGridView)
Dim dataType As DataType = CType(grid.GetRowValuesByKeyValue(e.Keys(0), "Type"), DataType)

custom-callback-based-implementation-of-cascading-comboboxes-in-inline-mode-e1362/VB/MultiCombo/Default.aspx.vb#L31

If (Not grid.IsNewRowEditing) Then
    Dim val As Object = grid.GetRowValuesByKeyValue(e.KeyValue, parentComboName)
    If (val Is Nothing OrElse val Is DBNull.Value) Then

how-to-edit-hierarchical-data-using-cascading-comboboxes-e1346/VB/MultiCombo/Default.aspx.vb#L77

Protected Sub ASPxGridView1_StartRowEditing(ByVal sender As Object, ByVal e As DevExpress.Web.Data.ASPxStartRowEditingEventArgs)
    Dim vals() As Object = CType(ASPxGridView1.GetRowValuesByKeyValue(e.EditingKeyValue, New String() {"Category1ID", "Category2ID", "Category3ID" }), Object())
    Session("Cat1ID") = vals(0)

how-to-use-cascading-comboboxes-in-an-inline-edit-mode-e1358/VB/MultiCombo/Default.aspx.vb#L77

Protected Sub grid_StartRowEditing(ByVal sender As Object, ByVal e As DevExpress.Web.Data.ASPxStartRowEditingEventArgs)
    Dim vals() As Object = CType(grid.GetRowValuesByKeyValue(e.EditingKeyValue, New String() {"Category1ID", "Category2ID", "Category3ID" }), Object())
    Session("Cat1ID") = vals(0)