LinqDataSourceStatusEventArgs.Result Property

Definition

Gets the object that represents the result of a data operation.

public:
 property System::Object ^ Result { System::Object ^ get(); };
public object Result { get; }
member this.Result : obj
Public ReadOnly Property Result As Object

Property Value

An object that contains the data from the data operation.

Examples

The following example shows an event handler for the Inserted event. In the event handler, if the Exception property is null, the product ID is retrieved from the object in the Result property. The product ID is a primary key for the table and is set by the database, therefore the value is not known until the insert operation has finished. The exception message is logged if the Exception property is not equal to null. The ExceptionHandled property is then set to true.

protected void LinqDataSource_Inserted(object sender, LinqDataSourceStatusEventArgs e)
{
    if (e.Exception == null)
    {
        Product newProduct = (Product)e.Result;
        Literal1.Text = "The new product id is " + newProduct.ProductID;
        Literal1.Visible = true;            
    }
    else
    {
        LogError(e.Exception.Message);
        Literal1.Text = "We are sorry. There was a problem saving the record. The administrator has been notified.";
        Literal1.Visible = true;
        e.ExceptionHandled = true;            
    }
}
Protected Sub LinqDataSource_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.LinqDataSourceStatusEventArgs)
    If (IsNothing(e.Exception)) Then
        Dim newProduct As Product
        newProduct = CType(e.Result, Product)
        Literal1.Text = "The new product id is " & newProduct.ProductID
        Literal1.Visible = True
    Else
        LogError(e.Exception.Message)
        Literal1.Text = "We are sorry. There was a problem saving the record. The administrator has been notified."
        Literal1.Visible = True
        e.ExceptionHandled = True
    End If
End Sub

Remarks

You use the Result property to examine values returned from a data operation. You can retrieve output parameters from a data operation or modify the values returned from a query.

The data stored in the Result property depends on the type of data operation that has been performed. When you delete data, the Result property contains an object of the type specified in the TableName property, with the original values that were deleted from the data source. When you insert or update data, the Result property contains an object of the type specified in the TableName property, with the new values that were saved to the data source. When you select data, the Result property contains the results of the query.

If the select query involves grouping the data or selecting a subset of properties from the type specified in the TableName property, the Result property contains an object of a dynamically created type. Otherwise, the Result property contains an object of the type specified in the TableName property.

Applies to