Datasets in Microsoft.Net - Validation Properties of the DataColumn

(Page 4 of 8 )

The DataColumn object exposes a number of properties that you can use to validate your data.

1. ReadOnly The simplest way to ensure that your data is valid is to not let users modify it. If you want to make the data in a DataColumn read-only, set the ReadOnly property of the DataColumn to True.
   
   
2. AllowDBNull Some database columns require values, while others accept empty, or null, values. The DataColumn object exposes an AllowDBNull property that you can set to control whether the column in your DataSet accepts null values.
   
   
3. MaxLength Many databases place restrictions on the size of a string in a column. In the Customers table, for example, the CustomerID column accepts a string of up to 5 characters and the CompanyName column accepts up to 40 characters. You can place similar restrictions on a DataColumn using the MaxLength property.
   
   
4. Unique The DataColumn lets you specify which values in a column are unique using the Unique property. When you set this property to True on a DataColumn, ADO.NET will examine the value stored in this column of each row in your DataTable. If you add or modify a row in your DataTable to create a duplicate value in a unique column, ADO.NET will throw a ConstraintException.

Next: The DataTable Object’s Constraints Collection >>
 

More ADO.NET Articles
More By Raghav Nayak

Comments On: Datasets in Microsoft.Net

>>> Be the FIRST to comment on this article!