To define primary keys for each Data Table in the Data Set

  1. Select each data adapter in turn and set the Active property under Live Data in the Object Inspector to True.
  2. Select the DataSet in the Component Tray.
  3. In the Object Inspector, in the Tables property, click the ellipsis (...) button.

This displays the Tables Collection Editor. If you have set all of the data adapters' Active properties to True, the Tables Collection Editor will contain one member for each DataTable stored in the corresponding DataSet.

  1. Select a table from the members list.
  2. In the Primary Key field in the Table Properties, click on the DataColumn[] entry to display a popup list of column names.
  3. Click the gray checkbox next to the column name of the column or columns that comprise the Primary Key.

The number 1 appears in the gray checkbox when selected.

7. Define Column properties and Constraints for your Primary Key columns.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment