Simple Data Binding Page - 3

15. When the user clicks the next button in the above screen, he will be immediately shown with the next screen of the wizard which shows all the Tables, Stored procedures, functions, Views, and Functions in a tree control. The user will have to choose a table or multiple tables from which he may want to extract data. He will then have to click on Next to continue.  

16. Next the user will have to click on the Advanced Binding property of the TextBox to open up the Formatting and Advanced Binding. The screen below will appear.

17. The user will have to click on the ComboBox Binding in the displayed form to see a smart tag. Clicking on any column will close the smart tag automatically.

18. Click on the appropriate column of the table shown in the smart tag. The next screen will appear as under:

19. Note that the Text property of the TextBox is bound to column Name of Department table. The user will see the floating window titled “Data sources”. He must click on any of the DataSet and drag the DataSet and drop it on the form. This process will create a DataGrid like structure on the screen. However, multiple values of the TextBox will be bound just to a single display control. As a next step, the user needs to add some kind of control for the navigation.

20. Add Binding Navigator to set the Data source of the control to the same data Source as that of the text box. Now press F5 to execute the program. The user will see that the data is bound and displayed in the text box. The BindingNavigator will also help the user to navigate through the data.

21. Simple-bound controls show only a single data element, therefore, it is very better to include navigation logic in a Windows Form with simple-bound controls