myPrimaryKey = OrderID myPrimaryKey = ProductID = OrderID = = False = False | myPrimaryKey OrderID OrderID False False 0 1 -1 False True Reading from the Order Details DataTable myPrimaryKey OrderID myPrimaryKey ProductID OrderID False False 0 1 -1 False False ProductID False False 0 1 -1 False False UnitPrice True False 0 1 -1 False False Adding Restrictions by Calling the DataAdapter Object s FillSchema Method Instead of adding restrictions yourself you can add them by calling the FillSchema method of your DataAdapter. The FillSchema method does the following Copies the schema information from the database. Creates DataTable objects in your DataSet if they don t already exist. Adds the constraints to the DataTable objects. Sets the properties of the DataColumn objects appropriately. The properties of the DataColumn objects set by FillSchema include the following The DataColumn name-which is stored in the ColumnName property. The DataColumn .NET data type-which is stored in the DataType property. The maximum length of a variable length data type-which is stored in the MaxLength property. Whether the .
