devexpress aspx datatable new row

Smons

3 min read

·

11-02-2025

54

0

Share

This article explains how to add new rows to a DevExpress ASPxGridView in your ASP.NET application. We'll cover several methods, from simple client-side additions to more complex server-side approaches with data binding. Knowing how to efficiently manage data within your grid is crucial for a dynamic and user-friendly application.

Understanding the ASPxGridView's Data Editing Capabilities

The DevExpress ASPxGridView is a powerful control offering various ways to edit data, including adding new records. Its flexibility allows you to tailor the new row experience to your specific needs. We'll examine different methods to best suit your application's architecture and complexity.

Method 1: Enabling the Built-in New Row Functionality

The simplest method is leveraging the ASPxGridView's built-in functionality. This requires minimal coding and is ideal for straightforward scenarios.

Steps:

1. Set the SettingsEditing.AddNewRowRow property: In your ASPxGridView declaration, set the SettingsEditing.AddNewRowRow property to True. This enables the automatic appearance of a new row at the bottom of the grid, allowing users to directly input data.

2. Handle the RowInserting event: (Optional) Use the RowInserting server-side event to perform validation or custom processing before the new row is actually inserted into your data source. This allows you to enforce data integrity rules.

protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) {
    // Perform validation and custom processing here.
    // Example: Check for duplicate entries.
    // ...

    e.Cancel = false; // Or e.Cancel = true; to cancel the insertion.
}

3. Configure Data Binding: Ensure your ASPxGridView is correctly bound to your data source. This allows the newly added row's data to be persisted.

Method 2: Programmatically Adding a New Row (Client-Side)

For more control, you can add new rows programmatically using client-side JavaScript. This approach offers greater flexibility in how and when the new row is added.

Steps:

1. Use the PerformCallback method: Initiate a callback to the server to handle the actual data insertion.

2. Handle the callback on the server-side: In your server-side code, handle the callback and insert the new row into your data source.

3. Refresh the grid: After successful insertion, refresh the ASPxGridView to display the new row.

function addNewRow() {
    grid.PerformCallback('AddNewRow');
}

//Server Side Code (in your code-behind)
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e) {
    if (e.Parameters == "AddNewRow") {
        // Add your new row logic here (e.g., insert into database)
        ASPxGridView1.DataBind(); //Refresh the grid
    }
}

Method 3: Adding a New Row with Server-Side Data Binding (Advanced)

This method offers the most control and is best for complex scenarios where data manipulation requires server-side processing.

Steps:

1. Create a new data object: Create a new instance of your data object representing the row you want to add. Populate its properties with the necessary data.

2. Insert the new data object: Use your data access layer to insert the new object into your data source (database, etc.).

3. Rebind the ASPxGridView: Rebind the grid to reflect the changes in your data source. This ensures the new row appears in the grid.

protected void AddNewRowButton_Click(object sender, EventArgs e) {
    // Create a new data object
    MyDataObject newRow = new MyDataObject();
    newRow.Property1 = "Value1";
    newRow.Property2 = "Value2";

    // Insert the new object into your data source
    MyDataLayer.Insert(newRow);

    // Rebind the ASPxGridView
    ASPxGridView1.DataBind();
}

Handling Data Validation

Regardless of the method chosen, implementing robust data validation is crucial. The RowInserting event (Method 1) and custom server-side logic (Methods 2 & 3) offer ideal places to perform validation. Prevent invalid data from entering your database by checking for required fields, data types, and any custom business rules. Display appropriate error messages to guide the user.

Conclusion

DevExpress ASPxGridView offers several ways to add new rows, each with its own advantages. Choosing the right method depends on the complexity of your application and the level of control needed. Remember to always prioritize data validation to ensure data integrity. Using a combination of client-side and server-side techniques can result in a highly responsive and user-friendly experience. Properly handling new rows is a key element in building a successful ASP.NET application with the DevExpress ASPxGridView.