Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

How to: View Errors Within a DataSet with the Windows Forms ErrorProvider Component 

You can use the Windows Forms ErrorProvider component to view column errors within a dataset or other data source. For an ErrorProvider component to display data errors on a form, it does not have to be directly associated with a control. Once it is bound to a data source, it can display an error icon next to any control that is bound to the same data source.

NoteNote

If you change the error provider's DataSource and DataMember properties at run time, you should use the BindToDataAndErrors method to avoid conflicts.

To display data errors

  1. Bind the component to a specific column within a data table.

    ' Assumes existence of DataSet1, DataTable1
    TextBox1.DataBindings.Add("Text", DataSet1, "Customers.Name")
    ErrorProvider1.DataSource = DataSet1
    ErrorProvider1.DataMember = "Customers"
    
    

    // Assumes existence of DataSet1, DataTable1
    textBox1.DataBindings.Add("Text", DataSet1, "Customers.Name");
    errorProvider1.DataSource = DataSet1;
    errorProvider1.DataMember = "Customers";
    
    

    // Assumes existence of DataSet1, DataTable1
    textBox1.get_DataBindings().Add("Text", DataSet1, "Customers.Name");
    errorProvider1.set_DataSource(DataSet1);
    errorProvider1.set_DataMember("Customers");
    
  2. Set the ContainerControl property to the form.

    ErrorProvider1.ContainerControl = Me
    
    

    errorProvider1.ContainerControl = this;
    
    

    errorProvider1.set_ContainerControl(this);
    
  3. Set the position of the current record to a row that contains a column error.

    DataTable1.Rows(5).SetColumnError("Name", "Bad data in this row.")
    Me.BindingContext(DataTable1).Position = 5
    
    

    DataTable1.Rows[5].SetColumnError("Name", "Bad data in this row.");
    this.BindingContext [DataTable1].Position = 5;
    
    

    DataTable1.get_Rows().get_Item(5).SetColumnError("Name",
       "Bad data in this row.");
    this.get_BindingContext().get_Item(DataTable1).set_Position(5);
    

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.