Devexpress Aspx Gridview Getrow

5 min read Oct 03, 2024

Getting Data From a DevExpress ASPxGridView Row

The DevExpress ASPxGridView control is a powerful tool for displaying and managing data in web applications. It provides a rich set of features, including sorting, filtering, editing, and more. One common task is retrieving data from a specific row in the grid. This article will guide you through the process of getting data from a DevExpress ASPxGridView row in your ASP.NET application.

Understanding the Process

There are several ways to access the data from a DevExpress ASPxGridView row. You can use the ASPxGridView's built-in events and methods, or leverage its client-side functionality using JavaScript. The choice depends on the specific context and your desired outcome.

Server-Side Data Access

Accessing data during events: You can access row data within ASPxGridView events, such as the RowDataBound or CustomDataCallback events. These events are triggered when the grid is rendered or during specific actions.

protected void ASPxGridView1_RowDataBound(object sender, DevExpress.Web.Data.ASPxDataBoundRowEventArgs e)
{
    if (e.RowType == DevExpress.Web.Data.RowType.Data)
    {
        // Get the values from the row using e.GetValue()
        string name = e.GetValue("Name").ToString(); 
        int age = Convert.ToInt32(e.GetValue("Age"));

        // Do something with the retrieved data
        // For example, display it in a label:
        Label1.Text = "Name: " + name + ", Age: " + age;
    }
}

Using GetDataRow() method: The ASPxGridView's GetDataRow() method allows you to obtain the underlying data row object for a specified visible row index.

protected void Button1_Click(object sender, EventArgs e)
{
    // Get the selected row index (assuming it's the first row)
    int rowIndex = 0;

    // Get the DataRow object for the selected row
    DataRow row = ASPxGridView1.GetDataRow(rowIndex);

    // Access data from the row
    string name = row["Name"].ToString();
    int age = Convert.ToInt32(row["Age"]);
}

Client-Side Data Access

Using Client-Side JavaScript Events: The ASPxGridView offers client-side events like FocusedRowChanged and SelectionChanged, allowing you to access data in the selected row using JavaScript.

function OnFocusedRowChanged(s, e) {
    var keyValue = s.GetRowKey(e.visibleIndex); // Get the row's key value
    var name = s.GetRowValues(e.visibleIndex, "Name"); // Get the "Name" value
    alert("Selected Row Key: " + keyValue + ", Name: " + name);
}

Using GetRowValues() Method: Similar to the server-side approach, the client-side GetRowValues() method can be used to retrieve specific values from a row.

function GetRowData(rowIndex) {
    var grid = ASPxClientGridView1;
    var name = grid.GetRowValues(rowIndex, 'Name');
    var age = grid.GetRowValues(rowIndex, 'Age');

    alert("Name: " + name + ", Age: " + age);
}

Tips for Working with DevExpress ASPxGridView

Understand the Data Source: The GetDataRow() and GetRowValues() methods rely on the data source connected to the ASPxGridView. Ensure you are accessing the correct data fields.
Handle Row Selection: If you are retrieving data based on user selection, use appropriate events like SelectionChanged to trigger your data retrieval logic.
Data Validation: Implement validation on the client-side or server-side to ensure data integrity before processing the retrieved values.

Conclusion

Retrieving data from a DevExpress ASPxGridView row is a common requirement for interactive web applications. Whether you need to process data on the server-side or dynamically manipulate it on the client-side, the ASPxGridView provides powerful methods and events to accomplish these tasks. By understanding the available approaches and using best practices, you can efficiently access and manage data within your ASP.NET applications.