Exforsys.com
 
Home Tutorials VB.NET 2005
 

Simple Data Binding

 

Simple Data Binding - Page 3

Page 3 of 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




First Page: Simple Data Binding


Read Next: .NET Complex Data Binding



 

 

Comments


lonrey said:

  This VB.NET 2005 Tutorial on Simple Data Binding was very helpful.
It allowed me to get a simple database program up and running from nothing in about half an hour.
I didn\'t have to refer to any other reference material.
Great job.by the author.
July 16, 2006, 9:05 am

felix said:

  I can't seem to drag the Data Set into the form and so the DataGrid like structure does not appear in my form. Any suggestions to solve this problem? Thanks
January 16, 2007, 7:36 pm

Flakky said:

  Was very clear and simple tutorial, Easy to implement with satisfying results.

Had some problems with getting to the right screens
(for example Data Source floating window) but this is just my lack of knowledge with the Visual Studio IDE

Good Job :X
January 25, 2007, 9:15 am

Senthil Babu said:

  It is really good for the beginners to understand the steps and working out to get the result.
Thanks.
March 12, 2007, 4:33 am

Punith Kumar said:

  Thanks,
April 5, 2007, 2:37 am

SQL Newby said:

  This was really helpful, but the Data Source dragging bit was a little unclear. For those like myself....
In the "Data" menu, select "Show Data Sources"
The "Data Sources" window opens. Highlight the table from the Data Set you want and drag that table to the form you want to use it on. If you don't want to actually see the table, just turn the Visible property to False. This changes some code automatically for you, so that if you add more text boxes to display your information, they are all linked. Ok, awesome!!! Happy coding =)
June 21, 2007, 1:59 pm

Mohit Bhai Agra Wale said:

  Its very helpful for developer and its good for all users.Thanks
January 18, 2008, 12:57 am

abhineet komal said:

  This is what i was trying for: thanx,plz put some same kind of programs like this
July 15, 2008, 5:17 am

Rajmohan said:

  very useful website. Easy to learn.Thanks
September 23, 2008, 4:56 am

santosh said:

  after data binding connection,we want enter new data add button with click event please send code how to add data
November 10, 2008, 3:13 am

Chris said:

  In effect it is very userful for beginners but it does not adress typical problems developers have. e.g. normalized data tables with FK etc. How can i represent this in a control (getting data from master table instead of FK) and how can i save it? Because DataTableAdpater doesn't create update command when table uses joins......
October 16, 2009, 5:38 am

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape